// 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
$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']), 'mid');
// Prepare data for the row template
$content['timestamp'] = generateDateTime($pool['timestamp'], 0);