\n";
$date_unix -= 259200;
$date_unix_check = mktime(0,0,0,date(4), date(4), date(2005));
if ($date_unix < $date_unix_check)
{
$sql_type = "spring05";
$sssql = "ss, notes,";
$sql_seriesid = "";
}
else
{
$sql_type = "regular05";
$sssql = "";
$sql_seriesid = "seriesid,";
}
$year_sql = date('Y', $date_unix);
$month_sql = date('m', $date_unix);
$day_sql = date('d', $date_unix);
$day_week = date('D', $date_unix);
$day_month = date('j', $date_unix);
$month = date('n', $date_unix);
$date_sql = $year_sql . "-" . $month_sql . "-" . $day_sql;
for ($i = 1; $i <= 7; $i++)
{
$line2 = "";
$sql = "SELECT id, $sql_seriesid DATE_FORMAT(date, '%a') AS date_day, DATE_FORMAT(date, '%c/%e') AS date_date, DATE_FORMAT(date, '%l:%i %p') AS time, opponent, $sssql location, tv, radio, innings, det_runs, opp_runs FROM $sql_type WHERE date LIKE '$date_sql%' LIMIT 0,2";
$result = mysql_query($sql) or die("Technical difficulties, please stand by!");
$row = mysql_fetch_array($result);
if ($row["id"] == 0)
{
$seven_day .= "| \n";
$seven_day .= " | " . $day_week . "
" . $month . "/" . $day_month . " | ";
$seven_day .= " ![](\"img/teams/7sched/blank.gif\") | ";
$seven_day .= " | ";
$seven_day .= "\n";
}
else
{
while ($row["id"] != 0)
{
$line2 = "";
$line3 = "";
$id = $row["id"];
$seriesid = $row["seriesid"];
$date_day = $row["date_day"];
$date_date = $row["date_date"];
$time = $row["time"];
$opponent = $row["opponent"];
$ss = $row["ss"];
$location = $row["location"];
$tv= $row["tv"];
$radio = $row["radio"];
$innings = $row["innings"];
$det_runs = $row["det_runs"];
$opp_runs = $row["opp_runs"];
$notes = $row["notes"];
$opp_sql = "SELECT city2, stadium, st_city, st_state FROM teams WHERE abbr = '$opponent'";
$opp_result = mysql_query($opp_sql);
$opp_row = mysql_fetch_array($opp_result);
$team = $opp_row["city2"];
$stadium = $opp_row["stadium"];
$st_city = $opp_row["st_city"];
$st_state = $opp_row["st_state"];
if ($location == "H")
{
$loc_type = "_home";
$loc_type2 = "";
$img_type = "-h";
}
else
{
$loc_type = "_away";
$loc_type2 = "@ ";
$img_type = "-a";
}
if ($opponent == "AS")
$loc_type = "_as";
if ($opponent == "BOS" && $month == "5" && $day_month == "23" && $location == "N")
{
$loc_type = "_hof";
$loc_type2 = "";
$img_type = "-a";
}
if ($ss == "Y")
$ss_type = " (SS)";
else
$ss_type = "";
if ($innings == 0)
{
if ($sql_type == "spring05")
$line2 .= "Cancelled";
else
$line2 .= "Postponed";
}
else if ($det_runs == NULL)
{
if ($radio && !$seriesid)
$radio = " - " . $radio;
else
$radio = "";
if ($tv)
$tv = " - " . $tv;
else
$tv = "";
$line2 .= $time . $tv . $radio;
}
else
{
if ($det_runs > $opp_runs)
$line2 .= "W, " . $det_runs . "-" . $opp_runs;
else if ($opp_runs > $det_runs)
$line2 .= "L, " . $opp_runs . "-" . $det_runs;
else
$line2 .= "T, " . $det_runs . "-" . $opp_runs;
if ($innings != 9)
$line2 .= " (" . $innings . ")";
}
if (!$seriesid)
{
if ($opponent == "PHI" && $month == "4" && $day_month == "2")
$line3 = "
Philadelphia, PA";
else if ($opponent == "BOS" && $month == "5" && $day_month == "23" && $location == "N")
$line3 = "
Cooperstown, NY";
else if ($location == 'H')
$line3 = "
Lakeland, FL";
else
$line3 = "
" . $st_city . ", " . $st_state;
}
else if ($location == 'H')
$line3 = "
Comerica Park";
else
$line3 = "
" . $stadium;
$seven_day_image = "![\""](\"img/teams/7sched/")
";
$seven_day .= "\n";
$seven_day .= " " . $day_week . "
" . $month . "/" . $day_month . " | ";
$seven_day .= " " . $seven_day_image . " | ";
$seven_day .= " " . $loc_type2 . $team . $ss_type . "
" . $line2 . $line3 . " | ";
$seven_day .= "
\n";
$row = mysql_fetch_array($result);
}
}
$date_unix += 86400;
$date_unix_check = mktime(0,0,0,date(4), date(4), date(2005));
if ($date_unix < $date_unix_check)
{
$sql_type = "spring05";
$sssql = "ss,";
$sql_seriesid = "";
}
else
{
$sql_type = "regular05";
$sssql = "";
$sql_seriesid = "seriesid,";
}
$year_sql = date('Y', $date_unix);
$month_sql = date('m', $date_unix);
$day_sql = date('d', $date_unix);
$day_week = date('D', $date_unix);
$day_month = date('j', $date_unix);
$month = date('n', $date_unix);
$date_sql = $year_sql . "-" . $month_sql . "-" . $day_sql;
}
$seven_day .= "
\n";
//////////////////// Seven Day Scoreboard Code ///////////////////
//////////////////// Prospects List ///////////////////
$counter = 0;
mysql_select_db("tigers_players",$db);
$sql = "SELECT * FROM topprospects ORDER BY rank";
$result = mysql_query($sql) or die("Technical difficulties, please stand by!");
while($row = mysql_fetch_array($result))
{
$counter++;
$rank = $row["rank"];
$trend = $row["trend"];
$name = $row["name"];
$pnum = $row["pnum"];
$team = $row["team"];
$blurb = $row["blurb"];
$prospects_list .= "\n";
$prospects_list .= "| " . $counter . " | \n";
$prospects_list .= "";
if ($trend == "UP")
$prospects_list .="![\"Up\"](\"img/arrow-up.gif\") ";
else if ($trend == "DN")
$prospects_list .="![\"Down\"](\"img/arrow-down.gif\") ";
else
$prospects_list .="![\"No](\"img/arrow-nochange.gif\") ";
$prospects_list .= " | \n";
$prospects_list .= "" . $name . " | \n";
$prospects_list .= "";
if ($team == "DET")
$prospects_list .= "Detroit (MLB)";
else if ($team == "TOL")
$prospects_list .= "Toledo (AAA)";
else if ($team == "ERE")
$prospects_list .= "Erie (AA)";
else if ($team == "LAK")
$prospects_list .= "Lakeland (A+)";
else if ($team == "WMI")
$prospects_list .= "W.Michigan (A)";
else if ($team == "ONE")
$prospects_list .= "Oneonta (A-)";
else if ($team == "GCL")
$prospects_list .= "GCL Tigers (R)";
else
$prospects_list .= "DSL Tigers (R)";
$prospects_list .= " | \n";
$prospects_list .= "
\n";
$prospects_list .= "![](\"img/topline/t_det.gif\")
";
$away_r = $det_runs;
$away_h = $det_hits;
$away_e = $det_errors;
$home_prob1 = strtoupper($opponent);
$home_prob2 = $opp_probable;
$away_prob1 = "DET";
$away_prob2 = $det_probable;
}
$date_full = "![](\"img/topline/f.gif\")
";
$ticker_counter = (int) 0;
$ticker_array = "messages[" . $ticker_counter . "]=\"Winning Pitcher: " . $wp . "\"\n";
$ticker_counter++;
$ticker_array .= "messages[" . $ticker_counter . "]=\"Losing Pitcher: " . $lp . "\"\n";
$ticker_counter++;
if ($save)
{
$ticker_array .= "messages[" . $ticker_counter . "]=\"Save: " . $save . "\"\n";
$ticker_counter++;
}
if ($pog == "TBA")
{
$ticker_array .= "messages[" . $ticker_counter . "]=\"Player of the Game: " . $pog . "\"\n";
$ticker_counter++;
}
else
{
$ticker_array .= "messages[" . $ticker_counter . "]=\"Player of the Game:\"\n";
$ticker_counter++;
$ticker_array .= "messages[" . $ticker_counter . "]=\"" . $pog . "\"\n";
$ticker_counter++;
}
$ticker_array .= "messages[" . $ticker_counter . "]=\" \"\n";
}
else
{
$home_r = "![](\"img/topline/r_blank.gif\"){kind=spacer}
";
$home_h = "![](\"img/topline/he_blank.gif\"){kind=spacer}
";
$home_e = "![](\"img/topline/f_ppd.gif\")
";
$scroller_delay = 1000000;
$ticker_array = "messages[0]=\"" . $notes . "\"\n";
}
if ($dh == "Y" || $ss == "Y")
{
}
//////////////////// Seven Day Scoreboard Code ///////////////////
$date_unix = mktime(0,0,0,date('m'), date('d'), date('Y'));
$date_unix += 3600;
$seven_day .= "
June 2007 
2006
AL
