// 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",
array(postRequestParameter('nickname'), getMemberId()), __FILE__, __LINE__);
- if (SQL_NUMROWS($result) == '0') {
+ if (SQL_HASZERONUMS($result)) {
// Nickname not in use, so set it now
SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `nickname`='%s' WHERE `userid`=%s LIMIT 1",
array(postRequestParameter('nickname'), getMemberId()), __FILE__, __LINE__);
- $content = getMessage('NICKNAME_SAVED');
+ $content = '{--NICKNAME_SAVED--}';
} else {
// Free result
SQL_FREERESULT($result);
// Nickname already in use!
- $content = getMessage('NICKNAME_ALREADY_IN_USE');
+ $content = '{--NICKNAME_ALREADY_IN_USE--}';
}
// Load template