Reset rewritten, SQL fixed, zeros are now numeric

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

diff --git a/inc/libs/autopurge_functions.php b/inc/libs/autopurge_functions.php
index f6bd9f340bca07b3615d4c5c1284a4117442beb0..1b20a242ea13ed78023ca009f47dacfb96b530fa 100644 (file)
--- a/inc/libs/autopurge_functions.php
+++ b/inc/libs/autopurge_functions.php
@@ -42,7 +42,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=%d 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);
@@ -61,13 +61,13 @@ function AUTOPURGE_ADD_POINTS($uid, $points)
        {
                // ... to jackpot account
                ADD_JACKPOT($points);
-               if (empty($jackpot)) $jackpot = "0";
+               if (empty($jackpot)) $jackpot = 0;
                $jackpot += $points;
        }
         else
        {
                // .. to user's account
-               $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET %s=%s+%s WHERE userid=%d AND ref_depth=0 LIMIT 1",
+               $result = 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