Renamed all SQL-related functions to camel-case notation

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

diff --git a/inc/libs/refback_functions.php b/inc/libs/refback_functions.php
index f079c6a35385d7d9792558575fe62d9325af531b..b8f077ba06d500731d231d16a291ca3d31d6221c 100644 (file)
--- a/inc/libs/refback_functions.php
+++ b/inc/libs/refback_functions.php
@@ -50,11 +50,11 @@ function addRefbackPoints ($userid, $ref, $points, $ref_points) {
        $return = $ref_points;
 
        // Get all ref levels
-       $result_refs = SQL_QUERY('SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `level` > 0 ORDER BY `level` ASC',
+       $result_refs = sqlQuery('SELECT `level`, `percents` FROM `{?_MYSQL_PREFIX?}_refdepths` WHERE `level` > 0 ORDER BY `level` ASC',
                __FUNCTION__, __LINE__);
 
        // "Walk" through all level
-       while ($content = SQL_FETCHARRAY($result_refs)) {
+       while ($content = sqlFetchArray($result_refs)) {
                //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'level=' . $content['level'] . ',percents=' . $content['percents'] . ' - LOOP START!');
                // Reset ref depths
                initReferralSystem();
@@ -81,7 +81,7 @@ function addRefbackPoints ($userid, $ref, $points, $ref_points) {
                                //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'points=' . $points . ',percents=' . $content['percents'] . ',refback_percents=' . $content['refback_percents'] . ',level=' . $content['level'] . ',refback_points=' . $refbackPoints);
 
                                // Update refback table ('refid' and 'userid' must be exchanged!)
-                               SQL_QUERY_ESC('UPDATE
+                               sqlQueryEscaped('UPDATE
        `{?_MYSQL_PREFIX?}_user_refs`
 SET
        `refback_points`=`refback_points`+%s
@@ -96,7 +96,7 @@ LIMIT 1',
                                        ), __FUNCTION__, __LINE__);
 
                                // Something must have been updated
-                               if (SQL_HASZEROAFFECTED()) {
+                               if (ifSqlHasZeroAffectedRows()) {
                                        // Please report this bug
                                        reportBug(__FUNCTION__, __LINE__, 'Nothing has been updated in user_refs,userid=' . $userid . ',refid=' . convertNullToZero($refid) . ',refbackPoints=' . $refbackPoints);
                                } // END - if
@@ -117,7 +117,7 @@ LIMIT 1',
        } // END - while
 
        // Free result
-       SQL_FREERESULT($result_refs);
+       sqlFreeResult($result_refs);
 
        // Restore ref depth
        $GLOBALS['ref_level'] = $GLOBALS['refback_depth'][$userid][$ref];
@@ -150,13 +150,13 @@ function getRefbackPercents ($userid, $refid) {
                $GLOBALS['refback_percents'][$userid][$refid] = '0';
 
                // Get percents from database
-               $result = SQL_QUERY_ESC("SELECT `refback_percents` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `refid`=%s LIMIT 1",
+               $result = sqlQueryEscaped("SELECT `refback_percents` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `refid`=%s LIMIT 1",
                        array($userid, $refid), __FUNCTION__, __LINE__);
 
                // Entry found? (Should be!)
-               if (SQL_NUMROWS($result) == 1) {
+               if (sqlNumRows($result) == 1) {
                        // Fetch percents
-                       list($GLOBALS['refback_percents'][$userid][$refid]) = SQL_FETCHROW($result);
+                       list($GLOBALS['refback_percents'][$userid][$refid]) = sqlFetchRow($result);
                        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',refid=' . $refid . ',percents=' . $GLOBALS['refback_percents'][$userid][$refid]);
                } else {
                        // Please report all findings
@@ -164,7 +164,7 @@ function getRefbackPercents ($userid, $refid) {
                }
 
                // Free result
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
        } // END - if
 
        // Return percents
@@ -179,7 +179,7 @@ function getArrayFromRefbackLevel ($refid, $level) {
        $userIds = array();
 
        // Look for all
-       $result = SQL_QUERY_ESC("SELECT
+       $result = sqlQueryEscaped("SELECT
        `userid`
 FROM
        `{?_MYSQL_PREFIX?}_user_refs`
@@ -192,16 +192,16 @@ ORDER BY
 
        // Entries found?
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'numRows=' . SQL_NUMROWS($result));
-       if (!SQL_HASZERONUMS($result)) {
+       if (!ifSqlHasZeroNums($result)) {
                // Add all
-               while ($content = SQL_FETCHARRAY($result)) {
+               while ($content = sqlFetchArray($result)) {
                        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'refid=' . convertNullToZero($refid) . ',level=' . $level . ',userid=' . $content['userid']);
                        array_push($userIds, $content['userid']);
                } // END - while
        } // END - if
 
        // Free result
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Return array
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'refid=' . convertNullToZero($refid) . ',userIds()=' . count($userIds) . ' - EXIT!');
@@ -215,7 +215,7 @@ function getArrayFromRefbackUserRefs ($userid, $level) {
        $refs = array();
 
        // Get refs from database
-       $result = SQL_QUERY_ESC("SELECT
+       $result = sqlQueryEscaped("SELECT
        `r`.`id`,
        `r`.`refid`,
        `r`.`refback_percents`,
@@ -239,9 +239,9 @@ ORDER BY
                array(bigintval($userid), bigintval($level)), __FUNCTION__, __LINE__);
 
        // Are there some entries?
-       if (!SQL_HASZERONUMS($result)) {
+       if (!ifSqlHasZeroNums($result)) {
                // Fetch all entries
-               while ($row = SQL_FETCHARRAY($result)) {
+               while ($row = sqlFetchArray($result)) {
                        // Init click rate
                        $row['click_rate'] = '0';
 
@@ -257,7 +257,7 @@ ORDER BY
        } // END - if
 
        // Free result
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Return result
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid=' . $userid . ',level=' . $level . ',refs()=' . count($refs) . ' - EXIT!');
@@ -274,17 +274,17 @@ function getArrayFromUserRefbackData ($id) {
        $id = bigintval($id);
 
        // Get entry from database
-       $result = SQL_QUERY_ESC("SELECT `id`, `userid`, `refid`, `refback_percents`, `level`, `refback_points` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `id`=%s AND `userid`=%s LIMIT 1",
+       $result = sqlQueryEscaped("SELECT `id`, `userid`, `refid`, `refback_percents`, `level`, `refback_points` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `id`=%s AND `userid`=%s LIMIT 1",
                array($id, getMemberId()), __FUNCTION__, __LINE__);
 
        // Is there an entry?
-       if (SQL_NUMROWS($result) == 1) {
+       if (sqlNumRows($result) == 1) {
                // Fetch data
-               $data = SQL_FETCHARRAY($result);
+               $data = sqlFetchArray($result);
        } // END - if
 
        // Free result
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Return entry
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'id=' . $id . ',data()=' . count($data) . ' - EXIT!');
@@ -326,7 +326,7 @@ function updateMemberRefbackPercents ($id, $percents, $note) {
        $percents = convertCommaToDot($percents);
 
        // Update entry
-       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_refs` SET `refback_percents`='%s' WHERE `id`=%s AND `userid`=%s LIMIT 1",
+       sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_refs` SET `refback_percents`='%s' WHERE `id`=%s AND `userid`=%s LIMIT 1",
                array(
                        $percents,
                        $id,
@@ -334,7 +334,7 @@ function updateMemberRefbackPercents ($id, $percents, $note) {
                ), __FUNCTION__, __LINE__);
 
        // Entry updated?
-       if (SQL_HASZEROAFFECTED()) {
+       if (ifSqlHasZeroAffectedRows()) {
                // Entry not updated!
                $status['message'] = 'MEMBER_REFBACK_ERROR_NOT_UPDATED';
                return $status;