get_user_ip(); $track['date_created'] = date("Y-m-d H:i:s"); $track['browser_type'] = $_SERVER['HTTP_USER_AGENT']; $track['page_type'] = "KML Download"; $track['url'] = $_SERVER['HTTP_HOST']; $tracking->insert($track); $search->set_filters(" AND FIND_IN_SET(p.location_id,:location_id)",":location_id",$_GET['location_string']); if(!empty($_GET['search_brand'])){ $search->set_filters(" AND FIND_IN_SET(p.brand_id,:brand_id)",":brand_id",$_GET['search_brand']); } if(!empty($_GET['type_id'])){ $search->set_filters(" AND FIND_IN_SET(p.type_id,:type_id)",":type_id",$_GET['type_id']); } if(eregi(",",$_GET['rating'])){ $search->set_filters(" AND FIND_IN_SET(p.rating,:rating)",":rating",$_GET['rating']); } else{ $search->set_filters(" AND p.rating>= :rating",":rating",$_GET['rating']); } if($_GET['is_featured']==1){ $search->set_filters(" AND p.is_featured= :is_featured",":is_featured",$_GET['is_featured']); } if(!empty($_GET['custom_field'])){ $search->set_filters(" AND FIND_IN_SET(pf.filter_id,:filter_id)",":filter_id",$_GET['custom_field']); } if(!empty($_GET['max_price'])){ $search->set_filters(" AND p.lowest_rate <= :lowest_rate",":lowest_rate",$_GET['max_price']); } if(!empty($_GET['bedrooms'])){ $search->set_filters(" AND r.bedrooms = :bedrooms",":bedrooms",$_GET['bedrooms']); } if(!empty($_GET['k'])){ $search->set_filters(" AND p.name LIKE :name",":name","%".$_GET['k']."%"); } if(!empty($_GET['property_facility'])){ $property_facility = explode(",",$_GET['property_facility']); if(is_array($property_facility)){ $count = 1; foreach($property_facility as $facility_key => $facility_val){ $search->set_filters(" AND FIND_IN_SET(:facility_list_$count,p.facility_list)",":facility_list_$count",$facility_val); $count++; } } } if(!empty($_GET['room_facility'])){ $room_facility = explode(",",$_GET['room_facility']); if(is_array($room_facility)){ $room_count = 1; foreach($room_facility as $room_facility_key => $room_facility_val){ $search->set_filters(" AND FIND_IN_SET(:room_facility_list_$room_count,r.facility_list)",":room_facility_list_$room_count",$room_facility_val); $room_count++; } } } $search->set_group_by("p.id"); $search->set_order_by("p.name ASC"); $results = $search->do_query("SELECT p.* FROM property p LEFT JOIN property_room r ON r.property_id=p.id LEFT JOIN property_filter pf ON p.id=pf.property_id WHERE p.is_active=0"); if(!empty($results)){ header("Content-Type: application/vnd.google-earth.kml+xml"); echo ''; ?> $data){?>

Visit Website
]]>
,