diff options
| author | Matthijs Kuiper <info@matthijskuiper.nl> | 2018-01-14 11:28:01 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-01-14 11:28:01 +0100 |
| commit | 76ab07b6646c807d321274bfdfb2814cffb6af90 (patch) | |
| tree | 3878861d9f6c8c70fd5d638fb3ce58857cee00d5 /html/pages/maps_info.php | |
| parent | cbae6c7e376faf9b4a76ab0631d9da168545e41f (diff) | |
| parent | 701165fded99ff9f70a4379444d9bd1432052c63 (diff) | |
Merge pull request #7 from sn3p/new-design4.4.0
New design
Diffstat (limited to 'html/pages/maps_info.php')
| -rw-r--r--[-rwxr-xr-x] | html/pages/maps_info.php | 529 |
1 files changed, 270 insertions, 259 deletions
diff --git a/html/pages/maps_info.php b/html/pages/maps_info.php index 329fcce..fc0a9e3 100755..100644 --- a/html/pages/maps_info.php +++ b/html/pages/maps_info.php @@ -1,6 +1,6 @@ <?php
-$map = my_addslashes($_GET[map]);
-$bugmap = my_addslashes($_GET[map]);
+$map = mysql_real_escape_string($_GET[map]);
+$bugmap = mysql_real_escape_string($_GET[map]);
$realmap = $bugmap.".unr";
$map_matches = small_query("SELECT COUNT(id) as matchcount, SUM(t0score+t1score+t2score+t3score) AS gamescore,
@@ -10,312 +10,323 @@ $map_last = small_query("SELECT time FROM uts_match WHERE mapfile = '$realmap' O $map_tottime = GetMinutes($map_matches[gametime]);
$map_lastmatch = mdate($map_last[time]);
-// Map pic code
-$mappic = strtolower("images/maps/".$map.".jpg");
+if($map_matches[gametime]<= 0) {
+
+ echo "map not found";
-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'])) {
+ // Map pic code
+ $mappic = getMapImageName($map);
+
+ echo '
+ <table class="zebra box" border="0" cellpadding="0" cellspacing="0" width="700">
+ <tbody>
+ <tr>
+ <th class="heading" align="center" colspan="4">Statistics for '.htmlentities($map).'</th>
+ </tr>
+ <tr>
+ <th colspan="4" class="mapheader">
+ <img border="0" alt="'.$map.'" src="'.$mappic.'" width=698>
+ </th>
+ </tr>
+ <tr>
+ <th align="center">Matches</th>
+ <td align="center">'.$map_matches[matchcount].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Time</th>
+ <td 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>
+ <th align="center">Fastest Capture</th>
+ <td 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>
+ <th align="center">Fastest Capture</th>
+ <td align="center">No record set!</td>
+ </tr>';
+ }
+ echo '
+ <tr>
+ <th align="center">Total Flags Captured</th>
+ <td align="center">'.$map_matches[gamescore].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Suicides</th>
+ <td 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>
+ <th align="center">Total Flags Captured</th>
+ <td align="center">'.$map_matches[gamescore].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Flags Taken</th>
+ <td align="center">'.$totals['flag_taken'].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Covers</th>
+ <td align="center">'.$totals['flag_cover'].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Flags Returned</th>
+ <td align="center">'.$totals['flag_return'].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Kills</th>
+ <td align="center">'.$map_matches[kills].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Suicides</th>
+ <td 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">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>';
+ <tr>
+ <th align="center">Total Objectives Achieved</th>
+ <td align="center">'.$totals[ass_obj].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Kills</th>
+ <td align="center">'.$map_matches[kills].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Suicides</th>
+ <td 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>
+ <th align="center">Team Releases</th>
+ <td align="center">'.$totals[ass_obj].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Kills</th>
+ <td align="center">'.$map_matches[kills].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Suicides</th>
+ <td 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>
+ <th align="center">Total Control Points Captured</th>
+ <td align="center">'.$totals['dom_cp'].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Kills</th>
+ <td align="center">'.$map_matches[kills].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Suicides</th>
+ <td align="center">'.$map_matches[suicides].'</td>
+ </tr>';
}
else {
echo '
- <tr>
- <td class="dark" align="center">Fastest Capture</td>
- <td class="grey" align="center">No record set!</td>
- </tr>';
+ <tr>
+ <th align="center">Total Score</th>
+ <td align="center">'.$map_matches[gamescore].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Kills</th>
+ <td align="center">'.$map_matches[kills].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Teamkills</th>
+ <td align="center">'.$map_matches[teamkills].'</td>
+ </tr>
+ <tr>
+ <th align="center">Total Suicides</th>
+ <td align="center">'.$map_matches[suicides].'</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");
+ <tr>
+ <th align="center">Last Match</th>
+ <td align="center">'.$map_lastmatch.'</td>
+ </tr>
+ </tbody></table>
+ <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) {
+ 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["rpage"]);
+ $cpage = preg_replace('/\D/', '', $_GET["page"]);
$qpage = $cpage*25;
- IF ($cpage == "") { $cpage = "0"; }
+ 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]"; }
+ $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)."&rpage=$npage\">[Next]</a>";
- IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
+ $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)."&rpage=$fpage\">[First]</a>";
- IF ($cpage == "0") { $fpageurl = "[First]"; }
+ $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)."&rpage=$lpage\">[Last]</a>";
- IF ($cpage == "$lpage") { $lpageurl = "[Last]"; }
+ $lpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$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>';
- }
-}
+ // list recent matches
+ echo '
+ <div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>
+ <table class="zebra box" border="0" cellpadding="0" cellspacing="0" width=700>
+ <tbody>
+ <tr>
+ <th class="heading" colspan="5" align="center">Recent Matches</th>
+ </tr>
+ <tr>
+ <th class="smheading" align="center" width="250">Date</th>
+ <th class="smheading" align="center" width="100">Match Type</th>
+ <th class="smheading" align="center">Player Count</th>
+ <th class="smheading" align="center" width="100">Time</th>
+ </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]);
-// 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 '
+ <tr class="clickableRow" href="./?p=match&mid='.$r_maps[id].'">
+ <td align="center"><a href="./?p=match&mid='.$r_maps[id].'">'.$r_matchtime.'</a></td>
+ <td align="center">'.$r_maps[gamename].'</td>
+ <td align="center">'.$map_pcount.'</td>
+ <td align="center">'.$r_gametime.'</td>
+ </tr>';
+ }
-IF($ecount > $ecount2) {
- $ecount2 = $ecount2+1;
-}
+ echo '
+ </tbody>
+ </table>
+ <div class="pages">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>';
-$fpage = 0;
-IF($ecount < 1) { $lpage = 0; }
-else { $lpage = $ecount2-1; }
+ // Do graph stuff
+ $bgwhere = "(mapfile = '$realmap' or mapfile = '$bugmap')";
+ include("pages/graph_mbreakdown.php");
-$cpage = preg_replace('/\D/', '', $_GET["page"]);
-$qpage = $cpage*25;
+ // 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");
-IF ($cpage == "") { $cpage = "0"; }
+ $ecount = $mcount/25;
+ $ecount2 = number_format($ecount, 0, '.', '');
-$tfpage = $cpage+1;
-$tlpage = $lpage+1;
+ if ($ecount > $ecount2) {
+ $ecount2 = $ecount2+1;
+ }
-$ppage = $cpage-1;
-$ppageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$ppage\">[Previous]</a>";
-IF ($ppage < "0") { $ppageurl = "[Previous]"; }
+ $fpage = 0;
+ if ($ecount < 1) { $lpage = 0; }
+ else { $lpage = $ecount2-1; }
-$npage = $cpage+1;
-$npageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$npage\">[Next]</a>";
-IF ($npage >= "$ecount") { $npageurl = "[Next]"; }
+ $cpage = preg_replace('/\D/', '', $_GET["rpage"]);
+ $qpage = $cpage*25;
-$fpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$fpage\">[First]</a>";
-IF ($cpage == "0") { $fpageurl = "[First]"; }
+ if ($cpage == "") { $cpage = "0"; }
-$lpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&page=$lpage\">[Last]</a>";
-IF ($cpage == "$lpage") { $lpageurl = "[Last]"; }
+ $tfpage = $cpage+1;
+ $tlpage = $lpage+1;
-// 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>';
+ $ppage = $cpage-1;
+ $ppageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$ppage\">[Previous]</a>";
+ if ($ppage < "0") { $ppageurl = "[Previous]"; }
-$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)) {
+ $npage = $cpage+1;
+ $npageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$npage\">[Next]</a>";
+ if ($npage >= "$ecount") { $npageurl = "[Next]"; }
- $r_mapfile = un_ut($r_maps[mapfile]);
- $r_matchtime = mdate($r_maps[time]);
- $r_gametime = GetMinutes($r_maps[gametime]);
+ $fpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$fpage\">[First]</a>";
+ if ($cpage == "0") { $fpageurl = "[First]"; }
- $map_pcount = small_count("SELECT id FROM uts_player WHERE matchid = $r_maps[id]");
+ $lpageurl = "<a class=\"pages\" href=\"./?p=minfo&map=".htmlentities($map)."&rpage=$lpage\">[Last]</a>";
+ if ($cpage == "$lpage") { $lpageurl = "[Last]"; }
- 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>';
+ $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">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div>
+ <table class="zebra box" border="0" cellpadding="0" cellspacing="0" width="700">
+ <tbody>
+ <tr>
+ <th class="heading" colspan="4" align="center">Fastest captures</th>
+ </tr>
+ <tr>
+ <th class="smheading" align="center" width="40">N°</th>
+ <th class="smheading" align="center" width="200">Name</th>
+ <th class="smheading" align="center" width="60">Time</th>
+ <th class="smheading" align="center" width="180">Date</th>
+ </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">Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</div><br>';
+ }
+ }
}
-echo'
-</tbody></table>
-<div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>';
?>
|