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/maps_info.php | 507 ++++++++++++++++++++++++----------------------- 1 file changed, 255 insertions(+), 252 deletions(-) mode change 100755 => 100644 html/pages/maps_info.php (limited to 'html/pages/maps_info.php') diff --git a/html/pages/maps_info.php b/html/pages/maps_info.php old mode 100755 new mode 100644 index 329fcce..a7c355e --- a/html/pages/maps_info.php +++ b/html/pages/maps_info.php @@ -1,6 +1,6 @@ - - Statistics for '.htmlentities($map).' - - - Matches - '.$map_matches[matchcount].' - '.htmlentities($map).' - - - Total Time - '.$map_tottime.' minutes - '; -// Show some gametype specific stuff -if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, 3)) == "bt-")) { - // Bunny Track - $record = small_query("SELECT pi.id, pi.name AS name, pi.country, e.col3 AS time, e.col4 AS date FROM uts_events AS e, uts_pinfo AS pi, uts_player AS p, uts_match AS m WHERE m.id = e.matchid AND m.id = p.matchid AND p.playerid = e.playerid AND pi.id = p.pid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') AND e.col1 = 'btcap' GROUP BY pi.id ORDER BY (0 + e.col3) ASC, e.col4 ASC LIMIT 0,1"); - if (!empty($record['time'])) { + // Map pic code + $mappic = getMapImageName($map); + + echo' + + + + + + + + + + + + + '; + // Show some gametype specific stuff + if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, 3)) == "bt-")) { + // Bunny Track + $record = small_query("SELECT pi.id, pi.name AS name, pi.country, e.col3 AS time, e.col4 AS date FROM uts_events AS e, uts_pinfo AS pi, uts_player AS p, uts_match AS m WHERE m.id = e.matchid AND m.id = p.matchid AND p.playerid = e.playerid AND pi.id = p.pid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') AND e.col1 = 'btcap' GROUP BY pi.id ORDER BY (0 + e.col3) ASC, e.col4 ASC LIMIT 0,1"); + if (!empty($record['time'])) { + echo ' + + + + '; + } + else { + echo ' + + + + '; + } echo ' - - - - '; + + + + + + + + '; + } + else if (strtolower(substr($map, 0, 4)) == "ctf-") { + // Capture the Flag + $totals = small_query("SELECT SUM(p.flag_taken) as flag_taken, SUM(p.flag_return) AS flag_return, SUM(p.flag_cover) AS flag_cover FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')"); + echo ' + + + + + + + + + + + + + + + + + + + + + + + + '; + } + else if (strtolower(substr($map, 0, 3)) == "as-") { + // Assault + $totals = small_query("SELECT SUM(p.ass_obj) as ass_obj FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')"); + echo ' + + + + + + + + + + + + '; + } + else if (strtolower(substr($map, 0, 3)) == "jb-") { + // Assault + $totals = small_query("SELECT SUM(p.ass_obj) as ass_obj FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')"); + echo ' + + + + + + + + + + + + '; + } + else if (strtolower(substr($map, 0, 4)) == "dom-") { + // Assault + $totals = small_query("SELECT SUM(p.dom_cp) as dom_cp FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')"); + echo ' + + + + + + + + + + + + '; } else { echo ' - - - - '; + + + + + + + + + + + + + + + + '; } echo ' - - - - - - - - '; -} -else if (strtolower(substr($map, 0, 4)) == "ctf-") { - // Capture the Flag - $totals = small_query("SELECT SUM(p.flag_taken) as flag_taken, SUM(p.flag_return) AS flag_return, SUM(p.flag_cover) AS flag_cover FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')"); - echo ' - - - - - - - - - - - - - - - - - - - - - - - - '; -} -else if (strtolower(substr($map, 0, 3)) == "as-") { - // Assault - $totals = small_query("SELECT SUM(p.ass_obj) as ass_obj FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')"); - echo ' - - - - - - - - - - - - '; -} -else if (strtolower(substr($map, 0, 3)) == "jb-") { - // Assault - $totals = small_query("SELECT SUM(p.ass_obj) as ass_obj FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')"); - echo ' - - - - - - - - - - - - '; -} -else if (strtolower(substr($map, 0, 4)) == "dom-") { - // Assault - $totals = small_query("SELECT SUM(p.dom_cp) as dom_cp FROM uts_player AS p, uts_match AS m WHERE m.id = p.matchid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap')"); - echo ' - - - - - - - - - - - - '; -} -else { - echo ' - - - - - - - - - - - - - - - - '; -} -echo ' - - - - -
Statistics for '.htmlentities($map).'
'.$mapname.'
Matches'.$map_matches[matchcount].'
Total Time'.$map_tottime.' minutes
Fastest Capture'.FormatPlayerName($record['country'], $record['id'], $record['name']).'
' . btcaptime($record['time']) . ' minutes
'.gmdate('d-m-Y h:i a', $record['date']).'
Fastest CaptureNo record set!
Fastest Capture'.FormatPlayerName($record['country'], $record['id'], $record['name']).'
' . btcaptime($record['time']) . ' minutes
'.gmdate('d-m-Y h:i a', $record['date']).'
Total Flags Captured'.$map_matches[gamescore].'
Total Suicides'.$map_matches[suicides].'
Total Flags Captured'.$map_matches[gamescore].'
Total Flags Taken'.$totals['flag_taken'].'
Total Covers'.$totals['flag_cover'].'
Total Flags Returned'.$totals['flag_return'].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Total Objectives Achieved'.$totals[ass_obj].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Team Releases'.$totals[ass_obj].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Total Control Points Captured'.$totals['dom_cp'].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Fastest CaptureNo record set!
Total Score'.$map_matches[gamescore].'
Total Kills'.$map_matches[kills].'
Total Teamkills'.$map_matches[teamkills].'
Total Suicides'.$map_matches[suicides].'
Total Flags Captured'.$map_matches[gamescore].'
Total Suicides'.$map_matches[suicides].'
Total Flags Captured'.$map_matches[gamescore].'
Total Flags Taken'.$totals['flag_taken'].'
Total Covers'.$totals['flag_cover'].'
Total Flags Returned'.$totals['flag_return'].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Total Objectives Achieved'.$totals[ass_obj].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Team Releases'.$totals[ass_obj].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Total Control Points Captured'.$totals['dom_cp'].'
Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'
Total Score'.$map_matches[gamescore].'
Total Kills'.$map_matches[kills].'
Total Teamkills'.$map_matches[teamkills].'
Total Suicides'.$map_matches[suicides].'
Last Match'.$map_lastmatch.'
-
'; - -// Do graph stuff -$bgwhere = "(mapfile = '$realmap' or mapfile = '$bugmap')"; -include("pages/graph_mbreakdown.php"); - -// Show a list of BT records -if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, 3)) == "bt-")) { - $mcount = small_count("SELECT pi.id FROM uts_events AS e, uts_pinfo AS pi, uts_player AS p, uts_match AS m WHERE m.id = e.matchid AND m.id = p.matchid AND p.playerid = e.playerid AND pi.id = p.pid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') GROUP BY pi.id"); + + Last Match + '.$map_lastmatch.' + + +
'; + + + // Show a list of recent matches + $mcount = small_count("SELECT id FROM uts_match WHERE mapfile = '$realmap' OR mapfile = '$bugmap' GROUP BY id"); $ecount = $mcount/25; $ecount2 = number_format($ecount, 0, '.', ''); @@ -186,7 +183,7 @@ if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, IF($ecount < 1) { $lpage = 0; } else { $lpage = $ecount2-1; } - $cpage = preg_replace('/\D/', '', $_GET["rpage"]); + $cpage = preg_replace('/\D/', '', $_GET["page"]); $qpage = $cpage*25; IF ($cpage == "") { $cpage = "0"; } @@ -195,127 +192,133 @@ if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, $tlpage = $lpage+1; $ppage = $cpage-1; - $ppageurl = "[Previous]"; + $ppageurl = "[Previous]"; IF ($ppage < "0") { $ppageurl = "[Previous]"; } $npage = $cpage+1; - $npageurl = "[Next]"; + $npageurl = "[Next]"; IF ($npage >= "$ecount") { $npageurl = "[Next]"; } - $fpageurl = "[First]"; + $fpageurl = "[First]"; IF ($cpage == "0") { $fpageurl = "[First]"; } - $lpageurl = "[Last]"; + $lpageurl = "[Last]"; IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } - $sql_btrecords = "SELECT pi.id, pi.name AS name, pi.country, e.col3 AS time, e.col4 AS date FROM uts_events AS e, uts_pinfo AS pi, uts_player AS p, uts_match AS m WHERE m.id = e.matchid AND m.id = p.matchid AND p.playerid = e.playerid AND pi.id = p.pid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') AND e.col1 = 'btcap' GROUP BY pi.id ORDER BY (0 + e.col3) ASC, e.col4 ASC LIMIT $qpage,25"; - $q_btrecords = mysql_query($sql_btrecords) or die (mysql_error()); - if (mysql_num_rows($q_btrecords) > 0) { - echo ' -
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
- - - - - - - - - - - '; - $i = $qpage; - $lasttime = -1; - while ($r_btrecords = mysql_fetch_array($q_btrecords)) { - $i++; - $class = ($i%2) ? 'grey' : 'grey2'; - echo ' - - - - '; - $lasttime = $r_btrecords['time']; - } - echo ' - -
Fastest captures
N°NameTimeDate
'.($lasttime == $r_btrecords['time'] ? '' : $i).' ', FormatPlayerName($r_btrecords['country'], $r_btrecords['id'], $r_btrecords['name']), '', btcaptime($r_btrecords['time']), '', gmdate('d-m-Y h:i a', $r_btrecords['date']), '
-
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'

