= $AuthLevel_BoardBottom) {
include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_connect.php");
$Teams = $TeamYear."R_";
$sql = "SELECT People.*, Positions.*, Groups.*
FROM People, Positions, Groups
WHERE People.PeopleID = Positions.PeopleID and Positions.GroupID = Groups.GroupID and
Positions.GroupID LIKE '$Teams' and Positions.PositionID = '43'
ORDER BY People.BirthDate ASC, People.LastName ASC, People.FirstName ASC";
include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_execute.php");
echo "- CGFP $TeamYear Players ASA Division/Playing Age -
";
$numrows = mysql_num_rows($sql_result);
echo $numrows." total players found
";
// Start results formatting
$TableStart = "";
$RowStart = "| ";
$RowEnd = " |
";
$Delim = "";
// echo "$numrows total position responses $Eol";
echo $TableStart;
echo $RowStart."PeopleID".$Delim."First Name".$Delim."Nick Name".$Delim."Last Name".$Delim."Telephone".$Delim."Birth Date".$Delim."ASA Div".$Delim."CGFP Div".$Delim."Div Status".$Delim."Team Letter".$Delim."Team Name".$RowEnd;
// Format results by row
while ($row = mysql_fetch_array($sql_result)) {
$RegistrationID = $row["RegistrationID"];
$PeopleID = $row["PeopleID"];
$FirstName = $row["FirstName"];
$NickName = $row["NickName"];
$LastName = $row["LastName"];
$Phone1 = $row["Phone1"];
unset($Phone1AC);
unset($Phone1Prefix);
unset($Phone1Suffix);
unset($Phone1Ext);
unset($Phone1Dsp);
$Phone1AC = substr("$Phone1", 0, 3);
$Phone1Prefix = substr("$Phone1", 3, 3);
$Phone1Suffix = substr("$Phone1", 6, 4);
$Phone1Ext = substr("$Phone1", 10, 10);
if ($Phone1) {
$Phone1Dsp .= $Phone1AC."-".$Phone1Prefix."-".$Phone1Suffix;
if ($Phone1Ext) {$Phone1Dsp .= " x-".$Phone1Ext;}
}
$BirthDate = $row["BirthDate"];
$GroupDivAge = $row["GroupDivAge"];
$GroupChar = $row["GroupChar"];
$GroupName = $row["GroupName"];
$BirthDate = $row["BirthDate"];
$BirthDate = explode("-", "$BirthDate");
$BirthYear = $BirthDate[0];
$BirthMonth = $BirthDate[1];
$BirthDay = $BirthDate[2];
if ($BirthYear > "0000") {
$BirthDsp = $BirthMonth."/".$BirthDay."/".$BirthYear;
}
##### ASA Division Calculations ####################################
$Age = ($TeamYear-1)-$BirthYear;
if (($Age < "3") || ($Age > "18")) {
$AsaDivision = "Ineligible Age";
} ELSE {
$PlayerBirthDate = $BirthYear."-".$BirthMonth."-".$BirthDay;
if ($Age > "18") {$AsaDivision = "Too Old";}
if ($Age < "19") {$AsaDivision = "18UA";}
if ($Age < "17") {$AsaDivision = "16UA";}
if ($Age < "15") {$AsaDivision = "14UA";}
if ($Age < "13") {$AsaDivision = "12UA";}
if ($Age < "11") {$AsaDivision = "10UA";}
if ($Age < "9") {$AsaDivision = "08UA";}
if ($Age < "7") {$AsaDivision = "06UA";}
if ($Age < "4") {$AsaDivision = "Too Young";}
}
if ($AsaDivision == $GroupDivAge) {
$DivStatus = "";
} elseif ($AsaDivision < $GroupDivAge) {
$DivStatus = "Up";
} else {
$DivStatus = "Down";
}
$PeopleID = "".$PeopleID."";
echo $RowStart.$PeopleID.$Delim.$FirstName.$Delim.$NickName.$Delim.$LastName.$Delim.$Phone1Dsp.$Delim.$BirthDsp.$Delim.$AsaDivision.$Delim.$GroupDivAge.$Delim.$DivStatus.$Delim.$GroupChar.$Delim.$GroupName.$RowEnd;
}
echo $TableEnd;
include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_close.php");
} ELSE {
echo "Only Board of Directors and above may view this file.";
}
?>
|