Statistics for '.htmlentities($map).' '.$map.' Matches '.$map_matches[matchcount].' 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.'
'; // 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 = mysqli_query($GLOBALS["___mysqli_link"], $sql_maps) or die(mysqli_error($GLOBALS["___mysqli_link"])); while ($r_maps = mysqli_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
Date Match Type Player Count Time
'.$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"); // 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 = mysqli_query($GLOBALS["___mysqli_link"], $sql_btrecords) or die (mysqli_error($GLOBALS["___mysqli_link"])); if (mysqli_num_rows($q_btrecords) > 0) { echo '
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; $i = $qpage; $lasttime = -1; while ($r_btrecords = mysqli_fetch_array($q_btrecords)) { $i++; $class = ($i%2) ? 'grey' : 'grey2'; echo ' '; $lasttime = $r_btrecords['time']; } echo '
Fastest captures
N° Name Time Date
'.($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.'

'; } } } ?>