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 {