<?
include ($_SERVER['DOCUMENT_ROOT']."/inc/config.php");
if ($ses_AuthLevel >= $AuthLevel_BoardBottom) {

	header("Content-Type: application/force-download");
	header("Content-Disposition: attachment; filename=\"Uniforms.csv\""); 

	include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_connect.php");

	$Teams = $TeamYear."R_";
	$sql = "SELECT People.*, PlayerFamily.*, Player.*, Positions.*, Groups.*
	FROM People, PlayerFamily, Player, Positions, Groups
	WHERE Player.PeopleID = PlayerFamily.RegistrationID and PlayerFamily.P_PeopleID = People.PeopleID and People.PeopleID = Positions.PeopleID and Positions.GroupID = Groups.GroupID and Positions.GroupID LIKE '$Teams'
	ORDER BY Groups.GroupID ASC, People.LastName ASC, People.FirstName ASC";

	include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_execute.php");

	echo "Registration #,PeopleID,First Name,Last Name,Division,Team Letter,Team Name,Shirt,Shorts,Socks,Extra Socks,Visor Name,\n";
	
	// Format results by row
	while ($row = mysql_fetch_array($sql_result)) {
		$RegistrationID = $row["RegistrationID"];
		$PeopleID = $row["PeopleID"];
		$FirstName = $row["FirstName"];
		$LastName = $row["LastName"];
		$GroupDivAge = $row["GroupDivAge"];
		$GroupChar = $row["GroupChar"];
		$GroupName = $row["GroupName"];
		$Shirt = $row["Shirt"];
		$Shorts = $row["Shorts"];
		$Socks = $row["Socks"];
		$SocksExtra = $row["SocksExtra"];
		$VisorName = $row["VisorName"];

		echo $RegistrationID.",".$PeopleID.",".$FirstName.",".$LastName.",".$GroupDivAge.",".$GroupChar.",".$GroupName.",".$Shirt.",".$Shorts.",".$Socks.",".$SocksExtra.",".$VisorName.",\n";
	}

	include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_close.php");
} ELSE {
	echo "Only Board of Directors and above may view this file.";
}
?>