Renamed all SQL-related functions to camel-case notation

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

diff --git a/inc/modules/admin/what-list_refs.php b/inc/modules/admin/what-list_refs.php
index 7864189edcc29cbd2efa716aee78f46e555799a2..4dd3a54e024c755710ea3a1d5944836198b8bec1 100644 (file)
--- a/inc/modules/admin/what-list_refs.php
+++ b/inc/modules/admin/what-list_refs.php
@@ -55,7 +55,7 @@ if (isGetRequestElementSet('userid')) {
                displayMessage(sprintf(getMessage('ADMIN_USER_TOTAL_REFS'), generateUserProfileLink(getRequestElement('userid')), $totalReferrals, $totalLockedReferrals));
 
                // Load all referral levels
-               $result_levels = SQL_QUERY("SELECT
+               $result_levels = sqlQuery("SELECT
        `level`,
        `percents`
 FROM
@@ -66,12 +66,12 @@ ORDER BY
        `level` ASC", __FILE__, __LINE__);
 
                // Are there some levels (VERY BAD IF NONE!)
-               if (!SQL_HASZERONUMS($result_levels)) {
+               if (!ifSqlHasZeroNums($result_levels)) {
                        // List all ref levels or entries if no refback is installed
                        $OUT = '';
-                       while ($levels = SQL_FETCHARRAY($result_levels)) {
+                       while ($levels = sqlFetchArray($result_levels)) {
                                // Load all refs of this user
-                               $result_refs = SQL_QUERY_ESC("SELECT `refid` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`=%s ORDER BY `refid` ASC",
+                               $result_refs = sqlQueryEscaped("SELECT `refid` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `userid`=%s AND `level`=%s ORDER BY `refid` ASC",
                                        array(
                                                $userid,
                                                $levels['level']
@@ -79,7 +79,7 @@ ORDER BY
                                //* DEBUG: */ debugOutput($userid.'/'.$levels['level'].'/'.SQL_NUMROWS($result_refs));
 
                                // Is there levels?
-                               if (!SQL_HASZERONUMS($result_refs)) {
+                               if (!ifSqlHasZeroNums($result_refs)) {
                                        // Count entries
                                        $totalReferrals       = getUsersTotalReferrals($userid, $levels['level']);
                                        $totalLockedReferrals = getUsersTotalLockedReferrals($userid, $levels['level']);
@@ -91,7 +91,7 @@ ORDER BY
                                        $OUT_REFS = '';
 
                                        // Load all refs
-                                       while ($content = SQL_FETCHARRAY($result_refs)) {
+                                       while ($content = sqlFetchArray($result_refs)) {
                                                // Is the data there?
                                                if (fetchUserData($content['refid'])) {
                                                        // Check for referrals
@@ -130,7 +130,7 @@ ORDER BY
                                }
 
                                // Free result
-                               SQL_FREERESULT($result_refs);
+                               sqlFreeResult($result_refs);
 
                                // Load level template
                                $OUT .= loadTemplate('admin_list_refs_level', TRUE, $levels);
@@ -150,7 +150,7 @@ ORDER BY
                }
 
                // Free result
-               SQL_FREERESULT($result_levels);
+               sqlFreeResult($result_levels);
        } else {
                // User not found
                displayMessage('{%message,ADMIN_MEMBER_404=' . getRequestElement('userid') . '%}');