redir_301();
}
$smarty = new Smarty();
$smarty->template_dir = '../smarty/templates/new_urls/';
$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);
$descr = "Buy " . preg_replace('/-/', ' ', $categoryName) . " Tickets at MongoTickets today! " . preg_replace('/-/', ' ', $categoryName) . " Tickets";
$smarty->assign("MetaDescr", $descr);
if ($dbh = mysql_connect($host_name, $db_username, $db_password)) {
mysql_select_db($db_name);
$categoryID = $id;
$limit = -1;
$subcategories = GetImmediateSubordinatesOfCategory($categoryID, $limit);
$bsql = "SELECT TitleTag FROM AdjacencyListCategories WHERE CategoryID={$categoryID}";
$categoryName = preg_replace('/-/', ' ', $categoryName);
$titleTag = "{$categoryName} Tickets";
if ($query_result = mysql_query($bsql)) {
while ($table_row = mysql_fetch_array($query_result)) {
$titleTag = $table_row['TitleTag'];
}
}
if (!is_array($subcategories)) {
handle_error_no_exit('category.php: no subcategories in this category ' . $_SERVER['REQUEST_URI'] . ' ');
$error_message = get_error_message();
$smarty->assign("ErrorMessage", $error_message);
$smarty->display('error_page.tpl');
} else {
$smarty->assign("title", $titleTag);
echo "<div id=\"content\">\n";
echo "<div id=\"breadcrumb_trail\">\n";
echo $breadcrumb_str;
echo "</div>\n";
echo "<div class=\"leaguetable\">\n";
echo "<h1><strong>{$categoryName} Tickets</strong></h1>\n";
echo "<table>\n";
echo "<tr>\n";
# division level
for ($i = 0; $i < 2; $i++) {
echo "<td>" . $subcategories[$i]['name'] . "</td>";
}
echo "</tr>\n";
echo "<tr>";
for ($i = 0; $i < 2; $i++) {
$subsubcategories = GetImmediateSubordinatesOfCategory($subcategories[$i]['id'], $limit);
if (is_array($subsubcategories) && count($subsubcategories) > 0) {
echo '<td>';
$counter = 0;
foreach ($subsubcategories as $index => $subsubcategoryArray) {
echo "<ul>";
echo "<li";
if ($counter <= 0) {
echo ' class="' . $css_class . '"';
}
echo ">{$subsubcategoryArray['name']}</li>\n";
if ($query_result = mysql_query('SELECT EventID,EventName FROM Events WHERE CategoryID = ' . $subsubcategoryArray[id] . ' 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);
if (strlen($pager_url_params) > 0) {
$pager_url_params = '?' . $pager_url_params;
}
if (strlen($num_prod_url_params) > 0) {
$num_prod_url_params = '?' . $num_prod_url_params;
}
if (strlen($rank_url_params) > 0) {
$rank_url_params = '?' . $rank_url_params;
}
if ($dbh) {
if ($categoryID != '') {
$categoryName = GetCategoryName($categoryID);
echo '<h1>' . $categoryName . '</h1>';
$breadcrumb_str = Breadcrumbs($categoryID, 0);
echo $breadcrumb_str;
$subsubcategories = GetImmediateSubordinatesOfCategory($categoryID, -1);
$suboord = '';
if (is_array($subsubcategories) && count($subsubcategories) > 0) {
echo '<br/>Below: ';
foreach ($subsubcategories as $index => $subsubcategoryArray) {
$anchor = '
<a href="http://www.mongotickets.com/event_ranking_editor.php?start=1&categoryID=' . $subsubcategoryArray[id] . '">' . $subsubcategoryArray[name] . '</a>';
if (strlen($suboord) > 0) {
$suboord .= ' , ';
}
$suboord .= $anchor;
}
echo '
' . $suboord;
}
echo '<br/>';
