X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-lock_user.php;h=7d0068360b343bb6922774075d5d9bdd56936aa2;hb=96dfdd6b8e6a56d6594c3525e5fd2a066697a6de;hp=f986bd30e8e7022c66dd8bdcf157686cdc6be822;hpb=d06135324f6f1bf09e462193425dfcc556d3e769;p=mailer.git

diff --git a/inc/modules/admin/what-lock_user.php b/inc/modules/admin/what-lock_user.php
index f986bd30e8..7d0068360b 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'));
+			$message = getMaskedMessage('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
@@ -115,7 +109,7 @@ LIMIT 1",
 			} // END - if
 
 			// Prepare message
-			$message = sprintf(getMessage('USER_ACCOUNT_UNLOCKED'), getRequestElement('userid'));
+			$message = getMaskedMessage('USER_ACCOUNT_UNLOCKED', getRequestElement('userid'));
 			$ACT = true;
 		} elseif (isPostRequestElementSet('del')) {
 			// Delete the account
@@ -126,51 +120,44 @@ 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['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']);
-						$content['text']   = sprintf(getMessage('ADMIN_TEXT_LOCK_ACCOUNT'), $content['userid']);
+						$content['header'] = getMaskedMessage('ADMIN_HEADER_LOCK_ACCOUNT', $content['userid']);
+						$content['text']   = getMaskedMessage('ADMIN_TEXT_LOCK_ACCOUNT', $content['userid']);
 						break;
 
 					case 'LOCKED': // Unlock the user
-						$content['ok']     = $lock;
-						$content['header'] = sprintf(getMessage('ADMIN_HEADER_UNLOCK_ACCOUNT'), $content['userid']);
-						$content['text']   = sprintf(getMessage('ADMIN_TEXT_UNLOCK_ACCOUNT'), $content['userid']);
+						$content['ok']     = 'unlock';
+						$content['header'] = getMaskedMessage('ADMIN_HEADER_UNLOCK_ACCOUNT', $content['userid']);
+						$content['text']   = getMaskedMessage('ADMIN_TEXT_UNLOCK_ACCOUNT', $content['userid']);
 						break;
 
 					case 'UNCONFIRMED': // Unconfirmed accounts cannot be unlocked!
 						$content['ok'] = 'del';
-						$content['header'] = sprintf(getMessage('ADMIN_HEADER_DEL_ACCOUNT'), $content['userid']);
-						$content['text']   = sprintf(getMessage('ADMIN_TEXT_DEL_ACCOUNT'), $content['userid']);
+						$content['header'] = getMaskedMessage('ADMIN_HEADER_DEL_ACCOUNT', $content['userid']);
+						$content['text']   = getMaskedMessage('ADMIN_TEXT_DEL_ACCOUNT', $content['userid']);
 						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>");
+				loadTemplate('admin_settings_saved', false, '<div class="admin_failed">' . getMaskedMessage('ADMIN_MEMBER_404', getRequestElement('userid')) . '</div>');
 			}
-
-			// Free result
-			SQL_FREERESULT($result);
 		}
 
 		// Is an URL set?
@@ -180,19 +167,19 @@ LIMIT 1",
 		} elseif ($ACT) {
 			// An action was performed...
 			if (!empty($message)) {
-				loadTemplate('admin_settings_saved', false, "<div class=\"admin_green\">".$message."</div>");
+				loadTemplate('admin_settings_saved', false, '<div class="admin_failed">' . $message . '</div>');
 			} else {
-				loadTemplate('admin_settings_saved', false, "<div class=\"admin_green\">".getMessage('ADMIN_USER_UPDATED')."</div>");
+				loadTemplate('admin_settings_saved', false, '<div class="admin_failed">' . getMessage('ADMIN_USER_UPDATED') . '</div>');
 			}
 		}
 	} else {
 		// Account does not exists!
-		loadTemplate('admin_settings_saved', false, "<div class=\"admin_failed\">".sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))."</div>");
+		loadTemplate('admin_settings_saved', false, '<div class="admin_failed">' . getMaskedMessage('ADMIN_MEMBER_404', getRequestElement('userid')) . '</div>');
 	}
 } else {
 	// List all users
 	addMemberSelectionBox();
 }
 
-//
+// [EOF]
 ?>