<? 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>"; ?>