| 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'