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

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

diff --git a/inc/libs/task_functions.php b/inc/libs/task_functions.php
index 6e8bb48ccb52330aca934af6f6bcac635154685a..4c99be29ab945e564abe27a36cd0d6945b9362fb 100644 (file)
--- a/inc/libs/task_functions.php
+++ b/inc/libs/task_functions.php
@@ -260,7 +260,7 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main)
 
                // Check for all accounts
                $SQLs[] = "SELECT DISTINCT d.userid, d.email, d.last_online
 
                // Check for all accounts
                $SQLs[] = "SELECT DISTINCT d.userid, d.email, d.last_online

-FROM "._MYSQL_PREFIX."_user_data AS d
+FROM `"._MYSQL_PREFIX."_user_data` AS d

 WHERE d.status='CONFIRMED' AND d.joined < (UNIX_TIMESTAMP() - ".$since.") AND d.last_online < (UNIX_TIMESTAMP() - ".$since.") AND d.ap_notified < (UNIX_TIMESTAMP() - ".$since.")
 ".$EXCLUDE_LIST."
 ORDER BY d.userid";
 WHERE d.status='CONFIRMED' AND d.joined < (UNIX_TIMESTAMP() - ".$since.") AND d.last_online < (UNIX_TIMESTAMP() - ".$since.") AND d.ap_notified < (UNIX_TIMESTAMP() - ".$since.")
 ".$EXCLUDE_LIST."
 ORDER BY d.userid";


@@ -271,7 +271,7 @@ ORDER BY d.userid";
 
        if (GET_EXT_VERSION("sql_patches") >= "0.3.4") {
                // Check for accounts without referal
 
        if (GET_EXT_VERSION("sql_patches") >= "0.3.4") {
                // Check for accounts without referal

-               $SQLs[]   = "SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE refid='0' ORDER BY userid";
+               $SQLs[]   = "SELECT userid FROM `"._MYSQL_PREFIX."_user_data` WHERE refid='0' ORDER BY userid";

                $DESCRs[] = TASK_ADMIN_LIST_ACCOUNT_NOREF;
                $TITLEs[] = TASK_ADMIN_LIST_ACCOUNT_NOREF_TITLE;
                $WHATs[]  = "list_user&amp;mode=norefs";
                $DESCRs[] = TASK_ADMIN_LIST_ACCOUNT_NOREF;
                $TITLEs[] = TASK_ADMIN_LIST_ACCOUNT_NOREF_TITLE;
                $WHATs[]  = "list_user&amp;mode=norefs";