| 
	
 | 
 Posted by titecs on 12/11/06 10:06 
<?php 
include "baglan.php"; 
include "ilan_no.php"; 
include "ayarlar.php"; 
 
$baglan = @fopen("$dosya", 'r'); 
$dosya_boyutu = @filesize($dosya); 
$duyurular = @fread($baglan, $dosya_boyutu); 
@fclose($baglan); 
 
if(strlen($duyurular) > 0){ 
	$duyuru_veri = explode(";ß;", $duyurular); 
	$duyuru_baslik = $duyuru_veri[0]; 
	$duyuru_yazi = $duyuru_veri[1]; 
	$duyuru_yazi = stripslashes($duyuru_yazi); 
} 
 
 
$strSQL = "SELECT İstanbul FROM emlak_iller"; 
$sorgu = mysql_query($strSQL); 
 
$strSQL = "SELECT * FROM emlak_son_eklenenler"; 
$sorgu2 = mysql_query($strSQL); 
 
$son_toplam = mysql_num_rows($sorgu2); 
 
if($son_toplam > 0){ 
if($son_toplam > 0){ 
$son_1_kat_id = @mysql_result($sorgu2, $son_toplam - 1, "kat_id"); 
$son_1_emlak_id = @mysql_result($sorgu2, $son_toplam - 1, "emlak_id"); 
} 
if($son_toplam > 1){ 
$son_2_kat_id = @mysql_result($sorgu2, $son_toplam - 2, "kat_id"); 
$son_2_emlak_id = @mysql_result($sorgu2, $son_toplam - 2, "emlak_id"); 
} 
if($son_toplam > 2){ 
$son_3_kat_id = @mysql_result($sorgu2, $son_toplam - 3, "kat_id"); 
$son_3_emlak_id = @mysql_result($sorgu2, $son_toplam - 3, "emlak_id"); 
} 
if($son_toplam > 3){ 
$son_4_kat_id = @mysql_result($sorgu2, $son_toplam - 4, "kat_id"); 
$son_4_emlak_id = @mysql_result($sorgu2, $son_toplam - 4, "emlak_id"); 
} 
 
if($son_toplam > 0){ 
$strSQL = "SELECT * FROM emlak_kategoriler WHERE kat_id = 
'$son_1_kat_id'"; 
$sorgu3 = mysql_query($strSQL); 
 
$tablo1 = "emlak_emlaklar_".mysql_result($sorgu3, 0, "kat_tablo"); 
} 
 
if($son_toplam > 1){ 
$strSQL = "SELECT * FROM emlak_kategoriler WHERE kat_id = 
'$son_2_kat_id'"; 
$sorgu3 = mysql_query($strSQL); 
 
$tablo2 = "emlak_emlaklar_".mysql_result($sorgu3, 0, "kat_tablo"); 
} 
 
if($son_toplam > 2){ 
$strSQL = "SELECT * FROM emlak_kategoriler WHERE kat_id = 
'$son_3_kat_id'"; 
$sorgu3 = mysql_query($strSQL); 
 
$tablo3 = "emlak_emlaklar_".mysql_result($sorgu3, 0, "kat_tablo"); 
} 
 
if($son_toplam > 3){ 
$strSQL = "SELECT * FROM emlak_kategoriler WHERE kat_id = 
'$son_4_kat_id'"; 
$sorgu3 = mysql_query($strSQL); 
 
$tablo4 = "emlak_emlaklar_".mysql_result($sorgu3, 0, "kat_tablo"); 
} 
 
if($son_toplam > 0){ 
$strSQL = "SELECT * FROM $tablo1 WHERE emlak_id = '$son_1_emlak_id'"; 
$sorgu4 = mysql_query($strSQL); 
$resim1 = @mysql_result($sorgu4, 0, "resim"); 
$tip1 = @mysql_result($sorgu4, 0, "tur"); 
$tip1 = $tip1." ".mysql_result($sorgu4, 0, "tip"); 
$il1 = @mysql_result($sorgu4, 0, "il"); 
$ilce1 = @mysql_result($sorgu4, 0, "ilce"); 
$semt1 = @mysql_result($sorgu4, 0, "semt"); 
$kur1 = @mysql_result($sorgu4, 0, "kur"); 
 
if($son_1_kat_id !== "5"){ 
	$alan1 = @mysql_result($sorgu4, 0, "alan"); 
	$alan_karakter = strlen($alan1); 
	$alan_dongu = floor(($alan_karakter-1)/3); 
	$alan_bastan = $alan_karakter - ($alan_dongu*3); 
	$alan_son = substr($alan1, 0, $alan_bastan); 
	for($i = 1; $i <= $alan_dongu; $i++){ 
		$alan_son = $alan_son.".".substr($alan1, ((($i-1)*3)+$alan_bastan), 
3); 
	} 
	$alan1 = $alan_son."m²"; 
}else{ 
	$alan1 = ""; 
} 
 
if($resim1 == ""){ 
	$resim1 = "resim_yok.jpg"; 
} 
 
 
$fiyat1 = @mysql_result($sorgu4, 0, "fiyat"); 
 
 
if(strlen($fiyat1) > 9 && intval(substr($fiyat1, -9, 9)) == 0){ 
 
	$kalan_karakter = strlen($fiyat1) - 9; 
	$bastan_fiyati = substr($fiyat1, 0, $kalan_karakter); 
	$fiyat_son = $bastan_fiyati." Milyar"; 
}else{ 
 
	$fiyat_karakter = strlen($fiyat1); 
	$fiyat_dongu = floor(($fiyat_karakter-1)/3); 
	$fiyat_bastan = $fiyat_karakter - ($fiyat_dongu*3); 
	$fiyat_son = substr($fiyat1, 0, $fiyat_bastan); 
	for($i = 1; $i <= $fiyat_dongu; $i++){ 
		$fiyat_son = $fiyat_son.".".substr($fiyat1, 
((($i-1)*3)+$fiyat_bastan), 3); 
	} 
} 
$fiyat1 = $fiyat_son; 
 
 
$strSQL = "SELECT il FROM emlak_iller WHERE ilkod = '$il1'"; 
$sorgu5 = mysql_query($strSQL); 
$il1_1 = @mysql_result($sorgu5, 0, "il"); 
$yer1 = $il1_1." / ".$ilce1." / ".$semt1; 
} 
 
if($son_toplam > 1){ 
$strSQL = "SELECT * FROM $tablo2 WHERE emlak_id = '$son_2_emlak_id'"; 
$sorgu4 = mysql_query($strSQL); 
$resim2 = @mysql_result($sorgu4, 0, "resim"); 
$tip2 = @mysql_result($sorgu4, 0, "tur"); 
$tip2 = $tip2." ".mysql_result($sorgu4, 0, "tip"); 
$il2 = @mysql_result($sorgu4, 0, "il"); 
$ilce2 = @mysql_result($sorgu4, 0, "ilce"); 
$semt2 = @mysql_result($sorgu4, 0, "semt"); 
$kur2 = @mysql_result($sorgu4, 0, "kur"); 
 
if($son_2_kat_id !== "5"){ 
	$alan2 = @mysql_result($sorgu4, 0, "alan"); 
	$alan_karakter = strlen($alan2); 
	$alan_dongu = floor(($alan_karakter-1)/3); 
	$alan_bastan = $alan_karakter - ($alan_dongu*3); 
	$alan_son = substr($alan2, 0, $alan_bastan); 
	for($i = 1; $i <= $alan_dongu; $i++){ 
		$alan_son = $alan_son.".".substr($alan2, ((($i-1)*3)+$alan_bastan), 
3); 
	} 
	$alan2 = $alan_son."m²"; 
}else{ 
	$alan2 = ""; 
} 
 
if($resim2 == ""){ 
	$resim2 = "resim_yok.jpg"; 
} 
 
 
$fiyat2 = @mysql_result($sorgu4, 0, "fiyat"); 
 
if(strlen($fiyat2) > 9 && intval(substr($fiyat2, -9, 9)) == 0){ 
 
	$kalan_karakter = strlen($fiyat2) - 9; 
	$bastan_fiyati = substr($fiyat2, 0, $kalan_karakter); 
	$fiyat_son = $bastan_fiyati." Milyar"; 
}else{ 
 
	$fiyat_karakter = strlen($fiyat2); 
	$fiyat_dongu = floor(($fiyat_karakter-1)/3); 
	$fiyat_bastan = $fiyat_karakter - ($fiyat_dongu*3); 
	$fiyat_son = substr($fiyat2, 0, $fiyat_bastan); 
	for($i = 1; $i <= $fiyat_dongu; $i++){ 
		$fiyat_son = $fiyat_son.".".substr($fiyat2, 
((($i-1)*3)+$fiyat_bastan), 3); 
	} 
} 
$fiyat2 = $fiyat_son; 
 
$strSQL = "SELECT il FROM emlak_iller WHERE ilkod = '$il2'"; 
$sorgu5 = mysql_query($strSQL); 
$il2_1 = @mysql_result($sorgu5, 0, "il"); 
$yer2 = $il2_1." / ".$ilce2." / ".$semt2; 
} 
 
if($son_toplam > 2){ 
$strSQL = "SELECT * FROM $tablo3 WHERE emlak_id = '$son_3_emlak_id'"; 
$sorgu4 = mysql_query($strSQL); 
$resim3 = @mysql_result($sorgu4, 0, "resim"); 
$tip3 = @mysql_result($sorgu4, 0, "tur"); 
$tip3 = $tip3." ".mysql_result($sorgu4, 0, "tip"); 
$il3 = @mysql_result($sorgu4, 0, "il"); 
$ilce3 = @mysql_result($sorgu4, 0, "ilce"); 
$semt3 = @mysql_result($sorgu4, 0, "semt"); 
$kur3 = @mysql_result($sorgu4, 0, "kur"); 
 
if($son_3_kat_id !== "5"){ 
	$alan3 = @mysql_result($sorgu4, 0, "alan"); 
	$alan_karakter = strlen($alan3); 
	$alan_dongu = floor(($alan_karakter-1)/3); 
	$alan_bastan = $alan_karakter - ($alan_dongu*3); 
	$alan_son = substr($alan3, 0, $alan_bastan); 
	for($i = 1; $i <= $alan_dongu; $i++){ 
		$alan_son = $alan_son.".".substr($alan3, ((($i-1)*3)+$alan_bastan), 
3); 
	} 
	$alan3 = $alan_son."m²"; 
}else{ 
	$alan3 = ""; 
} 
 
if($resim3 == ""){ 
	$resim3 = "resim_yok.jpg"; 
} 
 
 
$fiyat3 = @mysql_result($sorgu4, 0, "fiyat"); 
 
if(strlen($fiyat3) > 9 && intval(substr($fiyat3, -9, 9)) == 0){ 
 
	$kalan_karakter = strlen($fiyat3) - 9; 
	$bastan_fiyati = substr($fiyat3, 0, $kalan_karakter); 
	$fiyat_son = $bastan_fiyati." Milyar"; 
}else{ 
 
	$fiyat_karakter = strlen($fiyat3); 
	$fiyat_dongu = floor(($fiyat_karakter-1)/3); 
	$fiyat_bastan = $fiyat_karakter - ($fiyat_dongu*3); 
	$fiyat_son = substr($fiyat3, 0, $fiyat_bastan); 
	for($i = 1; $i <= $fiyat_dongu; $i++){ 
		$fiyat_son = $fiyat_son.".".substr($fiyat3, 
((($i-1)*3)+$fiyat_bastan), 3); 
	} 
} 
$fiyat3 = $fiyat_son; 
 
$strSQL = "SELECT il FROM emlak_iller WHERE ilkod = '$il3'"; 
$sorgu5 = mysql_query($strSQL); 
$il3_1 = @mysql_result($sorgu5, 0, "il"); 
$yer3 = $il3_1." / ".$ilce3." / ".$semt3; 
} 
 
if($son_toplam > 3){ 
$strSQL = "SELECT * FROM $tablo4 WHERE emlak_id = '$son_4_emlak_id'"; 
$sorgu4 = mysql_query($strSQL); 
$resim4 = @mysql_result($sorgu4, 0, "resim"); 
$tip4 = @mysql_result($sorgu4, 0, "tur"); 
$tip4 = $tip4." ".mysql_result($sorgu4, 0, "tip"); 
$il4 = @mysql_result($sorgu4, 0, "il"); 
$ilce4 = @mysql_result($sorgu4, 0, "ilce"); 
$semt4 = @mysql_result($sorgu4, 0, "semt"); 
$kur4 = @mysql_result($sorgu4, 0, "kur"); 
 
if($son_4_kat_id !== "5"){ 
	$alan4 = @mysql_result($sorgu4, 0, "alan"); 
	$alan_karakter = strlen($alan4); 
	$alan_dongu = floor(($alan_karakter-1)/3); 
	$alan_bastan = $alan_karakter - ($alan_dongu*3); 
	$alan_son = substr($alan4, 0, $alan_bastan); 
	for($i = 1; $i <= $alan_dongu; $i++){ 
		$alan_son = $alan_son.".".substr($alan4, ((($i-1)*3)+$alan_bastan), 
3); 
	} 
	$alan4 = $alan_son."m²"; 
}else{ 
	$alan4 = ""; 
} 
 
if($resim4 == ""){ 
	$resim4 = "resim_yok.jpg"; 
} 
 
 
$fiyat4 = @mysql_result($sorgu4, 0, "fiyat"); 
 
if(strlen($fiyat4) > 9 && intval(substr($fiyat4, -9, 9)) == 0){ 
 
	$kalan_karakter = strlen($fiyat4) - 9; 
	$bastan_fiyati = substr($fiyat4, 0, $kalan_karakter); 
	$fiyat_son = $bastan_fiyati." Milyar"; 
}else{ 
 
	$fiyat_karakter = strlen($fiyat4); 
	$fiyat_dongu = floor(($fiyat_karakter-1)/3); 
	$fiyat_bastan = $fiyat_karakter - ($fiyat_dongu*3); 
	$fiyat_son = substr($fiyat4, 0, $fiyat_bastan); 
	for($i = 1; $i <= $fiyat_dongu; $i++){ 
		$fiyat_son = $fiyat_son.".".substr($fiyat4, 
((($i-1)*3)+$fiyat_bastan), 3); 
	} 
} 
$fiyat4 = $fiyat_son; 
 
$strSQL = "SELECT il FROM emlak_iller WHERE ilkod = '$il4'"; 
$sorgu5 = mysql_query($strSQL); 
$il4_1 = @mysql_result($sorgu5, 0, "il"); 
$yer4 = $il4_1." / ".$ilce4." / ".$semt4; 
} 
 
} 
 
 
$ilan_no1 = ilan_no($son_1_kat_id, $son_1_emlak_id); 
$ilan_no2 = ilan_no($son_2_kat_id, $son_2_emlak_id); 
$ilan_no3 = ilan_no($son_3_kat_id, $son_3_emlak_id); 
$ilan_no4 = ilan_no($son_4_kat_id, $son_4_emlak_id); 
 
