$eventIntroText = $table_row[3];
$eventText = $table_row[4];
$eventImagePathname = $table_row[5];
}
if ($num_rows < 1) {
header('HTTP/1.1 301 Moved Permanently');
header('Location: http://www.mongotickets.com/');
exit;
}
$keywords = BuildEventKeywordList($categoryID, $eventName, $eventTypeID, $id);
$keywords = AmpersandToAnd($keywords);
$smarty->assign("SeoKeywords", $keywords);
$descr = "Buy {$eventName} Tickets at great prices. Discount {$eventName} tickets.";
$url = make_event_url($eventName, $id);
$breadcrumb_str = Breadcrumbs($categoryID, 0);
$breadcrumb_str = AppendBreadcrumb($breadcrumb_str, "{$url}", $eventName);
# if category is theater, list venues first.
$disp_home_away = 0;
if ($eventTypeID == 4) {
$title = "{$eventName} Tickets, {$eventName} Schedule, {$eventName} Dates, Discounted {$eventName} Tickets";
$smarty->assign("title", $title);
$smarty->assign("MetaDescr", $descr);
$smarty->display('main.tpl');
$venues = GetVenueList($id);
$smarty->assign("Breadcrumbs", $breadcrumb_str);
$smarty->assign("EventName", $eventName);
$smarty->assign("EventIntroText", $eventIntroText);
if (strlen($eventText) > 2) {
$smarty->assign("EventText", $eventText);
}
if (is_array($venues)) {
function list_all_venues($smarty)
{
$query = "SELECT SanitizedRegionCode, RegionCode FROM Venues WHERE 1 GROUP BY RegionCode ORDER BY RegionCode ASC";
# $query = "SELECT SanitizedRegionCode, RegionCode FROM Productions LEFT JOIN Venues on (Productions.VenueID = Venues.VenueID) WHERE 1 GROUP BY RegionCode ORDER BY RegionCode ASC";
if ($query_result = mysql_query($query)) {
while ($table_row = mysql_fetch_row($query_result)) {
$sanitizedRegionCode = $table_row[0];
$regionCode = $table_row[1];
$url = "/venues/{$sanitizedRegionCode}/";
$states[] = array("name" => "{$regionCode}", "url" => "{$url}");
}
$title = "Find All Venues";
$smarty->assign("title", $title);
$keywords = "find all Venues, find all venue tickets";
$smarty->assign("SeoKeywords", $keywords);
$smarty->assign("MetaDescr", "All Venues. Select a venue to find and buy event Tickets at MongoTickets.");
$smarty->display('main.tpl');
$breadcrumb_str = '<a href="/">Home</a>';
$breadcrumb_str = AppendBreadcrumb($breadcrumb_str, '/venues/', 'Venues');
$smarty->assign("Breadcrumbs", $breadcrumb_str);
$smarty->assign("h1", 'Choose a Region');
if (count($states) > 0) {
$smarty->assign("States", $states);
$smarty->assign("NumStates", count($states));
$smarty->display('all_venues.tpl');
} else {
echo "<div id=\"content\">";
echo "<div id=\"breadcrumb_trail\">{$breadcrumb_str}</div>";
echo "<div id=\"no_tickets\">";
echo "<h1>All Venues</h1>";
echo "<p>There are no venues</p>";
echo "</div>";
}
} else {
# 5xx status code
header('HTTP/1.0 500 Internal Server Error');
handle_error_no_exit('venues.code:list_venues_in_state(): I cannot connect to the database because: ' . mysql_error());
$error_message = get_error_message();
$smarty->assign("ErrorMessage", $error_message);
$smarty->display('main.tpl');
$smarty->display('error_page.tpl');
}
}
#######################
# $url = make_production_url($eventName, $id, city, $eventTypeID);
#echo 'url = ' . $url . ' and req_uri = ' . $req_uri;
# if ($url != $req_uri) {
# 301 redirect to correct url
# $url = ltrim ( $url, '/');
#echo 'here';
# header('HTTP/1.1 301 Moved Permanently');
# header('Location: http://www.mongotickets.com/' . $url);
# exit();
# }
$origEventName = $eventName;
if ($eventID != "") {
$url = make_event_url($eventName);
$breadcrumb_str = Breadcrumbs($categoryID, 0);
$breadcrumb_str = AppendBreadcrumb($breadcrumb_str, "{$url}", $eventName . " Tickets");
}
if ($eventID == 1124) {
$eventName .= " {$shortNote}";
$fullEventName = $eventName;
$breadcrumb_str = AppendBreadcrumbNoAnchor($breadcrumb_str, " {$fullEventName} Tickets");
$title = "{$fullEventName} Tickets, {$fullEventName} Schedule, {$fullEventName} Dates";
$heading1 = $fullEventName;
$subheading = "<strong>{$eventName} Tickets</strong>";
} elseif ($eventTypeID == 3 && ($oppEventName != '' && strcmp($oppEventName, 'Unknown Event') != 0)) {
$fullEventName = "{$eventName} vs. {$oppEventName}";
$titleEventName = "{$eventName} vs. {$oppEventName} Tickets";
$meta_descr = "{$titleEventName} - Buy {$titleEventName} for {$shortDate} at {$venueName} in {$city}, {$regionCode} at MongoTickets!";
$breadcrumb_str = AppendBreadcrumbNoAnchor($breadcrumb_str, " {$fullEventName} Tickets");
$title = "{$eventName} vs {$oppEventName} Tickets at {$venueName} {$regionCode} on {$shortDate}";
$heading1 = "{$eventName} vs {$oppEventName} Tickets";
$title = "{$city} ";
}
$title .= "{$eventName} Tickets";
if ($venueName != "") {
$title .= " at {$venueName}";
}
if ($regionCode != "") {
$title .= " - {$regionCode}";
}
$smarty->assign("title", $title);
$descr = "{$city} {$eventName} Tickets. Buy {$city} {$eventName} Tickets and all other Theater Tickets at MongoTickets. Buy your {$city} {$eventName} Tickets today.";
$smarty->assign("MetaDescr", $descr);
$smarty->display('main.tpl');
$urlEventName = make_event_url($eventName);
$breadcrumb_str = Breadcrumbs($categoryID, 0);
$breadcrumb_str = AppendBreadcrumb($breadcrumb_str, $urlEventName, $eventName . " Tickets");
if ($venueName != "") {
$breadcrumb_str = AppendBreadcrumbNoAnchor($breadcrumb_str, " {$eventName} at {$venueName}");
}
$smarty->assign("Breadcrumbs", $breadcrumb_str);
$smarty->assign("EventName", $eventName);
$smarty->assign("City", $city);
$eventBanner = GetEventText($categoryID, $eventTypeID, $eventName, $event_id);
$smarty->assign("EventText", $eventBanner["intro_text"]);
if ($eventBanner["image_pathname"] != "") {
$smarty->assign("EventImagePathname", $eventBanner["image_pathname"]);
}
$smarty->assign("Productions", $productions);
$smarty->assign("NumProductions", count($productions));
$smarty->display('productions_at_venue.tpl');
} else {
