r922: - Adding support for DST
[bugdar.git] / admin / user.php
1 <?php
2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
6 || #
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
10 || #
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
14 || # more details.
15 || #
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
21
22 require_once('./global.php');
23 require_once('./includes/api_user.php');
24
25 NavLinks::usersPages();
26 $navigator->set_focus('tab', 'users', null);
27
28 if (!can_perform('canadminusers'))
29 {
30 admin_login();
31 }
32
33 // ###################################################################
34
35 if (empty($_REQUEST['do']))
36 {
37 $_REQUEST['do'] = 'modify';
38 }
39
40 // ###################################################################
41
42 if ($_REQUEST['do'] == 'kill')
43 {
44 $user = new UserAPI($bugsys);
45 $user->set('userid', $bugsys->in['userid']);
46 $user->set_condition();
47 $user->delete();
48
49 $admin->redirect('user.php');
50 }
51
52 // ###################################################################
53
54 if ($_REQUEST['do'] == 'delete')
55 {
56 $admin->page_confirm($lang->string('Are you sure you want to delete this user?'), 'user.php?do=kill&amp;userid=' . $bugsys->input_clean('userid', TYPE_UINT));
57 }
58
59 // ###################################################################
60
61 if ($_POST['do'] == 'insert')
62 {
63 $user = new UserAPI($bugsys);
64 $user->set('displayname', $bugsys->in['displayname']);
65 $user->set('email', $bugsys->in['email']);
66 $user->set('showemail', $bugsys->in['showemail']);
67 $user->set('showcolours', $bugsys->in['showcolours']);
68 $user->set('usergroupid', $bugsys->in['usergroupid']);
69 $user->set('languageid', $bugsys->in['languageid']);
70 $user->set('timezone', $bugsys->in['timezone']);
71 $user->set('usedst', $bugsys->in['usedst']);
72 $user->set('password', $bugsys->in['password']);
73 $user->insert();
74
75 $admin->redirect('user.php?do=edit&userid=' . $user->insertid);
76 }
77
78 // ###################################################################
79
80 if ($_POST['do'] == 'update')
81 {
82 $user = new UserAPI($bugsys);
83 $user->set('userid', $bugsys->in['userid']);
84 $user->set_condition();
85 $user->set('displayname', $bugsys->in['displayname']);
86 $user->set('email', $bugsys->in['email']);
87 $user->set('showemail', $bugsys->in['showemail']);
88 $user->set('showcolours', $bugsys->in['showcolours']);
89 $user->set('usergroupid', $bugsys->in['usergroupid']);
90 $user->set('languageid', $bugsys->in['languageid']);
91 $user->set('timezone', $bugsys->in['timezone']);
92 $user->set('usedst', $bugsys->in['usedst']);
93 $user->set('password', $bugsys->in['password']);
94 $user->update();
95
96 $admin->redirect('user.php?do=edit&userid=' . $user->objdata['userid']);
97 }
98
99 // ###################################################################
100
101 if ($_REQUEST['do'] == 'edit' OR $_REQUEST['do'] == 'add')
102 {
103 $add = ($_REQUEST['do'] == 'add');
104 $edit = (!$add);
105
106 if ($edit)
107 {
108 NavLinks::usersEdit($bugsys->in['userid']);
109 $navigator->set_focus('link', 'users-pages-users', 'users-pages');
110
111 $user = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = " . $bugsys->input_clean('userid', TYPE_UINT));
112 if (!$user)
113 {
114 $admin->error($lang->getlex('error_invalid_id'));
115 }
116 }
117 else
118 {
119 NavLinks::usersAdd();
120 $navigator->set_focus('link', 'users-add', 'users');
121 }
122
123 $admin->page_start(($add ? $lang->string('Add User') : $lang->string('Edit User')));
124
125 $admin->form_start('user.php', ($add ? 'insert' : 'update'));
126
127 if ($edit)
128 {
129 $admin->form_hidden_field('userid', $user['userid']);
130 }
131
132 $admin->table_start();
133
134 $admin->table_head(($add ? $lang->string('Add User') : sprintf($lang->string('Edit User (userid: %1$s)'), $user['userid'])));
135
136 $admin->row_input($lang->string('Display Name'), 'displayname', $user['displayname']);
137 $admin->row_input($lang->string('Email'), 'email', $user['email']);
138 $admin->row_input(($add ? $lang->string('Password') : $lang->string('Password (Leave blank for no change)')), 'password');
139
140 foreach ($bugsys->datastore['usergroup'] AS $group)
141 {
142 $admin->list_item($group['title'], $group['usergroupid'], ($user['usergroupid'] == $group['usergroupid']));
143 }
144 $admin->row_list($lang->string('Usergroup'), 'usergroupid');
145
146 $admin->row_yesno($lang->string('Show Email Publicly'), 'showemail', $user['showemail']);
147 $admin->row_yesno($lang->string('Show Status Colours on Bug Listings'), 'showcolours', $user['showcolours']);
148
149 foreach ($bugsys->datastore['language'] AS $language)
150 {
151 $admin->list_item($language['title'], $language['languageid'], ($user['languageid'] == $language['languageid']));
152 }
153 $admin->row_list($lang->string('Language'), 'languageid');
154
155 foreach ($datef->fetch_timezone_list() AS $value => $string)
156 {
157 $admin->list_item($string, $value, ($user['timezone'] == $value));
158 }
159 $admin->row_list($lang->string('Timezone'), 'timezone');
160 $admin->row_yesno($lang->string('Observe Daylight Savings Time (DST)'), 'usedst', $user['usedst']);
161
162 $admin->row_submit();
163
164 $admin->table_end();
165 $admin->form_end();
166
167 $admin->page_end();
168 }
169
170 // ###################################################################
171
172 if ($_REQUEST['do'] == 'search')
173 {
174 $fail = false;
175
176 NavLinks::usersAdd();
177 $navigator->set_focus('link', 'users-pages-users', 'users-pages');
178
179 if (is_numeric($bugsys->in['userdata']))
180 {
181 $bugsys->input_clean('userdata', TYPE_UINT);
182 if ($db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = " . $bugsys->in['userdata']))
183 {
184 header('Location: user.php?do=edit&userid=' . $bugsys->in['userdata']);
185 }
186 else
187 {
188 $fail = true;
189 }
190 }
191 else
192 {
193 $bugsys->in['userdata'] = str_replace('%', '\%', $bugsys->in['userdata']);
194 $results = $db->query("SELECT * FROM " . TABLE_PREFIX . "user WHERE email LIKE '%" . $bugsys->input_escape('userdata') . "%' OR displayname LIKE '%" . $bugsys->input_escape('userdata') . "%'");
195
196 if ($db->num_rows($results) < 1)
197 {
198 $fail = true;
199 }
200 else
201 {
202 $admin->page_start($lang->string('Search Results'));
203
204 $admin->table_start();
205 $admin->table_head($lang->string('Search Results'), 4);
206 $admin->table_column_head(array($lang->string('Display Name'), $lang->string('Email'), $lang->string('User ID'), $lang->string('Actions')));
207
208 while ($row = $db->fetch_array($results))
209 {
210 $admin->row_multi_item(array(
211 $row['displayname'] => 'l',
212 $row['email'] => 'c',
213 $row['userid'] => 'c',
214 '<a href="user.php?do=edit&amp;userid=' . $row['userid'] . '">[' . $lang->string('Edit') . ']</a>' => 'c'
215 ));
216 }
217
218 $admin->table_end();
219
220 $admin->page_end();
221 }
222 }
223
224 if ($fail)
225 {
226 $admin->error($lang->string('Sorry, we could not find any users that matched your criteria.'));
227 }
228 }
229
230 // ###################################################################
231
232 if ($_REQUEST['do'] == 'modify')
233 {
234 NavLinks::usersAdd();
235 $navigator->set_focus('link', 'users-pages-users', 'users-pages');
236
237 $admin->page_start($lang->string('User Search'));
238
239 $admin->form_start('user.php', 'search');
240 $admin->table_start(true, '45%');
241
242 $admin->table_head($lang->string('User Search'));
243 $admin->row_input($lang->string('Name/Email/ID'), 'userdata');
244
245 $admin->row_submit('', ':save:', '');
246
247 $admin->table_end();
248 $admin->form_end();
249
250 $admin->page_end();
251 }
252
253 /*=====================================================================*\
254 || ###################################################################
255 || # $HeadURL$
256 || # $Id$
257 || ###################################################################
258 \*=====================================================================*/
259 ?>