users.inc.php

   1 <?php
   2 $page = isset($_GET['page']) ? intval($_GET['page']) : 1;
   3 $pages = ($page -1) * 50;
   4 $user_count = $pages;
   5
   6 $number_of_items = mysql_result(mysql_query('SELECT COUNT(*) FROM `users` WHERE '.$list_criteria), 0);
   7
   8 if ( !isset($_GET['order']) )
   9         $_GET['order'] = 'user';
  10 if ( !isset($_GET['list']) )
  11         $_GET['list'] = 'all';
  12
  13 $pagelist = '';
  14 if ( $number_of_items > 50 )
  15         $pagelist = pagelist(';order='.htmlentities($_GET['order']).';list='.htmlentities($_GET['list']));
  16
  17 echo $pagelist,'
  18 <table>
  19 <tr class="c3">';
  20
  21 foreach ( array(
  22                 'ID #' => 'user',
  23                 'Username' => 'name',
  24                 'Level' => 'level',
  25                 $strings['cookies'] => 'cookies',
  26                 $strings['points'] => 'points',
  27                 'Posts' => 'posts',
  28                 'Last Active (Idle Time)' => 'last_active'
  29         ) as $colname => $sqlname )
  30         echo '<th><a href="?order=',$sqlname,';list=',htmlentities($_GET['list']),URL_APPEND,'">',$colname,"</a></th>\n";
  31
  32 if ( $userinfo['level'] >= ADMIN )
  33         echo '<th><a href="?order=last_ip;list=',htmlentities($_GET['list']),URL_APPEND,'">Last IP</a></th>',"\n";
  34 echo "</tr>\n";
  35
  36 switch ( $_GET['order'] ) {
  37         case 'name' :
  38         case 'user' :
  39         case 'last_ip' :
  40                 $by = 'ASC';
  41                 break;
  42         case 'level' :
  43         case 'cookies' :
  44         case 'posts' :
  45         case 'points' :
  46         case 'last_active' :
  47                 $by = 'DESC';
  48                 break;
  49         default :
  50                 $_GET['order'] = 'user';
  51                 $by = 'ASC';
  52 }
  53
  54 $tmp = mysql_query('SELECT
  55         `users`.`user`,
  56         `users`.`level`,
  57         `users`.`cookies`,
  58         UNIX_TIMESTAMP(`users`.`last_active`),
  59         INET_NTOA(`users`.`last_ip`),
  60         COUNT(`messages`.`message`) AS `posts`,
  61         `users`.`points`
  62
  63         FROM `users` LEFT JOIN `messages` USING(`user`)
  64         WHERE '.$list_criteria.'
  65         GROUP BY `users`.`user`
  66         ORDER BY `'.mysql_real_escape_string($_GET['order']).'` '.$by.', `users`.`user`
  67         LIMIT '.$pages.', 50');
  68
  69 while ( $u = mysql_fetch_row($tmp) )
  70 {
  71         echo '<tr class=',colour(),'>
  72         <td>',$u[0],'</td>
  73         <td>',userlink($u[0]),'</td>
  74         <td>',$u[1],'</td>
  75         <td>',$u[2],'</td>
  76         <td>',$u[6],'</td>
  77         <td>',$u[5],'</td>
  78         <td>',date2($u[3]),' <small>(',idletime($u[3]),")</small></td>\n".
  79         ( $userinfo['level'] >= ADMIN ? "\t<td>".$u[4]."</td>\n" : '').
  80 "</tr>\n";
  81 }
  82
  83 echo "</table>\n",$pagelist;
  84 ?>