X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-lock_user.php;h=f91f2aedd4e6126dc03cefe6465ee6c5151bc326;hp=bf998d8863acf4d0b97d7d1a335b13dfe86e7492;hb=f2aeaab0cd313b2eeb151642455ed558f6b186dc;hpb=64c8349613addc3da2242c5cd6b99d64e3fb5f8e diff --git a/inc/modules/admin/what-lock_user.php b/inc/modules/admin/what-lock_user.php index bf998d8863..f91f2aedd4 100644 --- a/inc/modules/admin/what-lock_user.php +++ b/inc/modules/admin/what-lock_user.php @@ -1,7 +1,7 @@ = '0.3.5') { + if (isExtensionInstalledAndNewer('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(postRequestParameter('reason'), bigintval(getRequestParameter('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(getRequestParameter('userid'))), __FILE__, __LINE__); } // Entry updated? if (SQL_AFFECTEDROWS() == 1) { // Send an email to the user! In later version you can optionally switch this feature off - $message = loadEmailTemplate('lock-user', array('text' => postRequestElement('reason')), bigintval(getRequestElement('userid'))); + $message = loadEmailTemplate('lock-user', array('text' => postRequestParameter('reason')), bigintval(getRequestParameter('userid'))); // Send away... - sendEmail(bigintval(getRequestElement('userid')), ADMIN_LOCKED_SUBJ, $message); + sendEmail(bigintval(getRequestParameter('userid')), getMessage('ADMIN_LOCKED_SUBJ'), $message); } // END - if // Prepare message - $message = sprintf(getMessage('USER_ACCOUNT_LOCKED'), getRequestElement('userid')); + $message = getMaskedMessage('USER_ACCOUNT_LOCKED', bigintval(getRequestParameter('userid'))); $ACT = true; - } elseif ((isPostRequestElementSet(('unlock'))) && ($status == 'LOCKED')) { + } elseif ((isPostRequestParameterSet('unlock')) && (getUserData('status') == 'LOCKED')) { // Ok, unlock the account! - if (getExtensionVersion('user') >= '0.3.5') { + if (isExtensionInstalledAndNewer('user', '0.3.5')) { // Reset lock reason as well SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` @@ -95,70 +90,59 @@ SET WHERE `userid`=%s LIMIT 1", - array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__); + array(bigintval(getRequestParameter('userid'))), __FILE__, __LINE__); } else { // No lock reason to reset SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='CONFIRMED' WHERE `userid`=%s LIMIT 1", - array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__); + array(bigintval(getRequestParameter('userid'))), __FILE__, __LINE__); } // Entry updated? if (SQL_AFFECTEDROWS() == 1) { // Send an email to the user! In later version you can optionally switch this feature off - $message = loadEmailTemplate('unlock-user', array('text' => postRequestElement('reason')), bigintval(getRequestElement('userid'))); + $message = loadEmailTemplate('unlock-user', array('text' => postRequestParameter('reason')), bigintval(getRequestParameter('userid'))); // Send away... - sendEmail(bigintval(getRequestElement('userid')), getMessage('ADMIN_UNLOCKED_SUBJ'), $message); + sendEmail(bigintval(getRequestParameter('userid')), getMessage('ADMIN_UNLOCKED_SUBJ'), $message); if (isExtensionActive('rallye')) { - addUserToReferalRallye(getRequestElement('userid')); + addUserToReferalRallye(getRequestParameter('userid')); } // END - if } // END - if // Prepare message - $message = sprintf(getMessage('USER_ACCOUNT_UNLOCKED'), getRequestElement('userid')); + $message = getMaskedMessage('USER_ACCOUNT_UNLOCKED', bigintval(getRequestParameter('userid'))); $ACT = true; - } elseif (isPostRequestElementSet('del')) { + } elseif (isFormSent('del')) { // Delete the account $ACT = true; loadIncludeOnce('inc/modules/admin/what-del_user.php'); - } elseif (isPostRequestElementSet('no')) { + } elseif (isPostRequestParameterSet('no')) { // Do not lock him... - $URL = adminCreateUserLink(getRequestElement('userid')); + $url = adminCreateUserLink(getRequestParameter('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(getRequestParameter('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['userid'] = bigintval(getRequestElement('userid')); + $content['userid'] = getRequestParameter('userid'); // Realy want to lock? - switch ($status) { + switch (getUserData('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; } @@ -166,33 +150,30 @@ LIMIT 1", loadTemplate('admin_lock_user', false, $content); } else { // Account does not exists! - loadTemplate('admin_settings_saved', false, "
".sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))."
"); + loadTemplate('admin_settings_saved', false, '
' . getMaskedMessage('ADMIN_MEMBER_404', bigintval(getRequestParameter('userid'))) . '
'); } - - // Free result - SQL_FREERESULT($result); } // Is an URL set? - if (!empty($URL)) { + if (!empty($url)) { // Reload and die... - redirectToUrl($URL); + redirectToUrl($url); } elseif ($ACT) { // An action was performed... if (!empty($message)) { - loadTemplate('admin_settings_saved', false, "
".$message."
"); + loadTemplate('admin_settings_saved', false, '
' . $message . '
'); } else { - loadTemplate('admin_settings_saved', false, "
".getMessage('ADMIN_USER_UPDATED')."
"); + loadTemplate('admin_settings_saved', false, '
{--ADMIN_USER_UPDATED--}
'); } } } else { // Account does not exists! - loadTemplate('admin_settings_saved', false, "
".sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))."
"); + loadTemplate('admin_settings_saved', false, '
' . getMaskedMessage('ADMIN_MEMBER_404', bigintval(getRequestParameter('userid'))) . '
'); } } else { // List all users addMemberSelectionBox(); } -// +// [EOF] ?>