= '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__); } 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__); } // 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'))); // Send away... 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')) { // Ok, unlock the account! if (getExtensionVersion('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(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(getRequestElement('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'))); // Send away... sendEmail(bigintval(getRequestElement('userid')), getMessage('ADMIN_UNLOCKED_SUBJ'), $message); if (isExtensionActive('rallye')) { addUserToReferalRallye(getRequestElement('userid')); } // END - if } // END - if // Prepare message $message = sprintf(getMessage('USER_ACCOUNT_UNLOCKED'), getRequestElement('userid')); $ACT = true; } elseif (isPostRequestElementSet('del')) { // Delete the account $ACT = true; loadIncludeOnce('inc/modules/admin/what-del_user.php'); } elseif (isPostRequestElementSet('no')) { // Do not lock him... $URL = adminCreateUserLink(getRequestElement('userid')); } else { // Load user data we need if (fetchUserData(getRequestElement('userid'))) { // Transfer data to constants for the template $content['email'] = generateEmailLink(getUserData('email'), 'user_data'); $content['surname'] = getUserData('surname'); $content['family'] = getUserData('family'); $content['userid'] = bigintval(getRequestElement('userid')); // Realy want to lock? switch ($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']); 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']); 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']); break; } // Output form loadTemplate('admin_lock_user', false, $content); } else { // Account does not exists! loadTemplate('admin_settings_saved', false, "
".sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))."
"); } } // Is an URL set? if (!empty($URL)) { // Reload and die... redirectToUrl($URL); } elseif ($ACT) { // An action was performed... if (!empty($message)) { loadTemplate('admin_settings_saved', false, "
".$message."
"); } else { loadTemplate('admin_settings_saved', false, "
".getMessage('ADMIN_USER_UPDATED')."
"); } } } else { // Account does not exists! loadTemplate('admin_settings_saved', false, "
".sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))."
"); } } else { // List all users addMemberSelectionBox(); } // [EOF] ?>