| |
| BOSL Tournament 2019 |
Little League baseball is a very
good thing because it keeps
the parents off the streets.
~ Yogi Berra
|
|

   
Please support our
SPONSORS
Please support our
ADVERTISERS


|
BOSL – Mike Silva Memorial Year-End Tournament: September 6 to 8, 2019
Schedule | Round 1 Pods | Round 2 Pods | Rules/Tie-Breakers | ODDS/Our Picks
error_reporting (E_ALL);
/*
$host = "localhost";
$dbname = "traiecqa_bosl";
$dbpass = "bosl2020";
$database = "traiecqa_bosl";
*/
$host = "mariadb-041.wc1.lan3.stabletransit.com:3306";
$dbname = "513181_JGerrity";
$dbpass = "J8b$2o3$";
$database = "513181_gerrity";
//Connect to the database
$link = mysqli_connect("$host","$dbname","$dbpass");
if (!$link)
{
echo 'looks like the leaderboards are updating hold tight';
exit();
}
else
{
mysqli_select_db($link, $database) or die(mysqli_error($link));
}
/* Generate the standings */
echo "";
echo " ";
echo " ";
echo " ";
echo "Seed";
echo " ";
echo " ";
echo "Team";
echo " ";
echo " ";
echo "W/L/T";
echo " ";
echo " ";
echo "+/-";
echo " ";
$in = mysqli_query($link, "SELECT * FROM `bosl_year_end_2019` WHERE `round` = '2' AND `pod` = 'A' ORDER BY `seed`")or die( mysqli_error($link));
while($inf = mysqli_fetch_array($in)){
$team_ac = $inf['team_ac'];
$score = $inf['score'];
$wins = $inf['wins'];
$loss = $inf['loss'];
$ties = $inf['ties'];
$round = $inf['round'];
$seed = $inf['seed'];
$pod = $inf['pod'];
echo " ";
echo "$pod$seed";
echo " ";
echo " ";
echo "$team_ac";
echo " ";
echo " ";
echo "$wins/$loss/$ties";
echo " ";
echo " ";
echo "$score";
echo " ";
}
echo " ";
echo " ";
echo " ";
echo " ";
echo " ";
echo "Seed";
echo " ";
echo " ";
echo "Team";
echo " ";
echo " ";
echo "W/L/T";
echo " ";
echo " ";
echo "+/-";
echo " ";
$in = mysqli_query($link, "SELECT * FROM `bosl_year_end_2019` WHERE `round` = '2' AND `pod` = 'B' ORDER BY `seed`")or die( mysqli_error($link));
while($inf = mysqli_fetch_array($in)){
$team_ac = $inf['team_ac'];
$score = $inf['score'];
$wins = $inf['wins'];
$loss = $inf['loss'];
$ties = $inf['ties'];
$round = $inf['round'];
$seed = $inf['seed'];
$pod = $inf['pod'];
echo " ";
echo "$pod$seed";
echo " ";
echo " ";
echo "$team_ac";
echo " ";
echo " ";
echo "$wins/$loss/$ties";
echo " ";
echo " ";
echo "$score";
echo " ";
}
echo " ";
echo " ";
echo " ";
echo " ";
echo " ";
echo "Seed";
echo " ";
echo " ";
echo "Team";
echo " ";
echo " ";
echo "W/L/T";
echo " ";
echo " ";
echo "+/-";
echo " ";
$in = mysqli_query($link, "SELECT * FROM `bosl_year_end_2019` WHERE `round` = '2' AND `pod` = 'C' ORDER BY `seed`")or die( mysqli_error($link));
while($inf = mysqli_fetch_array($in)){
$team_ac = $inf['team_ac'];
$score = $inf['score'];
$wins = $inf['wins'];
$loss = $inf['loss'];
$ties = $inf['ties'];
$round = $inf['round'];
$seed = $inf['seed'];
$pod = $inf['pod'];
echo " ";
echo "$pod$seed";
echo " ";
echo " ";
echo "$team_ac";
echo " ";
echo " ";
echo "$wins/$loss/$ties";
echo " ";
echo " ";
echo "$score";
echo " ";
}
echo " ";
echo " ";
echo " ";
echo " ";
echo " ";
echo "Seed";
echo " ";
echo " ";
echo "Team";
echo " ";
echo " ";
echo "W/L/T";
echo " ";
echo " ";
echo "+/-";
echo " ";
$in = mysqli_query($link, "SELECT * FROM `bosl_year_end_2019` WHERE `round` = '2' AND `pod` = 'D' ORDER BY `seed`")or die( mysqli_error($link));
while($inf = mysqli_fetch_array($in)){
$team_ac = $inf['team_ac'];
$score = $inf['score'];
$wins = $inf['wins'];
$loss = $inf['loss'];
$ties = $inf['ties'];
$round = $inf['round'];
$seed = $inf['seed'];
$pod = $inf['pod'];
echo " ";
echo "$pod$seed";
echo " ";
echo " ";
echo "$team_ac";
echo " ";
echo " ";
echo "$wins/$loss/$ties";
echo " ";
echo " ";
echo "$score";
echo " ";
}
echo " ";
echo " ";
echo " ";
echo "";
echo " Game Time Diamond Teams PODS Status ";
/* Generate the schedule */
$i = 8;
$in = mysqli_query($link, "SELECT * FROM `bosl_year_end_schedule_2019` ORDER BY `game_id`")or die( mysqli_error($link));
while($inf = mysqli_fetch_array($in)){
$team_1 = $inf['team_1'];
$team_2 = $inf['team_2'];
$score_1 = $inf['score_1'];
$score_2 = $inf['score_2'];
$game_d = $inf['game_date'];
$game_t = $inf['game_time'];
$diamond = $inf['diamond'];
$status = $inf['status'];
$pod = $inf['pod'];
$game_id = $inf['game_id'];
if($game_id >= 25){
echo ($i % 2)?" ":" ";
echo " $game_d $game_t Sherwood $diamond $team_1 ($score_1) vs $team_2 ($score_2) POD $pod $status ";
echo " ";
$i++;
}
}
?>
|
|
|