diff options
Diffstat (limited to 'html/pages/maps_info.php')
| -rwxr-xr-x | html/pages/maps_info.php | 321 |
1 files changed, 321 insertions, 0 deletions
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 @@ +<?php
+$map = my_addslashes($_GET[map]);
+$bugmap = my_addslashes($_GET[map]);
+$realmap = $bugmap.".unr";
+
+$map_matches = small_query("SELECT COUNT(id) as matchcount, SUM(t0score+t1score+t2score+t3score) AS gamescore,
+SUM(gametime) AS gametime, SUM(kills) AS kills, SUM(deaths) AS deaths, SUM(suicides) AS suicides, SUM(teamkills) AS teamkills FROM uts_match WHERE mapfile = '$realmap' OR mapfile = '$bugmap'");
+$map_last = small_query("SELECT time FROM uts_match WHERE mapfile = '$realmap' OR mapfile = '$bugmap' ORDER BY time DESC LIMIT 0,1");
+
+$map_tottime = GetMinutes($map_matches[gametime]);
+$map_lastmatch = mdate($map_last[time]);
+
+// Map pic code
+$mappic = strtolower("images/maps/".$map.".jpg");
+
+if (file_exists($mappic)) {
+} else {
+ $mappic = ("images/maps/blank.jpg");
+}
+
+echo'
+<table class = "box" border="0" cellpadding="1" cellspacing="2" width="100%">
+ <tbody><tr>
+ <td class="heading" align="center" colspan="4">Statistics for '.htmlentities($map).'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Matches</td>
+ <td class="grey" align="center">'.$map_matches[matchcount].'</td>
+ <td class="grey" align="center" rowspan="9"><img border="0" alt="'.htmlentities($map).'" title="'.htmlentities($map).'" src="'.$mappic.'"></td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Time</td>
+ <td class="grey" align="center">'.$map_tottime.' minutes</td>
+ </tr>';
+// 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 '
+ <tr>
+ <td class="dark" align="center">Fastest Capture</td>
+ <td class="grey" align="center"><a href="?p=pinfo&pid='.$record[id].'">'.FormatPlayerName($record['country'], $record['id'], $record['name']).'</a><br>' . btcaptime($record['time']) . ' minutes<BR>'.gmdate('d-m-Y h:i a', $record['date']).'</td>
+ </tr>';
+ }
+ else {
+ echo '
+ <tr>
+ <td class="dark" align="center">Fastest Capture</td>
+ <td class="grey" align="center">No record set!</td>
+ </tr>';
+ }
+ echo '
+ <tr>
+ <td class="dark" align="center">Total Flags Captured</td>
+ <td class="grey" align="center">'.$map_matches[gamescore].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Suicides</td>
+ <td class="grey" align="center">'.$map_matches[suicides].'</td>
+ </tr>';
+}
+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 '
+ <tr>
+ <td class="dark" align="center">Total Flags Captured</td>
+ <td class="grey" align="center">'.$map_matches[gamescore].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Flags Taken</td>
+ <td class="grey" align="center">'.$totals['flag_taken'].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Covers</td>
+ <td class="grey" align="center">'.$totals['flag_cover'].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Flags Returned</td>
+ <td class="grey" align="center">'.$totals['flag_return'].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Kills</td>
+ <td class="grey" align="center">'.$map_matches[kills].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Suicides</td>
+ <td class="grey" align="center">'.$map_matches[suicides].'</td>
+ </tr>';
+}
+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 '
+ <tr>
+ <td class="dark" align="center">Total Objectives Achieved</td>
+ <td class="grey" align="center">'.$totals[ass_obj].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Kills</td>
+ <td class="grey" align="center">'.$map_matches[kills].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Suicides</td>
+ <td class="grey" align="center">'.$map_matches[suicides].'</td>
+ </tr>';
+}
+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 '
+ <tr>
+ <td class="dark" align="center">Team Releases</td>
+ <td class="grey" align="center">'.$totals[ass_obj].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Kills</td>
+ <td class="grey" align="center">'.$map_matches[kills].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Suicides</td>
+ <td class="grey" align="center">'.$map_matches[suicides].'</td>
+ </tr>';
+}
+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 '
+ <tr>
+ <td class="dark" align="center">Total Control Points Captured</td>
+ <td class="grey" align="center">'.$totals['dom_cp'].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Kills</td>
+ <td class="grey" align="center">'.$map_matches[kills].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Suicides</td>
+ <td class="grey" align="center">'.$map_matches[suicides].'</td>
+ </tr>';
+}
+else {
+ echo '
+ <tr>
+ <td class="dark" align="center">Total Score</td>
+ <td class="grey" align="center">'.$map_matches[gamescore].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Kills</td>
+ <td class="grey" align="center">'.$map_matches[kills].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Teamkills</td>
+ <td class="grey" align="center">'.$map_matches[teamkills].'</td>
+ </tr>
+ <tr>
+ <td class="dark" align="center">Total Suicides</td>
+ <td class="grey" align="center">'.$map_matches[suicides].'</td>
+ </tr>';
+}
+echo '
+ <tr>
+ <td class="dark" align="center">Last Match</td>
+ <td class="grey" align="center">'.$map_lastmatch.'</td>
+ </tr>
+</tbody></table>
+<br>';
+
+// 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 = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$ppage\">[Previous]</a>";
+ IF ($ppage < "0") { $ppageurl = "[Previous]"; }
+
+ $npage = $cpage+1;
+ $npageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$npage\">[Next]</a>";
+ IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
+
+ $fpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$fpage\">[First]</a>";
+ IF ($cpage == "0") { $fpageurl = "[First]"; }
+
+ $lpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$lpage\">[Last]</a>";
+ 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 '
+ <div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>
+ <table class = "box" border="0" cellpadding="0" cellspacing="2" width="480">
+ <tbody>
+ <tr>
+ <td class="heading" colspan="4" align="center">Fastest captures</td>
+ </tr>
+ <tr>
+ <td class="smheading" align="center" width="40">N°</td>
+ <td class="smheading" align="center" width="200">Name</td>
+ <td class="smheading" align="center" width="60">Time</td>
+ <td class="smheading" align="center" width="180">Date</td>
+ </tr>';
+ $i = $qpage;
+ $lasttime = -1;
+ while ($r_btrecords = mysql_fetch_array($q_btrecords)) {
+ $i++;
+ $class = ($i%2) ? 'grey' : 'grey2';
+ echo '
+ <tr><td class = "'.$class.'" align = "right">'.($lasttime == $r_btrecords['time'] ? '' : $i).' </td>
+ <td class = "'.$class.'" align = "center"><a href="?p=pinfo&pid='.$r_btrecords[id].'">', FormatPlayerName($r_btrecords['country'], $r_btrecords['id'], $r_btrecords['name']), '</a></td>
+ <td class = "'.$class.'" align = "center">', btcaptime($r_btrecords['time']), '</td>
+ <td class = "'.$class.'" align = "center">', gmdate('d-m-Y h:i a', $r_btrecords['date']), '</td></tr>';
+ $lasttime = $r_btrecords['time'];
+ }
+ echo '
+ </tbody>
+ </table>
+ <div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div><br>';
+ }
+}
+
+
+
+// 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 = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$ppage\">[Previous]</a>";
+IF ($ppage < "0") { $ppageurl = "[Previous]"; }
+
+$npage = $cpage+1;
+$npageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$npage\">[Next]</a>";
+IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
+
+$fpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$fpage\">[First]</a>";
+IF ($cpage == "0") { $fpageurl = "[First]"; }
+
+$lpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$lpage\">[Last]</a>";
+IF ($cpage == "$lpage") { $lpageurl = "[Last]"; }
+
+// list recent matches
+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="5" align="center">Recent Matches</td>
+ </tr>
+ <tr>
+ <td class="smheading" align="center" width="250">Date</td>
+ <td class="smheading" align="center" width="100">Match Type</td>
+ <td class="smheading" align="center">Player Count</td>
+ <td class="smheading" align="center" width="100">Time</td>
+ </tr>';
+
+$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'
+ <tr>
+ <td class="dark" align="center"><a class="darkhuman" href="./?p=match&mid='.$r_maps[id].'">'.$r_matchtime.'</a></td>
+ <td class="grey" align="center">'.$r_maps[gamename].'</td>
+ <td class="grey" align="center">'.$map_pcount.'</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>';
+?>
|