<?
if(!defined("IN_SITE")){
	print "Pls stop haxing";
	exit;
}
if(!isset($_GET["pagenum"])){
	$page = 1;
} else {
	$page = $_GET["pagenum"];
}
$max_results = 30;
$from = (($page * $max_results) - $max_results);
$sql = mysql_query("SELECT name, (SELECT name FROM jobs WHERE id = job) as job_name, (SELECT DATE_FORMAT(last_login, '%d/%c/%Y %r') FROM users WHERE id = owner_id) as last_seen, (SELECT status FROM users WHERE id = owner_id) as status FROM characters limit $from, $max_results") or print(mysql_error() . " " . __FILE__ . " #" . __LINE__);
print "<table border='1'><tr><td>Name</td><td>Job</td><td>Last Seen</td></tr>";
while($row = mysql_fetch_array($sql)){
	if($row["last_seen"] == 0){
		$timestamp = "Never";
	}
	if($row["status"] <= $_SESSION['user']['status']){
		?>
		<tr>
			<td valign='top'><?=$row['name'];?></td>
			<td valign='top'><?=$row['job_name'];?></td>
			<td valign='top'><?=$row['last_seen'];?></td>
		</tr>
		<?
	}
 }
// Figure out the total number of results in DB:
$sql = mysql_query("SELECT COUNT(id) as Num FROM characters") or print(mysql_error());
$total_results = mysql_result($sql, 0);
// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);
// Build Page Number Hyperlinks
echo "</table>
<br><table border='1'>
<tr>
<td valign='top'><center><b>Select a page</b></center></td>
</tr>
<tr>
<td valign='top'>";
// Build Previous Link
if($page > 1){
	$prev = ($page - 1);
	echo "<a href=\"?page=census&pagenum=$prev\"><B><</B><Previous</a> ";
}
for($i = 1; $i <= $total_pages; $i++){
	if(($page) == $i){
		echo "$i ";
	} else {
		echo "<a href=\"?page=census&pagenum=$i\"><B>$i</B></a> ";
	}
}
// Build Next Link
if($page < $total_pages){
	$next = ($page + 1);
	echo "<a href=\"?page=census&pagenum=$next\"><B>></B></a>";
}
print"</td></tr></table>";
print "</table>";				
?>