]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-list_task.php
Added update_year.sh (still not fully flexible) and updated all years with it.
[mailer.git] / inc / modules / admin / what-list_task.php
index 7298f63cc2066347da2b9fd563190777b62b1c29..0647775f9e0044a7b665b4ddc68108100244beae 100644 (file)
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2015 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=<pre>%s</pre>", print_r(postRequestArray(), TRUE)));
+                               reportBug(__FILE__, __LINE__, sprintf('Unknown task action performed. data=<pre>%s</pre>', 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'] = '';
 
@@ -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
                );