More SQL rewrites, TODO: Put all table and column names in backticks (`)

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

diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php
index 433dc73a03bc8c51f61d50dbf018db8d8b0679ff..9cc7e7e9959f2daaa632c53d133876b345daf735 100644 (file)
--- a/inc/libs/surfbar_functions.php
+++ b/inc/libs/surfbar_functions.php
@@ -504,7 +504,7 @@ function SURFBAR_HANDLE_LOW_POINTS () {
                        SURFBAR_NOTIFY_USER("low_points", $content);
 
                        // Update last notified
-                       SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET surfbar_low_notified=NOW() WHERE userid=%s LIMIT 1",
+                       SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET surfbar_low_notified=NOW() WHERE userid=%s LIMIT 1",
                                array($uid), __FILE__, __LINE__);
                } // END - if
        } // END - foreach
@@ -1122,7 +1122,7 @@ function SURFBAR_DETERMINE_DEPLETED_USERIDS ($limit=0) {
                // Get all userid except logged in one
                $result = SQL_QUERY_ESC("SELECT u.userid, UNIX_TIMESTAMP(d.surfbar_low_notified) AS notified
 FROM "._MYSQL_PREFIX."_surfbar_urls AS u
-INNER JOIN "._MYSQL_PREFIX."_user_data AS d
+INNER JOIN `"._MYSQL_PREFIX."_user_data` AS d
 ON u.userid=d.userid
 WHERE u.userid NOT IN (%s,0) AND u.status='ACTIVE'
 GROUP BY u.userid
@@ -1132,7 +1132,7 @@ ORDER BY u.userid ASC",
                // Get all userid
                $result = SQL_QUERY("SELECT u.userid, UNIX_TIMESTAMP(d.surfbar_low_notified) AS notified
 FROM "._MYSQL_PREFIX."_surfbar_urls AS u
-INNER JOIN "._MYSQL_PREFIX."_user_data AS d
+INNER JOIN `"._MYSQL_PREFIX."_user_data` AS d
 ON u.userid=d.userid
 WHERE u.status='ACTIVE'
 GROUP BY u.userid