Renamed all SQL-related functions to camel-case notation

[mailer.git] / inc / modules / admin / what-del_holiday.php

diff --git a/inc/modules/admin/what-del_holiday.php b/inc/modules/admin/what-del_holiday.php
index 6fc34c1832f2db5062bba570b846cd127db97117..0b567578343cf9e2a99cf5d9cca64bb28d77008f 100644 (file)
--- a/inc/modules/admin/what-del_holiday.php
+++ b/inc/modules/admin/what-del_holiday.php
@@ -49,7 +49,7 @@ if (ifPostContainsSelections()) {
        $count = '0';
        foreach (postRequestElement('sel') as $id => $sel) {
                // Get the userid
-               $result = SQL_QUERY_ESC("SELECT
+               $result = sqlQueryEscaped("SELECT
        `userid`,
        `holiday_start`,
        `holiday_end`
@@ -58,12 +58,12 @@ FROM
 WHERE
        `id`=%s
 LIMIT 1", array(bigintval($id)), __FILE__, __LINE__);
-               if (SQL_NUMROWS($result) == 1) {
+               if (sqlNumRows($result) == 1) {
                        // Load data and free memory
-                       $content = SQL_FETCHARRAY($result);
+                       $content = sqlFetchArray($result);
 
                        // Update user's account
-                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data`
+                       sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data`
 SET
        `holiday_active`='N',
        `holiday_activated`=0
@@ -72,7 +72,7 @@ WHERE
 LIMIT 1", array(bigintval($content['userid'])), __FILE__, __LINE__);
 
                        // Remove holiday
-                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM
+                       sqlQueryEscaped("DELETE LOW_PRIORITY FROM
        `{?_MYSQL_PREFIX?}_user_holidays`
 WHERE
        `id`=%s
@@ -89,7 +89,7 @@ LIMIT 1", array(bigintval($id)), __FILE__, __LINE__);
                } // END - if
 
                // Free result
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
        } // END - foreach
 
        // Display final message
@@ -99,7 +99,7 @@ LIMIT 1", array(bigintval($id)), __FILE__, __LINE__);
        $message = '{--ADMIN_HOLIDAY_SINGLE_404--}';
 
        // Fetch data
-       $result_load = SQL_QUERY_ESC("SELECT
+       $result_load = sqlQueryEscaped("SELECT
        `holiday_start` AS `start`,
        `holiday_end` AS `end`
 FROM
@@ -108,12 +108,12 @@ WHERE
        `userid`=%s
 LIMIT 1",
                array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
-       if (SQL_NUMROWS($result_load) == 1) {
+       if (sqlNumRows($result_load) == 1) {
                // Load data
-               $content = SQL_FETCHARRAY($result_load);
+               $content = sqlFetchArray($result_load);
 
                // Delete one holiday request (for task)
-               SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM
+               sqlQueryEscaped("DELETE LOW_PRIORITY FROM
        `{?_MYSQL_PREFIX?}_user_holidays`
 WHERE
        `userid`=%s
@@ -128,7 +128,7 @@ LIMIT 1", array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
        } // END - if
 
        // Free memory
-       SQL_FREERESULT($result_load);
+       sqlFreeResult($result_load);
 
        // Output message
        displayMessage($message);