X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-email_details.php;h=83150be3e37d825c1db78dc6b40cdc1825eaab14;hb=5fb5a921c011a3c1778b4abc4645530a5de50f59;hp=c761546c94d512b27e7dfaad86de1d683ced90e1;hpb=f2aeaab0cd313b2eeb151642455ed558f6b186dc;p=mailer.git diff --git a/inc/modules/admin/what-email_details.php b/inc/modules/admin/what-email_details.php index c761546c94..83150be3e3 100644 --- a/inc/modules/admin/what-email_details.php +++ b/inc/modules/admin/what-email_details.php @@ -65,10 +65,10 @@ WHERE ORDER BY `timestamp` DESC"; -$WHO = '{--_ALL--}'; +$WHO = ''; $SQL2 = ''; -if (isGetRequestParameterSet(('mid'))) { +if (isGetRequestParameterSet('mid')) { // Only a specific mail shall be displayed $sql = sprintf("SELECT `id`, `sender`, `subject`, `text`, `receivers`, `payment_id`, `data_type`, `timestamp`, `url`, `target_send`, `cat_id` @@ -98,10 +98,10 @@ ORDER BY // Init result_bonus $result_bonus = false; -if ((isExtensionActive('bonus')) && ($WHO == getMessage('_ALL'))) { +if ((isExtensionActive('bonus')) && (empty($WHO))) { // Check for maximum pages $result_bonus = SQL_QUERY("SELECT - `id`, `subject`, `text`, `receivers`, `points`, `time`, `data_type`, `timestamp`, `url`, `cat_id`, `target_send`, `mails_sent`, `clicks` + `id`, `subject`, `text`, `receivers`, `points`, `time`, `data_type`, `timestamp`, `url`, `cat_id`, `target_send`, `mails_sent`, `clicks`, (`mails_sent` - `clicks`) AS `unconfirmed` FROM `{?_MYSQL_PREFIX?}_bonus` @@ -128,7 +128,7 @@ if (!isGetRequestParameterSet('offset')) { } // END - if // Add limitation to SQL string -if (!isGetRequestParameterSet(('mid'))) { +if (!isGetRequestParameterSet('mid')) { // Create limitation line $add = ' LIMIT ' . (bigintval(getRequestParameter('offset')) * bigintval(getRequestParameter('page')) - bigintval(getRequestParameter('offset'))) . ', ' . bigintval(getRequestParameter('offset')); @@ -141,7 +141,7 @@ if (!isGetRequestParameterSet(('mid'))) { // Run SQL query for normal mails $result_list = SQL_QUERY($sql, __FILE__, __LINE__); -if ((!empty($SQL2)) && ($WHO == getMessage('_ALL'))) $result_bonus = SQL_QUERY($SQL2, __FILE__, __LINE__); +if ((!empty($SQL2)) && (empty($WHO))) $result_bonus = SQL_QUERY($SQL2, __FILE__, __LINE__); // Calculate pages $numPages = '0'; @@ -153,7 +153,7 @@ if (isConfigEntrySet('mails_page')) { SQL_FREERESULT($result_normal); $MAIL = false; -if (SQL_NUMROWS($result_list) > 0) { +if (!SQL_HASZERONUMS($result_list)) { // Init rows $OUT = ''; @@ -193,15 +193,15 @@ if (SQL_NUMROWS($result_list) > 0) { loadTemplate('admin_list_emails', false, $content); $MAIL = true; - if ((isExtensionActive('bonus')) && ($WHO == getMessage('_ALL'))) { + if ((isExtensionActive('bonus')) && (empty($WHO))) { // Only check if bonus extension is active - if (SQL_NUMROWS($result_bonus) > 0) outputHtml('

'); + if (!SQL_HASZERONUMS($result_bonus)) outputHtml('

'); } // END - if } -if ((isExtensionActive('bonus')) && ($WHO == getMessage('_ALL'))) { +if ((isExtensionActive('bonus')) && (empty($WHO))) { // Load bonus mails only when extension is active - if (SQL_NUMROWS($result_bonus) > 0) { + if (!SQL_HASZERONUMS($result_bonus)) { // Calculate pages $numPages = round(SQL_NUMROWS($result_bonus) / getConfig('mails_page') + 0.5);