From 3a58cb2802c8be14f78015105afe759b1c7ce692 Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Tue, 9 Jan 2018 00:43:43 +0100 Subject: Implement design for pages and update includes --- html/pages/servers_info.php | 208 ++++++++++++++++++++++---------------------- 1 file changed, 105 insertions(+), 103 deletions(-) mode change 100755 => 100644 html/pages/servers_info.php (limited to 'html/pages/servers_info.php') diff --git a/html/pages/servers_info.php b/html/pages/servers_info.php old mode 100755 new mode 100644 index 2548197..81f7772 --- a/html/pages/servers_info.php +++ b/html/pages/servers_info.php @@ -1,104 +1,106 @@ - $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.'
- - - - - - - - - - '; - -$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' - - - - - - '; -} - -echo' -
Unreal Tournament Match List
Date/TimeMatch TypeMapTime
'.$r_time.''.$r_recent[gamename].''.$r_mapfile.''.$r_gametime.'
-
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; + $ecount2) { + $ecount2 = $ecount2+1; +} + +$fpage = 0; +IF($ecount < 1) { $lpage = 0; } +else { $lpage = $ecount2-1; } + +$cpage = mysql_real_escape_string($_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.'
Server Info'.$serverinfo[serverinfo].'
Mutators + '.$serverinfo[mutators].' +
Game Info + '.$serverinfo[gameinfo].'
+
'; + +// Do graph stuff +$bgwhere = "serverip = '$serverip'"; +include("pages/graph_mbreakdown.php"); + +echo'
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
+ + + + + + + + + '; + +$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' + + + + + + '; +} + +echo' +
Unreal Tournament Match List
Date/TimeMatch TypeMap + Time
'.$r_time.''.$r_recent[gamename].''.$r_mapfile.''.$r_gametime.'
+
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; ?> \ No newline at end of file -- cgit