Game Schedules
Season*
Division*
Category*
Competition*
Group
-- Select Season--
";?>
-- Select Divisions --
"; ?>
-- Select Category--
"; ?>
-- Select Competition--
"; ?>
-- All Groups --
"; ?>
Team
Sort Sequence*
-- All Teams --
0){ $sql = "SELECT DISTINCT teams.teamid , teams.name , gameschedule.divisionid FROM teams INNER JOIN gameschedule ON teams.teamid = gameschedule.homeid WHERE gameschedule.divisionid = $ledivision AND gameschedule.groupid = $letier AND gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason ORDER BY teams.name;"; } else { $sql = "SELECT DISTINCT teams.teamid , teams.name , gameschedule.divisionid FROM teams INNER JOIN gameschedule ON teams.teamid = gameschedule.homeid WHERE gameschedule.divisionid = $ledivision AND gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason ORDER BY teams.name;"; } if($sqlcn){ $sqlresult = mysqli_query($sqlcn, $sql); if(($sqlresult == true)&&(mysqli_num_rows($sqlresult) != 0)){ while($sqlrow = mysqli_fetch_array($sqlresult)){ if(array_search($sqlrow["teamid"], $recordsadded) === false){ $recordsadded[] = $sqlrow["teamid"]; $records[$x]["theid"] = $sqlrow["teamid"]; $records[$x]["thename"] = $sqlrow["name"]; $records[$x]["thedivision"] = $sqlrow["divisionid"]; $x++; }// }// @mysqli_free_result($sqlresult); } }// //NEXT if($letier > 0){ $sql = "SELECT DISTINCT teams.teamid , teams.name , gameschedule.divisionid FROM teams INNER JOIN gameschedule ON teams.teamid = gameschedule.visitorid WHERE gameschedule.divisionid = $ledivision AND gameschedule.groupid = $letier AND gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason ORDER BY teams.name;"; } else { $sql = "SELECT DISTINCT teams.teamid , teams.name , gameschedule.divisionid FROM teams INNER JOIN gameschedule ON teams.teamid = gameschedule.visitorid WHERE gameschedule.divisionid = $ledivision AND gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason ORDER BY teams.name;"; } if($sqlcn){ $sqlresult = mysqli_query($sqlcn, $sql); if(($sqlresult == true)&&(mysqli_num_rows($sqlresult) != 0)){ while($sqlrow = mysqli_fetch_array($sqlresult)){ if(array_search($sqlrow["teamid"], $recordsadded) === false){ $recordsadded[] = $sqlrow["teamid"]; $records[$x]["theid"] = $sqlrow["teamid"]; $records[$x]["thename"] = $sqlrow["name"]; $records[$x]["thedivision"] = $sqlrow["divisionid"]; $x++; }// }// @mysqli_free_result($sqlresult); } }// //SORT if(count($records) > 0){ foreach($records as $key => $row){ $theid[$key] = $row['theid']; $thename[$key] = $row['thename']; $thedivision[$key] = $row['thedivision']; }// array_multisort($thename, SORT_ASC, $records); }//COUNT RECORDS for($y = 0; $y < count($records); $y++){ if(intval($leteam) == $records[$y][$callteam]){ ?>
"; ?>
>In Date/Time and then Game ID Order
>In Game ID Order
"; $sql = "SELECT gameschedule.gameid , gameschedule.groupid , gameschedule.series , gameschedule.homeid , gameschedule.visitorid , gameschedule.date , gameschedule.location , gameschedule.starttime , gameschedule.endtime , gameschedule.status , gameschedule.comments FROM gameschedule WHERE gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason AND gameschedule.divisionid = $ledivision AND gameschedule.groupid = $letier AND (gameschedule.homeid = $leteam OR gameschedule.visitorid = $leteam) $orderBy"; } else if (($leteam == -1)&&($letier != -1)){ //print "2
"; $sql = "SELECT gameschedule.gameid , gameschedule.groupid , gameschedule.series , gameschedule.homeid , gameschedule.visitorid , gameschedule.date , gameschedule.location , gameschedule.starttime , gameschedule.endtime , gameschedule.status , gameschedule.comments FROM gameschedule WHERE gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason AND gameschedule.divisionid = $ledivision AND gameschedule.groupid = $letier $orderBy"; } else if (($leteam != -1)&&($letier == -1)){ //print "3
"; $sql = "SELECT gameschedule.gameid , gameschedule.groupid , gameschedule.series , gameschedule.homeid , gameschedule.visitorid , gameschedule.date , gameschedule.location , gameschedule.starttime , gameschedule.endtime , gameschedule.status , gameschedule.comments FROM gameschedule WHERE gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason AND gameschedule.divisionid = $ledivision AND (gameschedule.homeid = $leteam OR gameschedule.visitorid = $leteam) $orderBy"; } else { //print "4
"; $sql = "SELECT gameschedule.gameid , gameschedule.groupid , gameschedule.series , gameschedule.homeid , gameschedule.visitorid , gameschedule.date , gameschedule.location , gameschedule.starttime , gameschedule.endtime , gameschedule.status , gameschedule.comments FROM gameschedule WHERE gameschedule.categoryid = $lecategory AND gameschedule.competitionid = $lecompetition AND gameschedule.seasonid = $leseason AND gameschedule.divisionid = $ledivision $orderBy"; }//end if //print "$sql
"; if($sqlcn){ $sqlresult = mysqli_query($sqlcn, $sql); if(($sqlresult == true)&&(mysqli_num_rows($sqlresult) != 0)){ $hasrecords = true; $zo = 0; }// }// ?>
There Are No Games Scheduled for this Filtered Selection
Date & Time Subject To Change Without Notice. Please Confirm With Your Team Manager.
Season:
Division:
Group:
Competition:
Category:
Date:
Game ID
Group
Home
Visitor
Date
Location
Start Time
End Time
Status
Remarks
'') && ($sqlrow[series] != $previousSeries) && ($letier != -1)&& ($leteam == -1)){ ?>
"; } else { print ">"; } print (getTeamName($sqlrow["homeid"])); print "\n"; ?>
"; } else { print ">"; } print (getTeamName($sqlrow["visitorid"])); print "\n"; ?>
