Renamed all SQL-related functions to camel-case notation

[mailer.git] / inc / libs / sponsor_functions.php

diff --git a/inc/libs/sponsor_functions.php b/inc/libs/sponsor_functions.php
index ff25ea405a28f74e7842f761a1e48e1b16e27bc2..fc12052eea581f4fe8e0e8043e8ada74653a55a0 100644 (file)
--- a/inc/libs/sponsor_functions.php
+++ b/inc/libs/sponsor_functions.php
@@ -72,11 +72,11 @@ function handleSponsorRequest ($postData, $update=false, $messageArray = array()
                                                        $SAVE = FALSE;
                                                } else {
                                                        // Add a new sponsor or update his data?
-                                                       $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE email='%s' LIMIT 1",
+                                                       $result = sqlQueryEscaped("SELECT `id` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE email='%s' LIMIT 1",
                                                                array($postData['email']), __FUNCTION__, __LINE__);
 
                                                        // Is a sponsor alread in the db?
-                                                       if (SQL_NUMROWS($result) == 1) {
+                                                       if (sqlNumRows($result) == 1) {
                                                                // Yes, he is!
                                                                if ((getWhat() == 'add_sponsor') || ($update)) {
                                                                        // Already found
@@ -88,7 +88,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray = array()
                                                        }
 
                                                        // Free memory
-                                                       SQL_FREERESULT($result);
+                                                       sqlFreeResult($result);
                                                }
                                                break;
 
@@ -189,7 +189,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray = array()
                                foreach ($postData as $k => $v) {
                                        // Do not add 'force' !
                                        if ($k != 'force') {
-                                               $OUT .= '<input type="hidden" name="' . secureString($k) . '" value="' . SQL_ESCAPE($v) . '" />';
+                                               $OUT .= '<input type="hidden" name="' . secureString($k) . '" value="' . sqlEscapeString($v) . '" />';
                                        } // END - if
                                } // END - foreach
 
@@ -208,7 +208,7 @@ function handleSponsorRequest ($postData, $update=false, $messageArray = array()
 
                        if (!empty($sql)) {
                                // Run SQL command
-                               $result = SQL_QUERY_ESC($sql, $DATA['values'], __FUNCTION__, __LINE__);
+                               $result = sqlQueryEscaped($sql, $DATA['values'], __FUNCTION__, __LINE__);
                        } // END - if
                } else {
                        // Error detected
@@ -272,7 +272,7 @@ function addSponsorMenu ($current) {
        if (isAdmin()) $WHERE = '';
 
        // Load main menu entries
-       $result_main = SQL_QUERY("SELECT
+       $result_main = sqlQuery("SELECT
        `action` AS `main_action`,
        `title` AS `main_title`
 FROM
@@ -282,11 +282,11 @@ WHERE
        " . $WHERE . "
 ORDER BY
        `sort` ASC", __FUNCTION__, __LINE__);
-       if (!SQL_HASZERONUMS($result_main)) {
+       if (!ifSqlHasZeroNums($result_main)) {
                // Load every menu and it's sub menus
-               while ($content = SQL_FETCHARRAY($result_main)) {
+               while ($content = sqlFetchArray($result_main)) {
                        // Load sub menus
-                       $result_sub = SQL_QUERY_ESC("SELECT
+                       $result_sub = sqlQueryEscaped("SELECT
        `what` AS `sub_what`,
        `title` AS `sub_title`
 FROM
@@ -299,10 +299,10 @@ WHERE
 ORDER BY
        `sort` ASC",
                        array($content['main_action']), __FUNCTION__, __LINE__);
-                       if (!SQL_HASZERONUMS($result_sub)) {
+                       if (!ifSqlHasZeroNums($result_sub)) {
                                // Load sub menus
                                $SUB = '';
-                               while ($content2 = SQL_FETCHARRAY($result_sub)) {
+                               while ($content2 = sqlFetchArray($result_sub)) {
                                        // Check if current selected menu is matching the loaded one
                                        if ($current == $content2['sub_what']) $content2['sub_title'] = '<strong>' . $content2['sub_title'] . '</strong>';
 
@@ -321,7 +321,7 @@ ORDER BY
                        }
 
                        // Free memory
-                       SQL_FREERESULT($result_sub);
+                       sqlFreeResult($result_sub);
                } // END - while
        } else {
                // No main menus active
@@ -329,7 +329,7 @@ ORDER BY
        }
 
        // Free memory
-       SQL_FREERESULT($result_main);
+       sqlFreeResult($result_main);
 
        // Return content
        return $OUT;
@@ -362,7 +362,7 @@ function updateSponsorLogin () {
        // Is sponsor?
        if (isSponsor()) {
                // Update last online timestamp
-               SQL_QUERY_ESC("UPDATE
+               sqlQueryEscaped("UPDATE
        `{?_MYSQL_PREFIX?}_sponsor_data`
 SET
        `last_online`=NOW()
@@ -376,7 +376,7 @@ LIMIT 1",
                        ), __FUNCTION__, __LINE__);
 
                // This update went fine?
-               $login = (!SQL_HASZEROAFFECTED());
+               $login = (!ifSqlHasZeroAffectedRows());
        } // END - if
 
        // Return status
@@ -409,7 +409,7 @@ function saveSponsorData ($postData, $content) {
                unset($postData[$remove]);
        } // END - foreach
 
-       // This array is for the submitted data which we will use with the SQL_QUERY_ESC() function to
+       // This array is for the submitted data which we will use with the sqlQueryEscaped() function to
        // secure the data
        $DATA = array();
 
@@ -419,7 +419,7 @@ function saveSponsorData ($postData, $content) {
                // Mmmmm, too less security here???
                $sql   .= " `" . secureString($key) . "`='%s',";
 
-               // We will secure this later inside the SQL_QUERY_ESC() function
+               // We will secure this later inside the sqlQueryEscaped() function
                array_push($DATA, secureString($value));
        } // END - foreach
 
@@ -478,11 +478,11 @@ function saveSponsorData ($postData, $content) {
        } // END - switch
 
        // Has an entry updated?
-       if (!SQL_HASZEROAFFECTED()) {
+       if (!ifSqlHasZeroAffectedRows()) {
                // Template and subject are set?
                if (!empty($templ) && !empty($subject)) {
                        // Run SQL command and check for success
-                       $result = SQL_QUERY_ESC($sql, $DATA, __FUNCTION__, __LINE__);
+                       $result = sqlQueryEscaped($sql, $DATA, __FUNCTION__, __LINE__);
 
                        // Add all data to content
                        $content['new_data'] = $postData;
@@ -535,7 +535,7 @@ function generateSponsorEmailLink ($email, $mod = 'admin') {
        // But admins shall always see it
        if (isAdmin()) $locked = '';
 
-       $result = SQL_QUERY_ESC("SELECT
+       $result = sqlQueryEscaped("SELECT
        `id`
 FROM
        `{?_MYSQL_PREFIX?}_sponsor_data`
@@ -544,16 +544,16 @@ WHERE
        " . $locked . "
 LIMIT 1",
                array($email), __FUNCTION__, __LINE__);
-       if (SQL_NUMROWS($result) == 1) {
+       if (sqlNumRows($result) == 1) {
                // Load sponsor_id
-               list($sponsor_id) = SQL_FETCHROW($result);
+               list($sponsor_id) = sqlFetchRow($result);
 
                // Rewrite email address to contact link
                $email = '{%url=modules.php?module=' . $mod . '&amp;what=sponsor_contct&amp;sponsor_id=' . bigintval($sponsor_id) . '%}';
        } // END - if
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Return rewritten (?) email address
        return $email;
@@ -571,11 +571,11 @@ function doProcessSponsorFormRequest ($messageArray = array()) {
        switch ($status) {
                case 'added': // Sponsor successfully added with account status = UNCONFIRMED!
                        // Check for his id number
-                       $result = SQL_QUERY_ESC("SELECT `id`, `hash` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE '%s' REGEXP `email` LIMIT 1",
+                       $result = sqlQueryEscaped("SELECT `id`, `hash` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE '%s' REGEXP `email` LIMIT 1",
                                array(postRequestElement('email')), __FUNCTION__, __LINE__);
-                       if (SQL_NUMROWS($result) == 1) {
+                       if (sqlNumRows($result) == 1) {
                                // id found so let's load it for the confirmation email
-                               list($id, $hash) = SQL_FETCHROW($result);
+                               list($id, $hash) = sqlFetchRow($result);
 
                                // Prepare data for the email template
                                $content['id']        = $id;
@@ -601,7 +601,7 @@ function doProcessSponsorFormRequest ($messageArray = array()) {
                        }
 
                        // Free memory
-                       SQL_FREERESULT($result);
+                       sqlFreeResult($result);
                        break;
 
                default:
@@ -686,13 +686,13 @@ function fetchSponsorData ($sponsor_id, $column = 'id') {
        $ADD = '';
 
        // Query for the sponsor
-       $result = SQL_QUERY_ESC("SELECT *".$ADD." FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `%s`='%s' LIMIT 1",
+       $result = sqlQueryEscaped("SELECT *".$ADD." FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `%s`='%s' LIMIT 1",
                array($column, $sponsor_id), __FUNCTION__, __LINE__);
 
        // Is there a record?
-       if (SQL_NUMROWS($result) == 1) {
+       if (sqlNumRows($result) == 1) {
                // Load data from cookies
-               $data = SQL_FETCHARRAY($result);
+               $data = sqlFetchArray($result);
 
                // Set the sponsor_id for later use
                setCurrentSponsorId($data['id']);
@@ -730,7 +730,7 @@ function fetchSponsorData ($sponsor_id, $column = 'id') {
        } // END - if
 
        // Free memory
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Return result
        return $found;