= '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(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(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' => postRequestParameter('reason')), bigintval(getRequestParameter('userid'))); // Send away... sendEmail(bigintval(getRequestParameter('userid')), getMessage('ADMIN_LOCKED_SUBJ'), $message); } // END - if // Prepare message $message = getMaskedMessage('USER_ACCOUNT_LOCKED', getRequestParameter('userid')); $ACT = true; } elseif ((isPostRequestParameterSet('unlock')) && (getUserData('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(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(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' => postRequestParameter('reason')), bigintval(getRequestParameter('userid'))); // Send away... sendEmail(bigintval(getRequestParameter('userid')), getMessage('ADMIN_UNLOCKED_SUBJ'), $message); if (isExtensionActive('rallye')) { addUserToReferalRallye(getRequestParameter('userid')); } // END - if } // END - if // Prepare message $message = getMaskedMessage('USER_ACCOUNT_UNLOCKED', getRequestParameter('userid')); $ACT = true; } elseif (isPostRequestParameterSet('del')) { // Delete the account $ACT = true; loadIncludeOnce('inc/modules/admin/what-del_user.php'); } elseif (isPostRequestParameterSet('no')) { // Do not lock him... $URL = adminCreateUserLink(getRequestParameter('userid')); } else { // Load user data we need if (fetchUserData(getRequestParameter('userid'))) { // Transfer data to constants for the template $content['email'] = generateEmailLink(getUserData('email'), 'user_data'); $content['surname'] = getUserData('surname'); $content['family'] = getUserData('family'); $content['status'] = getUserData('status'); $content['userid'] = bigintval(getRequestParameter('userid')); // Realy want to lock? switch ($content['status']) { case 'CONFIRMED': // Yes, lock him down... ;-) $content['ok'] = 'lock'; $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'] = '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'] = 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, '
' . getMaskedMessage('ADMIN_MEMBER_404', getRequestParameter('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, '
' . getMaskedMessage('ADMIN_MEMBER_404', getRequestParameter('userid')) . '
'); } } else { // List all users addMemberSelectionBox(); } // [EOF] ?>