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

[mailer.git] / inc / modules / admin / what-edit_user.php

diff --git a/inc/modules/admin/what-edit_user.php b/inc/modules/admin/what-edit_user.php
index b3bf8ec2a06452bd38bd61b3b2f7ae8b924db691..36962b8fa6d4041280b5c01ccb5fcdd9bcbaa302 100644 (file)
--- a/inc/modules/admin/what-edit_user.php
+++ b/inc/modules/admin/what-edit_user.php
@@ -18,8 +18,8 @@
  * @TODO Add support for ext-country                                    *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * 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 *
  * it under the terms of the GNU General Public License as published by *
@@ -46,13 +46,13 @@ if ((!defined('__SECURITY')) || (!isAdmin())) {
 addYouAreHereLink('admin', __FILE__);
 
 // Fix a notice
-$result_main = false;
+$result_main = FALSE;
 if (isGetRequestElementSet('userid')) {
        // Load user entry
-       $result_main = SQL_QUERY_ESC("SELECT
-       `userid`,`gender`,`surname`,`family`,`street_nr`,`zip`,`city`,`country`,
+       $result_main = sqlQueryEscaped("SELECT
+       `userid`, `gender`, `surname`, `family`, `street_nr`, `zip`, `city`, `country`,
        `email`,
-       `birth_day`,`birth_month`,`birth_year`,
+       `birth_day`, `birth_month`, `birth_year`,
        `max_mails`
 FROM
        `{?_MYSQL_PREFIX?}_user_data`
@@ -64,26 +64,26 @@ LIMIT 1",
                ), __FILE__, __LINE__);
 } // END - if
 
-if ((!isGetRequestElementSet('userid')) || (SQL_NUMROWS($result_main) == 1)) {
+if ((!isGetRequestElementSet('userid')) || (sqlNumRows($result_main) == 1)) {
        // User found
        if (!isGetRequestElementSet('userid')) {
                // Output selection form with all confirmed user accounts listed
                addMemberSelectionBox();
        } elseif (isFormSent('edit')) {
                // Ok, change the account...
-               $updateUser = false; $add = '';
-               if ((!isPostRequestElementSet('pass1')) && (!isPostRequestElementSet('pass2'))) {
+               $updateUser = FALSE; $add = '';
+               if ((!isPostRequestElementSet('password1')) && (!isPostRequestElementSet('password2'))) {
                        // Don't change the password
-                       $updateUser = true;
-               } elseif ((postRequestElement('pass1') == postRequestElement('pass2'))) {
+                       $updateUser = TRUE;
+               } elseif ((postRequestElement('password1') == postRequestElement('password2'))) {
                        // Change the password
-                       $updateUser = true;
-                       $add = ", `password`='" . generateHash(postRequestElement('pass1')) . "'";
+                       $updateUser = TRUE;
+                       $add = ",`password`='" . generateHash(postRequestElement('password1')) . "'";
                }
 
-               if ($updateUser === true) {
+               if ($updateUser === TRUE) {
                        // We have to add the following things: birthday and max receive mails
-                       SQL_QUERY_ESC("UPDATE
+                       sqlQueryEscaped("UPDATE
        `{?_MYSQL_PREFIX?}_user_data`
 SET
        `gender`='%s',
@@ -119,18 +119,18 @@ LIMIT 1",
                displayMessage($content);
        } else {
                // Load entry
-               $content = SQL_FETCHARRAY($result_main);
+               $content = sqlFetchArray($result_main);
 
                // Load template
-               loadTemplate('admin_edit_user', false, $content);
+               loadTemplate('admin_edit_user', FALSE, $content);
        }
 } else {
        // Account does not exists!
-       loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_MEMBER_404=' . bigintval(getRequestElement('userid')) . '%}');
+       displayErrorMessage('{%message,ADMIN_MEMBER_404=' . bigintval(getRequestElement('userid')) . '%}');
 }
 
 // Free the result
-SQL_FREERESULT($result_main);
+sqlFreeResult($result_main);
 
 // [EOF]
 ?>