| <?php |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| if (!defined('IN_PHPBB')) |
| { |
| exit; |
| } |
| |
| |
| |
| |
| class acp_ban |
| { |
| var $u_action; |
| |
| function main($id, $mode) |
| { |
| global $config, $db, $user, $auth, $template, $cache; |
| global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix; |
| |
| include($phpbb_root_path . 'includes/functions_user.' . $phpEx); |
| |
| $bansubmit = (isset($_POST['bansubmit'])) ? true : false; |
| $unbansubmit = (isset($_POST['unbansubmit'])) ? true : false; |
| $current_time = time(); |
| |
| $user->add_lang(array('acp/ban', 'acp/users')); |
| $this->tpl_name = 'acp_ban'; |
| $form_key = 'acp_ban'; |
| add_form_key($form_key); |
| |
| if (($bansubmit || $unbansubmit) && !check_form_key($form_key)) |
| { |
| trigger_error($user->lang['FORM_INVALID'] . adm_back_link($this->u_action), E_USER_WARNING); |
| } |
| |
| |
| if ($bansubmit) |
| { |
| |
| $ban = utf8_normalize_nfc(request_var('ban', '', true)); |
| $ban_len = request_var('banlength', 0); |
| $ban_len_other = request_var('banlengthother', ''); |
| $ban_exclude = request_var('banexclude', 0); |
| $ban_reason = utf8_normalize_nfc(request_var('banreason', '', true)); |
| $ban_give_reason = utf8_normalize_nfc(request_var('bangivereason', '', true)); |
| |
| if ($ban) |
| { |
| user_ban($mode, $ban, $ban_len, $ban_len_other, $ban_exclude, $ban_reason, $ban_give_reason); |
| |
| trigger_error($user->lang['BAN_UPDATE_SUCCESSFUL'] . adm_back_link($this->u_action)); |
| } |
| } |
| else if ($unbansubmit) |
| { |
| $ban = request_var('unban', array('')); |
| |
| if ($ban) |
| { |
| user_unban($mode, $ban); |
| |
| trigger_error($user->lang['BAN_UPDATE_SUCCESSFUL'] . adm_back_link($this->u_action)); |
| } |
| } |
| |
| |
| $this->page_title = $user->lang[strtoupper($mode) . '_BAN']; |
| |
| $l_ban_explain = $user->lang[strtoupper($mode) . '_BAN_EXPLAIN']; |
| $l_ban_exclude_explain = $user->lang[strtoupper($mode) . '_BAN_EXCLUDE_EXPLAIN']; |
| $l_unban_title = $user->lang[strtoupper($mode) . '_UNBAN']; |
| $l_unban_explain = $user->lang[strtoupper($mode) . '_UNBAN_EXPLAIN']; |
| $l_no_ban_cell = $user->lang[strtoupper($mode) . '_NO_BANNED']; |
| |
| switch ($mode) |
| { |
| case 'user': |
| $l_ban_cell = $user->lang['USERNAME']; |
| break; |
| |
| case 'ip': |
| $l_ban_cell = $user->lang['IP_HOSTNAME']; |
| break; |
| |
| case 'email': |
| $l_ban_cell = $user->lang['EMAIL_ADDRESS']; |
| break; |
| } |
| |
| $this->display_ban_options($mode); |
| |
| $template->assign_vars(array( |
| 'L_TITLE' => $this->page_title, |
| 'L_EXPLAIN' => $l_ban_explain, |
| 'L_UNBAN_TITLE' => $l_unban_title, |
| 'L_UNBAN_EXPLAIN' => $l_unban_explain, |
| 'L_BAN_CELL' => $l_ban_cell, |
| 'L_BAN_EXCLUDE_EXPLAIN' => $l_ban_exclude_explain, |
| 'L_NO_BAN_CELL' => $l_no_ban_cell, |
| |
| 'S_USERNAME_BAN' => ($mode == 'user') ? true : false, |
| |
| 'U_ACTION' => $this->u_action, |
| 'U_FIND_USERNAME' => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&form=acp_ban&field=ban'), |
| )); |
| } |
| |
| |
| |
| |
| function display_ban_options($mode) |
| { |
| global $user, $db, $template; |
| |
| |
| $ban_end_text = array(0 => $user->lang['PERMANENT'], 30 => $user->lang['30_MINS'], 60 => $user->lang['1_HOUR'], 360 => $user->lang['6_HOURS'], 1440 => $user->lang['1_DAY'], 10080 => $user->lang['7_DAYS'], 20160 => $user->lang['2_WEEKS'], 40320 => $user->lang['1_MONTH'], -1 => $user->lang['UNTIL'] . ' -> '); |
| |
| $ban_end_options = ''; |
| foreach ($ban_end_text as $length => $text) |
| { |
| $ban_end_options .= '<option value="' . $length . '">' . $text . '</option>'; |
| } |
| |
| switch ($mode) |
| { |
| case 'user': |
| |
| $field = 'username'; |
| $l_ban_cell = $user->lang['USERNAME']; |
| |
| $sql = 'SELECT b.*, u.user_id, u.username, u.username_clean |
| FROM ' . BANLIST_TABLE . ' b, ' . USERS_TABLE . ' u |
| WHERE (b.ban_end >= ' . time() . ' |
| OR b.ban_end = 0) |
| AND u.user_id = b.ban_userid |
| ORDER BY u.username_clean ASC'; |
| break; |
| |
| case 'ip': |
| |
| $field = 'ban_ip'; |
| $l_ban_cell = $user->lang['IP_HOSTNAME']; |
| |
| $sql = 'SELECT * |
| FROM ' . BANLIST_TABLE . ' |
| WHERE (ban_end >= ' . time() . " |
| OR ban_end = 0) |
| AND ban_ip <> ''"; |
| break; |
| |
| case 'email': |
| |
| $field = 'ban_email'; |
| $l_ban_cell = $user->lang['EMAIL_ADDRESS']; |
| |
| $sql = 'SELECT * |
| FROM ' . BANLIST_TABLE . ' |
| WHERE (ban_end >= ' . time() . " |
| OR ban_end = 0) |
| AND ban_email <> ''"; |
| break; |
| } |
| $result = $db->sql_query($sql); |
| |
| $banned_options = ''; |
| $ban_length = $ban_reasons = $ban_give_reasons = array(); |
| |
| while ($row = $db->sql_fetchrow($result)) |
| { |
| $banned_options .= '<option' . (($row['ban_exclude']) ? ' class="sep"' : '') . ' value="' . $row['ban_id'] . '">' . $row[$field] . '</option>'; |
| |
| $time_length = ($row['ban_end']) ? ($row['ban_end'] - $row['ban_start']) / 60 : 0; |
| $ban_length[$row['ban_id']] = (isset($ban_end_text[$time_length])) ? $ban_end_text[$time_length] : $user->lang['UNTIL'] . ' -> ' . $user->format_date($row['ban_end']); |
| |
| $ban_reasons[$row['ban_id']] = $row['ban_reason']; |
| $ban_give_reasons[$row['ban_id']] = $row['ban_give_reason']; |
| } |
| $db->sql_freeresult($result); |
| |
| if (sizeof($ban_length)) |
| { |
| foreach ($ban_length as $ban_id => $length) |
| { |
| $template->assign_block_vars('ban_length', array( |
| 'BAN_ID' => (int) $ban_id, |
| 'LENGTH' => $length, |
| 'A_LENGTH' => addslashes($length), |
| )); |
| } |
| } |
| |
| if (sizeof($ban_reasons)) |
| { |
| foreach ($ban_reasons as $ban_id => $reason) |
| { |
| $template->assign_block_vars('ban_reason', array( |
| 'BAN_ID' => $ban_id, |
| 'REASON' => $reason, |
| 'A_REASON' => addslashes(htmlspecialchars_decode($reason)), |
| )); |
| } |
| } |
| |
| if (sizeof($ban_give_reasons)) |
| { |
| foreach ($ban_give_reasons as $ban_id => $reason) |
| { |
| $template->assign_block_vars('ban_give_reason', array( |
| 'BAN_ID' => $ban_id, |
| 'REASON' => $reason, |
| 'A_REASON' => addslashes(htmlspecialchars_decode($reason)), |
| )); |
| } |
| } |
| |
| $template->assign_vars(array( |
| 'S_BAN_END_OPTIONS' => $ban_end_options, |
| 'S_BANNED_OPTIONS' => ($banned_options) ? true : false, |
| 'BANNED_OPTIONS' => $banned_options) |
| ); |
| } |
| } |
| |
| ?> |