require 'include/cfg.php'; function permayap($deger) { $turkce=array("ş","Ş","ı","(",")","'","ü","Ü","ö","Ö","ç","Ç"," ","/","*","?","ş","Ş","i","ğ","Ğ","I","ö","Ö","Ç","ç","ü","Ü","İ"); $duzgun=array("s","S","i","","","","u","U","o","O","c","C","-","-","-","","s","S","i","g","G","I","o","O","C","c","u","U","i"); $deger=str_replace($turkce,$duzgun,$deger); $deger = preg_replace("@[^A-Za-z0-9\-_]+@i","",$deger); return $deger; } if ($_GET['kmx'] == 1) { $_SESSION['gn'] = ""; $_SESSION['m_wrd'] = ""; $_SESSION['m_tipi1'] = ""; $_SESSION['m_tipi2'] = ""; $_SESSION['m_tipi3'] = ""; $_SESSION['m_tipi4'] = ""; $_SESSION['m_per']=""; $_SESSION['m_banyo']=""; $_SESSION['m_oda']=""; $_SESSION['m_fy1']=""; $_SESSION['m_fy2']=""; $_SESSION['m_mkare1']=""; $_SESSION['m_mkare2']=""; $_SESSION['m_kelime']=""; $_SESSION['m_sehirler_id']=""; $_SESSION['m_ilceler_id']=""; $_SESSION['m_semtler_id']=""; } if ( ($_GET['sfr'] == 1) || ($_GET['rnd'] > 0) || ($_GET['prs'] > 0) ) { $_SESSION['m_wrd'] = ""; $_SESSION['gn'] = ""; $_SESSION['m_durum'] = ""; $_SESSION['m_turu'] = ""; $_SESSION['m_tipi1'] = ""; $_SESSION['m_tipi2'] = ""; $_SESSION['m_tipi3'] = ""; $_SESSION['m_tipi4'] = ""; $_SESSION['m_per']=""; $_SESSION['m_banyo']=""; $_SESSION['m_oda']=""; $_SESSION['m_fy1']=""; $_SESSION['m_fy2']=""; $_SESSION['m_mkare1']=""; $_SESSION['m_mkare2']=""; $_SESSION['m_kelime']=""; $_SESSION['m_sehirler_id']=""; $_SESSION['m_ilceler_id']=""; $_SESSION['m_semtler_id']=""; } $fullurl = 'https://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $gridurl = str_replace('list.php', 'grid.php', $fullurl); $listurl = str_replace('grid.php', 'list.php', $fullurl); $sonuc = strpos($fullurl,"?"); if ($sonuc === false) { $fullurl = $fullurl."?ydk=1"; $mturl = $fullurl."?bs=1"; } else { $mturl = $fullurl; } //echo "mt:".$mturl; $ek = ""; $SQL = "firma ='$firmaid' && onay = '1' && yayin ='1' "; $mtlinki = str_replace('&xv='.$_GET['xv'].'','',$mturl); $mtlinki = str_replace('&ar=1','',$mtlinki); $mtlinki = str_replace('&vt=1','',$mtlinki); $mtlinki = str_replace('&bs=1','',$mtlinki); $mtlinki = str_replace('&mt=1','',$mtlinki); $mtlinki = str_replace('&mt=2','',$mtlinki); $mtlinki = str_replace('&mt=3','',$mtlinki); $mtlinki = str_replace('&mt=4','',$mtlinki); $mtlinki = str_replace('&mt=5','',$mtlinki); $mtlinki = str_replace('&mt=6','',$mtlinki); $mtlinki = str_replace('&mt=7','',$mtlinki); $mtlinki = str_replace('&mt=8','',$mtlinki); $mtlinki = str_replace('&sr='.$_GET['sr'].'','',$mtlinki); $mtlinki = str_replace('&&','&',$mtlinki); //echo "mtlink:".$mtlinki; $ordlinki = str_replace('&ord=1','',$fullurl); $ordlinki = str_replace('&ord=2','',$fullurl); $ordlinki = str_replace('&ord=3','',$fullurl); $ordlinki = str_replace('&ord=4','',$fullurl); $ordlinki = str_replace('&ord=5','',$fullurl); $ordlinki = str_replace('&ord=6','',$fullurl); $ordlinki = str_replace('&ord=7','',$fullurl); $ordlinki = str_replace('&ord=8','',$fullurl); $ordlinki = str_replace('&ord=9','',$fullurl); $ordlinki = str_replace('&ord=10','',$fullurl); $ordlinki = str_replace('&&','&',$ordlinki); if (($_GET['fs'] != 1) && ($_POST['firstsearch'] != 1) && (isset($_SESSION['onyuzsearch']))) { }else {} $_SESSION['onyuzsearch'] = ""; // SIFIRLA $yazilar = ""; $hangireklam = "reklam5"; $hangiikon = "1"; $k = $_GET['k']; if (!$k) { $k = "0"; } $liste = $_GET['liste']; $sirayagore = "asc"; $yeniliste = "0"; if ($liste == 0) { $sirayagore = "desc"; $yeniliste = "1"; } // PERSONELİN DİĞER İLANLARI if($_GET['prs'] > 0) { $SQL .="AND personel = '$_GET[prs]' "; $ek .= "&prs=$_GET[prs]"; } // FİRMANIN DİĞER İLANLARI if($_GET['rnd'] > 0) { $SQL .="AND firma = '$_GET[rnd]' "; $ek .= "&rnd=$_GET[rnd]"; } // ANAHTAR KEL�ME if ($_POST['m_wrdx'] != "") { $wrd = $_POST['m_wrdx']; $_SESSION['m_wrdx'] = $wrd; $words = explode(" ",$wrd); for($i=0;$i 0) { $_SESSION['m_sehirler_id'] = "$_POST[m_sehirler_id]";$SQL .="AND sehir = '$_SESSION[m_sehirler_id]' "; $bolge1 = $_SESSION['m_sehirler_id']; $shr = "&bolge1=$_SESSION[m_sehirler_id]"; $ek .= "&sehirler_id=$_SESSION[m_sehirler_id]";} if ($_SESSION['m_sehirler_id'] > 0) { $SQL .="AND sehir = '$_SESSION[m_sehirler_id]' "; $bolge1 = $_SESSION['m_sehirler_id']; $shr = "&bolge1=$_SESSION[m_sehirler_id]"; $ek .= "&sehirler_id=$_SESSION[m_sehirler_id]";} if ($_POST['m_ilceler_id'] > 0) { $_SESSION['m_ilceler_id'] = "$_POST[m_ilceler_id]"; $SQL .="AND ilce = '$_SESSION[m_ilceler_id]' "; $bolge2 = $_SESSION['m_ilceler_id']; $ilc = "&bolge2=$_SESSION[m_ilceler_id]"; $ek .= "&bolge2=$_SESSION[m_ilceler_id]"; } if ($_SESSION['m_ilceler_id'] > 0) { $SQL .="AND ilce = '$_SESSION[m_ilceler_id]' "; $bolge2 = $_SESSION['m_ilceler_id']; $ilc = "&bolge2=$_SESSION[m_ilceler_id]"; $ek .= "&bolge2=$_SESSION[m_ilceler_id]"; } if($_POST['sidebarsearch'] == '1') { $_SESSION['semtara']=""; } if ($_POST['m_semtler_id'] > 0) { $_SESSION['m_semtler_id']=""; $smtlrid = $_POST['m_semtler_id']; $toplamsemtvar = count($smtlrid); if( (isset($_POST['m_semtler_id'])) && (strlen($toplamsemtvar) >= 1) ){ $_SESSION['m_semtler_id']=array(); $_SESSION['m_semtler_id'] = $_POST['m_semtler_id']; if(isset($_SESSION['m_semtler_id'])){ array_push($_SESSION['m_semtler_id'],$_POST['m_semtler_id']); $SQL .="AND ("; foreach ($_POST['m_semtler_id'] as $seci) { if ($seci > 0) { $semtara .="semt = '$seci' OR "; } } $SQL .= substr($semtara, 0, -4).") "; $sess_semtara = substr($semtara, 0, -4).") "; }} $_SESSION['semtara'] = $sess_semtara; } else { if (strlen($_SESSION['semtara']) > 5) { $SQL .="AND ("; $SQL .= $_SESSION['semtara']; } } //if ($_SESSION['m_semtler_id'] > 0) { $SQL .="AND semt = '$_SESSION[m_semtler_id]' "; //$bolge3 = $_SESSION['m_semtler_id']; $ilc = "&bolge2=$_SESSION[m_semtler_id]"; $ek .= "&bolge2=$_SESSION[m_semtler_id]"; } // METREKARE if ($_POST['m_mkare1'] > 0) {$_SESSION['m_mkare1'] = "$_POST[m_mkare1]";$SQL .="AND mkare >= $_SESSION[m_mkare1] "; $ek .= "&mkare1=$_POST[m_mkare1]";} if ($_SESSION['m_mkare1'] > 0) {$SQL .="AND mkare >= $_SESSION[m_mkare1] "; $ek .= "&mkare1=$_SESSION[m_mkare1]";} if ($_POST['m_mkare2'] > 0) {$_SESSION['m_mkare2'] = "$_POST[m_mkare2]";$SQL .="AND mkare <= $_SESSION[m_mkare2] "; $ek .= "&mkare2=$_POST[m_mkare2]";} if ($_SESSION['m_mkare2'] > 0) {$SQL .="AND mkare <= $_SESSION[m_mkare2] "; $ek .= "&mkare2=$_SESSION[m_mkare2]";} // F�YAT if ($_POST['m_fy1'] > 0) {$_SESSION['m_fy1'] = "$_POST[m_fy1]";$SQL .="AND fiyat >= $_SESSION[m_fy1] "; $ek .= "&fy1=$_POST[m_fy1]";} if ($_SESSION['m_fy1'] > 0) {$SQL .="AND fiyat >= $_SESSION[m_fy1] "; $ek .= "&fy1=$_SESSION[m_fy1]";} if ($_POST['m_fy2'] > 0) {$_SESSION['m_fy2'] = "$_POST[m_fy2]";$SQL .="AND fiyat <= $_SESSION[m_fy2] "; $ek .= "&fy2=$_POST[m_fy2]";} if ($_SESSION['m_fy2'] > 0) {$SQL .="AND fiyat <= $_SESSION[m_fy2] "; $ek .= "&fy2=$_SESSION[m_fy2]";} // ODA SAYISI if ($_POST['m_oda'] > 0) {$_SESSION['m_oda'] = "$_POST[m_oda]";$SQL .="AND oda = $_SESSION[m_oda] "; $ek .= "&oda=$_POST[m_oda]";} if ($_SESSION['m_oda'] > 0) {$SQL .="AND oda = $_SESSION[m_oda] "; $ek .= "&oda=$_SESSION[m_oda]";} // ODA SAYISI if ($_POST['m_banyo'] > 0) {$_SESSION['m_banyo'] = "$_POST[m_banyo]"; $SQL .="AND banyo = $_SESSION[m_banyo] "; $ek .= "&banyo=$_POST[m_banyo]";} if ($_SESSION['m_banyo'] > 0) {$SQL .="AND banyo = $_SESSION[m_banyo] "; $ek .= "&banyo=$_SESSION[m_banyo]";} // PERSONEL if ($_POST['m_per'] != "") {$per = $_POST['m_per'];$_SESSION['m_per'] = $per;$SQL .="AND personel = $per "; $ek .= "&per=$_POST[m_per]";} if ($_SESSION['m_per'] != "") {$per = $_SESSION['m_per']; $SQL .="AND personel = $per "; $ek .= "&per=$_SESSION[m_per]";} // PROJE if ($_POST['m_prj'] != "") {$prj = $_POST['m_prj'];$_SESSION['m_prj'] = $prj;$SQL .="AND projesi = $prj ";$prj = "&prj=$_POST[prj]";$ek .= "&prj=$_POST[m_prj]";} if ($_SESSION['m_prj'] != "") {$prj = $_SESSION['m_prj'];$SQL .="AND projesi = $prj ";$prj = "&prj=$prj";$ek .= "&prj=$prj";} // DURUM if (($_GET['durum'] != "") && ($_GET['durum'] > 0)) { $durum = $_GET['durum']; $_SESSION['m_durum'] = $durum; if ($durum != 3) { $SQL .="AND durum = $durum "; } else { if ($_GET['kmx'] != 1) { $SQL .="AND odemeturu = '1' "; } } if ($_GET['gn'] == 1) { $SQL .="AND odemeturu = '1' AND durum = $durum "; $ek .= "&gn=$_GET[gn]"; } $ek .= "&durum=$_GET[durum]"; } if (($_POST['m_durum'] != "") && ($_POST['m_durum'] > 0)) { $durum = $_POST['m_durum']; $_SESSION['m_durum'] = $durum; if ($durum != 3) { $SQL .="AND durum = $durum "; } else { if ($_GET['kmx'] != 1) { $SQL .="AND odemeturu = '1' "; } } if ($_POST['gn'] == 1) { $SQL .="AND odemeturu = '1' AND durum = $durum "; $ek .= "&gn=$_GET[gn]"; } $ek .= "&durum=$_POST[m_durum]"; } if ( ($_SESSION['m_durum'] != "") && ($_GET['kmx'] != 1) ) { $durum = $_SESSION['m_durum']; if ($durum != 3) { $SQL .="AND durum = $durum "; } else { if ($_GET['kmx'] != 1) { $SQL .="AND odemeturu = '1' "; } } if ($_SESSION['gn'] == 1) { $SQL .="AND odemeturu = '1' AND durum = $durum "; $ek .= "&gn=$_GET[gn]"; } $ek .= "&durum=$durum";} // EMLAK TİPİ if ($_POST['m_tipi1'] != "") { $tipi = $_POST['m_tipi1']; $_SESSION['m_tipi1'] = $tipi; $SQL .="AND tur = $tipi "; $ek .= "&tipi=$tipi";} if ($_SESSION['m_tipi1'] != "") { $tipi = $_SESSION['m_tipi1']; $SQL .="AND tur = $tipi "; $ek .= "&tipi=$tipi";} if ($_POST['m_tipi2'] != "") { $tipi = $_POST['m_tipi2']; $_SESSION['m_tipi2'] = $tipi; $SQL .="AND tur = $tipi "; $ek .= "&tipi=$tipi"; } if ($_SESSION['m_tipi2'] != "") { $tipi = $_SESSION['m_tipi2']; $SQL .="AND tur = $tipi "; $ek .= "&tipi=$tipi";} if ($_POST['m_tipi3'] != "") { $tipi = $_POST['m_tipi3']; $_SESSION['m_tipi3'] = $tipi; $SQL .="AND tur = $tipi "; $ek .= "&tipi=$tipi"; } if ($_SESSION['m_tipi3'] != "") { $tipi = $_SESSION['m_tipi3']; $SQL .="AND tur = $tipi "; $ek .= "&tipi=$tipi";} if ($_POST['m_tipi4'] != "") { $tipi = $_POST['m_tipi4']; $_SESSION['m_tipi4'] = $tipi; $SQL .="AND tur = $tipi "; $ek .= "&tipi=$tipi"; } if ($_SESSION['m_tipi4'] != "") { $tipi = $_SESSION['m_tipi4']; $SQL .="AND tur = $tipi "; $ek .= "&tipi=$tipi";} // EMLAK TÜRÜ if (($_GET['tip'] != "") && ($_GET['tip'] > 0)) { $turu = $_GET['tip']; $_SESSION['m_turu'] = $turu; $SQL .="AND tip = $turu "; $ek .= "&turu=$_GET[tip]"; } if ($_POST['m_turu'] != "") { $turu = $_POST['m_turu']; $_SESSION['m_turu'] = $turu; $SQL .="AND tip = $turu "; $ek .= "&turu=$_POST[turu]"; } if ( ($_SESSION['m_turu'] != "") && ($_GET['kmx'] != 1) ) { $turu = $_SESSION['m_turu']; $SQL .="AND tip = $turu "; $ek .= "&turu=$turu"; } if ($turu <= 0) { $_SESSION['m_tipi1'] = ""; $_SESSION['m_tipi2'] = ""; $_SESSION['m_tipi3'] = ""; $_SESSION['m_tipi4'] = ""; } // MAL SAHIBI if ($_POST['m_sah'] != "") {$sah = $_POST['m_sah'];$_SESSION['m_sah'] = $sah;$SQL .="AND malsahibi = $sah "; $ek .= "&sah=$_POST[m_sah]";} if ($_SESSION['m_sah'] != "") {$sah = $_SESSION['m_sah'];$SQL .="AND malsahibi = $sah "; $ek .= "&sah=$_POST[m_sah]";} // first search $ekleme = date('Y-m-d'); $eklenenzaman = strtotime($ekleme); $_SESSION['SQL'] = $SQL; //echo $SQL; //echo $SQL; if ($_GET['mt'] > 0) { $_SESSION['mt'] = $_GET['mt']; $ek .= "&mt=$_GET[mt]"; } if ($_GET['vt'] == 1) { $_SESSION['vt'] = "1"; $ek .= "&vt=1"; } if ($_GET['ar'] == 1) { $_SESSION['ar'] = "1"; $ek .= "&ar=1"; } if ($_GET['kmx'] == 1) { if ($_GET['durum'] == 2) { //$SQL .=" AND reklam2 = 1 "; $ek .= "&kmx=1"; } if ($_GET['durum'] == 1) { //$SQL .=" AND reklam1 = 1 "; $ek .= "&kmx=1"; } } if ($_GET['ord'] == 1) { $ordlinki = str_replace('&ord=1','',$fullurl); $_SESSION['ord'] = "1"; $neyegore = "sehir"; $sirayagore = 'asc'; $ek .= "&ord=1"; } elseif ($_GET['ord'] == 2) { $ordlinki = str_replace('&ord=2','',$fullurl); $_SESSION['ord'] = "2"; $neyegore = "ilce"; $sirayagore = 'desc'; $ek .= "&ord=2"; } elseif ($_GET['ord'] == 3) { $ordlinki = str_replace('&ord=3','',$fullurl); $_SESSION['ord'] = "3"; $neyegore = "semt"; $sirayagore = 'asc'; $ek .= "&ord=3"; } elseif ($_GET['ord'] == 4) { $ordlinki = str_replace('&ord=4','',$fullurl); $_SESSION['ord'] = "4"; $neyegore = "tip"; $sirayagore = 'desc'; $ek .= "&ord=4"; } elseif ($_GET['ord'] == 5) { $ordlinki = str_replace('&ord=5','',$fullurl); $_SESSION['ord'] = "5"; $neyegore = "mkare"; $sirayagore = 'asc'; $ek .= "&ord=5"; } elseif ($_GET['ord'] == 6) { $ordlinki = str_replace('&ord=6','',$fullurl); $_SESSION['ord'] = "6"; $neyegore = "oda"; $sirayagore = 'desc'; $ek .= "&ord=6"; } elseif ($_GET['ord'] == 7) { $ordlinki = str_replace('&ord=7','',$fullurl); $_SESSION['ord'] = "7"; $neyegore = "fiyat"; $sirayagore = 'asc'; $ek .= "&ord=7"; } elseif ($_GET['ord'] == 8) { $ordlinki = str_replace('&ord=8','',$fullurl); $_SESSION['ord'] = "8"; $neyegore = "eklenenzaman"; $sirayagore = 'desc'; $ek .= "&ord=8"; } elseif ($_GET['ord'] == 9) { $ordlinki = str_replace('&ord=9','',$fullurl); $_SESSION['ord'] = "9"; $neyegore = "onaylananzaman"; $sirayagore = 'desc'; $ek .= "&ord=9"; } elseif ($_GET['ord'] == 10) { $ordlinki = str_replace('&ord=10','',$fullurl); $_SESSION['ord'] = "10"; $neyegore = "onaylananzaman"; $sirayagore = 'desc'; $ek .= "&ord=10"; } else { $ordlinki = $fullurl; $_SESSION['ord'] = "0"; $neyegore = "$hangireklam desc, id "; $sirayagore="desc"; $ek .= ""; } $ordlinki = str_replace('&&','&',$ordlinki); $ordlinki = str_replace('&','&',$ordlinki); if ($_SESSION['admin'] == 0) { $pl = " && personel = '$personelid' "; } else { $pl = ""; } //$expi = " && expire>$expire"; //$ek = ""; //$SQL = "akg ='$akg' "; // GÜNLÜK KİRALIK if ($_GET['gn'] == 1) { $kmx_o = $_GET['gn']; $_SESSION['m_durum'] = "3"; $_SESSION['gn'] = $gn; if ($_GET['kmx'] != 1) { $SQL .="AND odemeturu = '1' "; } $gn .= "&gn=$_GET[gn]"; } if ($_GET['gn'] == 1) { $_SESSION['m_durum'] = "3"; $_SESSION['gn'] = "1"; $ek .= "&gn=1"; } $xyazilar = ""; $hangireklam = "reklam5"; $hangiikon = "1"; $k = $_GET['k']; if (!$k) { $k = "0"; } $baslik = ""; $liste = $_GET['liste']; $orderx = $_GET['ord']; $sirayagore = "asc"; $yeniliste = "0"; if ($liste == 0) { $sirayagore = "desc"; $yeniliste = "1"; } if ($orderx == 0) { $neyegore = " rand() "; $sirayagore="desc"; } elseif ($orderx == 1) { $neyegore = "oda"; $sirayagore="asc"; } elseif ($orderx == 2) { $neyegore = "oda"; $sirayagore="desc"; } elseif ($orderx == 3) { $neyegore = "mkare"; $sirayagore="asc"; } elseif ($orderx == 4) { $neyegore = "mkare"; $sirayagore="desc"; } elseif ($orderx == 5) { $neyegore = "fiyat"; $sirayagore="asc"; } elseif ($orderx == 6) { $neyegore = "fiyat"; $sirayagore="desc"; } elseif ($orderx == 7) { $neyegore = "eklenenzaman"; $sirayagore="asc"; } elseif ($orderx == 8) { $neyegore = "eklenenzaman"; $sirayagore="desc"; } elseif ($orderx == 9) { $neyegore = "onaylananzaman"; $sirayagore="asc"; } elseif ($orderx == 10) { $neyegore = "onaylananzaman"; $sirayagore="desc"; } else { $neyegore = " rand() "; $sirayagore="desc"; } $sonsure = date("Y-m-d"); $expire = strtotime($sonsure); //$SQLx = $SQL."AND expire>$expire"; $_SESSION['onyuzsearch'] = $SQL; $SQLx = $SQL; if($_POST['sidebarsearch'] == '1') { echo ""; exit(); } $sayfa = "emlaklist"; $perpage = "12"; $SQLx = $SQL.$expdate; if (!isset($liste)) { $liste = "0"; } $ressec1 = "select * from ilanlar where $SQLx order by $neyegore $sirayagore limit $k, $perpage"; $genelsayi1 = "select * from ilanlar where $SQLx"; //echo $ressec1; //$numbers_array = extract_numbers($_SESSION['SemtSQL']); //$tr_numbers_array = extract_numbers($_SESSION['trSQL']); //$trz_numbers_array = extract_numbers($_SESSION['trzSQL']); //$gz_numbers_array = extract_numbers($_SESSION['gzSQL']); //$rm_numbers_array = extract_numbers($_SESSION['rmSQL']); //$kl_numbers_array = extract_numbers($_SESSION['klSQL']); //$rl_numbers_array = extract_numbers($_SESSION['rlSQL']); //$tp_numbers_array = extract_numbers($_SESSION['tpSQL']); //$km_numbers_array = extract_numbers($_SESSION['kmSQL']); //$hl_numbers_array = extract_numbers($_SESSION['hlSQL']); //$bn_numbers_array = extract_numbers($_SESSION['bnSQL']); $ressec = mysqli_query($dbhandle,$ressec1); $genelsayi = mysqli_query($dbhandle,$genelsayi1); $toplamkayit = mysqli_num_rows($genelsayi); include 'Pagination.php'; if (!isset($liste)) { $liste = "0"; } ?> $title = "Arama Sonuçları"; if (($_GET['durum'] == 2) && ($_GET['tip'] == 31)) { $title = __('Sabit_Satilikkonut'); } if (($_GET['durum'] == 1) && ($_GET['tip'] == 31)) { $title = __('Sabit_Kiralikkonut'); } if (($_GET['durum'] == 3) && ($_GET['tip'] == 31) && ($_GET['gn'] == 1)) { $title = __('Sabit_GunlukKiralik'); } if (($_GET['durum'] == 2) && ($_GET['tip'] == 32)) { $title = __('Sabit_Satilikticari'); } if (($_GET['durum'] == 1) && ($_GET['tip'] == 32)) { $title = __('Sabit_Kiralikticari'); } if (($_GET['durum'] == 2) && ($_GET['tip'] == 33)) { $title = __('Sabit_Satilikarsa'); } if (($_GET['durum'] == 1) && ($_GET['tip'] == 33)) { $title = __('Sabit_Kiralikarsa'); } if (($_GET['durum'] == 2) && ($_GET['tip'] == 34)) { $title = __('Sabit_SatilikTuristikTesis'); } if (($_GET['durum'] == 1) && ($_GET['tip'] == 34)) { $title = __('Sabit_KiralikTuristikTesis'); } if (($_SESSION['m_durum'] == 2) && ($_SESSION['m_tip'] == 31)) { $title = __('Sabit_Satilikkonut'); } if (($_SESSION['m_durum'] == 1) && ($_SESSION['m_tip'] == 31)) { $title = __('Sabit_Kiralikkonut'); } if ($_SESSION['m_durum'] == 3) { $title = __('Sabit_GunlukKiralik'); } if (($_SESSION['m_durum'] == 2) && ($_SESSION['m_tip'] == 32)) { $title = __('Sabit_Satilikticari'); } if (($_SESSION['m_durum'] == 1) && ($_SESSION['m_tip'] == 32)) { $title = __('Sabit_Kiralikticari'); } if (($_SESSION['m_durum'] == 2) && ($_SESSION['m_tip'] == 33)) { $title = __('Sabit_Satilikarsa'); } if (($_SESSION['m_durum'] == 1) && ($_SESSION['m_tip'] == 33)) { $title = __('Sabit_Kiralikarsa'); } if (($_SESSION['m_durum'] == 2) && ($_SESSION['m_tip'] == 34)) { $title = __('Sabit_SatilikTuristikTesis'); } if (($_SESSION['m_durum'] == 1) && ($_SESSION['m_tip'] == 34)) { $title = __('Sabit_KiralikTuristikTesis'); } if ($_GET['rnd'] > 0) { $secim = mysqli_query($dbhandle,"select * from uyeler where id = '$_GET[rnd]' limit 1"); while ($sk = mysqli_fetch_row($secim)) { $title = $sk[14]; } } // title yoksa if (strlen($title) < 2) { // durum if (isset($_SESSION['m_durum'])) { $ert = @mysqli_query($dbhandle,"select id,durum from durum where id= ".$_SESSION['m_durum']." && id != '' limit 1"); if (mysqli_num_rows($ert) > 0) { while ($tz = mysqli_fetch_row($ert)) { $title = "".__($tz[1]).""; }}} // durum // m_turu if (isset($_SESSION['m_turu'])) { $ert = @mysqli_query($dbhandle,"select id,tip from emlaktipi where id= ".$_SESSION['m_turu']." && id != '' limit 1"); if (mysqli_num_rows($ert) > 0) { while ($tz = mysqli_fetch_row($ert)) { $title .= " "."".__($tz[1]).""; }}} // m_turu // m_tipi1 if (isset($_SESSION['m_tipi1'])) { $ert = @mysqli_query($dbhandle,"select id,tip from emlaktipi where tur = '31' && id= ".$_SESSION['m_tipi1']." && id != '' limit 1"); if (mysqli_num_rows($ert) > 0) { while ($tz = mysqli_fetch_row($ert)) { $title .= " - "."".__($tz[1]).""; }}} // m_tipi1 // m_tipi1 if (isset($_SESSION['m_tipi2'])) { $ert = @mysqli_query($dbhandle,"select id,tip from emlaktipi where tur = '32' && id= ".$_SESSION['m_tipi2']." && id != '' limit 1"); if (mysqli_num_rows($ert) > 0) { while ($tz = mysqli_fetch_row($ert)) { $title .= " - "."".__($tz[1]).""; }}} // m_tipi1 // m_tipi1 if (isset($_SESSION['m_tipi3'])) { $ert = @mysqli_query($dbhandle,"select id,tip from emlaktipi where tur = '33' && id= ".$_SESSION['m_tipi3']." && id != '' limit 1"); if (mysqli_num_rows($ert) > 0) { while ($tz = mysqli_fetch_row($ert)) { $title .= " - "."".__($tz[1]).""; }}} // m_tipi1 // m_tipi1 if (isset($_SESSION['m_tipi4'])) { $ert = @mysqli_query($dbhandle,"select id,tip from emlaktipi where tur = '34' && id= ".$_SESSION['m_tipi4']." limit 1"); if (mysqli_num_rows($ert) > 0) { while ($tz = mysqli_fetch_row($ert)) { $title .= " - "."".__($tz[1]).""; }}} // m_tipi1 } // title yoksa if ($_GET['prs'] > 0) { $perb = mysqli_query($dbhandle,"select ad,soyad,firma,id from uyeler where id = '$_GET[prs]'"); while ($tv = mysqli_fetch_array($perb)) { if ($tv['firma'] > 0) { $tvs = $tv['firma']; } else { $tvs = $tv['id']; } $secim = mysqli_query($dbhandle,"select isyeriadikisa from uyeler where id = '$tvs' limit 1"); while ($sk = mysqli_fetch_row($secim)) { //$title = $sk[0]; } $title = "".__('Uyemenu_Temsilci')." : ".$tv["ad"]." ".$tv["soyad"].""; } } ?> include 'meta.php'; $popup = "0"; $yt = mysqli_query($dbhandle,"select * from sitereklamlari where yer = 'Popup' && yayin = '1' limit 1"); while ($sc = mysqli_fetch_row($yt)) { $dosyaadi = $sc[1].".".$sc[2]; $ustlink = $sc[7]; if (!file_exists('assets/site_banners/'.$dosyaadi)) { $popup = '0'; } else { $popup = "1"; $popupimage = "assets/site_banners/".$dosyaadi; } } if ($popup == 1) { ?> } ?> include 'header.php'; ?> if ($toplamkayit == 0) { ?> Aradığınız kriterlerde ilan bulunamamıştır YENİDEN ARA } else { ?>