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

[mailer.git] / inc / libs / doubler_functions.php

diff --git a/inc/libs/doubler_functions.php b/inc/libs/doubler_functions.php
index 424df56ef6f3cd858ce273a11a3b39e937ede8ed..f80d13630d12a2324943b70e3ece7a4307debcf2 100644 (file)
--- a/inc/libs/doubler_functions.php
+++ b/inc/libs/doubler_functions.php
@@ -67,7 +67,7 @@ function DOUBLER_GENERATE_TABLE ($uid="0", $done='N', $ref='N', $sort="ASC") {
 
        // List entries
        $result = SQL_QUERY("SELECT userid, refid, points, timemark
-FROM "._MYSQL_PREFIX."_doubler
+FROM `{!MYSQL_PREFIX!}_doubler`
 WHERE completed='".$done."' AND is_ref='".$ref."'".$ADD."
 ORDER BY timemark ".$sort."
 LIMIT ".$limit, __FILE__, __LINE__);
@@ -123,7 +123,7 @@ function DOUBLER_GET_TOTAL_POINTS_LEFT() {
 
        if (getConfig('doubler_jackpot') == "Y") {
                // Load jackpot
-               $result = SQL_QUERY("SELECT points FROM "._MYSQL_PREFIX."_jackpot WHERE ok='ok' LIMIT 1", __FILE__, __LINE__);
+               $result = SQL_QUERY("SELECT points FROM `{!MYSQL_PREFIX!}_jackpot` WHERE ok='ok' LIMIT 1", __FILE__, __LINE__);
                list($jackpot) = SQL_FETCHROW($result);
                SQL_FREERESULT($result);