admin/user.php

   1 <?php
   2 /*=====================================================================*\
   3 || ###################################################################
   4 || # Bugdar [#]version[#]
   5 || # Copyright ©2002-[#]year[#] Blue Static
   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 require_once('./includes/class_sort.php');
  25
  26 require_once('./includes/class_api_error.php');
  27 APIError(array(new API_Error_Handler($admin), 'admin_error'));
  28
  29 NavLinks::usersPages();
  30 $navigator->set_focus('tab', 'users', null);
  31
  32 if (!can_perform('canadminusers'))
  33 {
  34         admin_login();
  35 }
  36
  37 // ###################################################################
  38
  39 if (empty($_REQUEST['do']))
  40 {
  41         $_REQUEST['do'] = 'modify';
  42 }
  43
  44 // ###################################################################
  45
  46 if ($_REQUEST['do'] == 'kill')
  47 {
  48         $user = new UserAPI($bugsys);
  49         $user->set('userid',    $bugsys->in['userid']);
  50         $user->set_condition();
  51         $user->delete();
  52
  53         $admin->redirect('user.php');
  54 }
  55
  56 // ###################################################################
  57
  58 if ($_REQUEST['do'] == 'delete')
  59 {
  60         $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));
  61 }
  62
  63 // ###################################################################
  64
  65 if ($_POST['do'] == 'insert')
  66 {
  67         $user = new UserAPI($bugsys);
  68         $user->set('displayname',       $bugsys->in['displayname']);
  69         $user->set('email',                     $bugsys->in['email']);
  70         $user->set('showemail',         $bugsys->in['showemail']);
  71         $user->set('showcolours',       $bugsys->in['showcolours']);
  72         $user->set('usergroupid',       $bugsys->in['usergroupid']);
  73         $user->set('languageid',        $bugsys->in['languageid']);
  74         $user->set('timezone',          $bugsys->in['timezone']);
  75         $user->set('usedst',            $bugsys->in['usedst']);
  76         $user->set('password',          $bugsys->in['password']);
  77         $user->set('hidestatuses',      $bugsys->in['hidestatuses']);
  78         $user->set('defaultsorkey',     $bugsys->in['defaultsortkey']);
  79         $user->set('defaultsortas',     $bugsys->in['defaultsortas']);
  80         $user->insert();
  81
  82         $admin->redirect('user.php?do=edit&userid=' . $user->insertid);
  83 }
  84
  85 // ###################################################################
  86
  87 if ($_POST['do'] == 'update')
  88 {
  89         $user = new UserAPI($bugsys);
  90         $user->set('userid',            $bugsys->in['userid']);
  91         $user->set_condition();
  92         $user->set('displayname',       $bugsys->in['displayname']);
  93         $user->set('email',                     $bugsys->in['email']);
  94         $user->set('showemail',         $bugsys->in['showemail']);
  95         $user->set('showcolours',       $bugsys->in['showcolours']);
  96         $user->set('usergroupid',       $bugsys->in['usergroupid']);
  97         $user->set('languageid',        $bugsys->in['languageid']);
  98         $user->set('timezone',          $bugsys->in['timezone']);
  99         $user->set('usedst',            $bugsys->in['usedst']);
 100         $user->set('password',          $bugsys->in['password']);
 101         $user->set('hidestatuses',      $bugsys->in['hidestatuses']);
 102         $user->set('defaultsorkey',     $bugsys->in['defaultsortkey']);
 103         $user->set('defaultsortas',     $bugsys->in['defaultsortas']);
 104         $user->update();
 105
 106         $admin->redirect('user.php?do=edit&userid=' . $user->objdata['userid']);
 107 }
 108
 109 // ###################################################################
 110
 111 if ($_REQUEST['do'] == 'edit' OR $_REQUEST['do'] == 'add')
 112 {
 113         $add = ($_REQUEST['do'] == 'add');
 114         $edit = (!$add);
 115
 116         if ($edit)
 117         {
 118                 NavLinks::usersEdit($bugsys->in['userid']);
 119                 $navigator->set_focus('link', 'users-pages-users', 'users-pages');
 120
 121                 $user = new UserAPI($bugsys);
 122                 $user->set('userid', $bugsys->in['userid']);
 123                 $user->set_condition();
 124                 $user->fetch();
 125         }
 126         else
 127         {
 128                 NavLinks::usersAdd();
 129                 $navigator->set_focus('link', 'users-add', 'users');
 130         }
 131
 132         $admin->page_start(($add ? $lang->string('Add User') : $lang->string('Edit User')));
 133
 134         $admin->form_start('user.php', ($add ? 'insert' : 'update'));
 135
 136         if ($edit)
 137         {
 138                 $admin->form_hidden_field('userid', $user->objdata['userid']);
 139         }
 140
 141         $admin->table_start();
 142
 143         $admin->table_head(($add ? $lang->string('Add User') : sprintf($lang->string('Edit User (userid: %1$s)'), $user->objdata['userid'])));
 144
 145         $admin->row_input($lang->string('Display Name'), 'displayname', $user->objdata['displayname']);
 146         $admin->row_input($lang->string('Email'), 'email', $user->objdata['email']);
 147         $admin->row_input(($add ? $lang->string('Password') : $lang->string('Password (Leave blank for no change)')), 'password');
 148
 149         foreach ($bugsys->datastore['usergroup'] AS $group)
 150         {
 151                 $admin->list_item($group['title'], $group['usergroupid'], ($user->objdata['usergroupid'] == $group['usergroupid']));
 152         }
 153         $admin->row_list($lang->string('Usergroup'), 'usergroupid');
 154
 155         $admin->row_yesno($lang->string('Show Email Publicly'), 'showemail', $user->objdata['showemail']);
 156         $admin->row_yesno($lang->string('Show Status Colours on Bug Listings'), 'showcolours', $user->objdata['showcolours']);
 157
 158         foreach ($bugsys->datastore['language'] AS $language)
 159         {
 160                 $admin->list_item($language['title'], $language['languageid'], ($user->objdata['languageid'] == $language['languageid']));
 161         }
 162         $admin->row_list($lang->string('Language'), 'languageid');
 163
 164         foreach ($datef->fetch_timezone_list() AS $value => $string)
 165         {
 166                 $admin->list_item($string, $value, ($user->objdata['timezone'] == $value));
 167         }
 168         $admin->row_list($lang->string('Timezone'), 'timezone');
 169
 170         $admin->row_yesno($lang->string('Observe Daylight Savings Time (DST)'), 'usedst', $user->objdata['usedst']);
 171         $admin->row_text($lang->string('Hidden Statuses on Bug Listing'), construct_option_select('hidestatuses', $bugsys->datastore['status'], $user->objdata['hidestatuses'], 'statusid', 'status', 0, true));
 172         $admin->row_text($lang->string('Default Sort Order Column'), construct_option_select('defaultsortkey', ListSorter::fetch_by_text(false), $user->objdata['defaultsortkey']));
 173         $admin->row_text($lang->string('Default Sort Order Direction'), construct_option_select('defaultsortas', ListSorter::fetch_as_text(false), $user->objdata['defaultsortas']));
 174
 175         $admin->row_submit();
 176
 177         $admin->table_end();
 178         $admin->form_end();
 179
 180         $admin->page_end();
 181 }
 182
 183 // ###################################################################
 184
 185 if ($_REQUEST['do'] == 'search')
 186 {
 187         $fail = false;
 188
 189         NavLinks::usersAdd();
 190         $navigator->set_focus('link', 'users-pages-users', 'users-pages');
 191
 192         if (is_numeric($bugsys->in['userdata']))
 193         {
 194                 $bugsys->input_clean('userdata', TYPE_UINT);
 195                 if ($db->query_first("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = " . $bugsys->in['userdata']))
 196                 {
 197                         header('Location: user.php?do=edit&userid=' . $bugsys->in['userdata']);
 198                 }
 199                 else
 200                 {
 201                         $fail = true;
 202                 }
 203         }
 204         else
 205         {
 206                 $bugsys->in['userdata'] = str_replace('%', '\%', $bugsys->in['userdata']);
 207                 $results = $db->query("SELECT * FROM " . TABLE_PREFIX . "user WHERE email LIKE '%" . $bugsys->input_escape('userdata') . "%' OR displayname LIKE '%" . $bugsys->input_escape('userdata') . "%'");
 208
 209                 if ($db->num_rows($results) < 1)
 210                 {
 211                         $fail = true;
 212                 }
 213                 else
 214                 {
 215                         $admin->page_start($lang->string('Search Results'));
 216
 217                         $admin->table_start();
 218                         $admin->table_head($lang->string('Search Results'), 4);
 219                         $admin->table_column_head(array($lang->string('Display Name'), $lang->string('Email'), $lang->string('User ID'), $lang->string('Actions')));
 220
 221                         while ($row = $db->fetch_array($results))
 222                         {
 223                                 $admin->row_multi_item(array(
 224                                         $row['displayname'] => 'l',
 225                                         $row['email'] => 'c',
 226                                         $row['userid'] => 'c',
 227                                         '<a href="user.php?do=edit&amp;userid=' . $row['userid'] . '">[' . $lang->string('Edit') . ']</a>' => 'c'
 228                                 ));
 229                         }
 230
 231                         $admin->table_end();
 232
 233                         $admin->page_end();
 234                 }
 235         }
 236
 237         if ($fail)
 238         {
 239                 $admin->error($lang->string('Sorry, we could not find any users that matched your criteria.'));
 240         }
 241 }
 242
 243 // ###################################################################
 244
 245 if ($_REQUEST['do'] == 'modify')
 246 {
 247         NavLinks::usersAdd();
 248         $navigator->set_focus('link', 'users-pages-users', 'users-pages');
 249
 250         $admin->page_start($lang->string('User Search'));
 251
 252         $admin->form_start('user.php', 'search');
 253         $admin->table_start(true, '45%');
 254
 255         $admin->table_head($lang->string('User Search'));
 256         $admin->row_input($lang->string('Name/Email/ID'), 'userdata');
 257
 258         $admin->row_submit('', ':save:', '');
 259
 260         $admin->table_end();
 261         $admin->form_end();
 262
 263         $admin->page_end();
 264 }
 265
 266 /*=====================================================================*\
 267 || ###################################################################
 268 || # $HeadURL$
 269 || # $Id$
 270 || ###################################################################
 271 \*=====================================================================*/
 272 ?>