summaryrefslogtreecommitdiff
path: root/html/pages/servers_info.php
diff options
context:
space:
mode:
Diffstat (limited to 'html/pages/servers_info.php')
-rw-r--r--[-rwxr-xr-x]html/pages/servers_info.php208
1 files changed, 105 insertions, 103 deletions
diff --git a/html/pages/servers_info.php b/html/pages/servers_info.php
index 2548197..81f7772 100755..100644
--- a/html/pages/servers_info.php
+++ b/html/pages/servers_info.php
@@ -1,104 +1,106 @@
-<?php
-$serverip = $_GET[serverip];
-
-// Firstly we need to work out First Last Next Prev pages
-$scount = small_count("SELECT id FROM uts_match WHERE serverip = '$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 = $_GET["page"];
-IF ($cpage == "") { $cpage = "0"; }
-$qpage = $cpage*25;
-
-$tfpage = $cpage+1;
-$tlpage = $lpage+1;
-
-$ppage = $cpage-1;
-$ppageurl = "<a class=\"pages\" href=\"./?p=sinfo&amp;serverip=$serverip&amp;page=$ppage\">[Previous]</a>";
-IF ($ppage < "0") { $ppageurl = "[Previous]"; }
-
-$npage = $cpage+1;
-$npageurl = "<a class=\"pages\" href=\"./?p=sinfo&amp;serverip=$serverip&amp;page=$npage\">[Next]</a>";
-IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
-
-$fpageurl = "<a class=\"pages\" href=\"./?p=sinfo&amp;serverip=$serverip&amp;page=$fpage\">[First]</a>";
-IF ($cpage == "0") { $fpageurl = "[First]"; }
-
-$lpageurl = "<a class=\"pages\" href=\"./?p=sinfo&amp;serverip=$serverip&amp;page=$lpage\">[Last]</a>";
-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'
-<table class = "box" border="0" cellpadding="1" cellspacing="2" width="720">
- <tbody><tr>
- <td class="heading" align="center" colspan="4">'.$serverinfo[servername].'</td>
- </tr>
- <tr>
- <td class="dark" align="center" width="110">Last Match</td>
- <td class="grey" align="center" width="305">'.$matchdate.'</td>
- <td class="dark" align="center" width="305">Game Info</td>
- </tr>
- <tr>
- <td class="dark" align="center">Server Info</td>
- <td class="grey" align="center">'.$serverinfo[serverinfo].'</td>
- <td class="grey" align="center" rowspan="2">'.$serverinfo[gameinfo].'</td>
- </tr>
- <tr>
- <td class="dark" align="center">Mutators</td>
- <td class="grey" align="center">'.$serverinfo[mutators].'</td>
- </tr>
-</tbody></table>
-<br>';
-
-// Do graph stuff
-$bgwhere = "serverip = '$serverip'";
-include("pages/graph_mbreakdown.php");
-
-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="4" align="center">Unreal Tournament Match List</td>
- </tr>
- <tr>
- <td class="smheading" align="center" width="220">Date/Time</td>
- <td class="smheading" align="center" width="140">Match Type</td>
- <td class="smheading" align="center">Map</td>
- <td class="smheading" align="center" width="40">Time</td>
- </tr>';
-
-$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'
- <tr>
- <td class="dark" align="center"><a class="darkhuman" href="./?p=match&amp;mid='.$r_recent[id].'">'.$r_time.'</a></td>
- <td class="grey" align="center">'.$r_recent[gamename].'</td>
- <td class="grey" align="center"><a class="grey" href="./?p=minfo&amp;map='.$myurl.'">'.$r_mapfile.'</a></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>';
+<?php
+$serverip = mysql_real_escape_string($_GET[serverip]);
+
+// Firstly we need to work out First Last Next Prev pages
+$scount = small_count("SELECT id FROM uts_match WHERE serverip = '$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 = mysql_real_escape_string($_GET["page"]);
+IF ($cpage == "") { $cpage = "0"; }
+$qpage = $cpage*25;
+
+$tfpage = $cpage+1;
+$tlpage = $lpage+1;
+
+$ppage = $cpage-1;
+$ppageurl = "<a class=\"pages\" href=\"./?p=sinfo&amp;serverip=$serverip&amp;page=$ppage\">[Previous]</a>";
+IF ($ppage < "0") { $ppageurl = "[Previous]"; }
+
+$npage = $cpage+1;
+$npageurl = "<a class=\"pages\" href=\"./?p=sinfo&amp;serverip=$serverip&amp;page=$npage\">[Next]</a>";
+IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
+
+$fpageurl = "<a class=\"pages\" href=\"./?p=sinfo&amp;serverip=$serverip&amp;page=$fpage\">[First]</a>";
+IF ($cpage == "0") { $fpageurl = "[First]"; }
+
+$lpageurl = "<a class=\"pages\" href=\"./?p=sinfo&amp;serverip=$serverip&amp;page=$lpage\">[Last]</a>";
+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'
+<table class = "zebra box" border="0" cellpadding="0" cellspacing="0" width="700">
+ <tbody><tr>
+ <th class="heading" align="center" colspan="2">'.$serverinfo[servername].'</th>
+ </tr>
+ <tr>
+ <th align="center" width="110">Last Match</th>
+ <td align="center" width="305">'.$matchdate.'</td>
+ </tr>
+ <tr>
+ <th align="center">Server Info</th>
+ <td align="center">'.$serverinfo[serverinfo].'</td>
+ </tr>
+ <tr>
+ <th align="center">Mutators</td>
+ <td align="center">'.$serverinfo[mutators].'</th>
+ </tr>
+ <tr>
+ <th align="center">Game Info</td>
+ <td align="center">'.$serverinfo[gameinfo].'</td>
+ </tr>
+</tbody></table>
+<br>';
+
+// Do graph stuff
+$bgwhere = "serverip = '$serverip'";
+include("pages/graph_mbreakdown.php");
+
+echo'<div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>
+<table class="zebra box" border="0" cellpadding="0" cellspacing="0">
+ <tbody><tr>
+ <th class="heading" colspan="4" align="center">Unreal Tournament Match List</th>
+ </tr>
+ <tr>
+ <th class="smheading" align="center" width="220">Date/Time</th>
+ <th class="smheading" align="center" width="140">Match Type</th>
+ <th class="smheading" align="center">Map</td>
+ <th class="smheading" align="center" width="40">Time</th>
+ </tr>';
+
+$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'
+ <tr class="clickableRow" href="./?p=match&amp;mid='.$r_recent[id].'">
+ <td align="center"><a href="./?p=match&amp;mid='.$r_recent[id].'">'.$r_time.'</a></td>
+ <td align="center">'.$r_recent[gamename].'</td>
+ <td align="center"><a href="./?p=minfo&amp;map='.$myurl.'">'.$r_mapfile.'</a></td>
+ <td align="center">'.$r_gametime.'</td>
+ </tr>';
+}
+
+echo'
+</tbody></table>
+<div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>';
?> \ No newline at end of file
generated by cgit (git 2.34.1) at 2025-06-15 23:40:17 +0000