0){ $profile = array(); while ($r_profile = mysql_fetch_array ($q_profile)) array_push ($profile, $r_profile); $is_profile = true; } } $template = "content/list.html"; $title = $category ." verhuur.in ". $city; $breadcrumbs = array(array("http://www.verhuur.in","verhuur.in"),array("http://".$u_category.".verhuur.in",$category),array("http://".$u_category.".verhuur.in".$u_city,$city)); } // -------------------------------------- // profiel // -------------------------------------- if($_GET['profile'] != ""){ $q_profile = mysql_query(" SELECT * FROM profile WHERE mr_name = '".$_GET['profile']."' LIMIT 1") or die(mysql_error()); if(mysql_num_rows($q_profile) > 0){ $r_profile = mysql_fetch_array($q_profile); //haal zijn filiaal op $q_depot = mysql_query(" SELECT * FROM depot WHERE city = '".$city."' AND profile_id = '".$r_profile['id']."' LIMIT 1") or die(mysql_error()); if(mysql_num_rows($q_depot) == 1){ $depot = mysql_fetch_array ($q_depot); $gLat = $depot['gLat']; $gLng = $depot['gLng']; $gZlv = 14; $is_depot = true; } //haal zijn categorien op $q_profile_category = mysql_query(" SELECT DISTINCT name,mr_name FROM category,ccdp WHERE ccdp.category_id = category.id AND ccdp.profile_id = '".$r_profile['id']."'") or die(mysql_error()); if(mysql_num_rows($q_profile_category) > 1){ $profile_category = array(); while ($r_profile_category = mysql_fetch_array ($q_profile_category)) array_push ($profile_category, $r_profile_category); } //haal zijn steden op $q_profile_city = mysql_query(" SELECT DISTINCT name,mr_name FROM city,ccdp WHERE ccdp.city_id = city.id AND ccdp.profile_id = '".$r_profile['id']."'") or die(mysql_error()); if(mysql_num_rows($q_profile_city) > 1){ $profile_city = array(); while ($r_profile_city = mysql_fetch_array ($q_profile_city)) array_push ($profile_city, $r_profile_city); } // de rest van de variabelen $profile = $r_profile; $title = $r_profile['name'] ." | ". $category ." verhuur.in ". $city; $breadcrumbs = array(array("http://www.verhuur.in","verhuur.in"),array("http://".$u_category.".verhuur.in",$category),array("http://".$u_category.".verhuur.in".$u_city,$city),array($r_profile['mr_name'],$r_profile['name'])); popularity("profile",$r_profile['mr_name']); } else { $profile = ucfirst($_GET['profile']); $mr_profile = $_GET['profile']; $u_profile = "/".$mr_profile; $title = $profile ." | ". $category ." verhuur.in ". $city; $breadcrumbs = array(array("http://www.verhuur.in","verhuur.in"),array("http://".$u_category."verhuur.in",$category),array("http://".$u_category.".verhuur.in".$u_city,$city),array($mr_profile,$profile)); unknown($profile,3); } $template = "content/profile.html"; } // -------------------------------------- // overige gebreurtenissen // -------------------------------------- // start cookie sessie if(!$is_category && !$is_city){ check_bookmark(true); } else { check_bookmark(false); } // -------------------------------------- // start smarty // -------------------------------------- $smarty = new Smarty; //$smarty->debugging = true; //$smarty->assign("querystring",$_SERVER['QUERY_STRING']); // Google Maps $smarty->assign("gLat",$gLat); $smarty->assign("gLng",$gLng); $smarty->assign("gZlv",$gZlv); // De rest $smarty->assign("message",$_GET['message']); $smarty->assign("title",$title); $smarty->assign("breadcrumbs",$breadcrumbs); $smarty->assign("is_directory",true); $smarty->assign("list_category",$list_category); $smarty->assign("list_city",$list_city); $smarty->assign("list_referedSearch",$list_referedSearch); $smarty->assign("category",$category); $smarty->assign("mr_category",$mr_category); $smarty->assign("u_category",$u_category); $smarty->assign("category_list",$category_list); $smarty->assign("is_category",$is_category); $smarty->assign("city",$city); $smarty->assign("mr_city",$mr_city); $smarty->assign("u_city",$u_city); $smarty->assign("city_list",$city_list); $smarty->assign("is_city",$is_city); $smarty->assign("profile",$profile); $smarty->assign("profile_category",$profile_category); $smarty->assign("profile_city",$profile_city); $smarty->assign("is_profile",$is_profile); $smarty->assign("depot",$depot); $smarty->assign("is_depot",$is_depot); if($_COOKIE['city'] != "") { $smarty->assign("bookmark",$_COOKIE['city']); } $smarty->display($template); ?>