X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-nickname.php;h=7a9e7b511447e4500b7b0f879c56f1101be9f766;hb=76fd13e5938a334f08e43893eb9a4ff49f72bf07;hp=bd40a66b78226519a2e7ca046fc8763ca36c9b02;hpb=4e5020660b07f30b7bf3ccc0a2ca664a19a21c0d;p=mailer.git diff --git a/inc/modules/member/what-nickname.php b/inc/modules/member/what-nickname.php index bd40a66b78..7a9e7b5114 100644 --- a/inc/modules/member/what-nickname.php +++ b/inc/modules/member/what-nickname.php @@ -70,7 +70,7 @@ if ($isValid === true) { // 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__);