]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-list_task.php
Renamed all SQL-related functions to camel-case notation
[mailer.git] / inc / modules / admin / what-list_task.php
index 2a7d104633ff11109d65b22c9ea531b7877360e9..8625db86075f7cddd28e53c72596220b3b0d1c38 100644 (file)
@@ -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)
@@ -125,7 +125,7 @@ ORDER BY
                        }
 
                        // 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,7 +175,7 @@ ORDER BY
                } // END - while
 
                // Free memory
-               SQL_FREERESULT($result_tasks);
+               sqlFreeResult($result_tasks);
 
                // Prepare content
                $content = array(