database_select("bateworldcom_zips"); $coslat=cos(deg2rad($_GET["lat"])); $sinlat=sin( deg2rad($_GET["lat"]) ); $radlon=deg2rad($_GET["long"]); $query=$database->database_query("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 < 25 ORDER BY distance ASC LIMIT 0 , 10000"); $t=0; $zips=""; //$database->database_select("bateworld"); while($row=$database->database_fetch_array($query)) {// if($zips==""){ $zips="se_profilevalues.profilevalue_27='".$row["postal_code"]."'"; } else{ $zips=$zips." OR se_profilevalues.profilevalue_27='".$row["postal_code"]."'"; } } //if($row["country_code"]=="US") { $sql="SELECT * FROM se_users, se_profilevalues WHERE se_users.user_id=se_profilevalues.profilevalue_user_id AND user_lastactive>='".(time()-(60*60*24*90))."' AND (".$zips.")"; if($_GET["membername"]!=""){ $sql=$sql." AND se_profilevalues.profilevalue_2='".$_GET["membername"]."'"; } if($_GET["min"]!="-1"){ $sql=$sql." AND se_profilevalues.profilevalue_4<='".$_GET["min"]."-".date("m")."-".date("d")."'"; } if($_GET["max"]!="-1"){ $sql=$sql." AND se_profilevalues.profilevalue_4>='".$_GET["max"]."-".date("m")."-".date("d")."'"; } if($_GET["orientation"]!="-1"){ $sql=$sql." AND se_profilevalues.profilevalue_10='".$_GET["orientation"]."'"; } if($_GET["size"]!="-1"){ $sql=$sql." AND se_profilevalues.profilevalue_9='".$_GET["size"]."'"; } if($_GET["cut"]!="-1"){ $sql=$sql." AND se_profilevalues.profilevalue_15='".$_GET["cut"]."'"; } if($_GET["bodytype"]!="-1"){ $sql=$sql." AND se_profilevalues.profilevalue_28='".$_GET["bodytype"]."'"; } if($_GET["hair"]!="-1"){ $sql=$sql." AND se_profilevalues.profilevalue_16='".$_GET["hair"]."'"; } if($_GET["decoration"]!="-1"){ $sql=$sql." AND se_profilevalues.profilevalue_17='".$_GET["decoration"]."'"; } if($_GET["online"]=="1"){ $sql=$sql." AND user_lastactive>'".(time()-10*60)."' AND user_invisible=0 "; } if($_GET["photo"]=="1"){ $sql=$sql." AND user_photo <> '' "; } if($_GET["intro"]=="1"){ $sql=$sql." AND (introvid <> '' AND introapproved=1) "; } $sql.=" ORDER BY ".$_GET["sortby"]; $query1=$database->database_query($sql); while($row1=$database->database_fetch_array($query1)) { $owner1 = new SEUser(Array($row1["user_id"])); ?>
's Profile">=substr($row1["user_username"],0,10)?>
's Profile">=substr($row1["user_username"],0,10)?>