Well, thoughtyou might make this. Untested, should work.....
<?php
@include_once(DIRNAME(__FILE__) .'/globals.php');
$st = (isset($_GET['st']) && is_numeric($_GET['ord'])) ? abs(@intval($_GET['st'])) : 0;
$ord= (isset($_GET['ord']) && is_numeric($_GET['ord'])) ? abs(@intval($_GET['ord'])) : 'ASC';
$by = (isset($_GET['by']) && ctype_alpha($_GET['by'])) ? strip_tags(mysql_real_escape_string($_GET['by'])) : 'userid';
echo'<h3>Userlist</h3>';
$membs = $db->num_rows($db->query("SELECT userid FROM users"));
$pages=(int) ($membs/100)+1;
if($membs % 100 == 0)
{
$pages--;
}
echo'Pages: ';
for($i=1;$i <= $pages;$i++)
{
$stl=($i-1)*100;
echo'[url="?st='.$stl.'&by='.$by.'&ord='.$ord.'"]'.$i.'[/url]';
}
echo'
Order By: [url="?st='.$st.'&by=userid&ord='.$ord.'"]User ID[/url]| [url="?st='.$st.'&by=username&ord='.$ord.'"]Username[/url]| [url="?st='.$st.'&by=level&ord='.$ord.'"]Level[/url]| [url="?st='.$st.'&by=money&ord='.$ord.'"]Money[/url]
[url="?st='.$st.'&by='.$by.'&ord=asc"]Ascending[/url]| [url="?st='.$st.'&by='.$by.'&ord=desc"]Descending[/url]
';
$user = $db->query(sprintf("SELECT u.*, g.*, c.cityname, c.cityid ".
"FROM users AS u ".
"LEFT JOIN gangs AS g ON u.gang=g.gangID ".
"LEFT JOIN cities AS c ON u.location=c.cityid ".
"ORDER BY %s %s LIMIT %u, 100", $by, $ord, $st));
$no1=$st+1;
$no2=$st+100;
$ord = ''.$ord;
echo'Showing users '.$no1.' to '.$no2.' by order of '.$by.$ord.'.
<table width="75%" cellspacing="1" class="table">
<tr style="background:gray">
<th>ID</th>
<th>Name</th>
<th>Level</th>
<th>Money</th>
<th>Crystals</th>
<th>Location</th>
<th>Gender</th>
<th>Online</th>
</tr>';
while($r = $db->fetch_row($user))
{
$d="";
$r['username'] = ($r['donatordays']) ? '<span style="color:red;">'.$r['username'].'</span>' : $r['username'];
$d = ($r['donatordays']) ? '[img=donator.gif]' : '';
$status = ($r['laston'] >= time()-15*60) ? '<span style="color: green; font-weight:bold;">Online</span>' : '<span style="color: red; font-weight:bold;">Offline</span>';
echo'<tr>
<td>'.number_format($r['userid']).'</td>
<td>[url="viewuser.php?u='.$r['userid'].'"]'.$r['gangPREF'].' '.$r['username'].' '.$d.'[/url]</td>
<td>'.number_format($r['level']).'</td>
<td>'.money_formatter($r['money']).'</td>
<td>'.number_format($r['crystals']).'</td>
<td>'.$r['cityname'].'</td>
<td>'.$r['gender'].'</td>
<td>'.$status.'</td>
</tr>';
}
echo'</table>';
$h->endpage();
?>