Login form for guests in surfbar added, some trigger_error() added, misc rewrites

[mailer.git] / inc / modules / admin / what-email_archiv.php

diff --git a/inc/modules/admin/what-email_archiv.php b/inc/modules/admin/what-email_archiv.php
index 961edaec7e49d140959019b1dde541685115ec58..083402062f66e90aa288f87f3380cbda3fd0c0b4 100644 (file)
--- a/inc/modules/admin/what-email_archiv.php
+++ b/inc/modules/admin/what-email_archiv.php
@@ -51,14 +51,14 @@ ADD_DESCR('admin', __FILE__);
 //             0     1        2      3        4          5           6          7      8         9        10
 $sql = "SELECT id, sender, subject, text, receivers, payment_id, data_type, timestamp, url, target_send, cat_id
  FROM `{!_MYSQL_PREFIX!}_pool`
- WHERE data_type='SEND' OR data_type='DELETED'
+ WHERE `data_type`='SEND' OR `data_type`='DELETED'
  ORDER BY timestamp DESC";
 
 // Check for maximum pages
 $result_normal = SQL_QUERY($sql, __FILE__, __LINE__);
 
 // Set offset an current page to default values
-if (!REQUEST_ISSET_GET('page'))   REQUEST_SET_GET('page'  , "1");
+if (!REQUEST_ISSET_GET('page'))   REQUEST_SET_GET('page'  , '1');
 if (!REQUEST_ISSET_GET('offset')) REQUEST_SET_GET('offset', getConfig('mails_page'));
 
 // Add limitation to SQL string
@@ -76,8 +76,8 @@ if (SQL_NUMROWS($result) > 0) {
 
        // Add navigation table rows
        if ($PAGES > 1) {
-               define('__TOP_EMAIL_NAV'   , ADD_EMAIL_NAV($PAGES, getConfig('mails_page'), true , "3", true));
-               define('__BOTTOM_EMAIL_NAV', ADD_EMAIL_NAV($PAGES, getConfig('mails_page'), false, "3", true));
+               define('__TOP_EMAIL_NAV'   , ADD_EMAIL_NAV($PAGES, getConfig('mails_page'), true , '3', true));
+               define('__BOTTOM_EMAIL_NAV', ADD_EMAIL_NAV($PAGES, getConfig('mails_page'), false, '3', true));
        } else {
                define('__TOP_EMAIL_NAV'   , '');
                define('__BOTTOM_EMAIL_NAV', '');
@@ -87,7 +87,7 @@ if (SQL_NUMROWS($result) > 0) {
        while ($pool = SQL_FETCHROW($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",
-                       array(bigintval($pool[0])), __FILE__, __LINE__);
+               array(bigintval($pool[0])), __FILE__, __LINE__);
                list($sent, $clicks) = SQL_FETCHROW($result_mails);
                SQL_FREERESULT($result_mails);