X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-lock_user.php;h=83455cbe47d8ce37bf3461452968d82862710a13;hb=d6c3ea5b9bcab66b9a7f29efb48e4118b126472e;hp=bf998d8863acf4d0b97d7d1a335b13dfe86e7492;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e;p=mailer.git

diff --git a/inc/modules/admin/what-lock_user.php b/inc/modules/admin/what-lock_user.php
index bf998d8863..83455cbe47 100644
--- a/inc/modules/admin/what-lock_user.php
+++ b/inc/modules/admin/what-lock_user.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 09/28/2003 *
- * ===============                              Last change: 06/10/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 09/28/2003 *
+ * ===================                          Last change: 06/10/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-lock_user.php                               *
@@ -46,28 +46,22 @@ 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) {
-		// User found
-		list($status, $gender, $surname, $family, $email) = SQL_FETCHROW($result_user);
-
-		// Free result
-		SQL_FREERESULT($result_user);
 
+	// Load user's data
+	if (fetchUserData(getRequestElement('userid'))) {
 		// Is a lock reason set?
-		if ((isPostRequestElementSet('lock')) && ($status != 'LOCKED')) {
+		if ((isPostRequestElementSet('lock')) && (getUserData('status') != 'LOCKED')) {
 			// Ok, lock the account!
 			if (getExtensionVersion('user') >= '0.3.5') {
 				// Lock with reason
-				SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='LOCKED',lock_reason='%s',lock_timestamp=NOW() WHERE `userid`=%s LIMIT 1",
-				array(postRequestElement('reason'), bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
+				SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='LOCKED', `lock_reason`='%s', `lock_timestamp`=NOW() WHERE `userid`=%s LIMIT 1",
+					array(postRequestElement('reason'), bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
 			} else {
 				// Lock with no lock reason saved
 				SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='LOCKED' WHERE `userid`=%s LIMIT 1",
-				array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
+					array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
 			}
 
 			// Entry updated?
@@ -76,13 +70,13 @@ if (isGetRequestElementSet('userid')) {
 				$message = loadEmailTemplate('lock-user', array('text' => postRequestElement('reason')), bigintval(getRequestElement('userid')));
 
 				// Send away...
-				sendEmail(bigintval(getRequestElement('userid')), ADMIN_LOCKED_SUBJ, $message);
+				sendEmail(bigintval(getRequestElement('userid')), getMessage('ADMIN_LOCKED_SUBJ'), $message);
 			} // END - if
 
 			// Prepare message
 			$message = sprintf(getMessage('USER_ACCOUNT_LOCKED'), getRequestElement('userid'));
 			$ACT = true;
-		} elseif ((isPostRequestElementSet(('unlock'))) && ($status == 'LOCKED')) {
+		} elseif ((isPostRequestElementSet('unlock')) && (getUserData('status') == 'LOCKED')) {
 			// Ok, unlock the account!
 			if (getExtensionVersion('user') >= '0.3.5') {
 				// Reset lock reason as well
@@ -126,23 +120,16 @@ 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['fname']   = $DATA['family'];
+				$content['email']   = generateEmailLink(getUserData('email'), 'user_data');
+				$content['surname'] = getUserData('surname');
+				$content['family']  = getUserData('family');
+				$content['status']  = getUserData('status');
 				$content['userid']  = bigintval(getRequestElement('userid'));
 
 				// Realy want to lock?
-				switch ($status) {
+				switch ($content['status']) {
 					case 'CONFIRMED': // Yes, lock him down... ;-)
 						$content['ok']     = 'lock';
 						$content['header'] = sprintf(getMessage('ADMIN_HEADER_LOCK_ACCOUNT'), $content['userid']);
@@ -162,15 +149,15 @@ LIMIT 1",
 						break;
 				}
 
+				// Translate user status
+				$content['status'] = translateUserStatus($content['status']);
+
 				// Output form
 				loadTemplate('admin_lock_user', false, $content);
 			} else {
 				// 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?
@@ -194,5 +181,5 @@ LIMIT 1",
 	addMemberSelectionBox();
 }
 
-//
+// [EOF]
 ?>