X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-email_details.php;h=93eccb434375855a942c0dcb6c6a655860df627b;hb=e9da1508b2a3ccbf63adc999981674740a47e074;hp=0b2fe94e44d0d9a6514b5accc1f2e8bd598656b1;hpb=5071030af40e69ca4284642f44758964e18f5be8;p=mailer.git
diff --git a/inc/modules/admin/what-email_details.php b/inc/modules/admin/what-email_details.php
index 0b2fe94e44..93eccb4343 100644
--- a/inc/modules/admin/what-email_details.php
+++ b/inc/modules/admin/what-email_details.php
@@ -1,7 +1,7 @@
0) {
+$MAIL = FALSE;
+if (!ifSqlHasZeroNums($result_list)) {
// Init rows
- $OUT = ''; $content = array();
+ $OUT = '';
// Walk through all entries
- while ($pool = SQL_FETCHARRAY($result_list)) {
+ while ($content = sqlFetchArray($result_list)) {
// Unconfirmed mails and sent mails
- $result_uncon = SQL_QUERY_ESC("SELECT max_rec, clicks FROM `{!_MYSQL_PREFIX!}_user_stats` WHERE pool_id=%s LIMIT 1",
- array(bigintval($pool['id'])), __FILE__, __LINE__);
- list($pool['sent_email'], $pool['clicks']) = SQL_FETCHROW($result_uncon);
- SQL_FREERESULT($result_uncon);
+ $result_uncon = sqlQueryEscaped("SELECT (`max_rec` - `clicks`) AS `unconfirmed` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `pool_id`=%s LIMIT 1",
+ array(bigintval($content['id'])), __FILE__, __LINE__);
+
+ // Load and merge data
+ $content = merge_array($content, sqlFetchArray($result_uncon));
+
+ // Free result
+ sqlFreeResult($result_uncon);
// Unconfirmed mails
- $pool['unconfirmed'] = $pool['sent_email'] - $pool['clicks'];
- if ($pool['unconfirmed'] > 0) {
- // Add link to list_unconfirmed what-file
- $pool['unconfirmed'] = "".$pool['unconfirmed']."";
- } elseif ($pool['unconfirmed'] < 0) {
- // Sometimes rarely displayed minus values will be "fixed" to zero
- $pool['unconfirmed'] = 0;
- }
+ $content['unconfirmed'] = generateUnconfirmedAdminLink($content['id'], ($content['unconfirmed']), 'normal');
// Prepare content
- $content = $pool;
- $content['sender_link'] = generateUserProfileLink($pool['sender']);
- $content['subject'] = COMPILE_CODE($pool['subject']);
- $content['text'] = COMPILE_CODE($pool['text']);
- $content['payment'] = getPaymentTitlePrice($pool['payment_id']);
- $content['category'] = getCategory($pool['cat_id']);
- $content['receivers'] = str_replace(';', ", ", $pool['receivers']);
- $content['type'] = translatePoolType($pool['data_type']);
- $content['frametester'] = FRAMETESTER($pool['url']);
- $content['url'] = COMPILE_CODE($pool['url']);
- $content['timestamp'] = generateDateTime($pool['timestamp'], '0');
+ $content['timestamp'] = generateDateTime($content['timestamp'], 0);
// Load row template
- $OUT .= LOAD_TEMPLATE("admin_list_emails_row", true, $content);
+ $OUT .= loadTemplate('admin_list_emails_row', TRUE, $content);
} // END - while
// Free memory
- SQL_FREERESULT($result_list);
+ sqlFreeResult($result_list);
// Add navigation (with change box and colspan=3)
- $content['nav'] = '';
- if ($PAGES > 1) $content['nav'] = ADD_EMAIL_NAV($PAGES, getConfig('mails_page'), false, '3', true);
+ $content['nav'] = addEmailNavigation($numPages, getMailsPage(), FALSE, 3, TRUE);
// Prepare content
$content['rows'] = $OUT;
$content['who'] = $WHO;
// Mail orders are in pool so we can display them
- LOAD_TEMPLATE("admin_list_emails", false, $content);
+ loadTemplate('admin_list_emails', FALSE, $content);
- $MAIL = true;
- if ((EXT_IS_ACTIVE('bonus')) && ($WHO == _ALL)) {
- // Check only if bonus extension is active
- if (SQL_NUMROWS($result_bonus) > 0) OUTPUT_HTML("
");
- }
-}
+ $MAIL = TRUE;
+ if ((isExtensionActive('bonus')) && (empty($WHO))) {
+ // Only check if bonus extension is active
+ if (!ifSqlHasZeroNums($result_bonus)) outputHtml('
');
+ } // END - if
+} // END - if
-if ((EXT_IS_ACTIVE('bonus')) && ($WHO == _ALL)) {
+if ((isExtensionActive('bonus')) && (empty($WHO))) {
// Load bonus mails only when extension is active
- if (SQL_NUMROWS($result_bonus) > 0) {
+ if (!ifSqlHasZeroNums($result_bonus)) {
// Calculate pages
- $PAGES = round(SQL_NUMROWS($result_bonus) / getConfig('mails_page') + 0.5);
+ $numPages = round(sqlNumRows($result_bonus) / getMailsPage() + 0.5);
// List emails
- $OUT = ''; $content = array();
- while ($bonus = SQL_FETCHARRAY($result_bonus)) {
- // Calculate unconfirmed emails
- $bonus['unconfirmed'] = $bonus['mails_sent'] - $bonus['clicks'];
-
- // Add link?
- if ($bonus['unconfirmed'] > 0) {
- // Add link to list_unconfirmed what-file
- $bonus['unconfirmed'] = "".$bonus['unconfirmed']."";
- } // END - if
+ $OUT = '';
+ while ($content = sqlFetchArray($result_bonus)) {
+ // Add link to list_unconfirmed what-file
+ $content['unconfirmed'] = generateUnconfirmedAdminLink($content['id'], $content['unconfirmed'], 'bonus');
// Prepare content
- $content = $bonus;
- $content['time'] = createFancyTime($content['time']);
- $content['category'] = getCategory($content['cat_id']);
- $content['receivers'] = str_replace(';', ", ", $content['receivers']);
- $content['type'] = translatePoolType($content['data_type']);
- $content['frametester'] = FRAMETESTER($content['url']);
- $content['timestamp'] = generateDateTime($content['timestamp'], '0');
+ $content['timestamp'] = generateDateTime($content['timestamp'], 0);
// Load row template
- $OUT .= LOAD_TEMPLATE("admin_list_bonus_emails_row", true, $content);
+ $OUT .= loadTemplate('admin_list_bonus_emails_row', TRUE, $content);
} // END - while
// Add navigation (without change box but with colspan=3)
- $content['nav'] = '';
- if ($PAGES > 1) $content['nav'] = ADD_EMAIL_NAV($PAGES, getConfig('mails_page'), false, '3', true);
+ $content['nav'] = addEmailNavigation($numPages, getMailsPage(), FALSE, 3, TRUE);
// Prepare content
$content['rows'] = $OUT;
// Load main template
- LOAD_TEMPLATE("admin_list_bonus_emails", false, $content);
- $MAIL = true;
+ loadTemplate('admin_list_bonus_emails', FALSE, $content);
+ $MAIL = TRUE;
} // END - if
} // END - if
-if (!$MAIL) {
+if ($MAIL === FALSE) {
// No mail orders fond
- LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_NO_MAILS_IN_POOL'));
+ displayMessage('{--ADMIN_NO_MAILS_IN_POOL--}');
} // END - if
-//
+// [EOF]
?>