5 $page->title
= 'User List';
8 'online' => array('WHERE `last_active_date` > UNIX_TIMESTAMP() - 600', 'Online Users List'),
9 'banned' => array('WHERE `level` < '.LVL_RESTRICTED
, 'Banned Users List')
14 if ( isset($_GET['show']) && array_key_exists($_GET['show'], $sql) ) {
15 $where = $sql[$_GET['show']][0];
16 $page->title
= $sql[$_GET['show']][1];
22 '<table id="userlist">
28 <th>Last Active</th>',"\n",
29 ( LVL_ADMIN
<= $user->level ?
30 ' <th>Last IP</th>'."\n" : '' ),
34 'SELECT `users`.`userid`, `alias`, `level`, `points`, `last_active_date`,
35 INET_NTOA(`last_ip`) AS `last_ip`, COUNT(`messageid`) AS `msgs`
36 FROM `users` NATURAL LEFT JOIN `messages`
38 GROUP BY `userid` ASC');
40 $a = 1; // Shadebar variable
42 while ( $row = $q->fetch_assoc() ) {
43 echo '<tr class="content c',(++
$a&1),'">
44 <td>',$user->namelink($row['userid'], $row['alias']),'</td>
45 <td>',$row['level'],'</td>
46 <td>',$row['points'],'</td>
47 <td>',$row['msgs'],'</td>
48 <td>',$user->fdate($row['last_active_date']),"</td>\n",
49 ( LVL_ADMIN
<= $user->level ?
"\t<td>".$row['last_ip']."</td>\n" : '' ),