Renamed all SQL-related functions to camel-case notation

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

diff --git a/inc/modules/admin/what-del_sponsor.php b/inc/modules/admin/what-del_sponsor.php
index 07673f76160740e18799f39aa176e8279e5e6f80..0efe1821d87a70438bc044bf0817ef84450a05e3 100644 (file)
--- a/inc/modules/admin/what-del_sponsor.php
+++ b/inc/modules/admin/what-del_sponsor.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 *
@@ -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,13 +75,13 @@ 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'));
 
                        // Display form
-                       loadTemplate('admin_delete_sponsor', false, $content);
+                       loadTemplate('admin_delete_sponsor', FALSE, $content);
                }
        } else {
                // Sponsor not found
@@ -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--}');