$ecount2) {
$ecount2 = $ecount2+1;
}
$fpage = 0;
IF($ecount < 1) { $lpage = 0; }
else { $lpage = $ecount2-1; }
$cpage = $_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]"; }
// Get the last match entry for this server
$serverinfo = small_query("SELECT time, servername, serverinfo, gameinfo, mutators FROM uts_match WHERE serverip = '$serverip' ORDER BY time DESC LIMIT 0,1");
$matchdate = mdate($serverinfo[time]);
echo'
| '.$serverinfo[servername].' |
| Last Match |
'.$matchdate.' |
Game Info |
| Server Info |
'.$serverinfo[serverinfo].' |
'.$serverinfo[gameinfo].' |
| Mutators |
'.$serverinfo[mutators].' |
';
// Do graph stuff
$bgwhere = "serverip = '$serverip'";
include("pages/graph_mbreakdown.php");
echo'Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
| Unreal Tournament Match List |
| Date/Time |
Match Type |
Map |
Time |
';
$sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, m.gametime FROM uts_match AS m, uts_games AS g WHERE g.id = m.gid AND m.serverip = '$serverip' ORDER BY m.time DESC LIMIT $qpage,25";
$q_recent = mysql_query($sql_recent) or die(mysql_error());
while ($r_recent = mysql_fetch_array($q_recent)) {
$r_time = mdate($r_recent[time]);
$r_mapfile = un_ut($r_recent[mapfile]);
$r_gametime = sec2min($r_recent[gametime]);
$myurl = urlencode($r_mapfile);
echo'
| '.$r_time.' |
'.$r_recent[gamename].' |
'.$r_mapfile.' |
'.$r_gametime.' |
';
}
echo'
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
';
?>