?> 
<table width="742" border="0" align="center" class="sol_sag_alt" 
cellpadding="0" cellspacing="0"> 
  <tr> 
    <td width="150" bgcolor="#EBEEE5" valign="top"> 
	<? include "sol_menu.inc" ?> 
    </td> 
    <td width="460" height="100%" bgcolor="#D8DDCF" valign="top" 
align="center"> 
 
 
 
<TABLE width="100%" height="100%" border="0" cellspacing="0" 
cellpadding="1" class="sol_sag"> 
 
<TR> 
<TD valign="top"> 
<br> 
<center><b>SON EKLENEN 4 EMLAK</b></center> 
<br> 
<? if($son_toplam > 0){ ?> 
<table width="100%"  border="0" cellspacing="1" cellpadding="2"> 
  <tr> 
    <td rowspan="5" align="right" bgcolor="#FFFFFF" width="135"><a 
href="emlak_detay.php?kat=<?=$son_1_kat_id?>&eml=<?=$son_1_emlak_id?>"><IMG 
SRC="eml_img/thumb_<?=$resim1?>" width="135" height="100" 
BORDER="0"></a></td> 
	<td bgcolor="#F4F4F4"><b>İlan No</b></td> 
    <td bgcolor="#FFFFFF"><?=$ilan_no1?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Emlak Tipi</b></td> 
    <td bgcolor="#FFFFFF"><?=$tip1?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>İl/İlçe/Semt</b></td> 
    <td bgcolor="#FFFFFF"><?=$yer1?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Alan(m²)</b></td> 
    <td bgcolor="#FFFFFF"><?=$alan1?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Fiyat</b></td> 
    <td bgcolor="#FFFFFF"><?=$fiyat1?> <?=$kur1?></td> 
  </tr> 
  <tr> 
    <span class="kirmizi"><td bgcolor="#FFFFFF" colspan="3" 
align="right" height="20"><b><a 
href="emlak_detay.php?kat=<?=$son_1_kat_id?>&eml=<?=$son_1_emlak_id?>">Detaylı 
Bilgi</a>  </b></td></span> 
  </tr> 
</table> 
<br> 
</TD> 
</TR> 
 
<TR> 
<TD valign="top"> 
<? if($son_toplam > 1){ ?> 
<table width="100%"  border="0" cellspacing="1" cellpadding="2"> 
  <tr> 
    <td rowspan="5" align="right" bgcolor="#FFFFFF" width="135"><a 
href="emlak_detay.php?kat=<?=$son_2_kat_id?>&eml=<?=$son_2_emlak_id?>"><IMG 
SRC="eml_img/thumb_<?=$resim2?>" width="135" height="100" 
BORDER="0"></a></td> 
	<td bgcolor="#F4F4F4"><b>İlan No</b></td> 
    <td bgcolor="#FFFFFF"><?=$ilan_no2?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Emlak Tipi</b></td> 
    <td bgcolor="#FFFFFF"><?=$tip2?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>İl/İlçe/Semt</b></td> 
    <td bgcolor="#FFFFFF"><?=$yer2?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Alan(m²)</b></td> 
    <td bgcolor="#FFFFFF"><?=$alan2?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Fiyat</b></td> 
    <td bgcolor="#FFFFFF"><?=$fiyat2?> <?=$kur2?></td> 
  </tr> 
  <tr> 
    <span class="kirmizi"><td height="20" bgcolor="#FFFFFF" colspan="3" 
align="right"><b><a 
href="emlak_detay.php?kat=<?=$son_2_kat_id?>&eml=<?=$son_2_emlak_id?>">Detaylı 
Bilgi</a>  </b></td></span> 
  </tr> 
</table> 
<? } ?> 
<br> 
</TD> 
</TR> 
 
<TR> 
<TD valign="top"> 
<? if($son_toplam > 2){ ?> 
<table width="100%"  border="0" cellspacing="1" cellpadding="2"> 
  <tr> 
    <td rowspan="5" align="right" bgcolor="#FFFFFF" width="135"><a 
href="emlak_detay.php?kat=<?=$son_3_kat_id?>&eml=<?=$son_3_emlak_id?>"><IMG 
SRC="eml_img/thumb_<?=$resim3?>" width="135" height="100" 
BORDER="0"></a></td> 
    <td bgcolor="#F4F4F4"><b>İlan No</b></td> 
    <td bgcolor="#FFFFFF"><?=$ilan_no3?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Emlak Tipi</b></td> 
    <td bgcolor="#FFFFFF"><?=$tip3?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>İl/İlçe/Semt</b></td> 
    <td bgcolor="#FFFFFF"><?=$yer3?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Alan(m²)</b></td> 
    <td bgcolor="#FFFFFF"><?=$alan3?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Fiyat</b></td> 
    <td bgcolor="#FFFFFF"><?=$fiyat3?> <?=$kur3?></td> 
  </tr> 
  <tr> 
    <span class="kirmizi"><td height="20" bgcolor="#FFFFFF" colspan="3" 
align="right"><b><a 
href="emlak_detay.php?kat=<?=$son_3_kat_id?>&eml=<?=$son_3_emlak_id?>">Detaylı 
Bilgi</a>  </b></td></span> 
  </tr> 
</table> 
<? } ?> 
<br> 
</TD> 
</TR> 
 
<TR> 
<TD valign="top"> 
<? if($son_toplam > 3){ ?> 
<table width="100%"  border="0" cellspacing="1" cellpadding="2"> 
  <tr> 
    <td rowspan="5" align="right" bgcolor="#FFFFFF" width="135"><a 
href="emlak_detay.php?kat=<?=$son_4_kat_id?>&eml=<?=$son_4_emlak_id?>"><IMG 
SRC="eml_img/thumb_<?=$resim4?>" width="135" height="100" 
BORDER="0"></a></td> 
    <td bgcolor="#F4F4F4"><b>İlan No</b></td> 
    <td bgcolor="#FFFFFF"><?=$ilan_no4?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Emlak Tipi</b></td> 
    <td bgcolor="#FFFFFF"><?=$tip4?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>İl/İlçe/Semt</b></td> 
    <td bgcolor="#FFFFFF"><?=$yer4?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Alan(m²)</b></td> 
    <td bgcolor="#FFFFFF"><?=$alan4?></td> 
  </tr> 
  <tr> 
    <td bgcolor="#F4F4F4"><b>Fiyat</b></td> 
    <td bgcolor="#FFFFFF"><?=$fiyat4?> <?=$kur4?></td> 
  </tr> 
  <tr> 
    <span class="kirmizi"><td height="20" bgcolor="#FFFFFF" colspan="3" 
align="right"><b><a 
href="emlak_detay.php?kat=<?=$son_4_kat_id?>&eml=<?=$son_4_emlak_id?>">Detaylı 
Bilgi</a>  </b></td></span> 
  </tr> 
</table> 
<? } ?> 
<? } ?> 
<br> 
</TD> 
</TR> 
 
<TR> 
<TD> 
<? if(strlen($duyurular) > 0){ ?> 
<TABLE width="100%" border="0" cellspacing="1" cellpadding="4"> 
<TR> 
	<TD bgcolor="#F4F4F4"><b><?=$duyuru_baslik?></b></TD> 
</TR> 
<TR> 
	<TD bgcolor="#FFFFFF"><?=$duyuru_yazi?></TD> 
</TR> 
</TABLE> 
<? } ?> 
<br> 
</TD> 
</TR> 
 
</TABLE> 
	</td> 
    <td width="135" bgcolor="#EBEEE5" valign="top"> 
	<? include "sag_menu.inc" ?> 
    </td> 
  </tr> 
</table> 
</body> 
</html>
 
  
Navigation:
[Reply to this message] 
 |