$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',
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()
} // END - if
// Free result
- SQL_FREERESULT($result);
+ sqlFreeResult($result);
// Load template
displayMessage($content);