X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-lock_user.php;h=8c1aacad42f7532102d984fc30161974051ca752;hb=501a861954273a54a21b714587fc33b57322d8e4;hp=c418df55cb625f90d68c6ac341ab2492ab70cdf0;hpb=125728e8580923ae216baa96e8a4f286a6fea8f4;p=mailer.git

diff --git a/inc/modules/admin/what-lock_user.php b/inc/modules/admin/what-lock_user.php
index c418df55cb..8c1aacad42 100644
--- a/inc/modules/admin/what-lock_user.php
+++ b/inc/modules/admin/what-lock_user.php
@@ -46,11 +46,11 @@ addMenuDescription('admin', __FILE__);
 
 // Is a userid set?
 if (isGetRequestElementSet('userid')) {
-	// Load user's data
-	$result_user = SQL_QUERY_ESC("SELECT `status`, `gender`, `surname`, `family`, `email` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
-		array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
+	// Action not performed by default
 	$ACT = false;
-	if (SQL_NUMROWS($result_user) == 1) {
+
+	// Load user's data
+	if (fetchUserData(getRequestElement('userid'))) {
 		// Is a lock reason set?
 		if ((isPostRequestElementSet('lock')) && ($status != 'LOCKED')) {
 			// Ok, lock the account!
@@ -120,19 +120,11 @@ LIMIT 1",
 			$URL = adminCreateUserLink(getRequestElement('userid'));
 		} else {
 			// Load user data we need
-			$result = SQL_QUERY_ESC("SELECT `email`, `surname`, `family` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`=%s LIMIT 1",
-				array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
-
-			// Entry found?
-			if (SQL_NUMROWS($result) == 1) {
-				// Load data
-				$DATA = SQL_FETCHARRAY($result);
-
+			if (fetchUserData(getRequestElement('userid'))) {
 				// Transfer data to constants for the template
-				// @TODO Rewrite these all constants
-				$content['email']   = generateEmailLink($DATA['email'], 'user_data');
-				$content['surname'] = $DATA['surname'];
-				$content['family']  = $DATA['family'];
+				$content['email']   = generateEmailLink(getUserData('email'), 'user_data');
+				$content['surname'] = getUserData('surname');
+				$content['family']  = getUserData('family');
 				$content['userid']  = bigintval(getRequestElement('userid'));
 
 				// Realy want to lock?
@@ -162,9 +154,6 @@ LIMIT 1",
 				// Account does not exists!
 				loadTemplate('admin_settings_saved', false, "<div class=\"admin_failed\">".sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))."</div>");
 			}
-
-			// Free result
-			SQL_FREERESULT($result);
 		}
 
 		// Is an URL set?
@@ -183,9 +172,6 @@ LIMIT 1",
 		// Account does not exists!
 		loadTemplate('admin_settings_saved', false, "<div class=\"admin_failed\">".sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))."</div>");
 	}
-
-	// Free result
-	SQL_FREERESULT($result_user);
 } else {
 	// List all users
 	addMemberSelectionBox();