$dbh=mysql_connect ("localhost", "cityhrug_cmsusr", "}0omnlET@Ut;") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("cityhrug_ctCMSv1"); ?> include_once('/home/cityhrug/public_html/controllers/page-view_controller.php'); require_once('/home/cityhrug/admin_html/controllers/ctCMS_teams_controller.php'); function is_game_home($id){ $check_home_sql = "select * FROM `ctCMS_Teams_schedule` where `ID` ='$id'"; $check_home_q = mysql_query($check_home_sql); $check_home_info = mysql_fetch_assoc($check_home_q); if($check_home_info['home_away'] == "Y"){ return true; } return false; } $id = $_REQUEST['game_id']; $sport_info_sql = "select * from `ctCMS_Teams_sports` where name = 'Rugby'"; $sport_info_q = mysql_query($sport_info_sql)or die(mysql_error()); $sport_info = mysql_fetch_assoc($sport_info_q); $ot_count =0; $home = get_team_info($_REQUEST['team_id']); $game_info =get_game_info($id); $team_sql = "select * from ctCMS_Teams_teams where team_id = '".addslashes($game_info['h_team_id'])."' LIMIT 1"; $team_q = mysql_query($team_sql)or die(mysql_error()); $team_row = mysql_fetch_assoc($team_q); $away = get_team_info($game_info['a_team_id']); $ot_sql = "select * from `ctCMS_Teams_scores` where `game_id` = '".$id."' AND `period` regexp 'OT' AND removed='n' "; $ot_q = mysql_query($ot_sql) or die(mysql_error()); //print_r($game_info); ?>
-> ->
/*Here is another line of text in this article. Three more appear below. Read the full story
*/ ?>Location:
Map
if($game_info['Location'] == "Delaware Park - Main"){?>
View Larger Map
} ?>
if($game_info['Location'] == "Delaware Park - Rumsey"){?>
View Larger Map
} ?>
if(preg_match("/Johnn/i",$game_info['Location'])){ ?>
View Larger Map
} ?>