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');
}
}
function GetTopEventsSubordinateToCategoryID($categoryID, $limit)
{
include '../include/host_info.inc.php';
require '../include/ticket_db.php';
$events = array();
$num_events = 0;
$Bsql = 'SELECT EventName,EventID,EventRank FROM ModifiedPreorderTreeTraversalCategories as c1 LEFT JOIN ModifiedPreorderTreeTraversalCategories as c2 ON (c2.CategoryID=' . $categoryID . ') INNER JOIN Events ON (Events.CategoryID=c1.CategoryID) WHERE c1.lft BETWEEN c2.lft AND c2.rgt ORDER BY EventRank LIMIT ' . $limit;
if ($result = mysql_query($Bsql)) {
while ($table_row = mysql_fetch_array($result)) {
$eventID = $table_row['EventID'];
$eventName = $table_row['EventName'];
$eventRank = $table_row['EventRank'];
$url = make_event_url($eventName, $eventID);
if (strlen($table_row['EventName']) > 29) {
$num_events++;
}
if (strlen($table_row['EventName']) > 58) {
$num_events++;
}
$eventName = htmlspecialchars($table_row['EventName']);
$num_events++;
if ($num_events > $limit) {
break;
}
$events[] = array("name" => "{$eventName}", "url" => "{$url}", "rank" => "{$eventRank}", "id" => "{$eventID}");
}
} else {
handle_error_no_exit('GetTopEventsSubordinateToCategoryID: ' . mysql_error());
$events = "Error";
}
return $events;
}
$eventName = $table_row[1];
$eventTypeID = $table_row[2];
$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);
#### Can't do this since will cause problems
#### since url will come out differently for games
#######################
# $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");
$smarty->compile_dir = '../../smarty/templates_c/new_urls/';
$smarty->cache_dir = '../../smarty/cache/new_urls/';
$smarty->config_dir = '../../smarty/configs';
$smarty->compile_check = true;
$smarty->assign("RootUrl", $root_url);
$smarty->display('main.tpl');
if ($dbh = mysql_connect($host_name, $db_username, $db_password)) {
mysql_select_db($db_name);
$keywords = mysql_escape_string($keywords);
if ($search_pref == 'by_event') {
if ($query_result = mysql_query('SELECT EventID,EventName,CategoryID FROM Events WHERE EventName LIKE ' . "'%" . $keywords . "%' ORDER BY EventName ASC")) {
while ($table_row = mysql_fetch_array($query_result)) {
$eventID = $table_row['EventID'];
$eventName = $table_row['EventName'];
$categoryID = $table_row['CategoryID'];
$url = make_event_url($eventName, $categoryID);
$events[] = array("name" => "{$eventName}", "url" => "{$url}");
}
$smarty->assign("categoryName", $category);
$smarty->assign("Events", $events);
$smarty->assign("NumEvents", count($events));
$smarty->assign("SubCategories", $subcategories);
$smarty->assign("NumSubCategories", count($subcategories));
$breadcrumb_string = "<a href=\"{$root_url}/\">Home</a>";
$breadcrumb_string .= "> Search Results";
$smarty->assign("Breadcrumbs", $breadcrumb_string);
$smarty->display('search.tpl');
} else {
handle_error_no_exit('search.code: ' . mysql_error());
$error_message = get_error_message();
$smarty->assign("ErrorMessage", $error_message);
function fixup_url($smarty, $cats)
{
$categoryInfo = array();
$parentCategoryID = 0;
$parentCategoryName = 'Home';
$parentCategoryUrl = '';
$categories = split('/', trim($cats, '/'));
foreach ($categories as $idx => $sanCategoryName) {
if ($sanCategoryName == '') {
header('HTTP/1.1 301 Moved Permanently');
header('Location: http://www.mongotickets.com/' . $parentCategoryUrl);
exit;
} else {
$sanCategoryName = mysql_escape_string($sanCategoryName);
#echo $sanCategoryName . '<br/>';
$query = "SELECT AdjCat.CategoryID,AdjCat.CategoryName, ModCat.CategoryUrl FROM AdjacencyListCategories as AdjCat LEFT JOIN ModifiedPreorderTreeTraversalCategories ModCat ON (AdjCat.CategoryID=ModCat.CategoryID) WHERE AdjCat.SanitizedCategoryName='" . $sanCategoryName . "' AND AdjCat.ParentCategoryID={$parentCategoryID}";
if ($query_result = mysql_query($query)) {
$num_rows = mysql_num_rows($query_result);
if ($num_rows < 1) {
# could be event due to url = /category/<event> or /category/<event>/
$query = "SELECT EventName, CategoryID FROM Events WHERE SanitizedEventName='" . $sanCategoryName . "'";
if ($query_result = mysql_query($query)) {
$num_rows = mysql_num_rows($query_result);
if ($num_rows == 1) {
$table_row = mysql_fetch_row($query_result);
$url = make_event_url($table_row[0], $table_row[1]);
$parentCategoryUrl = ltrim($url, '/');
}
}
#301 redirect to $parentCategory
header('HTTP/1.1 301 Moved Permanently');
header('Location: http://www.mongotickets.com/' . $parentCategoryUrl);
exit;
} else {
$table_row = mysql_fetch_row($query_result);
$parentCategoryID = $table_row[0];
$parentCategoryName = $table_row[1];
$parentCategoryUrl = $table_row[2];
}
} else {
# 5xx status code
header('HTTP/1.0 500 Internal Server Error');
handle_error_no_exit('ticket_dispatch.code: fixup_url database query failed: ' . mysql_error());
$error_message = get_error_message();
$smarty->assign("ErrorMessage", $error_message);
$smarty->display('main.tpl');
$smarty->display('error_page.tpl');
}
}
}
$categoryInfo['categoryID'] = $parentCategoryID;
$categoryInfo['categoryName'] = $parentCategoryName;
$categoryInfo['categoryUrl'] = $parentCategoryUrl;
return $categoryInfo;
}
$smarty->template_dir = '../smarty/templates';
$smarty->compile_dir = '../smarty/templates_c';
$smarty->cache_dir = '../smarty/cache';
$smarty->config_dir = '../smarty/configs';
$smarty->compile_check = true;
$smarty->assign("RootUrl", $root_url);
$smarty->display('main.tpl');
if ($dbh = mysql_connect($host_name, $db_username, $db_password)) {
mysql_select_db($db_name);
$keywords = mysql_escape_string($keywords);
if ($search_pref == 'by_event') {
if ($query_result = mysql_query('SELECT EventID,EventName FROM Events WHERE EventName LIKE ' . "'%" . $keywords . "%' ORDER BY EventName ASC")) {
while ($table_row = mysql_fetch_array($query_result)) {
$eventID = $table_row['EventID'];
$eventName = $table_row['EventName'];
$url = make_event_url($eventName, $eventID);
$events[] = array("name" => "{$eventName}", "url" => "{$url}");
}
$smarty->assign("categoryName", $category);
$smarty->assign("Events", $events);
$smarty->assign("NumEvents", count($events));
$smarty->assign("SubCategories", $subcategories);
$smarty->assign("NumSubCategories", count($subcategories));
$breadcrumb_string = "<a href=\"{$root_url}/\">Home</a>";
$breadcrumb_string .= "<img src=\"{$root_url}/Images/SmallArrow.jpg\" alt=\" \"/> Search Results";
$smarty->assign("Breadcrumbs", $breadcrumb_string);
$smarty->display('search.tpl');
} else {
handle_error_no_exit('search.code: ' . mysql_error());
$error_message = get_error_message();
$smarty->assign("ErrorMessage", $error_message);
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');
}
}
}
if ($city != "") {
$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));
function DisplayPlayoffEvents($categoryID, $categoryName)
{
$categoryToEventCategories = array(24 => array(25, 30), 82 => array(83, 87), 1999 => array(19, 15), 250 => array(93, 97));
echo "<div class=\"category_event_list\">\n";
echo "<h1>{$categoryName}</h1>\n";
if (array_key_exists($categoryID, $categoryToEventCategories)) {
echo "<ul>\n";
foreach ($categoryToEventCategories[$categoryID] as $id) {
$events = GetEventsUnderCategory($id);
if (is_array($events) && count($events) > 0) {
foreach ($events as $index => $eventInfo) {
$eventName = $eventInfo['name'] . " Playoff Tickets";
$url = make_event_url($eventName, $eventInfo['id']);
$eventName = htmlspecialchars($eventName);
echo "<li><a href=\"{$url}\">{$eventName}</a></li>\n";
}
}
}
echo "</ul>\n";
}
echo "</div>";
}
<?php
#
# Copyright (c) 2007, Jassen Moran. All rights reserved.
# Quad tickets Confidential Proprietary.
#
require_once '../include/ticket_db.php';
require_once '../include/url_factory.inc.php';
$dbh = mysql_connect($host_name, $db_username, $db_password) or die('I cannot connect to the database because: ' . mysql_error());
mysql_select_db($db_name);
$date = "";
// retrieve the left and right value of the $root node
$bsql = 'SELECT Events.EventID, EventName, COUNT(Productions.EventID) as num_prods from Events LEFT JOIN Productions ON (Events.EventID = Productions.EventID) WHERE 1 GROUP BY Events.EventID HAVING num_prods > 0 ORDER BY num_prods DESC';
$result = mysql_query($bsql) or 'Error: query failed' . mysql_error();
$data .= "EventName,Url\n";
while ($row = mysql_fetch_row($result)) {
$line = '';
$eventID = $row[0];
$eventName = $row[1];
$count = $row[2];
$url = "http://www.mongotickets.com" . make_event_url($eventName, $eventID);
$line .= "\"{$eventName}\",{$url}";
$data .= trim($line) . "\n";
}
$data = str_replace("\r", "", $data);
mysql_close($dbh);
header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=active_events.csv");
header("Pragma: no-cache");
header("Expires: 0");
print "{$header}\n{$data}";
$productions[] = array("date" => $eventDate, "venuename" => $venueNameLocation, "eventDescr" => "{$eventName}", "url" => "{$url}");
}
if ($city != "") {
$title = "{$city} ";
}
$title .= "{$eventName} Tickets";
if ($venueName != "") {
$title .= " at {$venueName}";
}
if ($regionCode != "") {
$title .= " - {$regionCode}";
}
$smarty->assign("title", $title);
$smarty->display('main.tpl');
# use event ID from GET parameter
$urlEventName = make_event_url($eventName, $event_id);
$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));
echo 'Spr';
} elseif ($eventTypeID == 4) {
echo 'Thr';
} elseif ($eventTypeID == 1) {
echo '???';
} else {
echo 'Unk';
}
echo '</td>';
echo '<td align="left" width="6%"> ' . $keywords . '</td>';
echo '<td align="left" width="7%"> ';
$action = getAction($campaignStatus, $num_productions);
echo "{$action}</td>";
echo '<td align="left" width="4%"> ' . $dates . '</td>';
echo '<td align="left" width="30"> ' . $ID . '<input type="hidden" name="ID_' . $i . '" id="ID_' . $i . '" value="' . $ID . '"/></td>';
$ev_url = make_event_url($name);
$ev_url = "www.mongotickets.com" . $ev_url;
echo '<td align="left" width="33%"><input type="text" value="' . $ev_url . '" size="60"/></td>';
echo '</tr>';
$i++;
}
echo '<tr>
<td colspan="9" align="center"> <input type="submit" value="Update" /> </td>
</tr>';
echo '</form>';
echo '</table>';
if ($num_pages > 1) {
print_page_nav($start, $num_pages, $url_params);
}
} else {
}
