X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=inline;f=inc%2Fmodules%2Fadmin%2Foverview-inc.php;h=ed8f411107d33e32c57c11d81ae31aa87a00d278;hb=eefb72c90c4d30b82b9277acd42754dca014302b;hp=31073f84bba7a3d708186fb0a54588d7136d8b83;hpb=86ad0906acfc5c15d259033e280134b75321c7df;p=mailer.git diff --git a/inc/modules/admin/overview-inc.php b/inc/modules/admin/overview-inc.php index 31073f84bb..ed8f411107 100644 --- a/inc/modules/admin/overview-inc.php +++ b/inc/modules/admin/overview-inc.php @@ -8,7 +8,7 @@ * -------------------------------------------------------------------- * * Short description : Output standard task management * * -------------------------------------------------------------------- * - * Kurzbeschreibung : Standart-Aufgaben-Management ausgeben * + * Kurzbeschreibung : Standard-Aufgaben-Management ausgeben * * -------------------------------------------------------------------- * * $Revision:: $ * * $Date:: $ * @@ -16,7 +16,7 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -70,7 +70,7 @@ function outputStandardOverview (&$result_tasks) { // Is the extension not yet installed? if ($extInstalled === false) { // We maybe want to install an extension so let's test-drive it... - if (loadExtension($ext_name, getExtensionMode(), '', true)) { + if (loadExtension($ext_name, getExtensionMode(), '0.0.0', true)) { // Create a task for newly installed extension (we ignore the task id here) createNewExtensionTask($ext_name); } // END - if @@ -102,11 +102,11 @@ function outputStandardOverview (&$result_tasks) { // At last - but not least - check for own and new unassigned tasks... $result_tasks = SQL_QUERY_ESC("SELECT - `id`, `assigned_admin`, `userid`, `task_type`, `subject`, `text`, `task_created` + `id`,`assigned_admin`,`userid`,`task_type`,`subject`,`text`,`task_created` FROM `{?_MYSQL_PREFIX?}_task_system` WHERE - `assigned_admin`=%s OR (`assigned_admin`=0 AND `status`='NEW') + `assigned_admin`=%s OR ((`assigned_admin`=0 OR `assigned_admin` IS NULL) AND `status`='NEW') ORDER BY `userid` DESC, `task_type` DESC, @@ -115,7 +115,7 @@ ORDER BY array(getCurrentAdminId()), __FILE__, __LINE__); if (!SQL_HASZERONUMS($result_tasks)) { - // New jobs found! + // New jobs found $jobsDone = false; } // END - if @@ -133,11 +133,11 @@ function outputSeletectedTasks ($postData, $result_tasks) { $OUT = ''; foreach ($postData['sel'] as $taskId => $sel) { $result_task = SQL_QUERY_ESC("SELECT - `id`, `userid`, `task_type`, `subject`, `text`, `task_created`, `status`, `assigned_admin` + `id`,`userid`,`task_type`,`subject`,`text`,`task_created`,`status`,`assigned_admin` FROM `{?_MYSQL_PREFIX?}_task_system` WHERE - `id`=%s AND (`assigned_admin`=%s OR (`assigned_admin`=0 AND `status`='NEW')) + `id`=%s AND (`assigned_admin`=%s OR ((`assigned_admin`=0 OR `assigned_admin` IS NULL) AND `status`='NEW')) LIMIT 1", array( bigintval($taskId), @@ -151,7 +151,7 @@ LIMIT 1", if ($taskData['assigned_admin'] == '0') { // Assgin current admin to unassgigned task - SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `assigned_admin`=%s WHERE `id`=%s AND `assigned_admin`=0 LIMIT 1", + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `assigned_admin`=%s WHERE `id`=%s AND `assigned_admin`=NULL LIMIT 1", array( getCurrentAdminId(), bigintval($taskData['id']) @@ -174,10 +174,10 @@ LIMIT 1", $content = getUserDataArray(); // Generate HTML list entry - $add = '
%s", print_r($postData, true))); } // Update query - $result_tasks = SQL_QUERY_ESC("SELECT `id`, `assigned_admin`, `userid`, `task_type`, `subject`, `text`, `task_created` FROM `{?_MYSQL_PREFIX?}_task_system` WHERE `assigned_admin`=%s OR (`assigned_admin`=0 AND `status`='NEW') ORDER BY `task_created` DESC", + $result_tasks = SQL_QUERY_ESC("SELECT `id`,`assigned_admin`,`userid`,`task_type`,`subject`,`text`,`task_created` FROM `{?_MYSQL_PREFIX?}_task_system` WHERE `assigned_admin`=%s OR ((`assigned_admin`=0 OR `assigned_admin` IS NULL) AND `status`='NEW') ORDER BY `task_created` DESC", array(getCurrentAdminId()), __FILE__, __LINE__); } // END - if @@ -429,10 +429,7 @@ LIMIT 1", case 'EXTENSION_UPDATE': $content['infos'] = substr($content['subject'], 1, strpos($content['subject'], ':') - 1); break; - } - - // Get task type - $content['task_type_msg'] = '{--ADMIN_TASK_IS_' . strtoupper($content['task_type']) . '--}'; + } // END - switch if (isValidUserId($content['userid'])) { // Member found otherwise it's a system task