A lot while() conditions rewritten to SQL_FETCHARRAY(), see bug #107, @TODO tags...

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

diff --git a/inc/libs/autopurge_functions.php b/inc/libs/autopurge_functions.php
index f557eac2c50975c82678b38e1ccd5be15d8cc9bb..71fec0aa33b6023a2438fdcedd0f0a3b05d06d61 100644 (file)
--- a/inc/libs/autopurge_functions.php
+++ b/inc/libs/autopurge_functions.php
@@ -38,11 +38,9 @@ if (!defined('__SECURITY')) {
 }
 
 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",
-               array(bigintval($uid)), __FILE__, __LINE__);
+       $result = SQL_QUERY_ESC("SELECT ref_payout FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
+               array(bigintval($uid)), __FUNCTION__, __LINE__);
        list($payout) = SQL_FETCHROW($result);
        SQL_FREERESULT($result);
 
@@ -62,8 +60,8 @@ 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",
-                       array($target, $target, $points, bigintval($uid)), __FILE__, __LINE__);
+               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)), __FUNCTION__, __LINE__);
 
                // Update mediadata as well
                if ((GET_EXT_VERSION("mediadata") >= "0.0.4") && ($target == "points")) {