From 40dfa7d5c0dc8e4cb2c95e403b6b4b2c4bf70644 Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Sat, 4 Feb 2017 16:05:45 +0100 Subject: Original UTStats beta 4.2.8 --- html/pages/maps_info.php | 321 +++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 321 insertions(+) create mode 100755 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 new file mode 100755 index 0000000..329fcce --- /dev/null +++ b/html/pages/maps_info.php @@ -0,0 +1,321 @@ + + + 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'])) { + echo ' + + Fastest Capture + '.FormatPlayerName($record['country'], $record['id'], $record['name']).'
' . btcaptime($record['time']) . ' minutes
'.gmdate('d-m-Y h:i a', $record['date']).' + '; + } + else { + echo ' + + Fastest Capture + No record set! + '; + } + echo ' + + Total Flags Captured + '.$map_matches[gamescore].' + + + Total Suicides + '.$map_matches[suicides].' + '; +} +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 ' + + 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].' + '; +} +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 ' + + Total Objectives Achieved + '.$totals[ass_obj].' + + + Total Kills + '.$map_matches[kills].' + + + Total Suicides + '.$map_matches[suicides].' + '; +} +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 ' + + Team Releases + '.$totals[ass_obj].' + + + Total Kills + '.$map_matches[kills].' + + + Total Suicides + '.$map_matches[suicides].' + '; +} +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 ' + + Total Control Points Captured + '.$totals['dom_cp'].' + + + Total Kills + '.$map_matches[kills].' + + + Total Suicides + '.$map_matches[suicides].' + '; +} +else { + echo ' + + Total Score + '.$map_matches[gamescore].' + + + Total Kills + '.$map_matches[kills].' + + + Total Teamkills + '.$map_matches[teamkills].' + + + Total Suicides + '.$map_matches[suicides].' + '; +} +echo ' + + 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"); + + $ecount = $mcount/25; + $ecount2 = number_format($ecount, 0, '.', ''); + + IF($ecount > $ecount2) { + $ecount2 = $ecount2+1; + } + + $fpage = 0; + IF($ecount < 1) { $lpage = 0; } + else { $lpage = $ecount2-1; } + + $cpage = preg_replace('/\D/', '', $_GET["rpage"]); + $qpage = $cpage*25; + + IF ($cpage == "") { $cpage = "0"; } + + $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]"; } + + $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.'

'; + } +} + + + +// 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, '.', ''); + +IF($ecount > $ecount2) { + $ecount2 = $ecount2+1; +} + +$fpage = 0; +IF($ecount < 1) { $lpage = 0; } +else { $lpage = $ecount2-1; } + +$cpage = preg_replace('/\D/', '', $_GET["page"]); +$qpage = $cpage*25; + +IF ($cpage == "") { $cpage = "0"; } + +$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]"; } + +// 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]); + + $map_pcount = small_count("SELECT id FROM uts_player WHERE matchid = $r_maps[id]"); + + echo' + + + + + + '; +} + +echo' +
Recent Matches
DateMatch TypePlayer CountTime
'.$r_matchtime.''.$r_maps[gamename].''.$map_pcount.''.$r_gametime.'
+
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; +?> -- cgit