function Breadcrumbs($categoryID, $eventID) { include '../include/host_info.inc.php'; $Bsql = "SELECT C.CategoryID, C.CategoryName" . " FROM ModifiedPreorderTreeTraversalCategories AS B, ModifiedPreorderTreeTraversalCategories AS C" . " WHERE (B.lft BETWEEN C.lft AND C.rgt)" . " AND (B.CategoryID = {$categoryID})" . " ORDER BY C.lft"; #Might want to change to (B.lft BETWEEN (C.lft+1) AND C.rgt) $result = mysql_query($Bsql); $top_level_category_array = array(2, 3, 4); $breadcrumb_string = ""; while ($row = mysql_fetch_array($result)) { $categoryName = $row['CategoryName']; $categoryID = $row['CategoryID']; if (strlen($breadcrumb_string) > 0) { $breadcrumb_string .= " > "; } if (in_array($categoryID, $top_level_category_array)) { $url = make_main_category_url($categoryName); $breadcrumb_string .= "<a href=\"{$url}\">{$categoryName} Tickets</a>"; } elseif ($categoryID == 0) { $breadcrumb_string .= "<a href=\"{$root_url}/\">Home</a>"; } else { $url = make_category_url($categoryName, $categoryID); $breadcrumb_string .= "<a href=\"{$url}\">{$categoryName}</a>"; } } #if(pagetype is not category then add event or event and venue) #do not anchor current page breadcrumb. (optional) #if event page add event name to breadcrumb with no anchor, #if venue page add "even name at venue"with no anchor #if tickets list page, same as venue page. return $breadcrumb_string; }
$text_content = "Enjoy the best seats in the house, from the latest concert, theater, or sports events live at your nearest venue. Choose from "; for ($i = 0; $i < count($topThreeArray); $i++) { $limit = 10; $events = GetTopEventsSubordinateToCategoryID($topThreeArray[$i]['id'], $limit); if (!is_array($events)) { $error_message = get_error_message(); $smarty->assign("ErrorMessage", $error_message); $smarty->display('error_page.tpl'); $smarty->display('footer.tpl'); mysql_close($dbh); exit; } elseif (count($events) > 0) { $top_event_name = $events[0]['name']; $top_event_url = $events[0]['url']; $category_name = $topThreeArray[$i]['name']; $url_category_name = make_main_category_url($category_name); $category_id = $topThreeArray[$i]['id']; $num_events = count($events); if ($num_events > 0) { $events[$num_events - 1]['url'] = $url_category_name; $events[$num_events - 1]['name'] = "More {$category_name} Events…"; } $categories[] = array("catname" => "{$category_name} Tickets", "caturl" => "{$url_category_name}", "top_event_name" => "{$top_event_name}", "top_events" => $events, "catimage" => CATEGORY_IMAGES_PATH . $topThreeArray[$i]['catimage']); if (strlen($additional_text_content) > 0) { $additional_text_content .= ", to {$top_event_name} Tickets"; } else { $additional_text_content = "{$top_event_name} Tickets"; } } } $text_content .= $additional_text_content . " and more. MongoTickets.com carries tickets for all venue and seat locations.";