'; - } -} + // list recent matches + echo' +
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
+ + + + + + + + + + '; + $sql_maps = "SELECT m.id, m.time, g.name AS gamename, m.gametime + FROM uts_match AS m, uts_games AS g WHERE (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') AND m.gid = g.id ORDER BY time DESC LIMIT $qpage,25"; + $q_maps = mysql_query($sql_maps) or die(mysql_error()); + while ($r_maps = mysql_fetch_array($q_maps)) { + $r_mapfile = un_ut($r_maps[mapfile]); + $r_matchtime = mdate($r_maps[time]); + $r_gametime = GetMinutes($r_maps[gametime]); -// Show a list of recent matches -$mcount = small_count("SELECT id FROM uts_match WHERE mapfile = '$realmap' OR mapfile = '$bugmap' GROUP BY id"); + $map_pcount = small_count("SELECT id FROM uts_player WHERE matchid = $r_maps[id]"); -$ecount = $mcount/25; -$ecount2 = number_format($ecount, 0, '.', ''); + echo' + + + + + + '; + } -IF($ecount > $ecount2) { - $ecount2 = $ecount2+1; -} + echo' +
Recent Matches
DateMatch TypePlayer CountTime
'.$r_matchtime.''.$r_maps[gamename].''.$map_pcount.''.$r_gametime.'
+
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; + + // Do graph stuff + $bgwhere = "(mapfile = '$realmap' or mapfile = '$bugmap')"; + include("pages/graph_mbreakdown.php"); -$fpage = 0; -IF($ecount < 1) { $lpage = 0; } -else { $lpage = $ecount2-1; } + // Show a list of BT records + if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, 3)) == "bt-")) { + $mcount = small_count("SELECT pi.id FROM uts_events AS e, uts_pinfo AS pi, uts_player AS p, uts_match AS m WHERE m.id = e.matchid AND m.id = p.matchid AND p.playerid = e.playerid AND pi.id = p.pid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') GROUP BY pi.id"); -$cpage = preg_replace('/\D/', '', $_GET["page"]); -$qpage = $cpage*25; + $ecount = $mcount/25; + $ecount2 = number_format($ecount, 0, '.', ''); -IF ($cpage == "") { $cpage = "0"; } + IF($ecount > $ecount2) { + $ecount2 = $ecount2+1; + } -$tfpage = $cpage+1; -$tlpage = $lpage+1; + $fpage = 0; + IF($ecount < 1) { $lpage = 0; } + else { $lpage = $ecount2-1; } -$ppage = $cpage-1; -$ppageurl = "[Previous]"; -IF ($ppage < "0") { $ppageurl = "[Previous]"; } + $cpage = preg_replace('/\D/', '', $_GET["rpage"]); + $qpage = $cpage*25; -$npage = $cpage+1; -$npageurl = "[Next]"; -IF ($npage >= "$ecount") { $npageurl = "[Next]"; } + IF ($cpage == "") { $cpage = "0"; } -$fpageurl = "[First]"; -IF ($cpage == "0") { $fpageurl = "[First]"; } + $tfpage = $cpage+1; + $tlpage = $lpage+1; -$lpageurl = "[Last]"; -IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } + $ppage = $cpage-1; + $ppageurl = "[Previous]"; + IF ($ppage < "0") { $ppageurl = "[Previous]"; } -// list recent matches -echo' -
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
- - - - - - - - - - '; + $npage = $cpage+1; + $npageurl = "[Next]"; + IF ($npage >= "$ecount") { $npageurl = "[Next]"; } -$sql_maps = "SELECT m.id, m.time, g.name AS gamename, m.gametime -FROM uts_match AS m, uts_games AS g WHERE (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') AND m.gid = g.id ORDER BY time DESC LIMIT $qpage,25"; -$q_maps = mysql_query($sql_maps) or die(mysql_error()); -while ($r_maps = mysql_fetch_array($q_maps)) { + $fpageurl = "[First]"; + IF ($cpage == "0") { $fpageurl = "[First]"; } - $r_mapfile = un_ut($r_maps[mapfile]); - $r_matchtime = mdate($r_maps[time]); - $r_gametime = GetMinutes($r_maps[gametime]); + $lpageurl = "[Last]"; + IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } - $map_pcount = small_count("SELECT id FROM uts_player WHERE matchid = $r_maps[id]"); + $sql_btrecords = "SELECT pi.id, pi.name AS name, pi.country, e.col3 AS time, e.col4 AS date FROM uts_events AS e, uts_pinfo AS pi, uts_player AS p, uts_match AS m WHERE m.id = e.matchid AND m.id = p.matchid AND p.playerid = e.playerid AND pi.id = p.pid AND (m.mapfile = '$realmap' OR m.mapfile = '$bugmap') AND e.col1 = 'btcap' GROUP BY pi.id ORDER BY (0 + e.col3) ASC, e.col4 ASC LIMIT $qpage,25"; + $q_btrecords = mysql_query($sql_btrecords) or die (mysql_error()); + if (mysql_num_rows($q_btrecords) > 0) { + echo ' +
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
+
Recent Matches
DateMatch TypePlayer CountTime
+ + + + + + + + + + '; + $i = $qpage; + $lasttime = -1; + while ($r_btrecords = mysql_fetch_array($q_btrecords)) { + $i++; + $class = ($i%2) ? 'grey' : 'grey2'; + echo ' + + + + '; + $lasttime = $r_btrecords['time']; + } + echo ' + +
Fastest captures
N°NameTimeDate
'.($lasttime == $r_btrecords['time'] ? '' : $i).' ', FormatPlayerName($r_btrecords['country'], $r_btrecords['id'], $r_btrecords['name']), '', btcaptime($r_btrecords['time']), '', gmdate('d-m-Y h:i a', $r_btrecords['date']), '
+
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'

'; + } + } - echo' - - '.$r_matchtime.' - '.$r_maps[gamename].' - '.$map_pcount.' - '.$r_gametime.' - '; } -echo' - -
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; ?> -- cgit