HTML->XHTML preparation (still *A LOT* to convert

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

diff --git a/inc/libs/autopurge_functions.php b/inc/libs/autopurge_functions.php
index 7305ba5d4f8510b29eca159513511384bf90e05f..f557eac2c50975c82678b38e1ccd5be15d8cc9bb 100644 (file)
--- a/inc/libs/autopurge_functions.php
+++ b/inc/libs/autopurge_functions.php
@@ -37,41 +37,36 @@ if (!defined('__SECURITY')) {
        require($INC);
 }
 
-function AUTOPURGE_ADD_POINTS($uid, $points)
-{
+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)), __FILE__, __LINE__);
        list($payout) = SQL_FETCHROW($result);
        SQL_FREERESULT($result);
-       if (($payout > 0) && (!empty($payout)))
-       {
+
+       if (($payout > 0) && (!empty($payout))) {
                // Yes, he has.
                $target = "locked_points";
-       }
-        elseif ($payout == "0")
-       {
+       } elseif ($payout == "0") {
                // No, he has not
                $target = "points";
        }
+
        // Add points...
-       if (empty($payout))
-       {
+       if (empty($payout)) {
                // ... to jackpot account
                ADD_JACKPOT($points);
                if (empty($jackpot)) $jackpot = 0;
                $jackpot += $points;
-       }
-        else
-       {
+       } else {
                // .. to user's account
-               $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__);
+               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
-               if ((GET_EXT_VERSION("mediadata") >= "0.0.4") && ($target == "points"))
-               {
+               if ((GET_EXT_VERSION("mediadata") >= "0.0.4") && ($target == "points")) {
                        // Update database
                        MEDIA_UPDATE_ENTRY(array("total_points"), "add", $points);
                }