All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...

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

diff --git a/inc/modules/admin/what-list_unconfirmed.php b/inc/modules/admin/what-list_unconfirmed.php
index ba8c54288a4bb9a0e53068752527022f76880678..fb32ef6874a285843f8ec41fd19b33e83783ce77 100644 (file)
--- a/inc/modules/admin/what-list_unconfirmed.php
+++ b/inc/modules/admin/what-list_unconfirmed.php
@@ -52,8 +52,8 @@ if (!empty($_GET['mid']))
        define('__LIST_UNCON_TITLE', LIST_UNCONFIRMED_MEMBER_LINKS);
 
        // SQL query for mail data
-       $SQL = "SELECT DISTINCT s.id, p.sender, p.subject, p.text, p.url, p.timestamp, s.max_rec  FROM "._MYSQL_PREFIX."_pool AS p
-LEFT JOIN "._MYSQL_PREFIX."_user_stats AS s
+       $SQL = "SELECT DISTINCT s.id, p.sender, p.subject, p.text, p.url, p.timestamp, s.max_rec  FROM `{!MYSQL_PREFIX!}_pool` AS p
+LEFT JOIN `{!MYSQL_PREFIX!}_user_stats` AS s
 ON p.id=s.pool_id
 WHERE p.id='".$_GET['mid']."' LIMIT 1";
 
@@ -69,7 +69,7 @@ WHERE p.id='".$_GET['mid']."' LIMIT 1";
        define('__LIST_UNCON_TITLE', LIST_UNCONFIRMED_BONUS_LINKS);
 
        // SQL query for mail data (both ids are required for compatiblity to above normal mail
-       $SQL = "SELECT id, id, subject, text, url, timestamp, mails_sent FROM "._MYSQL_PREFIX."_bonus WHERE id='".$_GET['bid']."' LIMIT 1";
+       $SQL = "SELECT id, id, subject, text, url, timestamp, mails_sent FROM `{!MYSQL_PREFIX!}_bonus` WHERE id='".$_GET['bid']."' LIMIT 1";
 
        // Column, type and ID for member's mail
        $col = "bonus_id"; $type = "BONUS"; $ID = $_GET['bid'];
@@ -108,8 +108,8 @@ if ($listed)
                // accounts. So if you have delete one you did not see those links
                //
                $result = SQL_QUERY_ESC("SELECT DISTINCT l.userid, u.status, u.surname, u.family, u.gender, u.email
-FROM "._MYSQL_PREFIX."_user_links AS l
-LEFT JOIN `"._MYSQL_PREFIX."_user_data` AS u
+FROM `{!MYSQL_PREFIX!}_user_links` AS l
+LEFT JOIN `{!MYSQL_PREFIX!}_user_data` AS u
 ON l.userid=u.userid
 WHERE l.%s='%s' ORDER BY l.userid LIMIT %s",
                        array($col, $ID, bigintval($max)),__FILE__, __LINE__);
@@ -158,9 +158,9 @@ WHERE l.%s='%s' ORDER BY l.userid LIMIT %s",
         elseif ($_GET['mid'] > 0)
        {
                // Data in pool or in user_stats not found, so let's find out where data is missing
-               $result1 = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_pool WHERE id=%s LIMIT 1",
+               $result1 = SQL_QUERY_ESC("SELECT id FROM `{!MYSQL_PREFIX!}_pool` WHERE id=%s LIMIT 1",
                 array(bigintval($ID)), __FILE__, __LINE__);
-               $result2 = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_user_stats WHERE pool_id=%s LIMIT 1",
+               $result2 = SQL_QUERY_ESC("SELECT id FROM `{!MYSQL_PREFIX!}_user_stats` WHERE pool_id=%s LIMIT 1",
                 array(bigintval($ID)), __FILE__, __LINE__);
                if (SQL_NUMROWS($result1) == 1)
                {