$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 = "[Previous]";
if ($ppage < "0") { $ppageurl = "[Previous]"; }
$npage = $cpage+1;
$npageurl = "[Next]";
if ($npage >= "$ecount") { $npageurl = "[Next]"; }
$fpageurl = "[First]";
if ($cpage == "0") { $fpageurl = "[First]"; }
$lpageurl = "[Last]";
if ($cpage == "$lpage") { $lpageurl = "[Last]"; }
echo '
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
| Unreal Tournament Server List |
| Server Name |
Status |
Matches |
Frags |
TeamScore |
Hours |
';
$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 '
|
'.$r_servers[servername].'
|
|
'.$r_servers[matchcount].' |
'.$r_servers[frags].' |
'.$r_servers[matchscore].' |
'.$r_gametime.' |
';
}
echo '
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
';
?>