Renamed all SQL-related functions to camel-case notation

[mailer.git] / inc / modules / member / what-nickname.php

diff --git a/inc/modules/member/what-nickname.php b/inc/modules/member/what-nickname.php
index b0d4737e50d501a88c4e2fe2309fdbfe63bb37e9..afe8ed31ded0317a8404994030d5e9fa32437c97 100644 (file)
--- a/inc/modules/member/what-nickname.php
+++ b/inc/modules/member/what-nickname.php
@@ -68,14 +68,14 @@ if ($isValid === TRUE) {
        $content = '{--MEMBER_NICKNAME_ALREADY_IN_USE--}';
 
        // Look for nickname in database (we only need just one entry so don't worry about the "LIMIT 1" !)
-       $result = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `nickname`='%s' AND `userid` != %s LIMIT 1",
+       $result = sqlQueryEscaped("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `nickname`='%s' AND `userid` != %s LIMIT 1",
                array(
                        postRequestElement('nickname'),
                        getMemberId()
                ), __FILE__, __LINE__);
 
        // Is it not in use?
-       if (SQL_HASZERONUMS($result)) {
+       if (ifSqlHasZeroNums($result)) {
                // Prepare array
                $filterData = array(
                        'history_subject' => 'NICKNAME_CHANGED',
@@ -87,7 +87,7 @@ if ($isValid === TRUE) {
                runFilterChain('add_history_entry', $filterData);
 
                // Nickname not in use, so set it now
-               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `nickname`='%s' WHERE `userid`=%s LIMIT 1",
+               sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `nickname`='%s' WHERE `userid`=%s LIMIT 1",
                        array(
                                postRequestElement('nickname'),
                                getMemberId()
@@ -98,7 +98,7 @@ if ($isValid === TRUE) {
        } // END - if
 
        // Free result
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Load template
        displayMessage($content);