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

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

diff --git a/inc/libs/autopurge_functions.php b/inc/libs/autopurge_functions.php
index f557eac2c50975c82678b38e1ccd5be15d8cc9bb..89abcf3deef75c61a67fe436968b9e9dc5b844ee 100644 (file)
--- a/inc/libs/autopurge_functions.php
+++ b/inc/libs/autopurge_functions.php
@@ -41,7 +41,7 @@ function AUTOPURGE_ADD_POINTS($uid, $points) {
        global $jackpot;
 
        // Check if he has locked points or not
-       $result = SQL_QUERY_ESC("SELECT ref_payout FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT ref_payout FROM `{!MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
                array(bigintval($uid)), __FILE__, __LINE__);
        list($payout) = SQL_FETCHROW($result);
        SQL_FREERESULT($result);
@@ -62,7 +62,7 @@ function AUTOPURGE_ADD_POINTS($uid, $points) {
                $jackpot += $points;
        } else {
                // .. to user's account
-               SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET %s=%s+%s WHERE userid=%s AND ref_depth=0 LIMIT 1",
+               SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_user_points` SET %s=%s+%s WHERE userid=%s AND ref_depth=0 LIMIT 1",
                        array($target, $target, $points, bigintval($uid)), __FILE__, __LINE__);
 
                // Update mediadata as well