Renamed ifSqlHasZeroNums() to ifSqlHasZeroNumRows() and improved some queries.

[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 5312676f6671a0ecc4adaf927cac5746049b2b04..ba66cb970da059a4378feacbb67aeb1098b6bb32 100644 (file)
--- a/inc/modules/member/what-nickname.php
+++ b/inc/modules/member/what-nickname.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -50,7 +50,7 @@ if ((!isExtensionActive('nickname')) && (!isAdmin())) {
        return;
 } // END - if
 
-$isValid = false;
+$isValid = FALSE;
 
 if (isFormSent()) {
        // Nickname was submitted so let's check if it is not already in use
@@ -63,19 +63,19 @@ if (isFormSent()) {
        } // END - if
 } // END - if
 
-if ($isValid === true) {
+if ($isValid === TRUE) {
        // Nickname already in use which is the default
        $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 (ifSqlHasZeroNumRows($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,14 +98,14 @@ if ($isValid === true) {
        } // END - if
 
        // Free result
-       SQL_FREERESULT($result);
+       sqlFreeResult($result);
 
        // Load template
        displayMessage($content);
 } else {
-       // Do we have already submit the form?
+       // Is there already submit the form?
        if (isPostRequestElementSet('nickname')) {
-               loadTemplate('admin_settings_unsaved', false, '{--MEMBER_NICKNAME_IS_INVALID--}');
+               displayErrorMessage('{--MEMBER_NICKNAME_IS_INVALID--}');
        } // END - if
 
        // Load Template