<?php require_once '../include/ticket_db.php'; require_once 'err.php'; require_once '../public_html/DbUtils.php'; print_message("Creating Sports table......."); $dbh = mysql_connect($host_name, $db_username, $db_password) or die('CreateSportsTable: I cannot connect to the database because: ' . mysql_error()); mysql_select_db($db_name); $bsql = "DROP TABLE IF EXISTS CategoryToSportName_temp"; $query_result = mysql_query($bsql) or die('CreateSportsTable: DROP TABLE CategoryToSportName_temp failed: ' . mysql_error()); $bsql = "CREATE TABLE CategoryToSportName_temp(\n \t CategoryID INT NOT NULL,\n \t SportName CHAR(100),\n PRIMARY KEY (CategoryID)\n )"; $query_result = mysql_query($bsql) or die('CreateSportsTable: ' . mysql_error()); $bsql = "SELECT CategoryID,CategoryName FROM AdjacencyListCategories_temp WHERE ParentCategoryID=3"; $result = mysql_query($bsql) or die('CreateSportsTable: ' . mysql_error()); while ($row = mysql_fetch_array($result)) { $top_level_categories[] = array('id' => $row['CategoryID'], 'name' => $row['CategoryName']); } mysql_free_result($result); for ($i = 0; $i < count($top_level_categories); $i++) { $categories = GetAllSubordinatesOfCategory('ModifiedPreorderTreeTraversalCategories_temp', $top_level_categories[$i]['id']); $categoryName = strtolower($top_level_categories[$i]['name']); $result = mysql_query("INSERT INTO CategoryToSportName_temp (CategoryID, SportName) VALUES (" . $top_level_categories[$i]['id'] . ",'" . $categoryName . "')") or die('CreateSportsTable: ' . mysql_error()); for ($j = 0; $j < count($categories); $j++) { $result = mysql_query("INSERT INTO CategoryToSportName_temp (CategoryID, SportName) VALUES (" . $categories[$j]['id'] . ",'" . $categoryName . "')") or die('CreateSportsTable: ' . mysql_error()); } } mysql_close($dbh);
$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); $smarty->display('main.tpl'); if ($dbh = mysql_connect($host_name, $db_username, $db_password)) { mysql_select_db($db_name); echo '<div id="content">'; echo '<div class="left_bar">'; $top_level_categoryid_list = array("Sports" => 3, "Concert" => 2, "Theater" => 4); foreach ($top_level_categoryid_list as $categoryName => $categoryID) { echo "<div class=\"sitemapSection\">" . "<div><a class=\"sitemapHeading\" href=\"{$root_url}/" . strtolower($categoryName) . "-tickets/\">{$categoryName}</a>" . "</div>"; $childCategoryIDList = GetAllSubordinatesOfCategory('ModifiedPreorderTreeTraversalCategories', $categoryID); foreach ($childCategoryIDList as $childCategoryIDArray) { $url = make_category_url($childCategoryIDArray['name']); echo "<div class=\"indent_" . $childCategoryIDArray['depth'] . "\">" . "<a href=\"{$url}\">" . $childCategoryIDArray['name'] . "</a>" . "</div>"; #$indent++; } echo "</div>"; } echo '</div> <!-- end left_bar -->'; $smarty->display('right_bar.tpl'); $smarty->display('left_column.tpl'); # content to be closed by footer, echo "</div>"; } $smarty->display('footer.tpl'); ?>