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

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

diff --git a/inc/libs/refback_functions.php b/inc/libs/refback_functions.php
index 5f9293a3c14c36da4cee08667a9af2fff726282a..c437e29dd236834c4cc2be5093fa3e3f17b133d7 100644 (file)
--- a/inc/libs/refback_functions.php
+++ b/inc/libs/refback_functions.php
@@ -179,7 +179,7 @@ function UPDATE_REFBACK_TABLE($uid) {
        $old = 0; $minus = 0;
 
        // Check for his referal
-       $result_refid = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE refid=%s ORDER BY userid ASC",
+       $result_refid = SQL_QUERY_ESC("SELECT userid FROM `"._MYSQL_PREFIX."_user_data` WHERE refid=%s ORDER BY userid ASC",
                array(bigintval($uid)), __FILE__, __LINE__);
 
        // When no entry was updated then we have to create it here
@@ -275,7 +275,7 @@ function GET_USER_REFS ($uid, $level) {
        // Get refs from database
        $result = SQL_QUERY_ESC("SELECT r.id, r.refid, r.refback, r.points, d.status".$ADD."
 FROM "._MYSQL_PREFIX."_user_refs AS r
-LEFT JOIN "._MYSQL_PREFIX."_user_data AS d
+LEFT JOIN `"._MYSQL_PREFIX."_user_data` AS d
 ON r.refid=d.userid
 WHERE r.userid=%s AND r.level=%s
 ORDER BY r.refid ASC",