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 "
Name | Job | Last Seen |
";
while($row = mysql_fetch_array($sql)){
if($row["last_seen"] == 0){
$timestamp = "Never";
}
if($row["status"] <= $_SESSION['user']['status']){
?>
=$row['name'];?> |
=$row['job_name'];?> |
=$row['last_seen'];?> |
}
}
// 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 "
";
print "";
?>