base = new hockey_base(); if (!$this->base->isMobile) $this->visual = new visual_desktop($this->base); else $this->visual = new visual_mobile($this->base); $this->process(); if ($this->teaminfo) $this->base->title .= " - ".$this->teaminfo->teamname; $this->visual->Header($this->base->user->logged_in); $this->base->sportBar(); $this->content(); $this->visual->Footer(); } function process() { $sql_teaminfo = "SELECT * FROM teams WHERE teamurl = '".$_GET['team']."' AND sport = 4"; $result_teaminfo = DB::cxn()->query($sql_teaminfo); $this->teaminfo = $result_teaminfo->fetch_object(); } function content() { if ($this->teaminfo) { $q_stadium = "SELECT id, name, stadiumurl FROM stadiums WHERE id = ".$this->teaminfo->stadium; $r_stadium = DB::cxn()->query($q_stadium); $stadiuminfo = $r_stadium->fetch_object(); ?>
".$this->teaminfo->teamname.""; ?>
name; ?>
teaminfo->id."' AND showinlist = 0"; $result_links = mysql_query($sql_links); while ($row = mysql_fetch_assoc($result_links)) { $teamlinks[$row['linktype']] = $row['siteurl']; } if ($teamlinks['official']) echo "Official Site
"; ?>
style="width:600px;"> teaminfo->id." AND schedule.awayteam = teams.id) OR (schedule.hometeam != ".$this->teaminfo->id." AND schedule.hometeam = teams.id) WHERE schedule.season = ".$GLOBALS['hockey_season']." AND (schedule.awayteam = ".$this->teaminfo->id." OR schedule.hometeam = ".$this->teaminfo->id.") ORDER BY schedule.gamedate"; $result_schedule = mysql_query($sql_schedule); ?>
Scores/Schedule
GameDateOpponentScore/
Time
teaminfo->id == $row_schedule['awayteam']) echo "@ "; echo "".$row_schedule['teamcity'].""; ?> Scores/Schedule $row_schedule['homescore']) { $winnerscore = $row_schedule['awayscore']; $loserscore = $row_schedule['homescore']; } else { $winnerscore = $row_schedule['homescore']; $loserscore = $row_schedule['awayscore']; } if ($row_schedule['winner'] == $this->teaminfo->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 ""; } ?>
visual->showAd_336x280(); ?>