X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-unlock_emails.php;h=74384a2434c50551d10d758f531963eb0e6705d4;hp=0aea5c5dbd1df601b151ce102679ba32f5652e5e;hb=cf3765c38cf0a76f396aca291f71858936e92956;hpb=fb7120ffa230b62b54895bcf95952e1cf30f8594 diff --git a/inc/modules/admin/what-unlock_emails.php b/inc/modules/admin/what-unlock_emails.php index 0aea5c5dbd..74384a2434 100644 --- a/inc/modules/admin/what-unlock_emails.php +++ b/inc/modules/admin/what-unlock_emails.php @@ -1,7 +1,7 @@ 0) || (REQUEST_ISSET_POST(('lock')))) { - // Count checked checkboxes - $SEL = 0; - if (REQUEST_ISSET_POST('sel')) { - // Are there checked boxes? - if (count(REQUEST_POST('sel')) > 0) { - // Count now... We use an own function for now - $SEL = SELECTION_COUNT(REQUEST_POST('sel')); - } // END - if - } // END - if - - if (REQUEST_ISSET_POST(('accept'))) { - if ($SEL > 0) { +$result_main = SQL_QUERY("SELECT + `id`, `sender`, `subject`, `payment_id`, `timestamp`, `url`, `target_send`, `cat_id` +FROM + `{?_MYSQL_PREFIX?}_pool` +WHERE + `data_type`='ADMIN' +ORDER BY + `timestamp` ASC", __FILE__, __LINE__); + +if ((SQL_NUMROWS($result_main) > 0) || (isFormSent('lock'))) { + if (isFormSent('accept')) { + if (countPostSelection() > 0) { // Accept mail orders - foreach (REQUEST_POST('sel') as $id => $value) { - // Secure ID number + foreach (postRequestParameter('sel') as $id => $value) { + // Secure id number $id = bigintval($id); // Order placed in queue... - $result = SQL_QUERY_ESC("SELECT po.url, po.subject, po.sender, pay.payment, po.payment_id -FROM `{!_MYSQL_PREFIX!}_pool` AS po -INNER JOIN `{!_MYSQL_PREFIX!}_payments` AS pay -ON po.payment_id=pay.id -WHERE po.id=%s + $result = SQL_QUERY_ESC("SELECT + po.url, po.subject, po.sender, pay.payment, po.payment_id +FROM + `{?_MYSQL_PREFIX?}_pool` AS po +INNER JOIN + `{?_MYSQL_PREFIX?}_payments` AS pay +ON + po.payment_id=pay.id +WHERE + po.id=%s LIMIT 1", array($id), __FILE__, __LINE__); // Update wents fine? if (SQL_NUMROWS($result) == 1) { // Load data - $DATA = SQL_FETCHARRAY($result); + $content = SQL_FETCHARRAY($result); // Free result SQL_FREERESULT($result); // Is the surfbar installed? - if ((EXT_IS_ACTIVE("surfbar")) && (getConfig('surfbar_migrate_order') == "Y")) { + // @TODO Rewrite these if-blocks to a filter + if ((isExtensionActive('surfbar')) && (getConfig('surfbar_migrate_order') == 'Y')) { // Then "migrate" the URL to the surfbar - SURFBAR_ADMIN_MIGRATE_URL($DATA['url'], $DATA['sender']); + SURFBAR_ADMIN_MIGRATE_URL($content['url'], $content['sender']); } // END - if // Check for bonus extension version >= 0.4.4 for the order bonus - if ((GET_EXT_VERSION("bonus") >= "0.4.4") && (getConfig('bonus_active') == "Y")) { + if ((isExtensionInstalledAndNewer('bonus', '0.4.4')) && (getConfig('bonus_active') == 'Y')) { // Add points directly - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET bonus_order=bonus_order+".getConfig('bonus_order')." WHERE userid=%s LIMIT 1", - array(bigintval($DATA['sender'])), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `bonus_order`=`bonus_order`+{?bonus_order?} WHERE `userid`=%s LIMIT 1", + array(bigintval($content['sender'])), __FILE__, __LINE__); // Subtract bonus points from system - BONUS_POINTS_HANDLER(getConfig('bonus_order')); + handleBonusPoints(getConfig('bonus_order')); } // END - if // Load email template - $msg_user = LOAD_EMAIL_TEMPLATE("order-accept", array(), $DATA['sender']); + $message_user = loadEmailTemplate('order-accept', $content, $content['sender']); // Send email - SEND_EMAIL($DATA['sender'], MEMBER_ORDER_ACCEPTED, $msg_user); + sendEmail($content['sender'], '{--MEMBER_ORDER_ACCEPTED--}', $message_user); // Unlock selected email - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_pool` SET data_type='NEW' WHERE id=%s AND data_type='ADMIN' LIMIT 1", + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_pool` SET `data_type`='NEW' WHERE `id`=%s AND `data_type`='ADMIN' LIMIT 1", array($id), __FILE__, __LINE__); } // END - if } // END - foreach // Set message - $MSG = ADMIN_MAILS_ACTIVATED; + $message = '{--ADMIN_MAILS_ACTIVATED--}'; } else { // Nothing checked! - $MSG = ADMIN_MAILS_NOTHING_CHECKED; + $message = '{--ADMIN_MAILS_NOTHING_CHECKED--}'; } // Mails unlocked for mail delivery - LOAD_TEMPLATE("admin_settings_saved", false, $MSG); - } elseif (REQUEST_ISSET_POST(('reject'))) { - if ($SEL > 0) { + loadTemplate('admin_settings_saved', false, $message); + } elseif (isPostRequestParameterSet(('reject'))) { + if (countPostSelection() > 0) { // Reject mail orders - $OUT = ""; $SW = 2; - foreach (REQUEST_POST('sel') as $id => $value) { - // Secure ID number + $OUT = ''; + foreach (postRequestParameter('sel') as $id => $value) { + // Secure id number $id = bigintval($id); // Load URL and subject from pool - $result = SQL_QUERY_ESC("SELECT url, subject, sender FROM `{!_MYSQL_PREFIX!}_pool` WHERE id=%s LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `url`, `subject`, `sender` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s LIMIT 1", array($id), __FILE__, __LINE__); // Load data - $DATA = SQL_FETCHARRAY($result); + $content = SQL_FETCHARRAY($result); // Free result SQL_FREERESULT($result); // Load email template and send it away - $msg_user = LOAD_EMAIL_TEMPLATE("order-reject", array(), $DATA['sender']); - SEND_EMAIL($DATA['sender'], MEMBER_ORDER_REJECTED, $msg_user); + $message_user = loadEmailTemplate('order-reject', $content, $content['sender']); + sendEmail($content['sender'], '{--MEMBER_ORDER_REJECTED--}', $message_user); // If you do not enter an URL to redirect to, your URL will be set! - if ((!REQUEST_ISSET_POST(('redirect'))) || (REQUEST_POST('redirect') == "http://")) REQUEST_SET_POST('redirect', constant('URL')); + if ((!isPostRequestParameterSet('redirect')) || (postRequestParameter('redirect') == 'http://')) setPostRequestParameter('redirect', getConfig('URL')); // Redirect URL - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_pool` SET url='%s', data_type='NEW' WHERE id=%s LIMIT 1", - array(REQUEST_POST('redirect'), $id),__FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_pool` SET url='%s', `data_type`='NEW' WHERE `id`=%s LIMIT 1", + array(postRequestParameter('redirect'), $id),__FILE__, __LINE__); // Prepare data for the row template $content = array( - 'sw' => $SW, 'id' => $id, - 'url' => REQUEST_POST('url', $id), + 'url' => postRequestParameter('url', $id), ); // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_unlock_emails_redir_row", true, $content); - $SW = 3 - $SW; - } - define('__URL_ROWS', $OUT); + $OUT .= loadTemplate('admin_unlock_emails_redir_row', true, $content); + } // END - foreach // Load main template - LOAD_TEMPLATE("admin_unlock_emails_redir"); + loadTemplate('admin_unlock_emails_redir', false, $OUT); } else { // Nothing selected - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_MAILS_NOTHING_CHECKED')); + loadTemplate('admin_settings_saved', false, '{--ADMIN_MAILS_NOTHING_CHECKED--}'); } - } elseif ((REQUEST_ISSET_POST(('lock'))) && ($SEL > 0) && (getConfig('url_blacklist') == "Y")) { + } elseif ((isFormSent('lock')) && (countPostSelection() > 0) && (getConfig('url_blacklist') == 'Y')) { // Lock URLs - foreach (REQUEST_POST('sel') as $id => $url) { + foreach (postRequestParameter('sel') as $id => $url) { // Secure id number $id = bigintval($id); // Lookup in blacklist - $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_url_blacklist` WHERE `url`='%s' LIMIT 1", + $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_url_blacklist` WHERE `url`='%s' LIMIT 1", array($url), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 0) { + if (SQL_HASZERONUMS($result)) { // Did not find a record so we can add it... :) - SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_url_blacklist` (`url`,`pool_id`) VALUES ('%s',%s)", + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_url_blacklist` (`url`,`pool_id`) VALUES ('%s',%s)", array($url, $id), __FILE__, __LINE__); } // END - if @@ -194,55 +188,37 @@ LIMIT 1", } // END - foreach // Output message - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_URLS_BLOCKED')); - } elseif ((!REQUEST_ISSET_POST(('lock'))) && (!REQUEST_ISSET_POST(('accept'))) && (!REQUEST_ISSET_POST(('reject'))) && (getConfig('url_blacklist') == "Y")) { + loadTemplate('admin_settings_saved', false, '{--ADMIN_URLS_BLOCKED--}'); + } elseif ((!isFormSent('lock')) && (!isFormSent('accept')) && (!isFormSent('reject'))) { // Mail orders are in pool so we can display them - $OUT = ""; $SW = 2; + $OUT = ''; while ($content = SQL_FETCHARRAY($result_main)) { // Prepare data for the template - $content = array( - 'sw' => $SW, - 'id' => $content['id'], - 'sender' => $content['sender'], - 'u_link' => ADMIN_USER_PROFILE_LINK($content['sender']), - 'subj' => COMPILE_CODE($content['subject']), - 'tester' => FRAMETESTER($content['url']), - 'url' => $content['url'], - 'cat_title' => str_replace("\"", """, GET_CATEGORY($content['category'])), - 'cat_link' => $content['category'], - 'pay_title' => str_replace("\"", """, GET_PAYMENT($content['payment'], true)), - 'pay_link' => $content['payment'], - 'ordered' => MAKE_DATETIME($content['timestamp'], "2"), - 'tsend' => $content['target_send'], - ); + $content['timestamp'] = generateDateTime($content['timestamp'], 2); // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_unlock_emails_row", true, $content); - $SW = 3 - $SW; + $OUT .= loadTemplate('admin_unlock_emails_row', true, $content); } // END - while // Free memory SQL_FREERESULT($result_main); - define('__UNLOCK_ROWS', $OUT); - // Prepare rejection URL - $REJECT = "http://"; - if (GET_EXT_VERSION("other") >= "0.1.6") $REJECT = getConfig('reject_url'); - define('__REJECT_URL', $REJECT); + // Remember in array + $content['rows'] = $OUT; // Load main template - LOAD_TEMPLATE("admin_unlock_emails"); - } elseif ((REQUEST_ISSET_POST(('lock'))) && (getConfig('url_blacklist') != "Y")) { + loadTemplate('admin_unlock_emails', false, $content); + } elseif ((isFormSent('lock')) && (getConfig('url_blacklist') != 'Y')) { // URL blacklist not activated - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_URL_BLACKLIST_DISABLED')); + loadTemplate('admin_settings_saved', false, '{--ADMIN_URL_BLACKLIST_DISABLED--}'); } else { // Wrong call! - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_WRONG_CALL')); + loadTemplate('admin_settings_saved', false, '{--ADMIN_WRONG_CALL--}'); } } else { // No mail orders fond - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_NO_MAILS_IN_POOL')); + loadTemplate('admin_settings_saved', false, '{--ADMIN_NO_MAILS_IN_POOL--}'); } -// +// [EOF] ?>