<?
// Formats for download the registration database.  
// $_POST = array_map('stripslashes', $_POST);	// Strip the slashes
// extract($_POST);	// Allows global variables for the register pages

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

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

echo "Registration#,MemberID#,P_LastName,P_FirstName,P_NickName,P_EMailName,P_Street,P_Street2,P_City,P_State,P_PostalCode,P_Phone1,P_Phone1Type,P_Phone2,P_Phone2Type,P_Phone3,P_Phone3Type,P_BirthDate,P_BirthCity,P_BirthState,G1_ID#,G1_LastName,G1_FirstName,G1_NickName,G1_EMailName,G1_Street,G1_Street2,G1_City,G1_State,G1_PostalCode,G1_Phone1,G1_Phone1Type,G1_Phone2,G1_Phone2Type,G1_Phone3,G1_Phone3Type,G2_ID#,G2_LastName,G2_FirstName,G2_NickName,G2_EMailName,G2_Street,G2_Street2,G2_City,G2_State,G2_PostalCode,G2_Phone1,G2_Phone1Type,G2_Phone2,G2_Phone2Type,G2_Phone3,G2_Phone3Type,Season,Return,Source,Mgr,Coach,Pitcher,Catcher,AllStar,Experience,LastLeague,YearsExp,DivRqst,School,Grade,TimeStamp,\n";

//Shirt,Shorts,Socks,Extra Socks,Visor Name,

######################################################################################
// Query db and print the registration form
include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_connect.php");

//Create SQL statement
$sql = "SELECT PlayerFamily.*, Player.*
	FROM PlayerFamily, Player
	WHERE PlayerFamily.RegistrationID = Player.PeopleID
	ORDER BY P_LastName ASC, P_FirstName ASC";

include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_execute.php");
$numrows = mysql_num_rows($sql_result);
// echo $numrows." Registrations<BR>";

