From fdd379c949056fb3a2198039e452f6aae600ef35 Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Wed, 10 Jan 2018 03:13:17 +0100 Subject: Cleanup images and markup --- html/pages/maps_info.php | 220 ++++++++++++++++++++++++----------------------- 1 file changed, 114 insertions(+), 106 deletions(-) (limited to 'html/pages/maps_info.php') diff --git a/html/pages/maps_info.php b/html/pages/maps_info.php index a7c355e..fc0a9e3 100644 --- a/html/pages/maps_info.php +++ b/html/pages/maps_info.php @@ -19,19 +19,24 @@ if($map_matches[gametime]<= 0) { // Map pic code $mappic = getMapImageName($map); - echo' - - - - - + echo ' +
Statistics for '.htmlentities($map).'
'.$mapname.'
+ + + + + + + - - + + - - + + '; // Show some gametype specific stuff if ((strtolower(substr($map, 0, 7)) == "ctf-bt-") or (strtolower(substr($map, 0, 3)) == "bt-")) { @@ -40,25 +45,25 @@ if($map_matches[gametime]<= 0) { if (!empty($record['time'])) { echo ' - - + + '; } else { echo ' - - + + '; } echo ' - - + + - - + + '; } else if (strtolower(substr($map, 0, 4)) == "ctf-") { @@ -66,28 +71,28 @@ if($map_matches[gametime]<= 0) { $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-") { @@ -95,16 +100,16 @@ if($map_matches[gametime]<= 0) { $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-") { @@ -112,16 +117,16 @@ if($map_matches[gametime]<= 0) { $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-") { @@ -129,118 +134,119 @@ if($map_matches[gametime]<= 0) { $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).'
+ '.$map.' +
Matches'.$map_matches[matchcount].'Matches'.$map_matches[matchcount].'
Total Time'.$map_tottime.' minutesTotal 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 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 CaptureNo record set!
Total Flags Captured'.$map_matches[gamescore].'Total Flags Captured'.$map_matches[gamescore].'
Total Suicides'.$map_matches[suicides].'Total Suicides'.$map_matches[suicides].'
Total Flags Captured'.$map_matches[gamescore].'Total Flags Captured'.$map_matches[gamescore].'
Total Flags Taken'.$totals['flag_taken'].'Total Flags Taken'.$totals['flag_taken'].'
Total Covers'.$totals['flag_cover'].'Total Covers'.$totals['flag_cover'].'
Total Flags Returned'.$totals['flag_return'].'Total Flags Returned'.$totals['flag_return'].'
Total Kills'.$map_matches[kills].'Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'Total Suicides'.$map_matches[suicides].'
Total Objectives Achieved'.$totals[ass_obj].'Total Objectives Achieved'.$totals[ass_obj].'
Total Kills'.$map_matches[kills].'Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'Total Suicides'.$map_matches[suicides].'
Team Releases'.$totals[ass_obj].'Team Releases'.$totals[ass_obj].'
Total Kills'.$map_matches[kills].'Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'Total Suicides'.$map_matches[suicides].'
Total Control Points Captured'.$totals['dom_cp'].'Total Control Points Captured'.$totals['dom_cp'].'
Total Kills'.$map_matches[kills].'Total Kills'.$map_matches[kills].'
Total Suicides'.$map_matches[suicides].'Total Suicides'.$map_matches[suicides].'
Total Score'.$map_matches[gamescore].'Total Score'.$map_matches[gamescore].'
Total Kills'.$map_matches[kills].'Total Kills'.$map_matches[kills].'
Total Teamkills'.$map_matches[teamkills].'Total Teamkills'.$map_matches[teamkills].'
Total Suicides'.$map_matches[suicides].'Total Suicides'.$map_matches[suicides].'
Last Match'.$map_lastmatch.'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) { + 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["page"]); $qpage = $cpage*25; - IF ($cpage == "") { $cpage = "0"; } + if ($cpage == "") { $cpage = "0"; } $tfpage = $cpage+1; $tlpage = $lpage+1; $ppage = $cpage-1; $ppageurl = "[Previous]"; - IF ($ppage < "0") { $ppageurl = "[Previous]"; } + if ($ppage < "0") { $ppageurl = "[Previous]"; } $npage = $cpage+1; $npageurl = "[Next]"; - IF ($npage >= "$ecount") { $npageurl = "[Next]"; } + if ($npage >= "$ecount") { $npageurl = "[Next]"; } $fpageurl = "[First]"; - IF ($cpage == "0") { $fpageurl = "[First]"; } + if ($cpage == "0") { $fpageurl = "[First]"; } $lpageurl = "[Last]"; - IF ($cpage == "$lpage") { $lpageurl = "[Last]"; } + if ($cpage == "$lpage") { $lpageurl = "[Last]"; } // list recent matches - echo' + 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"; + 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]); + 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]"); + $map_pcount = small_count("SELECT id FROM uts_player WHERE matchid = $r_maps[id]"); - echo' - + echo ' + - '; + '; } - echo' -
Recent Matches
Recent Matches
DateMatch TypePlayer CountTimeDateMatch TypePlayer CountTime
'.$r_matchtime.' '.$r_maps[gamename].' '.$map_pcount.' '.$r_gametime.'
+ echo ' + +
Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'
'; // Do graph stuff @@ -254,71 +260,73 @@ if($map_matches[gametime]<= 0) { $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"]); $qpage = $cpage*25; - IF ($cpage == "") { $cpage = "0"; } + if ($cpage == "") { $cpage = "0"; } $tfpage = $cpage+1; $tlpage = $lpage+1; $ppage = $cpage-1; $ppageurl = "[Previous]"; - IF ($ppage < "0") { $ppageurl = "[Previous]"; } + if ($ppage < "0") { $ppageurl = "[Previous]"; } $npage = $cpage+1; $npageurl = "[Next]"; - IF ($npage >= "$ecount") { $npageurl = "[Next]"; } + if ($npage >= "$ecount") { $npageurl = "[Next]"; } $fpageurl = "[First]"; - IF ($cpage == "0") { $fpageurl = "[First]"; } + if ($cpage == "0") { $fpageurl = "[First]"; } $lpageurl = "[Last]"; - IF ($cpage == "$lpage") { $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"; + $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 ' - + + echo '
Fastest capturesFastest captures
N°NameTimeDate
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']), '
', 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.'

'; } } - } ?> -- cgit