createRecordSet("SELECT COUNT(listing_id) AS result FROM listings WHERE active = 1 AND ".$where." = ".$value); $count = $db->fetchArray($rs); return $count["result"]; } # Left Content $page_code = 'home'; $sql = "SELECT title, left_content, center_content FROM app_site_pages WHERE page_code = '".$page_code."' AND site_code = '".SITE_CODE."'"; $rs = $db->createRecordSet($sql); $page = $db->fetchArray($rs); $search = array(); array_push($search, array('text' => 'By department', 'url' => '')); $rs = $db->createRecordSet("SELECT * FROM listing_department ORDER BY name"); $departments = $db->fetchAll($rs); foreach($departments as $department) { $count = getCount("department_id", $department["department_id"]); $search_departments = array( 'text' => $department["name"].' ('.$count.')', 'url' => 'results.html?select_department='.$department["department_id"] ); array_push($search, $search_departments); } array_push($search, array('text' => '', 'url' => '')); array_push($search, array('text' => 'By type', 'url' => '')); $rs = $db->createRecordSet("SELECT * FROM listing_type ORDER BY name"); $types = $db->fetchAll($rs); foreach($types as $type) { $count = getCount("type_id", $type["type_id"]); $search_types = array( 'text' => $type["name"].' ('.$count.')', 'url' => 'results.html?select_type='.$type["type_id"] ); array_push($search, $search_types); } array_push($search, array('text' => '

 

', 'url' => '')); array_push($search, array('text' => 'By Town', 'url' => '')); $rs = $db->createRecordSet("SELECT * FROM p_town ORDER BY name"); $towns = $db->fetchAll($rs); foreach($towns as $town) { $count = getCount("ptown_id", $town["id"]); $search_towns = array( 'text' => $town["name"].' ('.$count.')', 'url' => 'results.html?primary_town='.$town["id"] ); array_push($search, $search_towns); } $map = array ( array( 'text' => 'Home', 'url' => 'index.html', 'sub' => array() ), array( 'text' => 'About Us', 'url' => 'about.html', 'sub' => array() ), array( 'text' => 'Contact Us', 'url' => 'contact.html', 'sub' => array() ), array( 'text' => 'Sign Up', 'url' => 'user_signup.html', 'sub' => array() ), array( 'text' => 'Log In', 'url' => 'login.html', 'sub' => array() ), array( 'text' => 'Properties', 'url' => 'all_properties.html', 'sub' => $search ), ); # Header $smarty->assign("nav", ""); $smarty->assign("title", "Site Map"); # Main content # left content $smarty->assign("left_content", $page["left_content"]); # center content $smarty->assign("site_map", $map); $smarty->assign("search", array("search2.tpl")); $smarty->assign("callouts", array("featured_vertical_new.tpl")); $smarty->assign("contents", array("site_map.tpl")); //$smarty->assign("callouts", array("search.tpl", "featured_vertical.tpl")); $smarty->display("main.tpl"); ?>