Renamed all SQL-related functions to camel-case notation

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

diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php
index bb118906a0236de3714c53e885b94cc2404a512f..b053c1d19392ab1567e865184613df7021879785 100644 (file)
--- a/inc/libs/bonus_functions.php
+++ b/inc/libs/bonus_functions.php
@@ -96,14 +96,14 @@ function addTurboBonus ($id, $userid, $type) {
        }
 
        // Add points to his account directly
-       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `turbo_bonus`=`turbo_bonus`+%s WHERE `userid`=%s LIMIT 1",
+       sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `turbo_bonus`=`turbo_bonus`+%s WHERE `userid`=%s LIMIT 1",
                array(
                        $points,
                        bigintval($userid)
                ), __FUNCTION__, __LINE__);
 
        // Rember this whole data for displaying ranking list
-       SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_bonus_turbo` (`userid`, `mail_id`, `bonus_id`, `level`, `points`, `timemark`) VALUES (%s, %s, %s, %s, %s, UNIX_TIMESTAMP())",
+       sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_bonus_turbo` (`userid`, `mail_id`, `bonus_id`, `level`, `points`, `timemark`) VALUES (%s, %s, %s, %s, %s, UNIX_TIMESTAMP())",
                array(
                        bigintval($userid),
                        $mailId,
@@ -132,7 +132,7 @@ function addBonusRanks ($data, $type, $userid) {
        $ranks = count(explode(';', getTurboRates())) + 1;
 
        // Load current user's data
-       $result = SQL_QUERY_ESC("SELECT `level`, `points`, `timemark` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s AND `userid`=%s LIMIT 1",
+       $result = sqlQueryEscaped("SELECT `level`, `points`, `timemark` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s AND `userid`=%s LIMIT 1",
                array(
                        $type,
                        $data,
@@ -140,9 +140,9 @@ function addBonusRanks ($data, $type, $userid) {
                ), __FUNCTION__, __LINE__);
 
        // Entry found?
-       if (SQL_NUMROWS($result) == 1) {
+       if (sqlNumRows($result) == 1) {
                // Load data
-               $GLOBALS['ranking_content'] = merge_array($GLOBALS['ranking_content'], SQL_FETCHARRAY($result));
+               $GLOBALS['ranking_content'] = merge_array($GLOBALS['ranking_content'], sqlFetchArray($result));
 
                // Remember all values for later use
                $self = TRUE;
@@ -155,13 +155,13 @@ function addBonusRanks ($data, $type, $userid) {
        } // END - if
 
        // Load rankings
-       $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s ORDER BY `level` ASC LIMIT {?bonus_lines?}",
+       $result = sqlQueryEscaped("SELECT `id` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s ORDER BY `level` ASC LIMIT {?bonus_lines?}",
                array($type, $data), __FUNCTION__, __LINE__);
-       if (!SQL_HASZERONUMS($result)) {
+       if (!ifSqlHasZeroNums($result)) {
                // Output all ranks (levels)
-               for ($rank = 1; $rank <= SQL_NUMROWS($result); $rank++) {
+               for ($rank = 1; $rank <= sqlNumRows($result); $rank++) {
                        // Load data
-                       $result_users = SQL_QUERY_ESC("SELECT
+                       $result_users = sqlQueryEscaped("SELECT
        `userid`,
        `points`
 FROM
@@ -177,13 +177,13 @@ LIMIT 1",
                        $rows['points'] = '---';
 
                        // Are you one of them?
-                       if (SQL_NUMROWS($result_users) == 1) {
+                       if (sqlNumRows($result_users) == 1) {
                                // Load data
-                               $rows = merge_array($rows, SQL_FETCHARRAY($result_users));
+                               $rows = merge_array($rows, sqlFetchArray($result_users));
                        } // END - if
 
                        // Free result
-                       SQL_FREERESULT($result_users);
+                       sqlFreeResult($result_users);
 
                        // Add more
                        $rows['rank'] = $rank;
@@ -274,11 +274,11 @@ function handleBonusPoints ($mode, $userid) {
 // Purges expired fast-click bonus entries
 function purgeExpiredTurboBonus () {
        // Remove entries
-       $result = SQL_QUERY('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE (UNIX_TIMESTAMP() - `timemark`) >= {?bonus_timeout?}', __FUNCTION__, __LINE__);
+       $result = sqlQuery('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE (UNIX_TIMESTAMP() - `timemark`) >= {?bonus_timeout?}', __FUNCTION__, __LINE__);
 
-       if (!SQL_HASZEROAFFECTED()) {
+       if (!ifSqlHasZeroAffectedRows()) {
                // Send out email to admin
-               sendAdminNotification('{--ADMIN_AUTOPURGE_TURBO_SUBJECT--}', 'admin_purge_turbo', SQL_AFFECTEDROWS());
+               sendAdminNotification('{--ADMIN_AUTOPURGE_TURBO_SUBJECT--}', 'admin_purge_turbo', sqlAffectedRows());
        } // END - if
 }