query masking rewritten in more SQLs, several cleanups and fix on beg link

[mailer.git] / inc / pool-update.php

diff --git a/inc/pool-update.php b/inc/pool-update.php
index fabbcbdb0e1093121092b82e4555fa8b4ff157e0..573af01bf9b41b056d4a0dd965ef85ce289176fb 100644 (file)
--- a/inc/pool-update.php
+++ b/inc/pool-update.php
@@ -60,7 +60,7 @@ if (SQL_NUMROWS($result_main) > 0)
        while ($DATA = SQL_FETCHROW($result_main))
        {
                // Check fetched data for HTML
-               $HTML = $DATA[10]; if ($HTML == $DATA[0]) $HTML = "N";
+               $HTML = $DATA[10]; if ($HTML == $DATA[0]) $HTML = 'N';
 
                // Compile URL and subject line
                $DATA[7] = COMPILE_CODE($DATA[7]);
@@ -259,7 +259,7 @@ if (SQL_NUMROWS($result_main) > 0)
                                                {
                                                        // User does not exists, pay points back
                                                        $POINTS = GET_PAY_POINTS($DATA[5]);
-                                                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+%s WHERE userid=%d AND ref_depth='0' LIMIT 1",
+                                                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+%s WHERE userid=%d AND ref_depth=0 LIMIT 1",
                                                         array($POINTS, bigintval($DATA[1])), __FILE__, __LINE__);
 
                                                        // Update mediadata as well