// Init SQL
$sql = "SELECT
- `id`,`sender`,`subject`,`text`,`receivers`,`payment_id`,`data_type`,`timestamp`,`url`,`target_send`,`cat_id`
+ `id`,
+ `sender`,
+ `subject`,
+ `text`,
+ `receivers`,
+ `payment_id`,
+ `data_type`,
+ `timestamp`,
+ `url`,
+ `target_send`,
+ `cat_id`
FROM
`{?_MYSQL_PREFIX?}_pool`
WHERE
// Mail orders are in pool so we can display them
// Add navigation table rows
- $content['top_email_nav'] = addEmailNavigation($numPages, getMailsPage(), true , 3, true);
- $content['bottom_email_nav'] = addEmailNavigation($numPages, getMailsPage(), false, 3, true);
+ $content['top_email_nav'] = addEmailNavigation($numPages, getMailsPage(), TRUE , 3, TRUE);
+ $content['bottom_email_nav'] = addEmailNavigation($numPages, getMailsPage(), FALSE, 3, TRUE);
// List all entries
$OUT = '';
while ($pool = SQL_FETCHARRAY($result)) {
// Check sent mails and clicks
- $result_mails = SQL_QUERY_ESC("SELECT `max_rec`,`clicks` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `pool_id`=%s LIMIT 1",
+ $result_mails = SQL_QUERY_ESC("SELECT `max_rec`, `clicks` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `pool_id`=%s LIMIT 1",
array(bigintval($pool['id'])), __FILE__, __LINE__);
// Load entries
SQL_FREERESULT($result_mails);
// Unconfirmed mails
- $pool['unconfirmed'] = generateUnconfirmedAdminLink($pool['id'], ($pool['max_rec'] - $pool['clicks']), 'mid');
+ $pool['unconfirmed'] = generateUnconfirmedAdminLink($pool['id'], ($pool['max_rec'] - $pool['clicks']), 'normal');
// Prepare data for the row template
$content['timestamp'] = generateDateTime($pool['timestamp'], 0);
$content = merge_array($content, $pool);
// Load row template and switch colors
- $OUT .= loadTemplate('admin_email_archiv_row', true, $content);
+ $OUT .= loadTemplate('admin_email_archiv_row', TRUE, $content);
} // END - while
// Remmber generated rows in array
$content['rows'] = $OUT;
// Load main template
- loadTemplate('admin_email_archiv', false, $content);
+ loadTemplate('admin_email_archiv', FALSE, $content);
} else {
// No mail orders fond
displayMessage('{--ADMIN_NO_MAILS_IN_POOL--}');