phpBB
Statistics
| Revision:

root / branches / phpBB-3_0_0 / phpBB / includes / acp / acp_ban.php

History | View | Annotate | Download (7 kB)

1 5323 acydburn
<?php
2 8147 acydburn
/**
3 5323 acydburn
*
4 5323 acydburn
* @package acp
5 5323 acydburn
* @version $Id$
6 8147 acydburn
* @copyright (c) 2005 phpBB Group
7 8147 acydburn
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
8 5323 acydburn
*
9 5323 acydburn
*/
10 5323 acydburn
11 5323 acydburn
/**
12 8147 acydburn
* @ignore
13 8147 acydburn
*/
14 8147 acydburn
if (!defined('IN_PHPBB'))
15 8147 acydburn
{
16 8147 acydburn
        exit;
17 8147 acydburn
}
18 8147 acydburn
19 8147 acydburn
/**
20 5323 acydburn
* @package acp
21 5323 acydburn
*/
22 5323 acydburn
class acp_ban
23 5323 acydburn
{
24 5558 acydburn
        var $u_action;
25 5558 acydburn
26 5323 acydburn
        function main($id, $mode)
27 5323 acydburn
        {
28 5323 acydburn
                global $config, $db, $user, $auth, $template, $cache;
29 6015 acydburn
                global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;
30 5323 acydburn
31 5323 acydburn
                include($phpbb_root_path . 'includes/functions_user.' . $phpEx);
32 5323 acydburn
33 5323 acydburn
                $bansubmit        = (isset($_POST['bansubmit'])) ? true : false;
34 8120 kellanved
                $unbansubmit = (isset($_POST['unbansubmit'])) ? true : false;
35 5323 acydburn
                $current_time = time();
36 5323 acydburn
37 7005 davidmj
                $user->add_lang(array('acp/ban', 'acp/users'));
38 5323 acydburn
                $this->tpl_name = 'acp_ban';
39 8120 kellanved
                $form_key = 'acp_ban';
40 8120 kellanved
                add_form_key($form_key);
41 5323 acydburn
42 8123 kellanved
                if (($bansubmit || $unbansubmit) && !check_form_key($form_key))
43 8120 kellanved
                {
44 8120 kellanved
                        trigger_error($user->lang['FORM_INVALID'] . adm_back_link($this->u_action), E_USER_WARNING);
45 8120 kellanved
                }
46 8120 kellanved
47 5323 acydburn
                // Ban submitted?
48 5323 acydburn
                if ($bansubmit)
49 5323 acydburn
                {
50 5323 acydburn
                        // Grab the list of entries
51 7920 acydburn
                        $ban                                = utf8_normalize_nfc(request_var('ban', '', true));
52 5323 acydburn
                        $ban_len                        = request_var('banlength', 0);
53 5323 acydburn
                        $ban_len_other                = request_var('banlengthother', '');
54 5323 acydburn
                        $ban_exclude                = request_var('banexclude', 0);
55 7920 acydburn
                        $ban_reason                        = utf8_normalize_nfc(request_var('banreason', '', true));
56 7920 acydburn
                        $ban_give_reason        = utf8_normalize_nfc(request_var('bangivereason', '', true));
57 5323 acydburn
58 6925 acydburn
                        if ($ban)
59 6925 acydburn
                        {
60 6925 acydburn
                                user_ban($mode, $ban, $ban_len, $ban_len_other, $ban_exclude, $ban_reason, $ban_give_reason);
61 5323 acydburn
62 6925 acydburn
                                trigger_error($user->lang['BAN_UPDATE_SUCCESSFUL'] . adm_back_link($this->u_action));
63 6925 acydburn
                        }
64 5323 acydburn
                }
65 5323 acydburn
                else if ($unbansubmit)
66 5323 acydburn
                {
67 5323 acydburn
                        $ban = request_var('unban', array(''));
68 5323 acydburn
69 6925 acydburn
                        if ($ban)
70 6925 acydburn
                        {
71 6925 acydburn
                                user_unban($mode, $ban);
72 5323 acydburn
73 6925 acydburn
                                trigger_error($user->lang['BAN_UPDATE_SUCCESSFUL'] . adm_back_link($this->u_action));
74 6925 acydburn
                        }
75 5323 acydburn
                }
76 5323 acydburn
77 5323 acydburn
                // Define language vars
78 5323 acydburn
                $this->page_title = $user->lang[strtoupper($mode) . '_BAN'];
79 5323 acydburn
80 5323 acydburn
                $l_ban_explain = $user->lang[strtoupper($mode) . '_BAN_EXPLAIN'];
81 5323 acydburn
                $l_ban_exclude_explain = $user->lang[strtoupper($mode) . '_BAN_EXCLUDE_EXPLAIN'];
82 5323 acydburn
                $l_unban_title = $user->lang[strtoupper($mode) . '_UNBAN'];
83 5323 acydburn
                $l_unban_explain = $user->lang[strtoupper($mode) . '_UNBAN_EXPLAIN'];
84 5323 acydburn
                $l_no_ban_cell = $user->lang[strtoupper($mode) . '_NO_BANNED'];
85 5323 acydburn
86 5323 acydburn
                switch ($mode)
87 5323 acydburn
                {
88 5323 acydburn
                        case 'user':
89 5633 acydburn
                                $l_ban_cell = $user->lang['USERNAME'];
90 5633 acydburn
                        break;
91 5323 acydburn
92 5633 acydburn
                        case 'ip':
93 5633 acydburn
                                $l_ban_cell = $user->lang['IP_HOSTNAME'];
94 5633 acydburn
                        break;
95 5633 acydburn
96 5633 acydburn
                        case 'email':
97 5633 acydburn
                                $l_ban_cell = $user->lang['EMAIL_ADDRESS'];
98 5633 acydburn
                        break;
99 5633 acydburn
                }
100 5633 acydburn
101 5633 acydburn
                $this->display_ban_options($mode);
102 5633 acydburn
103 5633 acydburn
                $template->assign_vars(array(
104 5633 acydburn
                        'L_TITLE'                                => $this->page_title,
105 5633 acydburn
                        'L_EXPLAIN'                                => $l_ban_explain,
106 5633 acydburn
                        'L_UNBAN_TITLE'                        => $l_unban_title,
107 5633 acydburn
                        'L_UNBAN_EXPLAIN'                => $l_unban_explain,
108 5633 acydburn
                        'L_BAN_CELL'                        => $l_ban_cell,
109 5633 acydburn
                        'L_BAN_EXCLUDE_EXPLAIN'        => $l_ban_exclude_explain,
110 5633 acydburn
                        'L_NO_BAN_CELL'                        => $l_no_ban_cell,
111 5633 acydburn
112 5633 acydburn
                        'S_USERNAME_BAN'        => ($mode == 'user') ? true : false,
113 5633 acydburn
114 5633 acydburn
                        'U_ACTION'                        => $this->u_action,
115 8099 acydburn
                        'U_FIND_USERNAME'        => append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=searchuser&amp;form=acp_ban&amp;field=ban'),
116 8099 acydburn
                ));
117 5633 acydburn
        }
118 5633 acydburn
119 6073 acydburn
        /**
120 6073 acydburn
        * Display ban options
121 6073 acydburn
        */
122 5633 acydburn
        function display_ban_options($mode)
123 5633 acydburn
        {
124 5633 acydburn
                global $user, $db, $template;
125 5633 acydburn
126 5633 acydburn
                // Ban length options
127 5633 acydburn
                $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'] . ' -&gt; ');
128 5633 acydburn
129 5633 acydburn
                $ban_end_options = '';
130 5633 acydburn
                foreach ($ban_end_text as $length => $text)
131 5633 acydburn
                {
132 5633 acydburn
                        $ban_end_options .= '<option value="' . $length . '">' . $text . '</option>';
133 5633 acydburn
                }
134 5633 acydburn
135 5633 acydburn
                switch ($mode)
136 5633 acydburn
                {
137 5633 acydburn
                        case 'user':
138 5633 acydburn
139 5323 acydburn
                                $field = 'username';
140 5323 acydburn
                                $l_ban_cell = $user->lang['USERNAME'];
141 5323 acydburn
142 6698 acydburn
                                $sql = 'SELECT b.*, u.user_id, u.username, u.username_clean
143 5323 acydburn
                                        FROM ' . BANLIST_TABLE . ' b, ' . USERS_TABLE . ' u
144 5323 acydburn
                                        WHERE (b.ban_end >= ' . time() . '
145 5323 acydburn
                                                        OR b.ban_end = 0)
146 5323 acydburn
                                                AND u.user_id = b.ban_userid
147 6650 acydburn
                                        ORDER BY u.username_clean ASC';
148 5323 acydburn
                        break;
149 5323 acydburn
150 5323 acydburn
                        case 'ip':
151 5323 acydburn
152 5323 acydburn
                                $field = 'ban_ip';
153 5323 acydburn
                                $l_ban_cell = $user->lang['IP_HOSTNAME'];
154 5323 acydburn
155 5323 acydburn
                                $sql = 'SELECT *
156 5323 acydburn
                                        FROM ' . BANLIST_TABLE . '
157 5323 acydburn
                                        WHERE (ban_end >= ' . time() . "
158 5323 acydburn
                                                        OR ban_end = 0)
159 10088 terrafrost
                                                AND ban_ip <> ''
160 10088 terrafrost
                                        ORDER BY ban_ip";
161 5323 acydburn
                        break;
162 5323 acydburn
163 5323 acydburn
                        case 'email':
164 5323 acydburn
165 5323 acydburn
                                $field = 'ban_email';
166 5323 acydburn
                                $l_ban_cell = $user->lang['EMAIL_ADDRESS'];
167 5323 acydburn
168 5323 acydburn
                                $sql = 'SELECT *
169 5323 acydburn
                                        FROM ' . BANLIST_TABLE . '
170 5323 acydburn
                                        WHERE (ban_end >= ' . time() . "
171 5323 acydburn
                                                        OR ban_end = 0)
172 10088 terrafrost
                                                AND ban_email <> ''
173 10088 terrafrost
                                        ORDER BY ban_email";
174 5323 acydburn
                        break;
175 5323 acydburn
                }
176 5323 acydburn
                $result = $db->sql_query($sql);
177 5323 acydburn
178 11531 git-gate
                $banned_options = $excluded_options = array();
179 5323 acydburn
                $ban_length = $ban_reasons = $ban_give_reasons = array();
180 5323 acydburn
181 5323 acydburn
                while ($row = $db->sql_fetchrow($result))
182 5323 acydburn
                {
183 11531 git-gate
                        $option = '<option value="' . $row['ban_id'] . '">' . $row[$field] . '</option>';
184 5323 acydburn
185 11531 git-gate
                        if ($row['ban_exclude'])
186 11531 git-gate
                        {
187 11531 git-gate
                                $excluded_options[] = $option;
188 11531 git-gate
                        }
189 11531 git-gate
                        else
190 11531 git-gate
                        {
191 11531 git-gate
                                $banned_options[] = $option;
192 11531 git-gate
                        }
193 11531 git-gate
194 5323 acydburn
                        $time_length = ($row['ban_end']) ? ($row['ban_end'] - $row['ban_start']) / 60 : 0;
195 5323 acydburn
196 9727 nickvergessen
                        if ($time_length == 0)
197 9727 nickvergessen
                        {
198 9727 nickvergessen
                                // Banned permanently
199 9727 nickvergessen
                                $ban_length[$row['ban_id']] = $user->lang['PERMANENT'];
200 9727 nickvergessen
                        }
201 9727 nickvergessen
                        else if (isset($ban_end_text[$time_length]))
202 9727 nickvergessen
                        {
203 9727 nickvergessen
                                // Banned for a given duration
204 9727 nickvergessen
                                $ban_length[$row['ban_id']] = sprintf($user->lang['BANNED_UNTIL_DURATION'], $ban_end_text[$time_length], $user->format_date($row['ban_end'], false, true));
205 9727 nickvergessen
                        }
206 9727 nickvergessen
                        else
207 9727 nickvergessen
                        {
208 9727 nickvergessen
                                // Banned until given date
209 9727 nickvergessen
                                $ban_length[$row['ban_id']] = sprintf($user->lang['BANNED_UNTIL_DATE'], $user->format_date($row['ban_end'], false, true));
210 9727 nickvergessen
                        }
211 9727 nickvergessen
212 5323 acydburn
                        $ban_reasons[$row['ban_id']] = $row['ban_reason'];
213 5323 acydburn
                        $ban_give_reasons[$row['ban_id']] = $row['ban_give_reason'];
214 5323 acydburn
                }
215 5323 acydburn
                $db->sql_freeresult($result);
216 5323 acydburn
217 5323 acydburn
                if (sizeof($ban_length))
218 5323 acydburn
                {
219 5323 acydburn
                        foreach ($ban_length as $ban_id => $length)
220 5323 acydburn
                        {
221 5323 acydburn
                                $template->assign_block_vars('ban_length', array(
222 8099 acydburn
                                        'BAN_ID'        => (int) $ban_id,
223 5888 naderman
                                        'LENGTH'        => $length,
224 8099 acydburn
                                        'A_LENGTH'        => addslashes($length),
225 8099 acydburn
                                ));
226 5323 acydburn
                        }
227 5323 acydburn
                }
228 5323 acydburn
229 5323 acydburn
                if (sizeof($ban_reasons))
230 5323 acydburn
                {
231 5323 acydburn
                        foreach ($ban_reasons as $ban_id => $reason)
232 5323 acydburn
                        {
233 5323 acydburn
                                $template->assign_block_vars('ban_reason', array(
234 5323 acydburn
                                        'BAN_ID'        => $ban_id,
235 5888 naderman
                                        'REASON'        => $reason,
236 10691 git-gate
                                        'A_REASON'        => addslashes($reason),
237 8099 acydburn
                                ));
238 5323 acydburn
                        }
239 5323 acydburn
                }
240 5323 acydburn
241 5323 acydburn
                if (sizeof($ban_give_reasons))
242 5323 acydburn
                {
243 5323 acydburn
                        foreach ($ban_give_reasons as $ban_id => $reason)
244 5323 acydburn
                        {
245 5323 acydburn
                                $template->assign_block_vars('ban_give_reason', array(
246 5323 acydburn
                                        'BAN_ID'        => $ban_id,
247 5888 naderman
                                        'REASON'        => $reason,
248 10691 git-gate
                                        'A_REASON'        => addslashes($reason),
249 8099 acydburn
                                ));
250 5323 acydburn
                        }
251 5323 acydburn
                }
252 5323 acydburn
253 11531 git-gate
                $options = '';
254 11531 git-gate
                if ($excluded_options)
255 11531 git-gate
                {
256 11531 git-gate
                        $options .= '<optgroup label="' . $user->lang['OPTIONS_EXCLUDED'] . '">';
257 11531 git-gate
                        $options .= implode('', $excluded_options);
258 11531 git-gate
                        $options .= '</optgroup>';
259 11531 git-gate
                }
260 11531 git-gate
261 11531 git-gate
                if ($banned_options)
262 11531 git-gate
                {
263 11531 git-gate
                        $options .= '<optgroup label="' . $user->lang['OPTIONS_BANNED'] . '">';
264 11531 git-gate
                        $options .= implode('', $banned_options);
265 11531 git-gate
                        $options .= '</optgroup>';
266 11531 git-gate
                }
267 11531 git-gate
268 5323 acydburn
                $template->assign_vars(array(
269 5323 acydburn
                        'S_BAN_END_OPTIONS'        => $ban_end_options,
270 11531 git-gate
                        'S_BANNED_OPTIONS'        => ($banned_options || $excluded_options) ? true : false,
271 11531 git-gate
                        'BANNED_OPTIONS'        => $options,
272 11531 git-gate
                ));
273 5323 acydburn
        }
274 5323 acydburn
}
275 5323 acydburn
276 5323 acydburn
?>