Renamed all SQL-related functions to camel-case notation
[mailer.git] / inc / modules / admin / what-del_sponsor.php
index 0ffab7d914891a5a466b022e6b402a9bf58acd8b..0efe1821d87a70438bc044bf0817ef84450a05e3 100644 (file)
@@ -45,13 +45,13 @@ addYouAreHereLink('admin', __FILE__);
 
 if (isGetRequestElementSet('id')) {
        // Check for selected sponsor
-       $result = SQL_QUERY_ESC("SELECT `id`, `email`, `gender`, `surname`, `family` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1",
+       $result = sqlQueryEscaped("SELECT `id`, `email`, `gender`, `surname`, `family` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1",
                array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);
-       if (SQL_NUMROWS($result) == 1) {
+       if (sqlNumRows($result) == 1) {
                // Remove sponsor
                if (isFormSent()) {
                        // Load data and remember it in constants
-                       $content = SQL_FETCHARRAY($result);
+                       $content = sqlFetchArray($result);
 
                        // Prepare data for the template
                        $content['reason']  = postRequestElement('reason');
@@ -61,11 +61,11 @@ if (isGetRequestElementSet('id')) {
                        sendEmail($content['email'], '{--ADMIN_SPONSOR_DELETE_SUBJECT--}', $message);
 
                        // Remove account
-                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1",
+                       sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1",
                                array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);
 
                        // Remove orders
-                       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_orders` WHERE `sponsor_id`='%s' LIMIT 1",
+                       sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_sponsor_orders` WHERE `sponsor_id`='%s' LIMIT 1",
                                array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);
 
                        // Output message
@@ -75,7 +75,7 @@ if (isGetRequestElementSet('id')) {
                        redirectToUrl('modules.php?module=admin&what=list_sponsor&id='.bigintval(getRequestElement('id')));
                } else {
                        // Load data
-                       $content = SQL_FETCHARRAY($result);
+                       $content = sqlFetchArray($result);
 
                        // Transfer data to constants for the template
                        $content['userid'] = bigintval(getRequestElement('id'));
@@ -89,7 +89,7 @@ if (isGetRequestElementSet('id')) {
        }
 
        // Free result
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 } else {
        // Not called by what-list_sponsor.php
        displayMessage('{--ADMIN_CALL_NOT_DIRECTLY--}');