X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=inc%2Flibs%2Ftask_functions.php;h=f251b7c2784fa06e7ccb254af1a09ffae14059f7;hb=310ab1fd53100627fa054ea5579f283ed77bfaec;hp=978b87ba5a19a49fddfadfcaab28fde1fe1ccc9e;hpb=3b85bd5030ad591b0c5cb038ca534a7b50e1b319;p=mailer.git diff --git a/inc/libs/task_functions.php b/inc/libs/task_functions.php index 978b87ba5a..f251b7c278 100644 --- a/inc/libs/task_functions.php +++ b/inc/libs/task_functions.php @@ -139,7 +139,7 @@ function OUTPUT_ADVANCED_OVERVIEW (&$result_main) // // Solved tasks // - $value = GET_TOTAL_DATA("CLOSED", "task_system", "id", "status", true, sprintf(" AND assigned_admin=%s", GET_ADMIN_ID(get_session('admin_login')))); + $value = GET_TOTAL_DATA("SOLVED", "task_system", "id", "status", true, sprintf(" AND assigned_admin=%s", GET_ADMIN_ID(get_session('admin_login')))); if ($value > 0) { define('__TASK_SOLVED_VALUE', "".$value.""); @@ -485,13 +485,13 @@ ORDER BY beg_points DESC, userid"; if (EXT_IS_ACTIVE("theme")) { // List all themes - $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_themes ORDER BY id"; + $SQLs[] = "SELECT id FROM `"._MYSQL_PREFIX."_themes` ORDER BY id"; $WHATs[] = "theme_edit"; $DESCRs[] = TASK_ADMIN_LIST_THEME_ALL; $TITLEs[] = TASK_ADMIN_LIST_THEME_ALL_TITLE; // List active themes - $SQLs[] = "SELECT id FROM "._MYSQL_PREFIX."_themes WHERE theme_active='Y' ORDER BY id"; + $SQLs[] = "SELECT id FROM `"._MYSQL_PREFIX."_themes` WHERE theme_active='Y' ORDER BY id"; $WHATs[] = "theme_edit"; $DESCRs[] = TASK_ADMIN_LIST_THEME_ACTIVE; $TITLEs[] = TASK_ADMIN_LIST_THEME_ACTIVE_TITLE;