user_exists) { $page = "error"; $smarty->assign('error_header', 639); $smarty->assign('error_message', 656); $smarty->assign('error_submit', 641); include "footer.php"; } function general(){ global $user, $database1, $database; if(isset($_POST['distance'])) { $distance = $_POST['distance']; } elseif(isset($_GET['distance'])) { $distance = $_GET['distance']; } else { $distance = "5"; } ?>
Select a Region: " />
database_query("SELECT id FROM bateworldcom_zips.countries WHERE name='".$database->database_real_escape_string($_GET["country"])."' LIMIT 1"); $row1=$database->database_fetch_array($query1); $country=$row1["id"]; $query=$database->database_query("SELECT latitude, longitude FROM bateworldcom_zips.zipcodes1, bateworldcom_zips.countries WHERE bateworldcom_zips.zipcodes1.postal_code='".$database->database_real_escape_string($_GET["zip"])."' AND bateworldcom_zips.countries.id='".$country."' AND bateworldcom_zips.countries.alpha_2=bateworldcom_zips.zipcodes1.country_code LIMIT 1"); } else{ $query=$database->database_query("SELECT latitude, longitude FROM bateworldcom_zips.zipcodes1 WHERE postal_code='".$database->database_real_escape_string($_GET["zip"])."' LIMIT 1"); } $row=$database->database_fetch_array($query); if($row["latitude"]!=""){ $coslat=cos(deg2rad($row["latitude"])); $sinlat=sin( deg2rad($row["latitude"]) ); $radlon=deg2rad($row["longitude"]); $sql1="SELECT country_code, place_name, admin_name1, admin_code1, postal_code, ( 3959 * acos( ".$coslat." * cos( radianslat ) * cos( radianslon - ".$radlon." ) + ".$sinlat." * sin( radianslat ) ) ) AS distance FROM bateworldcom_zips.zipcodes1 HAVING distance <= ".$database->database_real_escape_string($distance)." ORDER BY distance ASC LIMIT 0 , 10000"; $url_string1 .="field_27=".urlencode($zip)."&"; $query1=$database->database_query($sql1); $o=1; while($row1=$database->database_fetch_array($query1)) { if($o==1){ $zips="airbnbate.zip='".$row1["postal_code"]."'"; } else{ $zips.=" OR airbnbate.zip='".$row1["postal_code"]."'"; } $o++; } } else{$total_users=0;} } ?> database_real_escape_string($_REQUEST["country"])."' AND state='".$database->database_real_escape_string($_REQUEST["region"])."'"; $sql=$sql. "ORDER BY se_users.user_username"; $query=$database->database_query($sql);} else{ $sql="SELECT se_users.*, airbnbate.* FROM airbnbate, se_users WHERE se_users.user_id=airbnbate.userid AND country='".$database->database_real_escape_string($_REQUEST["country"])."'"; $sql=$sql."ORDER BY se_users.user_username ASC"; $query=$database->database_query($sql);} while($row=$database->database_fetch_array($query)) { ?>

Hosting in:
".$row["description"]; if(trim($row["airurl"])!=""){echo "

Air BnB URL
";} if(trim($row["misterurl"])!=""){echo "Mister BnB URL";} ?>
"> " height="60" width="60" />
See Full Profile

assign('forumcats', $forumcat_array); $smarty->assign('forum_is_moderator', $forum_is_moderator); include "footer.php"; ?>