Enter the Clanbase WarID

'; echo'

Team BreakDown of Match
Red Team	Blue Team
'; $sql_rteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 0 ORDER BY pi.name ASC"; $q_rteam = mysql_query($sql_rteam); while ($r_rteam = mysql_fetch_array($q_rteam)) { echo''.$r_rteam[name].' '; } echo'	'; $sql_bteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 1 ORDER BY pi.name ASC"; $q_bteam = mysql_query($sql_bteam); while ($r_bteam = mysql_fetch_array($q_bteam)) { echo''.$r_bteam[name].' '; } echo'

'; IF ($wid == "") { } IF ($stage >= "1") { include("includes/clanbase.php"); $warinfo = get_clans($wid); } IF ($stage == "1") { $claninfo0 = get_players($warinfo[0][1]); $claninfo1 = get_players($warinfo[1][1]); echo''; } IF ($stage == "2") { $redteam = $_GET["red"]; IF($redteam == $warinfo[0][1]) { $redcid = $warinfo[0][1]; $redname = $warinfo[0][2]; $redinfo = get_players($warinfo[0][1]); $bluecid = $warinfo[1][1]; $bluename = $warinfo[1][2]; $blueinfo = get_players($warinfo[1][1]); } else { $redcid = $warinfo[1][1]; $redname = $warinfo[1][2]; $redinfo = get_players($warinfo[1][1]); $bluecid = $warinfo[0][1]; $bluename = $warinfo[0][2]; $blueinfo = get_players($warinfo[0][1]); } echo'

'; $redcount = count($redinfo); $bluecount = count($blueinfo); $sql_rteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 0 ORDER BY pi.name ASC"; $q_rteam = mysql_query($sql_rteam); while($r_rteam = mysql_fetch_array($q_rteam)) { echo''; } echo''; $sql_bteam = "SELECT p.id, pi.name FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND matchid = $id AND team = 1 ORDER BY pi.name ASC"; $q_bteam = mysql_query($sql_bteam); while($r_bteam = mysql_fetch_array($q_bteam)) { echo''; } echo'

Clan and Player Info for Clanbase War ID '.$wid.'
'.$redname.'
'.$r_rteam[name].'
'.$bluename.'
'.$r_bteam[name].'

'; } ?>

Who Played As Red Team?