X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-del_email.php;h=47ab0459cce11577d0dddb2a73e8250a6ded8eef;hp=029364057183c32ed747190cd6823e954b3041b1;hb=61621983cc6d7195fcc7eab29b5f6080ff283b34;hpb=09d80c9e9fab53408938a69f25e46dfb1fb7a6a1 diff --git a/inc/modules/admin/what-del_email.php b/inc/modules/admin/what-del_email.php index 0293640571..47ab0459cc 100644 --- a/inc/modules/admin/what-del_email.php +++ b/inc/modules/admin/what-del_email.php @@ -16,8 +16,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2016 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -46,52 +46,45 @@ addYouAreHereLink('admin', __FILE__); // Init counter for deleted mails $count = '0'; -if (isGetRequestParameterSet('mid')) { +if ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (postRequestElement('type') == 'normal')) { // Load email data - $result = SQL_QUERY_ESC("SELECT `id`, `sender`, `subject`, `url`, `timestamp`, `cat_id`, `payment_id` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1", - array(bigintval(getRequestParameter('mid'))), __FILE__, __LINE__); + // @TODO Unused: cat_id + $content = getPoolDataFromId(getRequestElement('id')); // Delete mail only once - if (SQL_NUMROWS($result) == 1) { - // Load data - $content = SQL_FETCHARRAY($result); - - // Get points we shall pay back per mail - $content['price'] = getPaymentPoints($content['payment_id'], 'price'); - // @TODO Unused: cat_id, payment_id - + if (count($content) > 0) { // Prepare data for the template $content['timestamp'] = generateDateTime($content['timestamp'], 0); // Load template - loadTemplate('admin_delete_email_normal', false, $content); + loadTemplate('admin_delete_email_normal', FALSE, $content); // Load email template and send the email away $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 + $result_pool = sqlQueryEscaped("SELECT + `s`.`id` FROM - `{?_MYSQL_PREFIX?}_user_stats` AS s + `{?_MYSQL_PREFIX?}_user_stats` AS `s` LEFT JOIN - `{?_MYSQL_PREFIX?}_pool` AS p + `{?_MYSQL_PREFIX?}_pool` AS `p` ON - s.pool_id=p.id + `s`.`pool_id`=`p`.`id` WHERE - s.`pool_id`=%s + `s`.`pool_id`=%s LIMIT 1", - array(bigintval(getRequestParameter('mid'))), __FILE__, __LINE__); - if (SQL_NUMROWS($result_pool) == 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 = countSumTotalData($stats_id, 'user_links', 'userid', 'stats_id', true); + $links = countSumTotalData($stats_id, 'user_links', 'userid', 'stats_id', TRUE); // Reset sent mails for recipient(s) - reduceRecipientReceivedMails('stats_id', getRequestParameter('mid'), $links); + reduceRecipientReceivedMails('stats_id', getRequestElement('id'), $links); // Calc total points and pay them back $totalPoints = $links * $content['price']; @@ -109,130 +102,123 @@ LIMIT 1", } // END - if // Pay back points - //* DEBUG: */ debugOutput('PAYBACK:'.$content['sender']); - addPointsDirectly('mail_deleted', $content['sender'], $totalPoints); + initReferralSystem(); + addPointsThroughReferralSystem('mail_deleted', $content['sender'], $totalPoints); // Output message if (getConfig('repay_deleted_mails') == 'REPAY') { // Repayed - displayMessage(getMaskedMessage('ADMIN_POINTS_REPAYED', - '{%pipe,translateComma=' . $totalPoints . '%}' - )); + displayMessage('{%message,ADMIN_POINTS_REPAYED=' . $totalPoints . '%}'); } else { // To jackpot - displayMessage(getMaskedMessage('ADMIN_POINTS_TO_JACKPOT', - '{%pipe,translateComma=' . $totalPoints . '%}' - )); + displayMessage('{%message,ADMIN_POINTS_TO_JACKPOT=' . $totalPoints . '%}'); } } else { // Points shredded! - displayMessage(getMaskedMessage('ADMIN_POINTS_SHREDDED', '{%pipe,translateComma=' . $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__); - $count += SQL_AFFECTEDROWS(); + $count += sqlAffectedRows(); // Load template for link - displayMessage('{--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(getRequestParameter('mid'))), __FILE__, __LINE__); - $count += 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 - outputHtml(getMaskedMessage('ADMIN_DELETED_MAILS_COUNT', $count)); + outputHtml('{%message,ADMIN_DELETED_MAILS_COUNT=' . $count . '%}'); } else { // Mail already deleted! displayMessage('{--ADMIN_NORMAL_MAIL_ALREADY_DELETED--}'); } // Free result - SQL_FREERESULT($result); -} elseif (isGetRequestParameterSet('pid')) { + 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(getRequestParameter('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 displayMessage('{--ADMIN_USER_STATS_REMOVED--}'); -} elseif ((isGetRequestParameterSet('bid')) && (isExtensionActive('bonus'))) { +} 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 LIMIT 1", - array(bigintval(getRequestParameter('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 - $content = SQL_FETCHARRAY($result); + $content = sqlFetchArray($result); // Reset sent mails for recipient(s) - reduceRecipientReceivedMails('bonus_id', getRequestParameter('bid'), $content['mails_sent']); + reduceRecipientReceivedMails('bonus_id', getRequestElement('id'), $content['mails_sent']); // Init counter for deleted mails $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(getRequestParameter('bid'))), __FILE__, __LINE__); - $count += SQL_AFFECTEDROWS(); - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s", - array(bigintval(getRequestParameter('bid'))), __FILE__, __LINE__); - $count += 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 - $content['timestamp'] = generateDateTime($content['timestamp'], 0); - $content['cnt'] = $count; + $content['timestamp'] = generateDateTime($content['timestamp'], '0'); + $content['count'] = $count; // Load template - loadTemplate('admin_delete_email_bonus', false, $content); + loadTemplate('admin_delete_email_bonus', FALSE, $content); } else { // Mail already deleted! displayMessage('{--ADMIN_BONUS_MAIL_ALREADY_DELETED--}'); } - - // Free result - SQL_FREERESULT($result); -} elseif ((isGetRequestParameterSet('nid')) && (isExtensionInstalledAndNewer('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 LIMIT 1", - array(bigintval(getRequestParameter('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 - $content = SQL_FETCHARRAY($result); + $content = sqlFetchArray($result); // Init counter for deleted mails $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(getRequestParameter('nid'))), __FILE__, __LINE__); - $count += SQL_AFFECTEDROWS(); - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `bonus_id`=%s", - array(bigintval(getRequestParameter('nid'))), __FILE__, __LINE__); - $count += 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 - $content['timestamp'] = generateDateTime($content['timestamp'], 0); - $content['cnt'] = $count; + $content['timestamp'] = generateDateTime($content['timestamp'], '0'); + $content['count'] = $count; // Load template - loadTemplate('admin_delete_email_notify', false, $content); + loadTemplate('admin_delete_email_notify', FALSE, $content); } else { // Mail already deleted! displayMessage('{--ADMIN_NOTIFY_MAIL_ALREADY_DELETED--}'); } // Free result - SQL_FREERESULT($result); + sqlFreeResult($result); } else { // No mail orders fond displayMessage('{--ADMIN_WRONG_CALL--}');