X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Fmodules%2Fadmin%2Fwhat-email_archiv.php;h=df2f81324e3da856b18fe65772680971faeb9bb9;hb=6b35670152207024eac824879ceeffdaf847c972;hp=d6338d6fe1e7413983e847d6bf5a9afcc6ec6243;hpb=4c221b6350439b8f91db58f142f03f79014f2eaf;p=mailer.git diff --git a/inc/modules/admin/what-email_archiv.php b/inc/modules/admin/what-email_archiv.php index d6338d6fe1..df2f81324e 100644 --- a/inc/modules/admin/what-email_archiv.php +++ b/inc/modules/admin/what-email_archiv.php @@ -48,7 +48,7 @@ addYouAreHereLink('admin', __FILE__); // 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 @@ -86,7 +86,7 @@ if (!SQL_HASZERONUMS($result)) { $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 @@ -96,7 +96,7 @@ if (!SQL_HASZERONUMS($result)) { 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);