X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-lock_user.php;h=79cc7c84e203e8ab9d08ba2b08c8605b6139c63d;hp=06c4557c92bb6b21e18b873fb73a9b657d09c333;hb=a18efdcd57ba91893f0958a457b5c58639b135c3;hpb=1cf72a9c1a5e737509af79d49f0731da2eb6a218 diff --git a/inc/modules/admin/what-lock_user.php b/inc/modules/admin/what-lock_user.php index 06c4557c92..79cc7c84e2 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($_POST['reason'], bigintval($_GET['u_id'])), __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($_GET['u_id'])), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='LOCKED' WHERE `userid`=%s LIMIT 1", + array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__); } // Entry updated? - if (SQL_AFFECTEDROWS() == 1) { + if (!SQL_HASZEROAFFECTED()) { // Send an email to the user! In later version you can optionally switch this feature off - $msg = LOAD_EMAIL_TEMPLATE("lock-user", array('text' => $_POST['reason']), bigintval($_GET['u_id'])); + $message = loadEmailTemplate('member_user_locked', array('text' => postRequestElement('reason')), bigintval(getRequestElement('userid'))); // Send away... - SEND_EMAIL(bigintval($_GET['u_id']), ADMIN_LOCKED_SUBJ, $msg); + sendEmail(bigintval(getRequestElement('userid')), '{--ADMIN_LOCKED_SUBJECT--}', $message); } // END - if // Prepare message - $MSG = USER_ACCOUNT_LOCKED_1.$_GET['u_id'].USER_ACCOUNT_LOCKED_2; - $ACT = true; - } elseif ((!empty($_POST['unlock'])) && ($status == "LOCKED")) { + $message = '{%message,ADMIN_USER_ACCOUNT_LOCKED=' . bigintval(getRequestElement('userid')) . '%}'; + $isActive = true; + } elseif ((isPostRequestElementSet('unlock')) && (getUserData('status') == 'LOCKED')) { // Ok, unlock the account! - if (GET_EXT_VERSION("user") >= "0.3.5") { + if (isExtensionInstalledAndNewer('user', '0.3.5')) { // Reset lock reason as well - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `status`='CONFIRMED',lock_reason='',lock_timestamp='0000-00-00 00:00' WHERE userid=%s LIMIT 1", - array(bigintval($_GET['u_id'])), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE + `{?_MYSQL_PREFIX?}_user_data` +SET + `status`='CONFIRMED', + `lock_reason`='', + `lock_timestamp`=NULL +WHERE + `userid`=%s +LIMIT 1", + array(bigintval(getRequestElement('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($_GET['u_id'])), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='CONFIRMED' WHERE `userid`=%s LIMIT 1", + array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__); } // Entry updated? - if (SQL_AFFECTEDROWS() == 1) { + if (!SQL_HASZEROAFFECTED()) { // Send an email to the user! In later version you can optionally switch this feature off - $msg = LOAD_EMAIL_TEMPLATE("unlock-user", array('text' => $_POST['reason']), bigintval($_GET['u_id'])); + $message = loadEmailTemplate('member_user_unlocked', array('text' => postRequestElement('reason')), bigintval(getRequestElement('userid'))); // Send away... - SEND_EMAIL(bigintval($_GET['u_id']), getMessage('ADMIN_UNLOCKED_SUBJ'), $msg); - if (EXT_IS_ACTIVE("rallye")) { - RALLYE_AUTOADD_USER($_GET['u_id']); + sendEmail(bigintval(getRequestElement('userid')), '{--ADMIN_UNLOCKED_SUBJECT--}', $message); + if (isExtensionActive('rallye')) { + addUserToReferralRallye(getRequestElement('userid')); } // END - if } // END - if // Prepare message - $MSG = USER_ACCOUNT_UNLOCKED_1.$_GET['u_id'].USER_ACCOUNT_UNLOCKED_2; - $ACT = true; - } elseif (isset($_POST['del'])) { + $message = '{%message,ADMIN_USER_ACCOUNT_UNLOCKED=' . bigintval(getRequestElement('userid')) . '%}'; + $isActive = true; + } elseif (isFormSent('delete')) { // Delete the account - $ACT = true; - LOAD_INC_ONCE("inc/modules/admin/what-del_user.php"); - } elseif (!empty($_POST['no'])) { + $isActive = true; + loadIncludeOnce('inc/modules/admin/what-del_user.php'); + } elseif (isPostRequestElementSet('no')) { // Do not lock him... - $URL = "modules.php?module=admin&what=list_user&u_id=".bigintval($_GET['u_id']); + $url = adminCreateUserLink(getRequestElement('userid')); } else { - $result = SQL_QUERY_ESC("SELECT email, surname, family FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1", - array(bigintval($_GET['u_id'])), __FILE__, __LINE__); - - // Entry found? - if (SQL_NUMROWS($result) == 1) { - // Load data - list ($email, $sname, $fname) = SQL_FETCHROW($result); - - // Free result - SQL_FREERESULT($result); - + // Load user data we need + if (fetchUserData(getRequestElement('userid'))) { // Transfer data to constants for the template - define('__EMAIL', CREATE_EMAIL_LINK($email, "user_data")); - define('__SNAME', $sname); - define('__FNAME', $fname); - define('__UID' , bigintval($_GET['u_id'])); + $content['userid'] = getRequestElement('userid'); // Realy want to lock? - switch ($status) - { - case "CONFIRMED": // Yes, lock him down... ;-) - define('__OK_VALUE' , "lock"); - define('__HEADER_VALUE', ADMIN_HEADER_LOCK_ACCOUNT_1.__UID.ADMIN_HEADER_LOCK_ACCOUNT_2); - define('__TEXT_VALUE' , ADMIN_TEXT_LOCK_ACCOUNT_1.__UID.ADMIN_TEXT_LOCK_ACCOUNT_2); - break; - - case "LOCKED": // Unlock the user - define('__OK_VALUE' , "unlock"); - define('__HEADER_VALUE', ADMIN_HEADER_UNLOCK_ACCOUNT_1.__UID.ADMIN_HEADER_UNLOCK_ACCOUNT_2); - define('__TEXT_VALUE' , ADMIN_TEXT_UNLOCK_ACCOUNT_1.__UID.ADMIN_TEXT_UNLOCK_ACCOUNT_2); - break; - - case "UNCONFIRMED": // Unconfirmed accounts cannot be unlocked! - define('__OK_VALUE' , "del"); - define('__HEADER_VALUE', ADMIN_HEADER_DEL_ACCOUNT_1.__UID.ADMIN_HEADER_DEL_ACCOUNT_2); - define('__TEXT_VALUE' , ADMIN_TEXT_DEL_ACCOUNT_1.__UID.ADMIN_TEXT_DEL_ACCOUNT_2); - break; + switch (getUserData('status')) { + case 'CONFIRMED': // Yes, lock him down... ;-) + $content['ok'] = 'lock'; + $content['header'] = '{%message,ADMIN_HEADER_LOCK_ACCOUNT=' . $content['userid'] . '%}'; + $content['text'] = '{%message,ADMIN_TEXT_LOCK_ACCOUNT=' . $content['userid'] . '%}'; + break; + + case 'LOCKED': // Unlock the user + $content['ok'] = 'unlock'; + $content['header'] = '{%message,ADMIN_HEADER_UNLOCK_ACCOUNT=' . $content['userid'] . '%}'; + $content['text'] = '{%message,ADMIN_TEXT_UNLOCK_ACCOUNT=' . $content['userid'] . '%}'; + break; + + case 'UNCONFIRMED': // Unconfirmed accounts cannot be unlocked! + $content['ok'] = 'delete'; + $content['header'] = '{%message,ADMIN_HEADER_DELETE_ACCOUNT=' . $content['userid'] . '%}'; + $content['text'] = '{%message,ADMIN_TEXT_DELETE_ACCOUNT=' . $content['userid'] . '%}'; + break; } // Output form - LOAD_TEMPLATE("admin_lock_user"); + loadTemplate('admin_lock_user', false, $content); } else { // Account does not exists! - LOAD_TEMPLATE("admin_settings_saved", false, "
".sprintf(getMessage('ADMIN_MEMBER_404'), $_GET['u_id'])."
"); + loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_MEMBER_404=' . bigintval(getRequestElement('userid')), '%}'); } } // Is an URL set? - if (!empty($URL)) { + if (!empty($url)) { // Reload and die... - LOAD_URL($URL); - } elseif ($ACT) { + redirectToUrl($url); + } elseif ($isActive) { // An action was performed... - if (!empty($MSG)) { - LOAD_TEMPLATE("admin_settings_saved", false, "
".$MSG."
"); + if (!empty($message)) { + loadTemplate('admin_settings_unsaved', false, $message); } else { - LOAD_TEMPLATE("admin_settings_saved", false, "
".getMessage('ADMIN_USER_UPDATED')."
"); + displayMessage('{--ADMIN_USER_UPDATED--}'); } } } else { // Account does not exists! - LOAD_TEMPLATE("admin_settings_saved", false, "
".sprintf(getMessage('ADMIN_MEMBER_404'), $_GET['u_id'])."
"); + loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_MEMBER_404=' . bigintval(getRequestElement('userid')), '%}'); } } else { // List all users - ADD_MEMBER_SELECTION_BOX(); + addMemberSelectionBox(); } -// +// [EOF] ?>