1 files changed, 74 insertions, 0 deletions
diff --git a/html/pages/servers.php b/html/pages/servers.php
new file mode 100755
index 0000000..63d3721
--- /dev/null
+++ b/html/pages/servers.php
@@ -0,0 +1,74 @@
+<?php
+// Firstly we need to work out First Last Next Prev pages
+
+$scount = small_count("SELECT servername, serverip FROM uts_match GROUP BY servername, serverip");
+
+$ecount = $scount/25;
+$ecount2 = number_format($ecount, 0, '.', '');
+
+IF($ecount > $ecount2) {
+	$ecount2 = $ecount2+1;
+}
+
+$fpage = 0;
+IF($ecount < 1) { $lpage = 0; }
+else { $lpage = $ecount2-1; }
+
+$cpage = preg_replace('/\D/', '', $_GET["page"]);
+IF ($cpage == "") { $cpage = "0"; }
+$qpage = $cpage*25;
+
+$tfpage = $cpage+1;
+$tlpage = $lpage+1;
+
+$ppage = $cpage-1;
+$ppageurl = "<a class=\"pages\" href=\"./?p=servers&amp;page=$ppage\">[Previous]</a>";
+IF ($ppage < "0") { $ppageurl = "[Previous]"; }
+
+$npage = $cpage+1;
+$npageurl = "<a class=\"pages\" href=\"./?p=servers&amp;page=$npage\">[Next]</a>";
+IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
+
+$fpageurl = "<a class=\"pages\" href=\"./?p=servers&amp;page=$fpage\">[First]</a>";
+IF ($cpage == "0") { $fpageurl = "[First]"; }
+
+$lpageurl = "<a class=\"pages\" href=\"./?p=servers&amp;page=$lpage\">[Last]</a>";
+IF ($cpage == "$lpage") { $lpageurl = "[Last]"; }
+
+echo'
+<div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>
+<table class="box" border="0" cellpadding="1" cellspacing="1">
+  <tbody><tr>
+    <td class="heading" colspan="6" align="center">Unreal Tournament Server List</td>
+  </tr>
+  <tr>
+    <td class="smheading" align="center" width="250">Server Name</td>
+    <td class="smheading" align="center" width="50">Status</td>
+    <td class="smheading" align="center" width="100">Matches</td>
+    <td class="smheading" align="center">Frags</td>
+    <td class="smheading" align="center" width="100">TeamScore</td>
+    <td class="smheading" align="center" width="100">Hours</td>
+  </tr>';
+
+$sql_servers = "SELECT servername, serverip, COUNT(*) AS matchcount, SUM(frags) AS frags, SUM(t0score+t1score+t2score+t3score) AS matchscore, SUM(gametime) AS gametime
+FROM uts_match GROUP BY servername, serverip ORDER BY servername ASC LIMIT $qpage,25";
+$q_servers = mysql_query($sql_servers) or die(mysql_error());
+while ($r_servers = mysql_fetch_array($q_servers)) {
+
+	  $r_gametime = sec2hour($r_servers[gametime]);
+
+	  echo'
+	  <tr>
+		<td class="dark" align="center"><a class="darkhuman" href="./?p=sinfo&amp;serverip='.$r_servers[serverip].'">'.$r_servers[servername].'</a></td>
+		<td class="grey" align="center"><a href="./?p=squery&amp;serverip='.$r_servers[serverip].'"><img border="0" alt="Server Status" title="Server Status" src="images/magnify.gif"></a></td>
+		<td class="grey" align="center">'.$r_servers[matchcount].'</td>
+		<td class="grey" align="center">'.$r_servers[frags].'</td>
+		<td class="grey" align="center">'.$r_servers[matchscore].'</td>
+		<td class="grey" align="center">'.$r_gametime.'</td>
+	  </tr>';
+}
+
+echo'
+</tbody></table>
+<div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>';
+?>
+\ No newline at end of file