X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_task.php;h=5f9da909cd0a13fc6ab98217de615026909b6ab0;hb=6b1e55213d76a67e9aa3d9f1e4dcb55e0bbf12ee;hp=31389aa8adfb9c810beb521566b89d29a7c6058c;hpb=596c8ab32594401ca84abfbfe35513ddfff31bec;p=mailer.git diff --git a/inc/modules/admin/what-list_task.php b/inc/modules/admin/what-list_task.php index 31389aa8ad..5f9da909cd 100644 --- a/inc/modules/admin/what-list_task.php +++ b/inc/modules/admin/what-list_task.php @@ -16,7 +16,7 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * Copyright (c) 2009 - 2013 by Mailer Developer Team * * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -74,7 +74,7 @@ switch (getRequestElement('type')) { break; default: // Unknown type - logDebugMessage(__FILE__, __LINE__, sprintf("Unknown task type %s detected.", getRequestElement('type'))); + logDebugMessage(__FILE__, __LINE__, sprintf('Unknown task type %s detected.', getRequestElement('type'))); displayMessage('{%message,ADMIN_TASK_UNKNOWN_MODE' . getRequestElement('type') . '%}'); break; } // END - switch @@ -87,7 +87,7 @@ if (!empty($whereStatement)) { outputSeletectedTasks(postRequestArray(), $dmy); } else { // Start listing tasks matching selected filter - $result_tasks = SQL_QUERY('SELECT + $result_tasks = sqlQuery('SELECT `id`, `assigned_admin`, `userid`, `task_type`, `subject`, `text`, `task_created` FROM `{?_MYSQL_PREFIX?}_task_system` @@ -104,7 +104,7 @@ ORDER BY if (isFormSent('unassign')) { // Unassign from tasks foreach (postRequestElement('sel') as $id => $sel) { - SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `assigned_admin`=NULL WHERE `id`=%s AND `assigned_admin`=%s LIMIT 1", + sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_task_system` SET `assigned_admin`=NULL WHERE `id`=%s AND `assigned_admin`=%s LIMIT 1", array(bigintval($id), getCurrentAdminId()), __FILE__, __LINE__); } // END - foreach } elseif (isFormSent('delete')) { @@ -112,7 +112,7 @@ ORDER BY foreach (postRequestElement('sel') as $id => $sel) { if (getRequestElement('type') == 'deleted') { // Delete task immediately - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_task_system` WHERE `id`=%s LIMIT 1", + sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_task_system` WHERE `id`=%s LIMIT 1", array(bigintval($id)),__FILE__, __LINE__); } else { // Mark task as to be deleted (purged by autopurge extension) @@ -121,11 +121,11 @@ ORDER BY } // END - foreach } else { // Unknown action performed - reportBug(__FILE__, __LINE__, sprintf("Unknown task action performed. data=
%s
", print_r(postRequestArray(), TRUE))); + reportBug(__FILE__, __LINE__, sprintf('Unknown task action performed. data=
%s
', print_r(postRequestArray(), TRUE))); } // Update query - $result_tasks = SQL_QUERY('SELECT + $result_tasks = sqlQuery('SELECT `id`, `assigned_admin`, `userid`, `task_type`, `subject`, `text`, `task_created` FROM `{?_MYSQL_PREFIX?}_task_system` @@ -138,7 +138,7 @@ ORDER BY // There are uncompleted jobs! $OUT = ''; - while ($content = SQL_FETCHARRAY($result_tasks)) { + while ($content = sqlFetchArray($result_tasks)) { // Init infos $content['infos'] = ''; @@ -151,7 +151,7 @@ ORDER BY } // END - switch // Member assigned with task? - if (isValidUserId($content['userid'])) { + if (isValidId($content['userid'])) { // Member found otherwise it's a system task $content['userid'] = generateUserProfileLink($content['userid']); } else { @@ -175,11 +175,11 @@ ORDER BY } // END - while // Free memory - SQL_FREERESULT($result_tasks); + sqlFreeResult($result_tasks); // Prepare content $content = array( - 'message' => '{--ADMIN_OVERVIEW_TASK_' . strtoupper(getRequestElement('type')) . '_TYPE--}', + 'message' => '{--ADMIN_OVERVIEW_TASK_' . strtoupper(getRequestElement('type')) . '_TYPE_TITLE--}', 'type' => getRequestElement('type'), 'rows' => $OUT );