From cf540de5d3229941e4104e4d5b6b66681f97f4d3 Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Wed, 10 Jan 2018 02:08:58 +0100 Subject: Server list layout and link --- html/pages/maps.php | 89 +++++++++++++++++++++++++------------------------- html/pages/servers.php | 66 +++++++++++++++++++++---------------- 2 files changed, 81 insertions(+), 74 deletions(-) (limited to 'html/pages') diff --git a/html/pages/maps.php b/html/pages/maps.php index 9d30179..69c8785 100644 --- a/html/pages/maps.php +++ b/html/pages/maps.php @@ -12,14 +12,13 @@ function SortPic($curr_field, $filter, $sort) { return(' '); } - // Get filter and set sorting $filter = my_addslashes($_GET[filter]); $sort = my_addslashes($_GET[sort]); $q = my_addslashes($_GET[q]); $gid = preg_replace('/\D/', '', $_GET[gid]); -IF (empty($filter) or (!in_array(strtolower($filter), array("mapfile", "matchcount", "frags", "matchscore", "gametime")))) { +if (empty($filter) or (!in_array(strtolower($filter), array("mapfile", "matchcount", "frags", "matchscore", "gametime")))) { $filter = "mapfile"; } @@ -37,32 +36,29 @@ else { if (isset($q)) { if ($gid != 0) { - $sql_condition .= ' AND mapfile LIKE "%' . $q . '%" '; + $sql_condition .= ' AND mapfile LIKE "%' . $q . '%" '; } else { - $sql_condition .= ' WHERE mapfile LIKE "%' . $q . '%" '; + $sql_condition .= ' WHERE mapfile LIKE "%' . $q . '%" '; } $url_condition .= "&q=".urlencode($q); } - // Firstly we need to work out First Last Next Prev pages - $mcount = small_count("SELECT mapfile FROM uts_match" . $sql_condition . " GROUP BY mapfile"); - -$ecount = $mcount/25; +$ecount = $mcount / 25; $ecount2 = number_format($ecount, 0, '.', ''); -IF($ecount > $ecount2) { +if ($ecount > $ecount2) { $ecount2 = $ecount2+1; } $fpage = 0; -IF($ecount < 1) { $lpage = 0; } +if ($ecount < 1) { $lpage = 0; } else { $lpage = $ecount2-1; } $cpage = preg_replace('/\D/', '', $_GET["page"]); -IF ($cpage == "") { $cpage = "0"; } +if ($cpage == "") { $cpage = "0"; } $qpage = $cpage*25; $tfpage = $cpage+1; @@ -70,46 +66,49 @@ $tlpage = $lpage+1; $ppage = $cpage-1; $ppageurl = "[Previous]"; -IF ($ppage < "0") { $ppageurl = "[Previous]"; } +if ($ppage < "0") { $ppageurl = "[Previous]"; } $npage = $cpage+1; $npageurl = "[Next]"; -IF ($npage >= "$ecount") { $npageurl = "[Next]"; } +if ($npage >= "$ecount") { $npageurl = "[Next]"; } $fpageurl = "[First]"; -IF ($cpage == "0") { $fpageurl = "[First]"; } +if ($cpage == "0") { $fpageurl = "[First]"; } $lpageurl = "[Last]"; -IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } +if ($cpage == "$lpage") { $lpageurl = "[Last]"; } echo'
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
- + + + + + Filter: + +
+ + + + +
+ @@ -120,26 +119,26 @@ echo ' '; $sql_maps = "SELECT IF(RIGHT(mapfile,4) LIKE '.unr', mapfile, CONCAT(mapfile, '.unr')) as mapfile, COUNT(id) AS matchcount, AVG(frags) AS frags, AVG(t0score+t1score+t2score+t3score) AS matchscore, SUM(gametime) AS gametime -FROM uts_match" . $sql_condition . " GROUP BY mapfile ORDER BY $filter $sort LIMIT $qpage,25"; + FROM uts_match" . $sql_condition . " GROUP BY mapfile ORDER BY $filter $sort LIMIT $qpage,25"; $q_maps = mysql_query($sql_maps) or die(mysql_error()); -while ($r_maps = mysql_fetch_array($q_maps)) { +while ($r_maps = mysql_fetch_array($q_maps)) { $r_mapfile = un_ut($r_maps[mapfile]); $myurl = urlencode($r_mapfile); $r_gametime = GetMinutes($r_maps[gametime]); - echo' + echo ' - - - - - + + + + + '; } -echo' +echo '
Unreal Tournament Maps ListMaps List
- - - - Filter: '; -echo ' '; - -echo '
-
'; - -echo ' -
Map Name'.SortPic('mapfile', $filter, $sort).'
'.$r_mapfile.''.$r_maps[matchcount].''.get_dp($r_maps[frags]).''.get_dp($r_maps[matchscore]).''.$r_gametime.''.$r_mapfile.''.$r_maps[matchcount].''.get_dp($r_maps[frags]).''.get_dp($r_maps[matchscore]).''.$r_gametime.'
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; -?> \ No newline at end of file +?> diff --git a/html/pages/servers.php b/html/pages/servers.php index 8b27fab..770796b 100644 --- a/html/pages/servers.php +++ b/html/pages/servers.php @@ -1,21 +1,20 @@ $ecount2) { - $ecount2 = $ecount2+1; +if ($ecount > $ecount2) { + $ecount2 = $ecount2+1; } $fpage = 0; -IF($ecount < 1) { $lpage = 0; } +if($ecount < 1) { $lpage = 0; } else { $lpage = $ecount2-1; } $cpage = preg_replace('/\D/', '', $_GET["page"]); -IF ($cpage == "") { $cpage = "0"; } +if ($cpage == "") { $cpage = "0"; } $qpage = $cpage*25; $tfpage = $cpage+1; @@ -23,23 +22,24 @@ $tlpage = $lpage+1; $ppage = $cpage-1; $ppageurl = "[Previous]"; -IF ($ppage < "0") { $ppageurl = "[Previous]"; } +if ($ppage < "0") { $ppageurl = "[Previous]"; } $npage = $cpage+1; $npageurl = "[Next]"; -IF ($npage >= "$ecount") { $npageurl = "[Next]"; } +if ($npage >= "$ecount") { $npageurl = "[Next]"; } $fpageurl = "[First]"; -IF ($cpage == "0") { $fpageurl = "[First]"; } +if ($cpage == "0") { $fpageurl = "[First]"; } $lpageurl = "[Last]"; -IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } +if ($cpage == "$lpage") { $lpageurl = "[Last]"; } -echo' +echo '
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
- - - +
Unreal Tournament Server List
+ + + @@ -51,24 +51,32 @@ echo' '; $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"; + 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]); +while ($r_servers = mysql_fetch_array($q_servers)) { + $r_gametime = sec2hour($r_servers[gametime]); - echo' - - - - - - - - '; + echo ' + + + + + + + + '; } -echo' -
Server List
Server Name
'.$r_servers[servername].'Server Status'.$r_servers[matchcount].''.$r_servers[frags].''.$r_servers[matchscore].''.$r_gametime.'
+ '.$r_servers[servername].' + + + Server Status + + '.$r_servers[matchcount].''.$r_servers[frags].''.$r_servers[matchscore].''.$r_gametime.'
+echo ' + + +
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; -?> \ No newline at end of file +?> -- cgit