2 /*=====================================================================*\
3 || ################################################################### ||
4 || # BugStrike [#]version[#]
5 || # --------------------------------------------------------------- # ||
6 || # Copyright ©2002-[#]year[#] by Iris Studios, Inc. All Rights Reserved. # ||
7 || # This file may not be reproduced in any way without permission. # ||
8 || # --------------------------------------------------------------- # ||
9 || # User License Agreement at http://www.iris-studios.com/license/ # ||
10 || ################################################################### ||
11 \*=====================================================================*/
13 require_once('./global.php');
14 require_once('./includes/functions_datastore.php');
16 if (!can_perform('canadmingroups'))
21 // ###################################################################
23 if (empty($_REQUEST['do']))
25 $_REQUEST['do'] = 'modify';
28 // ###################################################################
30 if ($_REQUEST['do'] == 'kill')
32 if ($bugsys->in
['usergroupid'] < 7)
34 $admin->error(phrase('cant_delete_default_usergroup'));
37 $db->query("DELETE FROM " . TABLE_PREFIX
. "usergroup WHERE usergroupid = " . intval($bugsys->in
['usergroupid']));
38 $db->query("UPDATE " . TABLE_PREFIX
. "user SET usergroupid = 2 WHERE usergroupid = " . intval($bugsys->in
['usergroupid']));
43 $admin->redirect('usergroup.php?do=modify');
46 // ###################################################################
48 if ($_REQUEST['do'] == 'delete')
50 if ($bugsys->in
['usergroupid'] < 7)
52 $admin->error(phrase('cant_delete_default_usergroup'));
55 $admin->page_confirm(phrase('confirm_delete_usergroup'), 'usergroup.php?do=kill&usergroupid=' . intval($bugsys->in
['usergroupid']));
58 // ###################################################################
60 if ($_REQUEST['do'] == 'add' OR $_REQUEST['do'] == 'edit')
62 $add = (($_REQUEST['do'] == 'add') ? true
: false
);
63 $edit = (($_REQUEST['do'] == 'edit') ? true
: false
);
65 $admin->page_start((($add) ?
phrase('new_usergroup') : phrase('edit_usergroup')));
67 $admin->form_start('usergroup.php', (($add) ?
'insert' : 'update'));
71 $usergroup = $db->query_first("SELECT * FROM " . TABLE_PREFIX
. "usergroup WHERE usergroupid = " . intval($bugsys->in
['usergroupid']));
72 if (!is_array($usergroup))
77 $admin->form_hidden_field('usergroupid', $usergroup['usergroupid']);
81 $usergroup['permissions'] = 319;
85 $admin->table_start();
86 $admin->table_head(phrase('usergroup_details'));
87 $admin->row_input(phrase('usergroup_title'), 'title', $bugsys->sanitize($usergroup['title']));
88 $admin->row_input(phrase('usergroup_display_title'), 'displaytitle', $bugsys->sanitize($usergroup['displaytitle']));
89 $admin->row_input(phrase('usergroup_open_markup'), 'opentag', $bugsys->sanitize($usergroup['opentag']));
90 $admin->row_input(phrase('usergroup_close_markup'), 'closetag', $bugsys->sanitize($usergroup['closetag']));
94 $admin->table_start();
96 // define permissions as groups
109 'moderation' => array(
124 $admin->table_head(phrase('usergroup_permission_settings'));
126 foreach ($permissions AS $group => $settings)
128 $admin->row_span(phrase("permissions_group_$group"), 'thead', 'center');
129 foreach ($settings AS $setting)
131 $admin->row_yesno(phrase("permissions_$setting"), "perm[$setting]", ($usergroup['permissions'] & $_PERMISSION["$setting"]));
138 $admin->table_start();
139 $admin->row_submit();
147 // ###################################################################
149 if ($_POST['do'] == 'insert')
151 foreach ($_POST['perm'] AS $permtitle => $binaryswitch)
153 $permissionvalue +
= $_PERMISSION["$permtitle"] * $binaryswitch;
157 INSERT INTO " . TABLE_PREFIX
. "usergroup
158 (title, displaytitle, opentag, closetag, permissions)
160 ('" . $bugsys->in
['title'] . "', '" . $bugsys->in
['displaytitle'] . "',
161 '" . $bugsys->in
['opentag'] . "', '" . $bugsys->in
['closetag'] . "',
168 $admin->redirect('usergroup.php?do=modify');
171 // ###################################################################
173 if ($_POST['do'] == 'update')
175 sanitize(array('usergroupid' => INT, 'title' => STR
, 'displaytitle' => STR
, 'opentag' => STR
, 'closetag' => STR
));
177 foreach ($_POST['perm'] AS $permtitle => $binaryswitch)
179 $permissionvalue +
= $_PERMISSION["$permtitle"] * $binaryswitch;
183 UPDATE " . TABLE_PREFIX
. "usergroup
184 SET title = '" . $bugsys->in
['title'] . "',
185 displaytitle = '" . $bugsys->in
['displaytitle'] . "',
186 opentag = '" . $bugsys->unsanitize($bugsys->in
['opentag']) . "',
187 closetag = '" . $bugsys->unsanitize($bugsys->in
['closetag']) . "',
188 permissions = $permissionvalue
189 WHERE usergroupid = " . intval($bugsys->in
['usergroupid'])
195 $admin->redirect('usergroup.php?do=modify');
198 // ###################################################################
200 if ($_REQUEST['do'] == 'modify')
202 $admin->page_start(phrase('usergroup_manager'));
204 $admin->form_start('usergroup.php', 'null');
205 $admin->table_start();
206 $admin->table_head(phrase('usergroup_manager'), 3);
208 $groups = $db->query("SELECT * FROM " . TABLE_PREFIX
. "usergroup ORDER BY usergroupid ASC");
209 while ($group = $db->fetch_array($groups))
211 $usergroups["$group[usergroupid]"] = $group;
213 $db->free_result($groups);
215 $groups = $db->query("
216 SELECT COUNT(user.userid) AS total, user.usergroupid
217 FROM " . TABLE_PREFIX
. "user AS user
218 LEFT JOIN " . TABLE_PREFIX
. "usergroup AS usergroup USING (usergroupid)
219 GROUP BY usergroup.usergroupid
220 ORDER BY usergroup.usergroupid"
222 while ($group = $db->fetch_array($groups))
224 $usergroups["$group[usergroupid]"]['total'] = $group['total'];
227 $admin->table_column_head(array(phrase('usergroup'), phrase('number_of_users'), phrase('action')));
228 foreach ($usergroups AS $group)
230 $admin->row_multi_item(array("<a href=\"usergroup.php?do=edit&usergroupid=$group[usergroupid]\">$group[title]</a>" => 'l', ((!$group['total']) ?
'-' : $group['total']) => 'c', "<a href=\"usergroup.php?do=edit&usergroupid=$group[usergroupid]\">" . phrase('edit_wraplink') . "</a>" . (($group['usergroupid'] > 6) ?
"<a href=\"usergroup.php?do=delete&usergroupid=$group[usergroupid]\">" . phrase('delete_wraplink') . "</a>" : '') => 'c'));
233 $admin->row_span('<input type="button" name="addug" value=" ' . phrase('add_new_usergroup') . ' " onclick="window.location = \'usergroup.php?do=add\';" />', 'tfoot', 'center', 3);
240 /*=====================================================================*\
241 || ###################################################################
244 || ###################################################################
245 \*=====================================================================*/