include "../inc-ayar.php"; ?> // zoom level bulunuyor if(!$zoom) { $zoom=9; } // sehir sqli ayarlaniyor $sehiridsql=""; if(is_numeric($sehirid)) { $sehiridsql=" AND sehirid='$sehirid'";} // zinciri belli ies $zincirsql=""; if(is_numeric($zincirid)) { $zincirsql=" AND anazincirid='$zincirid'";} // enlem boylami belli ise if($enlem AND $boylam) { $uzakliksql=""; $sqlbolge=""; // mesefasi yakin olan restoranlar sadece $uzakliksql=", ACOS(SIN(RADIANS($enlem)) * SIN(RADIANS(`enlem`)) + COS(RADIANS($enlem)) * COS(RADIANS(`enlem`)) * COS( RADIANS(`boylam`) - RADIANS($boylam))) * 6371 AS `distance`"; $sqlbolge=" AND IFNULL(ACOS(SIN(RADIANS($enlem)) * SIN(RADIANS(`enlem`)) + COS(RADIANS($enlem)) * COS(RADIANS(`enlem`)) * COS( RADIANS(`boylam`) - RADIANS($boylam))) * 6371,0) < 50"; $sql="select *$uzakliksql from mekan where anazincirid<>'0' AND yayin='1' $sehiridsql $zincirsql $sqlbolge ORDER BY distance limit 10"; $sonuc=sql_query($sql); } else { // zincir subeleri ceikiliyor ceikiliyor $sql="select * from mekan where anazincirid<>'0' AND yayin='1' $sehiridsql $zincirsql limit 1000"; $sonuc=sql_query($sql); } $haritaenlemboylamlar=""; $haritaaciklamalar=""; while($a=sql_fetch_array($sonuc)) { $sehirwwwisim=wwwismidonustur($sdsehirler[$a[sehirid]]); $a[isim]=addslashes($a[isim]); $haritaenlemboylamlar.="['$a[isim]', $a[enlem],$a[boylam]],"; $haritaaciklamalar.="['