]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-edit_sponsor.php
Renamed all SQL-related functions to camel-case notation
[mailer.git] / inc / modules / admin / what-edit_sponsor.php
index fcf0284f937ce7549a9b2fb5e15d27b46aaedc27..14bfd64d9be2c70e6d33690075efca105d2593d5 100644 (file)
@@ -45,7 +45,7 @@ addYouAreHereLink('admin', __FILE__);
 
 if ((isGetRequestElementSet('id')) && (isGetRequestElementSet('do'))) {
        // Check for selected sponsor
-       $result_main = SQL_QUERY_ESC("SELECT
+       $result_main = sqlQueryEscaped("SELECT
        `id`, `company`, `position`, `gender`, `surname`, `family`,
        `street_nr1`, `street_nr2`, `zip`, `city`, `country`,
        `phone`, `fax`, `cell`, `email`, `url`, `tax_ident`,
@@ -56,9 +56,9 @@ WHERE
        `id`=%s
 LIMIT 1",
                array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);
-       if (SQL_NUMROWS($result_main) == 1) {
+       if (sqlNumRows($result_main) == 1) {
                // Load sponsor details
-               $content = SQL_FETCHARRAY($result_main);
+               $content = sqlFetchArray($result_main);
 
                //  Warning because low points
                $content['receive_warnings'] = addSelectionBox('yn', $content['receive_warnings'], 'receive_warning');
@@ -78,7 +78,7 @@ LIMIT 1",
                                                $points = bigintval(convertCommaToDot(postRequestElement('points')));
 
                                                // Add points to account
-                                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_amount`=`points_amount`+%s WHERE `id`=%s LIMIT 1",
+                                               sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_amount`=`points_amount`+%s WHERE `id`=%s LIMIT 1",
                                                        array($points, bigintval(getRequestElement('id'))), __FILE__, __LINE__);
 
                                                // Remember points /reason for the template
@@ -101,7 +101,7 @@ LIMIT 1",
                                                $points = bigintval(convertCommaToDot(postRequestElement('points')));
 
                                                // Add points to account
-                                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_used`=`points_used`+%s WHERE `id`=%s LIMIT 1",
+                                               sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `points_used`=`points_used`+%s WHERE `id`=%s LIMIT 1",
                                                        array($points, bigintval(getRequestElement('id'))), __FILE__, __LINE__);
 
                                                // Remember points /reason for the template
@@ -170,7 +170,7 @@ LIMIT 1",
        }
 
        // Free result
-       SQL_FREERESULT($result_main);
+       sqlFreeResult($result_main);
 } else {
        // Not called by what-list_sponsor.php
        displayMessage('{--ADMIN_CALL_NOT_DIRECTLY--}');