X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-nickname.php;h=afe8ed31ded0317a8404994030d5e9fa32437c97;hp=b0d4737e50d501a88c4e2fe2309fdbfe63bb37e9;hb=155492a5b96cec674846973a8524238b0365a848;hpb=da5c63bacddced77a951cbe7b223f314885a6c87

diff --git a/inc/modules/member/what-nickname.php b/inc/modules/member/what-nickname.php
index b0d4737e50..afe8ed31de 100644
--- 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);