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"; } ?>
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;} } ?>| =$row["user_username"]?> Hosting in: if(trim($row["city"])!=""){echo $row["city"].", ";} if(trim($row["state"])!=""){echo $row["state"]." ";} if(trim($row["zip"])!=""){echo "".$row["zip"]." ";} if(trim($row["country"])!=""){echo $row["country"]." ";} echo " ".$row["description"]; if(trim($row["airurl"])!=""){echo " Air BnB URL ";} if(trim($row["misterurl"])!=""){echo "Mister BnB URL";} ?> | "> if($row["user_photo"]==""){?> }else{
$user_id=$row["userid"];
$subdir = $user_id+999-(($user_id-1)%1000);
$userdir = "./uploads_user/$subdir/$user_id/";
?>
See Full Profile |