// Format results by row
while ($row = mysql_fetch_array($sql_result)) {
	$PeopleID = $row["PeopleID"];
	$P_PeopleID = $row["P_PeopleID"];
	$P_LastName = $row["P_LastName"];
	$P_FirstName = $row["P_FirstName"];
	$P_NickName = $row["P_NickName"];
	$P_EMailName_Priv = $row["P_EMailName_Priv"];
	$P_EMailName = $row["P_EMailName"];
	$P_Address_Priv = $row["P_Address_Priv"];
	$P_Street = $row["P_Street"];
	$P_Street2 = $row["P_Street2"];
	$P_City = $row["P_City"];
	$P_State = $row["P_State"];
	$P_PostalCode = $row["P_PostalCode"];
	$P_Phone1_Priv = $row["P_Phone1_Priv"];
	$P_Phone1 = $row["P_Phone1"];
	$P_Phone1Type = $row["P_Phone1Type"];
	$P_Phone23_Priv = $row["P_Phone23_Priv"];
	$P_Phone2 = $row["P_Phone2"];
	$P_Phone2Type = $row["P_Phone2Type"];
	$P_Phone3 = $row["P_Phone3"];
	$P_Phone3Type = $row["P_Phone3Type"];
	$P_BirthDate = $row["P_BirthDate"];
	$P_BirthCity = $row["P_BirthCity"];
	$P_BirthState = $row["P_BirthState"];
	$G1_PeopleID = $row["G1_PeopleID"];
	$G1_LastName = $row["G1_LastName"];
	$G1_FirstName = $row["G1_FirstName"];
	$G1_NickName = $row["G1_NickName"];
	$G1_EMailName_Priv = $row["G1_EMailName_Priv"];
	$G1_EMailName = $row["G1_EMailName"];
	$G1_Address_Priv = $row["G1_Address_Priv"];
	$G1_Street = $row["G1_Street"];
	$G1_Street2 = $row["G1_Street2"];
	$G1_City = $row["G1_City"];
	$G1_State = $row["G1_State"];
	$G1_PostalCode = $row["G1_PostalCode"];
	$G1_Phone1_Priv = $row["G1_Phone1_Priv"];
	$G1_Phone1 = $row["G1_Phone1"];
	$G1_Phone1Type = $row["G1_Phone1Type"];
	$G1_Phone23_Priv = $row["G1_Phone23_Priv"];
	$G1_Phone2 = $row["G1_Phone2"];
	$G1_Phone2Type = $row["G1_Phone2Type"];
	$G1_Phone3 = $row["G1_Phone3"];
	$G1_Phone3Type = $row["G1_Phone3Type"];
	$G1_BirthDate = $row["G1_BirthDate"];
	$G1_BirthCity = $row["G1_BirthCity"];
	$G1_BirthState = $row["G1_BirthState"];
	$G2_PeopleID = $row["G2_PeopleID"];
	$G2_LastName = $row["G2_LastName"];
	$G2_FirstName = $row["G2_FirstName"];
	$G2_NickName = $row["G2_NickName"];
	$G2_EMailName_Priv = $row["G2_EMailName_Priv"];
	$G2_EMailName = $row["G2_EMailName"];
	$G2_Address_Priv = $row["G2_Address_Priv"];
	$G2_Street = $row["G2_Street"];
	$G2_Street2 = $row["G2_Street2"];
	$G2_City = $row["G2_City"];
	$G2_State = $row["G2_State"];
	$G2_PostalCode = $row["G2_PostalCode"];
	$G2_Phone1_Priv = $row["G2_Phone1_Priv"];
	$G2_Phone1 = $row["G2_Phone1"];
	$G2_Phone1Type = $row["G2_Phone1Type"];
	$G2_Phone23_Priv = $row["G2_Phone23_Priv"];
	$G2_Phone2 = $row["G2_Phone2"];
	$G2_Phone2Type = $row["G2_Phone2Type"];
	$G2_Phone3 = $row["G2_Phone3"];
	$G2_Phone3Type = $row["G2_Phone3Type"];
	$G2_BirthDate = $row["G2_BirthDate"];
	$G2_BirthCity = $row["G2_BirthCity"];
	$G2_BirthState = $row["G2_BirthState"];
	$RecordPassword = $row["RecordPassword"];
	$Updated = $row["Updated"];
	$P_Season = $row["Season"];
	$P_Return = $row["Returning"];
	$P_Sister = $row["Sister"];
	$P_Mgr = $row["Mgr"];
	$P_Coach = $row["Coach"];
	$P_Pitcher = $row["Pitcher"];
	$P_Catcher = $row["Catcher"];
	$P_AllStar = $row["AllStar"];
	$P_Experience = $row["Experience"];
	$P_LastLeague = $row["LastLeague"];
	$P_Years = $row["Years"];
	$P_DivisionRequest = $row["DivisionRequest"];
	$P_School = $row["School"];
	$P_Grade = $row["Grade"];
	$P_Shirt = $row["Shirt"];
	$P_Shorts = $row["Shorts"];
	$P_Socks = $row["Socks"];
	$P_SocksExtra = $row["SocksExtra"];
	$P_VisorName = $row["VisorName"];
	$P_TimeStamp = $row["TimeStamp"];
/*	$P_Physician = $row["Physician"];
	$P_PhysicianPhone = $row["PhysicianPhone"];
	$P_MedicalInsurance = $row["MedicalInsurance"];
	$P_MedicalPolicy = $row["MedicalPolicy"];
	$P_LastPhysical = $row["LastPhysical"];
	$P_LastTetanus = $row["LastTetanus"];
	$P_Emergency = $row["Emergency"];
	$P_Relationship = $row["Relationship"];
	$P_EmergDay = $row["EmergDay"];
	$P_EmergEve = $row["EmergEve"];
	$P_EmergCell = $row["EmergCell"];
	$P_Restrictions = $row["Restriction"];*/
/*
	echo "$PeopleID,$P_LastName,$P_FirstName,$P_NickName,$P_EMailName_Priv,$P_EMailName,$P_Address_Priv,$P_Street,$P_Street2,$P_City,$P_State,$P_PostalCode,$P_Phone1_Priv,$P_Phone1,$P_Phone1Type,$P_Phone23_Priv,$P_Phone2,$P_Phone2Type,$P_Phone3,$P_Phone3Type,$P_BirthDate,$P_BirthCity,$P_BirthState,$G1_LastName,$G1_FirstName,$G1_NickName,$G1_EMailName_Priv,$G1_EMailName,$G1_Address_Priv,$G1_Street,$G1_Street2,$G1_City,$G1_State,$G1_PostalCode,$G1_Phone1_Priv,$G1_Phone1,$G1_Phone1Type,$G1_Phone23_Priv,$G1_Phone2,$G1_Phone2Type,$G1_Phone3,$G1_Phone3Type,$G1_BirthDate,$G1_BirthCity,$G1_BirthState,$G2_LastName,$G2_FirstName,$G2_NickName,$G2_EMailName_Priv,$G2_EMailName,$G2_Address_Priv,$G2_Street,$G2_Street2,$G2_City,$G2_State,$G2_PostalCode,$G2_Phone1_Priv,$G2_Phone1,$G2_Phone1Type,$G2_Phone23_Priv,$G2_Phone2,$G2_Phone2Type,$G2_Phone3,$G2_Phone3Type,$G2_BirthDate,$G2_BirthCity,$G2_BirthState,$RecordPassword,$Updated,$P_Season,$P_Return,$P_Sister,$P_SisterName,$P_Mgr,$P_Coach,$P_Pitcher,$P_Catcher,$P_AllStar,$P_Experience,$P_LastLeague,$P_Years $P_DivisionRequest,$P_School,$P_Grade,$P_Shirt,$P_Socks,$P_TimeStamp,$P_Physician,$P_PhysicianPhone,$P_MedicalInsurance,$P_MedicalPolicy,$P_LastPhysical,$P_LastTetanus, $P_Emergency,$P_Relationship,$P_EmergDay,$P_EmergEve,$P_EmergCell,$P_Restrictions<BR>"; */

include ($_SERVER['DOCUMENT_ROOT']."/files/register/RegisterDspConvert.php");


	echo "$PeopleID,$P_PeopleID,$P_LastName,$P_FirstName,$P_NickName,$P_EMailName,$P_Street,$P_Street2,$P_City,$P_State,$P_PostalCode,$P_Phone1Dsp,$P_Phone1Type,$P_Phone2Dsp,$P_Phone2Type,$P_Phone3Dsp,$P_Phone3Type,$P_BirthDate,$P_BirthCity,$P_BirthState,$G1_PeopleID,$G1_LastName,$G1_FirstName,$G1_NickName,$G1_EMailName,$G1_Street,$G1_Street2,$G1_City,$G1_State,$G1_PostalCode,$G1_Phone1Dsp,$G1_Phone1Type,$G1_Phone2Dsp,$G1_Phone2Type,$G1_Phone3Dsp,$G1_Phone3Type,$G2_PeopleID,$G2_LastName,$G2_FirstName,$G2_NickName,$G2_EMailName,$G2_Street,$G2_Street2,$G2_City,$G2_State,$G2_PostalCode,$G2_Phone1Dsp,$G2_Phone1Type,$G2_Phone2Dsp,$G2_Phone2Type,$G2_Phone3Dsp,$G2_Phone3Type,$P_Season,$P_Return,$P_Sister,$P_Mgr,$P_Coach,$P_Pitcher,$P_Catcher,$P_AllStar,$P_Experience,$P_LastLeague,$P_Years,$P_DivisionRequest,$P_School,$P_Grade,$P_TimeStamp\n";

// $P_Shirt,$P_Shorts,$P_Socks,$P_SocksExtra,$P_VisorName,
unset($P_Phone1Dsp);
unset($P_Phone2Dsp);
unset($P_Phone3Dsp);
unset($G1_Phone1Dsp);
unset($G1_Phone2Dsp);
unset($G1_Phone3Dsp);
unset($G2_Phone1Dsp);
unset($G2_Phone2Dsp);
unset($G2_Phone3Dsp);


}

