function list_events_at_venue($smarty, $venueID)
{
$query = "SELECT Events.EventID, EventName, EventTypeID, VenueName, RegionCode,ProductionID,DATE_FORMAT(EventDate, '%a. %M %e, %Y %h:%i %p'),CategoryUrl,City,Events.CategoryID, SanitizedVenueName FROM Events inner join Productions on (Events.EventID = Productions.EventID) LEFT JOIN Venues on (Productions.VenueID = Venues.VenueID) LEFT JOIN ModifiedPreorderTreeTraversalCategories as c on (Events.CategoryID=c.CategoryID) WHERE Productions.VenueID = '{$venueID}' ORDER BY EventDate ASC";
if ($query_result = mysql_query($query)) {
while ($table_row = mysql_fetch_row($query_result)) {
$eventID = $table_row[0];
$eventName = $table_row[1];
$eventTypeID = $table_row[2];
$venueName = $table_row[3];
$regionCode = $table_row[4];
$productionID = $table_row[5];
$date = $table_row[6];
$categoryUrl = $table_row[7];
$city = utf8_decode($table_row[8]);
$categoryID = $table_row[9];
$sanitizedVenueName = $table_row[10];
if (strlen($eventName) < 1) {
handle_error_no_exit('venues.php: empty event name from db query vid=' . $_REQUEST['venue_id'] . ' ' . $_SERVER['REQUEST_URI'] . ' returning 301');
}
$prodUrl = make_production_url($eventName, $productionID, $city, $eventTypeID);
$eventUrl = make_event_url($eventName);
$events[] = array("name" => "{$eventName}", "date" => "{$date}", "event_url" => $eventUrl, "prod_url" => "{$prodUrl}");
}
$title = "{$venueName} Tickets, {$venueName} Seating Chart";
$smarty->assign("title", $title);
$keywords = "{$venueName} Seating Chart, {$venueName} Tickets";
$smarty->assign("SeoKeywords", $keywords);
$smarty->assign("MetaDescr", "{$venueName} Tickets. Buy tickets to events at {$venueName} in {$city}, {$regionCode} at MongoTickets.");
$smarty->display('main.tpl');
$breadcrumb_str = '<a href="/">Home</a>';
$venueUrl = make_venue_url($sanitizedVenueName);
# $breadcrumb_str = AppendBreadcrumb($breadcrumb_str, "$venueUrl", $venueName);
$breadcrumb_str = AppendBreadcrumbNoAnchor($breadcrumb_str, " {$venueName} Tickets");
$smarty->assign("Breadcrumbs", $breadcrumb_str);
if (count($events) > 0) {
$smarty->assign("venueName", $venueName);
$smarty->assign("EventsArray", $events);
$smarty->assign("NumEvents", count($events));
$smarty->display('events_at_venue.tpl');
} else {
echo "<div id=\"content\">";
echo "<div id=\"breadcrumb_trail\">{$breadcrumb_str}</div>";
echo "<div id=\"no_tickets\">";
echo "<h1>{$venueName} Events</h1>";
echo "<p>There are currently no events at {$venueName}</p>";
echo "</div>";
}
} else {
# 5xx status code
header('HTTP/1.0 500 Internal Server Error');
handle_error_no_exit('venues.code:list_events_at_venue(): query failed because: ' . mysql_error() . ' ' . $_SERVER['REQUEST_URI'] . ' returning 500');
$error_message = get_error_message();
$smarty->assign("ErrorMessage", $error_message);
$smarty->display('main.tpl');
$smarty->display('error_page.tpl');
}
}
$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";
$subheading = "<strong>{$eventName} Tickets</strong>";
$eventName = $fullEventName;
} else {
$fullEventName = "{$eventName} at {$venueName}";
$meta_descr = "{$eventName} at {$venueName} Tickets - Buy {$eventName} Tickets for {$shortDate} at {$venueName} in {$city}, {$regionCode} at MongoTickets!";
$subheading = "<strong>{$eventName} Tickets</strong> {$city}";
$breadcrumb_str = AppendBreadcrumbNoAnchor($breadcrumb_str, " {$fullEventName} Tickets");
$title = "{$eventName} Tickets at {$venueName} in {$city}, {$regionCode} on {$shortDate}";
$heading1 = "{$eventName} Tickets";
}
$smarty->assign("MetaDescr", $meta_descr);
mysql_close($dbh);
} else {
header('HTTP/1.0 500 Internal Server Error');
handle_error_no_exit('tickets.code: I cannot connect to the database because: ' . mysql_error() . ' production id= ' . $id . ' event id = ' . $eventID . ' uri= ' . $_SERVER['REQUEST_URI'] . ' returning 500');
$error_message = get_error_message();
$smarty->assign("ErrorMessage", $error_message);
$smarty->display('main.tpl');
$smarty->display('error_page.tpl');
}
$keywords = "";
$keywords = BuildEventKeywordList($fullEventName, $city);
function list_events_at_venue($smarty, $venueID)
{
$query = "SELECT Events.EventID, EventName, EventTypeID, VenueName, RegionCode,ProductionID,DATE_FORMAT(EventDate, '%a. %M %e, %Y'),CategoryUrl,City,Events.CategoryID, SanitizedVenueName, Address1, PostalCode,DATE_FORMAT(EventDate, '%h:%i %p') FROM Events inner join Productions on (Events.EventID = Productions.EventID) LEFT JOIN Venues on (Productions.VenueID = Venues.VenueID) LEFT JOIN ModifiedPreorderTreeTraversalCategories as c on (Events.CategoryID=c.CategoryID) WHERE Productions.VenueID = '{$venueID}' AND DATEDIFF(NOW(), EventDate) <= 0 ORDER BY EventDate ASC";
if ($query_result = mysql_query($query)) {
$num_rows = mysql_num_rows($query_result);
while ($table_row = mysql_fetch_row($query_result)) {
$eventID = $table_row[0];
$eventName = $table_row[1];
$eventTypeID = $table_row[2];
$venueName = $table_row[3];
$regionCode = $table_row[4];
$productionID = $table_row[5];
$date = $table_row[6];
$categoryUrl = $table_row[7];
$city = utf8_decode($table_row[8]);
$categoryID = $table_row[9];
$sanitizedVenueName = $table_row[10];
$address1 = $table_row[11];
$zipcode = $table_row[12];
$productionTime = $table_row[13];
if (strlen($eventName) < 1) {
handle_error_no_exit('venues.php: empty event name from db query vid=' . $_REQUEST['venue_id'] . ' ' . $_SERVER['REQUEST_URI'] . ' returning 301');
redir_301();
}
$venueUrl = make_venue_url($sanitizedVenueName);
$prodUrl = make_production_url($eventName, $productionID, $city, $eventTypeID);
$eventUrl = make_event_url($eventName);
$events[] = array("name" => "{$eventName}", "date" => "{$date}", "event_url" => $eventUrl, "prod_url" => "{$prodUrl}", "venue_url" => "{$venueUrl}", "event_id" => $eventID, "time" => "{$productionTime}");
}
if ($num_rows < 1) {
$query = "SELECT VenueName, Address1, RegionCode,City,PostalCode FROM Venues WHERE VenueID = '{$venueID}'";
if ($query_result = mysql_query($query)) {
$num_rows = mysql_num_rows($query_result);
while ($table_row = mysql_fetch_row($query_result)) {
$venueName = $table_row[0];
$address1 = $table_row[1];
$regionCode = $table_row[2];
$city = utf8_decode($table_row[3]);
$zipcode = $table_row[4];
}
if ($num_rows < 1) {
handle_error_no_exit('venues.new_urls.php: no productions at venue and cannot find venue id in database vid=' . $_REQUEST['venue_id'] . ' ' . $_SERVER['REQUEST_URI'] . ' returning 301');
redir_301();
}
}
}
$title = "{$venueName} Tickets, {$venueName} Seating Chart";
$smarty->assign("title", $title);
$keywords = "{$venueName} Seating Chart, {$venueName} Tickets";
$smarty->assign("SeoKeywords", $keywords);
$smarty->assign("MetaDescr", "{$venueName} Tickets. Buy tickets to events at {$venueName} in {$city}, {$regionCode} at MongoTickets.");
$smarty->display('main.tpl');
$breadcrumb_str = '<a href="/">Home</a>';
# $venueUrl = make_venue_url($sanitizedVenueName);
# $breadcrumb_str = AppendBreadcrumb($breadcrumb_str, "$venueUrl", $venueName);
$breadcrumb_str = AppendBreadcrumbNoAnchor($breadcrumb_str, " {$venueName} Tickets");
$smarty->assign("Breadcrumbs", $breadcrumb_str);
if (count($events) > 0) {
$venueMapUrl = GetVenueMapUrl($venueID, $events[0]['event_id']);
} else {
$venueMapUrl = GetVenueMapUrl($venueID, 1);
}
$address1 = htmlspecialchars($address1);
$smarty->assign("Address", $address1);
$smarty->assign("City", $city);
$smarty->assign("ZipCode", $zipcode);
$smarty->assign("State", $regionCode);
$smarty->assign("venueName", $venueName);
$smarty->assign("EventsArray", $events);
$smarty->assign("NumEvents", count($events));
$smarty->assign("Address", $address1);
$smarty->assign("City", $city);
$smarty->assign("ZipCode", $zipcode);
$smarty->assign("State", $regionCode);
$smarty->assign("SeatingChartUrl", $venueMapUrl);
$smarty->display('events_at_venue.tpl');
#else {
# echo '<div id="content">';
# echo '<div class="left_bar">';
# echo "<div id=\"breadcrumb_trail\">$breadcrumb_str</div>";
# echo "<div id=\"no_tickets\">";
# echo "<h1>$venueName Events</h1>";
# echo '<p>Address: 4 Yawkey Way<br/>';
# echo 'City: Boston<br/>';
# echo 'State: MA<br/>';
# echo 'Zip: 02215';
# echo '</p>';
# echo '<h2><strong>Events at ' . $venueName . '</strong></h2>';
# echo "<p>There are currently no events at $venueName.</p>";
# echo "</div>";
# echo "</div> <!-- end left_bar -->";
# $smarty->display('right_bar.tpl');
# $smarty->display('left_column.tpl');
#}
} else {
# 5xx status code
header('HTTP/1.0 500 Internal Server Error');
handle_error_no_exit('venues.code:list_events_at_venue(): query failed because: ' . mysql_error() . ' ' . $_SERVER['REQUEST_URI'] . ' returning 500');
$error_message = get_error_message();
$smarty->assign("ErrorMessage", $error_message);
$smarty->display('main.tpl');
$smarty->display('error_page.tpl');
}
}
$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 {
$smarty->assign("title", $title);
$smarty->display('main.tpl');
$descr = "{$eventName} Tickets - Buy {$eventName} Tickets and all other Tickets at MongoTickets. Buy your {$eventName} Tickets today.";
# uncomment
$url = make_event_url($eventName);
# comment
#$url = $req_uri;
#echo '<br>$url=' . $url . '<br>$req_uri=' .$req_uri;
# if ($url != $req_uri) {
#echo 'invalid, redirecting'; exit;
# 301 redirect to correct url
# $url = ltrim ( $url, '/');
# header('HTTP/1.1 301 Moved Permanently');
# header('Location: http://www.mongotickets.com/' . $url);
# exit();
# }
$breadcrumb_str = Breadcrumbs($categoryID);
$breadcrumb_str = AppendBreadcrumbNoAnchor($breadcrumb_str, "{$eventName} Tickets");
# if category is theater, list venues first.
$disp_home_away = 0;
if ($eventTypeID == 4) {
$title = "{$eventName} Tickets, {$eventName} Schedule, {$eventName} Dates, Discounted {$eventName} Tickets";
$descr = "{$eventName} Tickets - Buy {$eventName} Tickets and all other Theater Tickets at MongoTickets. Buy your {$eventName} Tickets today.";
if (array_key_exists($eventID, $seo_data)) {
$title = $seo_data[$eventID]['title_tag'];
$descr = $seo_data[$eventID]['meta_descr'];
$keywords = $seo_data[$eventID]['keywords'];
$smarty->assign("SeoKeywords", $keywords);
}
$smarty->assign("title", $title);
$smarty->assign("MetaDescr", $descr);
$smarty->display('main.tpl');
$venues = GetVenueList($eventID, $categoryID);
$url = make_event_url($eventName, $eventID);
$eventTypeID = $table_row[2];
$events[] = array("name" => "{$eventName}", "url" => "{$url}");
}
# $keywords = BuildEventKeywordList($categoryID,$eventName, $eventTypeID, $id);
#$keywords = AmpersandToAnd($keywords);
#$smarty->assign("SeoKeywords", $keywords);
#$title = "$eventName Tickets @ " . COMPANY_NAME;
#$smarty->assign("title", $title);
$title = "{$venueName} Tickets @ " . COMPANY_NAME;
$smarty->assign("title", $title);
#$keywords = GetKeywordsForCategoryID($categoryID);
$smarty->assign("SeoKeywords", $keywords);
$smarty->display('main.tpl');
$breadcrumb_str = "<a href=\"{$root_url}/\">Home</a>";
$breadcrumb_str = AppendBreadcrumbNoAnchor($breadcrumb_str, " {$venueName} Events");
$smarty->assign("Breadcrumbs", $breadcrumb_str);
if (count($events) > 0) {
$smarty->assign("venueName", $venueName);
$smarty->assign("EventsArray", $events);
$smarty->assign("NumEvents", count($events));
$smarty->display('venue_events.tpl');
} else {
echo "<div id=\"content\">";
echo "<div id=\"breadcrumb_trail\">{$breadcrumb_str}</div>";
echo "<div id=\"no_tickets\">";
echo "<h1>{$venueName} Events</h1>";
echo "<p>There are currently no events at {$venueName}</p>";
echo "</div>";
}
} else {
