base = new top();
if (!$this->base->isMobile) $this->visual = new visual_desktop($this->base);
else $this->visual = new visual_mobile($this->base);
$this->base->title .= " - Stadiography";
$this->visual->Header($this->base->user->logged_in);
$this->content();
$this->visual->Footer();
}
function content()
{
$q = "SELECT * FROM stadiums WHERE stadiumurl = '".addslashes(strtolower($_GET['stadiumshort']))."'";
$r = DB::cxn()->query($q);
if ($r->num_rows)
{
$this->stadiuminfo = $r->fetch_object();
}
if ($this->stadiuminfo)
{
$q_details = "SELECT * FROM stadium_details WHERE stadiumid = ".$this->stadiuminfo->id;
$r_details = DB::cxn()->query($q_details);
while ($row_detail = $r_details->fetch_object())
{
$this->details[$row_detail->keyname] = $row_detail->keyvalue;
}
$q_teams = "SELECT id, teamcity, teamname, teamurl, sport, stadium FROM teams WHERE stadium = ".$this->stadiuminfo->id." ORDER BY sport, teamname";
$r_teams = DB::cxn()->query($q_teams);
$this->teams = array();
while ($row_team = $r_teams->fetch_object())
{
$this->teams[] = $row_team;
}
}
?>
stadiuminfo)
{
?>
bold font24" style="margin-bottom:2px;">stadiuminfo->name; ?>
center" style="margin-bottom:10px;">
details['opened']) { ?>Opened: details['opened']; ?>
details['url']) { ?>
Visit Web Site
center" style="margin-bottom:10px;">
details['url']) { ?>', $this->details['address']); ?>
View on Google Maps
stadiuminfo)
{
?>
teams))
{
foreach ($this->teams as $team)
{
if ($team->sport == 1) $this->schedule_baseball($team);
else if ($team->sport == 2) $this->schedule_football($team);
else if ($team->sport == 3) $this->schedule_basketball($team);
else if ($team->sport == 4) $this->schedule_hockey($team);
}
}
?>
teamname; ?>
No Games Scheduled
teamname; ?>
id." AND schedule.awayteam = teams.id) OR (schedule.hometeam != ".$inTeam->id." AND schedule.hometeam = teams.id) WHERE schedule.season = ".$GLOBALS['football_season']." AND (schedule.awayteam = ".$inTeam->id." OR schedule.hometeam = ".$inTeam->id.") ORDER BY schedule.week";
$r_schedule = DB::cxn()->query($q_schedule);
?>
| Week | Opponent | Score/
Date/Time |
|---|
fetch_object())
{
if ($i + 1 != $row_schedule->week) {
echo "| ".($i + 1)." | Bye |
";
$i++;
}
?>
| week; ?> |
id == $row_schedule->awayteam) echo "@ ";
echo "teamurl."/\" class=\"nodecoration\">".$row_schedule->teamname."";
?>
|
winner) == 0) echo date("D n/j", strtotime($row_schedule->gamedate))." ".date("g:ia", strtotime($row_schedule->gametime));
else {
if ($row_schedule->awayscore > $row_schedule->homescore) {
$winnerscore = $row_schedule->awayscore;
$loserscore = $row_schedule->homescore;
}
else {
$winnerscore = $row_schedule->homescore;
$loserscore = $row_schedule->awayscore;
}
if ($row_schedule->winner == $inTeam->id) echo "W ".$winnerscore."-".$loserscore;
else if ($row_schedule->winner > 0) echo "L ".$loserscore."-".$winnerscore;
else if ($row_schedule->winner == 0) echo "T ".$loserscore."-".$winnerscore;
echo "";
}
?>
|
teamname; ?>
id." AND schedule.awayteam = teams.id) OR (schedule.hometeam != ".$inTeam->id." AND schedule.hometeam = teams.id) WHERE schedule.season = ".$GLOBALS['basketball_season']." AND (schedule.awayteam = ".$inTeam->id." OR schedule.hometeam = ".$inTeam->id.") AND schedule.gamedate >= '".date("Y-m-d")."' ORDER BY schedule.gamedate LIMIT 0, 10";
$r_schedule = DB::cxn()->query($q_schedule);
?>
| Date | Opponent | Score/
Time |
|---|
fetch_object())
{
?>
| gamedate)); ?> |
id == $row_schedule->awayteam) echo "@ ";
echo "teamurl."/\" class=\"nodecoration\">".$row_schedule->teamname."";
?>
|
winner) == 0) echo date("g:ia", strtotime($row_schedule->gametime));
else {
if ($row_schedule->awayscore > $row_schedule->homescore) {
$winnerscore = $row_schedule->awayscore;
$loserscore = $row_schedule->homescore;
}
else {
$winnerscore = $row_schedule->homescore;
$loserscore = $row_schedule->awayscore;
}
if ($row_schedule->winner == $inTeam->id) echo "W ".$winnerscore."-".$loserscore;
else if ($row_schedule->winner > 0) echo "L ".$loserscore."-".$winnerscore;
else if ($row_schedule->winner == 0) echo "T ".$loserscore."-".$winnerscore;
echo "";
}
?>
|
teamname; ?>
id." AND schedule.awayteam = teams.id) OR (schedule.hometeam != ".$inTeam->id." AND schedule.hometeam = teams.id) WHERE schedule.season = ".$GLOBALS['hockey_season']." AND (schedule.awayteam = ".$inTeam->id." OR schedule.hometeam = ".$inTeam->id.") AND schedule.gamedate >= '".date("Y-m-d")."' ORDER BY schedule.gamedate LIMIT 0, 10";
$r_schedule = DB::cxn()->query($q_schedule);
?>
| Date | Opponent | Score/
Time |
|---|
fetch_object())
{
?>
| gamedate)); ?> |
id == $row_schedule->awayteam) echo "@ ";
echo "teamurl."/\" class=\"nodecoration\">".$row_schedule->teamname."";
?>
|
winner) == 0) echo date("g:ia", strtotime($row_schedule->gametime));
else {
if ($row_schedule->awayscore > $row_schedule->homescore) {
$winnerscore = $row_schedule->awayscore;
$loserscore = $row_schedule->homescore;
}
else {
$winnerscore = $row_schedule->homescore;
$loserscore = $row_schedule->awayscore;
}
if ($row_schedule->winner == $inTeam->id) echo "W ".$winnerscore."-".$loserscore;
else if ($row_schedule->winner > 0) echo "L ".$loserscore."-".$winnerscore;
else if ($row_schedule->winner == 0) echo "T ".$loserscore."-".$winnerscore;
if ($row_schedule->ot) echo " OT";
echo "";
}
?>
|