X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Ftask_functions.php;h=4c99be29ab945e564abe27a36cd0d6945b9362fb;hp=6e8bb48ccb52330aca934af6f6bcac635154685a;hb=6c763653e88b9d10627e651ca59c7201d4b7d62b;hpb=f9cc6f432459393d1c3a220e5270705d341a350e diff --git a/inc/libs/task_functions.php b/inc/libs/task_functions.php index 6e8bb48ccb..4c99be29ab 100644 --- 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 -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"; @@ -271,7 +271,7 @@ ORDER BY d.userid"; 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&mode=norefs";