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/match_info_ctf.php | 362 ++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 362 insertions(+) create mode 100755 html/pages/match_info_ctf.php (limited to 'html/pages/match_info_ctf.php') diff --git a/html/pages/match_info_ctf.php b/html/pages/match_info_ctf.php new file mode 100755 index 0000000..7426a4e --- /dev/null +++ b/html/pages/match_info_ctf.php @@ -0,0 +1,362 @@ + + + Flag Event Summary + + + Team: Red + + + Player + Score + Flag Taken + Flag Pickup + Flag Drop + Flag Assist + Flag Cover + Flag Seal + Flag Capture + Flag Kill + Flag Return + + + Team + Player + '; + +$sql_msred = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank +FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 0 ORDER BY gamescore DESC"; +$q_msred = mysql_query($sql_msred) or die(mysql_error()); +$i = 0; +while ($r_msred = zero_out(mysql_fetch_array($q_msred))) { + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + + $redpname = $r_msred[name]; + $myurl = urlencode($r_msred[name]); + + + + echo''; + if ($r_msred['banned'] != 'Y') { + echo ''.FormatPlayerName($r_msred[country], $r_msred['pid'], $redpname, $gid, $gamename, true, $r_msred['rank']).''; + } else { + $r_msred ['gamescore'] = '-'; + $r_msred ['flag_taken'] = '-'; + $r_msred ['flag_pickedup'] = '-'; + $r_msred ['flag_dropped'] = '-'; + $r_msred ['flag_assist'] = '-'; + $r_msred ['flag_cover'] = '-'; + $r_msred ['flag_seal'] = '-'; + $r_msred ['flag_capture'] = '-'; + $r_msred ['flag_kill'] = '-'; + $r_msred ['flag_return'] = '-'; + echo ''.FormatPlayerName($r_msred[country], $r_msred['pid'], $redpname, $gid, $gamename, true, $r_msred['rank']).''; + } + + echo ' + + '.$r_msred[gamescore].' + '.$r_msred[flag_taken].' + '.$r_msred[flag_pickedup].' + '.$r_msred[flag_dropped].' + '.$r_msred[flag_assist].' + '.$r_msred[flag_cover].' + '.$r_msred[flag_seal].' + '.$r_msred[flag_capture].' + '.$r_msred[flag_kill].' + '.$r_msred[flag_return].' + '; +} + +$teamscore = small_query("SELECT t0score AS teamscore FROM uts_match WHERE id = $mid"); +$msredtot = small_query("SELECT SUM(gamescore) AS gamescore, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return +FROM uts_player WHERE matchid = $mid AND team = 0 ORDER BY gamescore DESC"); + + +echo' + + Totals + '.$teamscore[teamscore].' + '.$msredtot[gamescore].' + '.$msredtot[flag_taken].' + '.$msredtot[flag_pickedup].' + '.$msredtot[flag_dropped].' + '.$msredtot[flag_assist].' + '.$msredtot[flag_cover].' + '.$msredtot[flag_seal].' + '.$msredtot[flag_capture].' + '.$msredtot[flag_kill].' + '.$msredtot[flag_return].' + + + + + Team: Blue + + + Player + Score + Flag Taken + Flag Pickup + Flag Drop + Flag Assist + Flag Cover + Flag Seal + Flag Capture + Flag Kill + Flag Return + + + Team + Player + '; + +$sql_msblue = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank +FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 1 ORDER BY gamescore DESC"; +$q_msblue = mysql_query($sql_msblue) or die(mysql_error()); +$i = 0; +while ($r_msblue = zero_out(mysql_fetch_array($q_msblue))) { + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + + $bluepname = $r_msblue[name]; + $myurl = urlencode($r_msblue[name]); + + echo''; + if ($r_msblue['banned'] != 'Y') { + echo ''.FormatPlayerName($r_msblue[country], $r_msblue['pid'], $bluepname, $gid, $gamename, true, $r_msblue['rank']).''; + } else { + $r_msblue ['gamescore'] = '-'; + $r_msblue ['flag_taken'] = '-'; + $r_msblue ['flag_pickedup'] = '-'; + $r_msblue ['flag_dropped'] = '-'; + $r_msblue ['flag_assist'] = '-'; + $r_msblue ['flag_cover'] = '-'; + $r_msblue ['flag_seal'] = '-'; + $r_msblue ['flag_capture'] = '-'; + $r_msblue ['flag_kill'] = '-'; + $r_msblue ['flag_return'] = '-'; + echo ''.FormatPlayerName($r_msblue[country], $r_msblue['pid'], $bluepname, $gid, $gamename, true, $r_msblue['rank']).''; + } + + echo ' + + '.$r_msblue[gamescore].' + '.$r_msblue[flag_taken].' + '.$r_msblue[flag_pickedup].' + '.$r_msblue[flag_dropped].' + '.$r_msblue[flag_assist].' + '.$r_msblue[flag_cover].' + '.$r_msblue[flag_seal].' + '.$r_msblue[flag_capture].' + '.$r_msblue[flag_kill].' + '.$r_msblue[flag_return].' + '; +} + +$teamscore = small_query("SELECT t1score AS teamscore FROM uts_match WHERE id = $mid"); +$msbluetot = small_query("SELECT SUM(gamescore) AS gamescore, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return +FROM uts_player WHERE matchid = $mid AND team = 1 ORDER BY gamescore DESC"); + +echo' + + Totals + '.$teamscore[teamscore].' + '.$msbluetot[gamescore].' + '.$msbluetot[flag_taken].' + '.$msbluetot[flag_pickedup].' + '.$msbluetot[flag_dropped].' + '.$msbluetot[flag_assist].' + '.$msbluetot[flag_cover].' + '.$msbluetot[flag_seal].' + '.$msbluetot[flag_capture].' + '.$msbluetot[flag_kill].' + '.$msbluetot[flag_return].' + '; + +// Check If Green Team Were Used (CTF4 Compatibility) + +$greencheck = small_count("SELECT * FROM uts_player WHERE matchid = $mid AND team = 2"); +IF ($greencheck > 0) { + + echo' + Team: Green + + + Player + Score + Flag Taken + Flag Pickup + Flag Drop + Flag Assist + Flag Cover + Flag Seal + Flag Capture + Flag Kill + Flag Return + + + Team + Player + '; + + $sql_msgreen = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank + FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 2 ORDER BY gamescore DESC"; + $q_msgreen = mysql_query($sql_msgreen) or die(mysql_error()); + $i = 0; + while ($r_msgreen = zero_out(mysql_fetch_array($q_msgreen))) { + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + + $greenpname = $r_msgreen[name]; + $myurl = urlencode($r_msgreen[name]); + + echo''; + if ($r_msgreen['banned'] != 'Y') { + echo ''.FormatPlayerName($r_msgreen[country], $r_msgreen['pid'], $greenpname, $gid, $gamename, true, $r_msgreen['rank']).''; + } else { + $r_msgreen ['gamescore'] = '-'; + $r_msgreen ['flag_taken'] = '-'; + $r_msgreen ['flag_pickedup'] = '-'; + $r_msgreen ['flag_dropped'] = '-'; + $r_msgreen ['flag_assist'] = '-'; + $r_msgreen ['flag_cover'] = '-'; + $r_msgreen ['flag_seal'] = '-'; + $r_msgreen ['flag_capture'] = '-'; + $r_msgreen ['flag_kill'] = '-'; + $r_msgreen ['flag_return'] = '-'; + echo ''.FormatPlayerName($r_msgreen[country], $r_msgreen['pid'], $greenpname, $gid, $gamename, true, $r_msgreen['rank']).''; + } + + echo ' + + '.$r_msgreen[gamescore].' + '.$r_msgreen[flag_taken].' + '.$r_msgreen[flag_pickedup].' + '.$r_msgreen[flag_dropped].' + '.$r_msgreen[flag_assist].' + '.$r_msgreen[flag_cover].' + '.$r_msgreen[flag_seal].' + '.$r_msgreen[flag_capture].' + '.$r_msgreen[flag_kill].' + '.$r_msgreen[flag_return].' + '; + } + + $teamscore = small_query("SELECT t1score AS teamscore FROM uts_match WHERE id = $mid"); + $msgreentot = small_query("SELECT SUM(gamescore) AS gamescore, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return + FROM uts_player WHERE matchid = $mid AND team = 2 ORDER BY gamescore DESC"); + + echo' + + Totals + '.$teamscore[teamscore].' + '.$msgreentot[gamescore].' + '.$msgreentot[flag_taken].' + '.$msgreentot[flag_pickedup].' + '.$msgreentot[flag_dropped].' + '.$msgreentot[flag_assist].' + '.$msgreentot[flag_cover].' + '.$msgreentot[flag_seal].' + '.$msgreentot[flag_capture].' + '.$msgreentot[flag_kill].' + '.$msgreentot[flag_return].' + '; +} + +// Check If Gold Team Were Used (CTF4 Compatibility) + +$goldcheck = small_count("SELECT * FROM uts_player WHERE matchid = $mid AND team = 3"); +IF ($goldcheck > 0) { + + echo' + Team: Gold + + + Player + Score + Flag Taken + Flag Pickup + Flag Drop + Flag Assist + Flag Cover + Flag Seal + Flag Capture + Flag Kill + Flag Return + + + Team + Player + '; + + $sql_msgold = "SELECT p.playerid, pi.name, pi.banned, p.country, p.pid, p.gamescore, p.flag_taken, p.flag_pickedup, p.flag_dropped, p.flag_assist, p.flag_cover, p.flag_seal, p.flag_capture, p.flag_kill, p.flag_return, p.rank + FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $mid AND team = 3 ORDER BY gamescore DESC"; + $q_msgold = mysql_query($sql_msgold) or die(mysql_error()); + $i = 0; + while ($r_msgold = zero_out(mysql_fetch_array($q_msgold))) { + $i++; + $class = ($i % 2) ? 'grey' : 'grey2'; + + $goldpname = $r_msgold[name]; + $myurl = urlencode($r_msgold[name]); + + echo''; + if ($r_msgold['banned'] != 'Y') { + echo ''.FormatPlayerName($r_msgold[country], $r_msgold['pid'], $goldpname, $gid, $gamename, true, $r_msgold['rank']).''; + } else { + $r_msgold ['gamescore'] = '-'; + $r_msgold ['flag_taken'] = '-'; + $r_msgold ['flag_pickedup'] = '-'; + $r_msgold ['flag_dropped'] = '-'; + $r_msgold ['flag_assist'] = '-'; + $r_msgold ['flag_cover'] = '-'; + $r_msgold ['flag_seal'] = '-'; + $r_msgold ['flag_capture'] = '-'; + $r_msgold ['flag_kill'] = '-'; + $r_msgold ['flag_return'] = '-'; + echo ''.FormatPlayerName($r_msgold[country], $r_msgold['pid'], $goldpname, $gid, $gamename, true, $r_msgold['rank']).''; + } + + echo ' + + '.$r_msgold[gamescore].' + '.$r_msgold[flag_taken].' + '.$r_msgold[flag_pickedup].' + '.$r_msgold[flag_dropped].' + '.$r_msgold[flag_assist].' + '.$r_msgold[flag_cover].' + '.$r_msgold[flag_seal].' + '.$r_msgold[flag_capture].' + '.$r_msgold[flag_kill].' + '.$r_msgold[flag_return].' + '; + } + + $teamscore = small_query("SELECT t1score AS teamscore FROM uts_match WHERE id = $mid"); + $msgoldtot = small_query("SELECT SUM(gamescore) AS gamescore, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return + FROM uts_player WHERE matchid = $mid AND team = 3 ORDER BY gamescore DESC"); + + echo' + + Totals + '.$teamscore[teamscore].' + '.$msgoldtot[gamescore].' + '.$msgoldtot[flag_taken].' + '.$msgoldtot[flag_pickedup].' + '.$msgoldtot[flag_dropped].' + '.$msgoldtot[flag_assist].' + '.$msgoldtot[flag_cover].' + '.$msgoldtot[flag_seal].' + '.$msgoldtot[flag_capture].' + '.$msgoldtot[flag_kill].' + '.$msgoldtot[flag_return].' + '; +} + +echo' +
'; + +?> -- cgit