X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-del_email.php;h=d6f42b43a242abc48b543a4725402852587b1088;hb=754861aaacc51a871b8b91f382c3e0b57726f692;hp=f402412014f8aa0fb5d26e1fa0aa326b46c1dbc7;hpb=a090e351c49fe021fb3064325694da03402332e0;p=mailer.git diff --git a/inc/modules/admin/what-del_email.php b/inc/modules/admin/what-del_email.php index f402412014..d6f42b43a2 100644 --- a/inc/modules/admin/what-del_email.php +++ b/inc/modules/admin/what-del_email.php @@ -1,22 +1,23 @@ 0) { // Prepare data for the template - define('__ID' , $id); - define('__SENDER' , ADMIN_USER_PROFILE_LINK($sender)); - define('__SUBJECT', $subject); - define('__URL' , DEREFERER($url)); - define('__ORDERED', MAKE_DATETIME($timestamp, "0")); + $content['timestamp'] = generateDateTime($content['timestamp'], 0); // Load template - LOAD_TEMPLATE("admin_del_email_normal"); - - // Transfer data to data array - $DATA = array('url' => $url, 'subject' => $subject); + loadTemplate('admin_delete_email_normal', FALSE, $content); // Load email template and send the email away - $msg_user = LOAD_EMAIL_TEMPLATE("order-deleted", array(), $sender); - SEND_EMAIL($sender, getMessage('MEMBER_ORDER_DELETED'), $msg_user); + $message_user = loadEmailTemplate('member_order_deleted', $content, $content['sender']); + sendEmail($content['sender'], '{--MEMBER_ORDER_DELETED--}', $message_user); // Fetch right stats_id from pool - $result_pool = SQL_QUERY_ESC("SELECT s.id FROM `{!_MYSQL_PREFIX!}_user_stats` AS s -LEFT JOIN `{!_MYSQL_PREFIX!}_pool` AS p -ON s.pool_id=p.id -WHERE s.pool_id=%s LIMIT 1", - array(bigintval(REQUEST_GET('mid'))), __FILE__, __LINE__); - if (SQL_NUMROWS($result_pool) == 1) { + $result_pool = sqlQueryEscaped("SELECT + `s`.`id` +FROM + `{?_MYSQL_PREFIX?}_user_stats` AS `s` +LEFT JOIN + `{?_MYSQL_PREFIX?}_pool` AS `p` +ON + `s`.`pool_id`=`p`.`id` +WHERE + `s`.`pool_id`=%s +LIMIT 1", + array(bigintval(getRequestElement('id'))), __FILE__, __LINE__); + if (sqlNumRows($result_pool) == 1) { // Fetch stats id - list($stats_id) = SQL_FETCHROW($result_pool); + list($stats_id) = sqlFetchRow($result_pool); // Get all user links - $links = GET_TOTAL_DATA($stats_id, "user_links", 'userid', "stats_id", true); + $links = countSumTotalData($stats_id, 'user_links', 'userid', 'stats_id', TRUE); // Reset sent mails for recipient(s) - REDUCED_RECIPIENT_RECEIVED_MAILS("stats_id", REQUEST_GET('mid'), $links); + reduceRecipientReceivedMails('stats_id', getRequestElement('id'), $links); // Calc total points and pay them back - $totalPoints = $links * $price; + $totalPoints = $links * $content['price']; // Shall we pay the points back to the user? - if (getConfig('repay_deleted_mails') != "SHRED") { - //* DEBUG: */ echo $stats_id.":".$totalPoints."/".$links."/".$price."
\n"; - if ($totalPoints > 0) { - // Shall we payback to user or jackpot? - if (getConfig('repay_deleted_mails') == "JACKPOT") { - // Set jackpot - $sender = 0; - } // END - if - - // Pay back points - //* DEBUG: */ echo "PAYBACK:".$sender."
\n"; - ADD_POINTS_REFSYSTEM("mail_deleted", $sender, $totalPoints, true, "0", false,"direct"); - - // Output message - if (getConfig('repay_deleted_mails') == "REPAY") { - // Repayed - LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_POINTS_REPAYED'), - TRANSLATE_COMMA($totalPoints) - )); - } else { - // To jackpot - LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_POINTS_TO_JACKPOT'), - TRANSLATE_COMMA($totalPoints) - )); - } + if ($totalPoints == 0) { + // No points repayed! + displayMessage('{--ADMIN_NO_POINTS_REPAYED--}'); + } elseif (getConfig('repay_deleted_mails') != 'SHRED') { + //* DEBUG: */ debugOutput($stats_id . ':' . $totalPoints . '/' . $links . '/' . $content['price']); + // Shall we payback to user or jackpot? + if (getConfig('repay_deleted_mails') == 'JACKPOT') { + // Set jackpot + $content['sender'] = '0'; + } // END - if + + // Pay back points + initReferralSystem(); + addPointsThroughReferralSystem('mail_deleted', $content['sender'], $totalPoints); + + // Output message + if (getConfig('repay_deleted_mails') == 'REPAY') { + // Repayed + displayMessage('{%message,ADMIN_POINTS_REPAYED=' . $totalPoints . '%}'); } else { - // No points repayed! - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_NO_POINTS_REPAYED')); + // To jackpot + displayMessage('{%message,ADMIN_POINTS_TO_JACKPOT=' . $totalPoints . '%}'); } } else { // Points shredded! - LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_POINTS_SHREDDED'), $totalPoints)); + displayMessage('{%message,ADMIN_POINTS_SHREDDED=' . $totalPoints . '%}'); } // Remove links from DB - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_links` WHERE stats_id=%s", + sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `stats_id`=%s", array(bigintval($stats_id)), __FILE__, __LINE__); - $cnt += SQL_AFFECTEDROWS(); + $count += sqlAffectedRows(); // Load template for link - LOAD_TEMPLATE('admin_settings_saved', false, "".ADMIN_REMOVE_STATS_ENTRY.""); + displayMessage('{--ADMIN_REMOVE_STATS_ENTRY--}'); } // END - if // Free the result - SQL_FREERESULT($result_pool); + sqlFreeResult($result_pool); // Delete mail from queue - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_pool` WHERE id=%s LIMIT 1", - array(bigintval(REQUEST_GET('mid'))), __FILE__, __LINE__); - $cnt += SQL_AFFECTEDROWS(); + sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1", + array(bigintval(getRequestElement('id'))), __FILE__, __LINE__); + $count += sqlAffectedRows(); // Output link for manually removing stats entry - OUTPUT_HTML(sprintf(ADMIN_DELETED_MAILS_COUNT, $cnt)); + outputHtml('{%message,ADMIN_DELETED_MAILS_COUNT=' . $count . '%}'); } else { // Mail already deleted! - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_NORMAL_MAIL_ALREADY_DELETED')); + displayMessage('{--ADMIN_NORMAL_MAIL_ALREADY_DELETED--}'); } -} elseif (REQUEST_ISSET_GET(('pid'))) { + + // Free result + sqlFreeResult($result); +} elseif (isGetRequestElementSet('pid')) { // Remove stats entries - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE pool_id=%s LIMIT 1", - array(bigintval(REQUEST_GET('pid'))), __FILE__, __LINE__); + sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `pool_id`=%s LIMIT 1", + array(bigintval(getRequestElement('pid'))), __FILE__, __LINE__); // Output message - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_USER_STATS_REMOVED')); -} elseif ((REQUEST_ISSET_GET(('bid'))) && (EXT_IS_ACTIVE('bonus'))) { + displayMessage('{--ADMIN_USER_STATS_REMOVED--}'); +} elseif (((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'bonus')) && (isExtensionActive('bonus'))) { // Load data from bonus mail - $result = SQL_QUERY_ESC("SELECT id, subject, url, timestamp, mails_sent FROM `{!_MYSQL_PREFIX!}_bonus` WHERE id=%s", - array(bigintval(REQUEST_GET('bid'))), __FILE__, __LINE__); + $result = sqlQueryEscaped("SELECT `id`, `subject`, `url`, `timestamp`, `mails_sent` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", + array(bigintval(getRequestElement('id'))), __FILE__, __LINE__); // Delete mail only once - if (SQL_NUMROWS($result) == 1) { + if (sqlNumRows($result) == 1) { // Load data - list ($id, $subject, $url, $timestamp, $sent) = SQL_FETCHROW($result); + $content = sqlFetchArray($result); // Reset sent mails for recipient(s) - REDUCED_RECIPIENT_RECEIVED_MAILS('bonus_id', REQUEST_GET('bid'), $sent); + reduceRecipientReceivedMails('bonus_id', getRequestElement('id'), $content['mails_sent']); // Init counter for deleted mails - $cnt = 0; + $count = '0'; // Delete bonus mail entirely from database - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_bonus` WHERE id=%s LIMIT 1", - array(bigintval(REQUEST_GET('bid'))), __FILE__, __LINE__); - $cnt += SQL_AFFECTEDROWS(); - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_links` WHERE bonus_id=%s", - array(bigintval(REQUEST_GET('bid'))), __FILE__, __LINE__); - $cnt += SQL_AFFECTEDROWS(); + sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", + array(bigintval(getRequestElement('id'))), __FILE__, __LINE__); + $count += sqlAffectedRows(); + sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s", + array(bigintval(getRequestElement('id'))), __FILE__, __LINE__); + $count += sqlAffectedRows(); // Prepare data for the template - define('__ID' , $id); - define('__SUBJECT', $subject); - define('__URL' , DEREFERER($url)); - define('__ORDERED', MAKE_DATETIME($timestamp, "0")); - define('__CNT' , $cnt); + $content['timestamp'] = generateDateTime($content['timestamp'], '0'); + $content['count'] = $count; // Load template - LOAD_TEMPLATE("admin_del_email_bonus"); + loadTemplate('admin_delete_email_bonus', FALSE, $content); } else { // Mail already deleted! - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_BONUS_MAIL_ALREADY_DELETED')); + displayMessage('{--ADMIN_BONUS_MAIL_ALREADY_DELETED--}'); } - - // Free result - SQL_FREERESULT($result); -} elseif ((REQUEST_ISSET_GET(('nid'))) && (GET_EXT_VERSION('bonus') >= '0.8.7')) { +} elseif ((isGetRequestElementSet('nid')) && (isExtensionInstalledAndNewer('bonus', '0.8.7'))) { // Load data from bonus mail - $result = SQL_QUERY_ESC("SELECT id, subject, url, timestamp FROM `{!_MYSQL_PREFIX!}_bonus` WHERE id=%s", - array(bigintval(REQUEST_GET('nid'))), __FILE__, __LINE__); + $result = sqlQueryEscaped("SELECT `id`, `subject`, `url`, `timestamp` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", + array(bigintval(getRequestElement('nid'))), __FILE__, __LINE__); // Delete mail only once - if (SQL_NUMROWS($result) == 1) { + if (sqlNumRows($result) == 1) { // Load data - list ($id, $subject, $url, $timestamp) = SQL_FETCHROW($result); - SQL_FREERESULT($result); + $content = sqlFetchArray($result); // Init counter for deleted mails - $cnt = 0; + $count = '0'; // Delete bonus mail entirely from database - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_bonus` WHERE id=%s LIMIT 1", - array(bigintval(REQUEST_GET('nid'))), __FILE__, __LINE__); - $cnt += SQL_AFFECTEDROWS(); - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_links` WHERE bonus_id=%s", - array(bigintval(REQUEST_GET('nid'))), __FILE__, __LINE__); - $cnt += SQL_AFFECTEDROWS(); + sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", + array(bigintval(getRequestElement('nid'))), __FILE__, __LINE__); + $count += sqlAffectedRows(); + sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s", + array(bigintval(getRequestElement('nid'))), __FILE__, __LINE__); + $count += sqlAffectedRows(); // Prepare data for the template - define('__ID' , $id); - define('__SUBJECT', $subject); - define('__URL' , DEREFERER($url)); - define('__ORDERED', MAKE_DATETIME($timestamp, "0")); - define('__CNT' , $cnt); + $content['timestamp'] = generateDateTime($content['timestamp'], '0'); + $content['count'] = $count; // Load template - LOAD_TEMPLATE("admin_del_email_notify"); + loadTemplate('admin_delete_email_notify', FALSE, $content); } else { // Mail already deleted! - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_NOTIFY_MAIL_ALREADY_DELETED')); + displayMessage('{--ADMIN_NOTIFY_MAIL_ALREADY_DELETED--}'); } + + // Free result + sqlFreeResult($result); } else { // No mail orders fond - LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_WRONG_CALL')); + displayMessage('{--ADMIN_WRONG_CALL--}'); } -// +// [EOF] ?>