/*	$UpdatedYear = substr("$Updated", 0, 4);
	$UpdatedMonth = substr("$Updated", 4, 2);
	$UpdatedDay = substr("$Updated", 6, 2);
	$UpdatedHour = substr("$Updated", 8, 2);
	$UpdatedMin = substr("$Updated", 10, 2);
	$UpdatedSec = substr("$Updated", 12, 2);
	$UpdatedPeriod = "PM";

	if ($UpdatedHour < "12") {$UpdatedPeriod = "AM";}
	if ($UpdatedHour == "00") {$UpdateHour = "12";}
	if ($UpdatedHour > "12") {$UpdatedHour = $UpdatedHour-"12";}
	$P_TimeStamp = $UpdatedMonth."/".$UpdatedDay."/".$UpdatedYear." at ".$UpdatedHour.":".$UpdatedMin." ".$UpdatedPeriod;

	include ($_SERVER['DOCUMENT_ROOT']."/files/register/RegisterDspConvert.php");
	include ($_SERVER['DOCUMENT_ROOT']."/files/register/RegistrationFormPrint.php");*/
	include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_close.php");
	$Param1 = "Registration Data";
} else {
	echo "You're either not logged on or have insufficient authorization to view this file.";
	$Param1 = "Insufficient Authority";
}
// Begin security table update
if ($Param1 || $Param2) {
	$ActionClass = "Reports";
	$ActionType = "Registration";
	// set param1 and param2 above
	include ($DocRoot."/inc/security.php");
}
// End security table update
?>