Master Schedule
This is the "official" schedule of the BCSA Spring League.
All schedule formats are kept current with all changes.
The full Master Schedule is available with the following formats:
All schedule formats are kept current with all changes.
The full Master Schedule is available with the following formats:
Without having to download the schedule, you can select the schedule view based on the following parameters:
conn();
$club="";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$club=$_POST['club'];
$ageg=$_POST['ageg'];
$div=$_POST['div'];
$teamInfo=$_POST['team'];
if (isset($teamInfo) & strlen($teamInfo)>0 ) {
list($club,$ageg, $div, $team) = explode(".", $teamInfo);
}
} else {
$club=isset($_GET['club']) ? $_GET['club'] : "";
$ageg=isset($_GET['ageg']) ? $_GET['ageg'] : "";
$div=isset($_GET['div']) ? $_GET['div'] : "";
}
echo " ".PHP_EOL; // echo "
".PHP_EOL;
// echo "
".PHP_EOL;
// echo " ".PHP_EOL;
$scriptData = "
";
echo $scriptData.PHP_EOL;
echo " ".PHP_EOL;
echo " ".PHP_EOL;
echo "
".PHP_EOL;
// echo " ".PHP_EOL;
// echo " ".PHP_EOL;
}
}
?>
| Gm# | ".PHP_EOL; echo "Age | ".PHP_EOL; echo "Div | ".PHP_EOL; echo "Date | ".PHP_EOL; echo "Time | ".PHP_EOL; echo "Home Team | ".PHP_EOL; echo "Visiting Team | ".PHP_EOL; echo "Field | ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; if (!isset($club) || $club=="") { if (isset($club) and strlen($club) > 0) { $club = $club; } else { if (!isset($ageg) or strlen($ageg) == 0) { $club = "ALL"; } } } if ((isset($club) and strlen($club) > 0) || (isset($ageg) and strlen($ageg) > 0)) { if ($club == "ALL") { $sqlStmt = "SELECT * FROM ".$scheduleDbTable." "; $sqlOrder = " ORDER BY `Gm#`"; } else { $sqlStmt = "SELECT * FROM ".$scheduleDbTable." WHERE "; if (isset($team) and strlen($team) > 0) { $sqlClub = "(`Home Team`='".$club." ".$team."' OR `Visiting Team`='".$club." ".$team."')"; $sqlAND = " AND "; $sqlOrder = " ORDER BY Date, Time"; } else if (isset($club) and strlen($club) > 0) { $sqlClub = "(`Home Team` LIKE '".$club."%' OR `Visiting Team` LIKE '".$club."%')"; $sqlAND = " AND "; $sqlOrder = " ORDER BY Date, Time"; } else { $sqlClub = ""; $sqlAND = ""; $sqlOrder = " ORDER BY `Div`, Date, Time"; } if (isset($div) and strlen($div) > 0) { $sqlStmt .= $sqlClub.$sqlAND."Age='".$ageg."' AND `Div`=".$div; } else if (isset($ageg) and strlen($ageg) > 0) { $sqlStmt .= $sqlClub.$sqlAND."Age='".$ageg."'"; } else { $sqlStmt .= $sqlClub; } } $sqlStmt .= $sqlOrder; // echo "VML- ",$sqlStmt; //get schedule if ($showSchedule) { $result = $db->query($sqlStmt); if($result && $result->num_rows>0) { while ($rs = $result->fetch_array()) { $dateTime = new DateTimeImmutable($rs['Date'] . " " . $rs['Time']); list($date, $time, $ampm) = explode(" ", $dateTime->format('m/d/Y h:i A')); if (isGameTBA($rs['Date'], $rs['Time'])) { $date = "TBA"; $time = "TBA"; $ampm = ""; } else if (wasGameForfeited($rs['Date'], $rs['Time'])) { $date = "FORFEIT"; $time = "FORFEIT"; $ampm = ""; } echo "
|---|---|---|---|---|---|---|---|
| ".$rs['Gm#']." | ".PHP_EOL; echo "".$rs['Age']." | ".PHP_EOL; echo "".$rs['Div']." | ".PHP_EOL; echo "".$date." | ".PHP_EOL; echo "".$time." ".$ampm." | ".PHP_EOL; echo "".$rs['Home Team']." | ".PHP_EOL; echo "".$rs['Visiting Team']." | ".PHP_EOL; echo "".$rs['Field']." | ".PHP_EOL; echo "