<?php
function buyuk($deger)
{
$deger = str_replace("ç","Ç",$deger);
$deger = str_replace("ğ","Ğ",$deger);
$deger = str_replace("ı","I",$deger);
$deger = str_replace("i","İ",$deger);
$deger = str_replace("ö","Ö",$deger);
$deger = str_replace("ü","Ü",$deger);
$deger = str_replace("ş","Ş",$deger);
$deger = strtoupper($deger);
$deger = trim($deger);
return $deger;
}
function kucuk($deger)
{
$deger = str_replace("Ç","ç",$deger);
$deger = str_replace("Ğ","ğ",$deger);
$deger = str_replace("I","ı",$deger);
$deger = str_replace("İ","i",$deger);
$deger = str_replace("Ö","ö",$deger);
$deger = str_replace("Ü","ü",$deger);
$deger = str_replace("Ş","ş",$deger);
$deger = strtolower($deger);
$deger = trim($deger);
return $deger;
}
function ilkbuyuk($deger)
{
$deger = @split(" ",trim($deger));
$deger_tr = "";
for($x=0; $x < count($deger); $x++)
{
$deger_bas = substr($deger[$x],0,1);
$deger_son = substr($deger[$x],1);
$deger_bas = buyuk($deger_bas);
$deger_tr .= $deger_bas.$deger_son." ";
}
$deger_tr = trim($deger_tr);
return $deger_tr;
}
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "landsubmit")) {
function gel($text2 ="") {
foreach ($_REQUEST as $var => $value) {
if (stripos($var, 'img_SWFUpload_') !== false) {
if (stripos($var, '_fileName') !== false){
$img_fileName[] = $value;
}
}
}
if(is_array(@$img_fileName))
{
foreach (@$img_fileName as $i => $value) {
$text2.= "'$img_fileName[$i]',";
}}
return $text2;
}
$hey=substr(gel(),0,-1);
function kelime_say($metin) {
$parcalar = explode(",", $metin);
$say = count($parcalar);
return $say;
}
$kel= kelime_say($hey);
function res($er,$sa ="") {
for ($i=0; $i < $er; $i++) {
if($i=='0'){$sa.= 'resim,';}else{$sa.= 'resim'.$i.',';}
}
return $sa;
}
if(empty($hey)){$resimvar='yok';}else{$resimvar='e vet';}
$insertSQL = sprintf("INSERT INTO ilanlar (uyeid,il, ilce, semt,mahalle, baslik, etiket, metre, tabela, tarih, pafta, ada, parsel, isinma, fiyat, yapidurumu, depozit, depfb, kackat, fiyatbirim, oda, kati, kullanimdurumu, konutturu, cadde, sokak, aciklama, takas, kredi, durum, tipi, x, resimvar,harita,aptadi,aptno,dno) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s,%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString(@$_SESSION['uyeid'], "int"),
GetSQLValueString(@$_POST['il'], "text"),
GetSQLValueString(@$_POST['ilce'], "text"),
GetSQLValueString(@$_POST['semt'], "text"),
GetSQLValueString(@$_POST['mahalle'], "text"),
GetSQLValueString(ilkbuyuk(kucuk($_POST['baslik'])), "text"),
GetSQLValueString(@$_POST['etiket'], "text"),
GetSQLValueString(@$_POST['metre'], "text"),
GetSQLValueString(@$_POST['tabela'], "text"),
GetSQLValueString(@$_POST['tarih'], "text"),
GetSQLValueString(@$_POST['pafta'], "text"),
GetSQLValueString(@$_POST['ada'], "text"),
GetSQLValueString(@$_POST['parsel'], "text"),
GetSQLValueString(@$_POST['isinma'], "text"),
GetSQLValueString(@$_POST['fiyat'], "text"),
GetSQLValueString(@$_POST['yapidurumu'], "text"),
GetSQLValueString(@$_POST['depozit'], "text"),
GetSQLValueString(@$_POST['depfb'], "text"),
GetSQLValueString(@$_POST['kackat'], "text"),
GetSQLValueString($_POST['fiyatbirim'], "text"),
GetSQLValueString(@$_POST['oda'], "text"),
GetSQLValueString(@$_POST['kati'], "text"),
GetSQLValueString(@$_POST['kullanimdurumu'], "text"),
GetSQLValueString($_POST['konutturu'], "text"),
GetSQLValueString($_POST['cadde'], "text"),
GetSQLValueString($_POST['sokak'], "text"),
GetSQLValueString($_POST['aciklama'], "text"),
GetSQLValueString(@$_POST['takas'], "text"),
GetSQLValueString(@$_POST['kredi'], "text"),
GetSQLValueString(@$_POST['durum'], "int"),
GetSQLValueString($_POST['tipi'], "int"),
GetSQLValueString($_POST['x'], "text"),
GetSQLValueString($resimvar, "text"),
GetSQLValueString($_POST['harita'], "text"),
GetSQLValueString($_POST['aptadi'], "text"),
GetSQLValueString($_POST['aptno'], "text"),
GetSQLValueString($_POST['dno'], "text"));
$Result1 = $dba->query($insertSQL) or die(mysql_error());
$ilanid = mysql_insert_id();
if(empty($hey)){
$s="INSERT INTO resimler(resim,resim1,resim2,resim3,resim4,resim5, resim6,resim7,resim8,resim9,resim10,resim11,resim1 2,resim13,resim14,resim15,resim16,resim17,resim18, resim19,id) VALUES('noimage.gif','noimage.gif','noimage.gif',' noimage.gif','noimage.gif','noimage.gif','noimage. gif','noimage.gif','noimage.gif','noimage.gif','no image.gif','noimage.gif','noimage.gif','noimage.gi f','noimage.gif','noimage.gif','noimage.gif','noim age.gif','noimage.gif','noimage.gif','$ilanid')";
$Result2 = $dba->query($s) ;}else{
$s="INSERT INTO resimler(".res($kel)."id) VALUES($hey,'$ilanid')";
$dba->query($s) ;}
$insertSQL3 = sprintf("INSERT INTO ozellikler (ilan_id,adsl, ahsap_dograma,tipi, asansor, cam, cam_mozaik, guvenlik, kapici, otopark, pvc, yangin, bahce, bahce_ortak, alarm, fitnes, hidrafor, mutfak, celik, kabin, gdolap, hali, hbanyo, kpiyer, panjur, laminant, ankestre_mutfak, asma_tavan, balkon, barbeku, esyali, dkagit, faxtel, gordiafon, isicam, jakuzi, kablouydu, balkonkapali, klima, laminatmutfak, marley, mermer, dogalgaz, panelkapi, parke, snayielek, satenalci, satenboya, sauna, spot, sofben, somine, teras, yerdenisit, vestiyer, jenarator, siteicinde, sudepo, tenis, havuz,ebeveyn) VALUES (%s, %s, %s, %s,%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($ilanid, "int"),
GetSQLValueString(isset($_POST['adsl']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['ahsap_dograma']) ? "true" : "", "defined","1","0"),
GetSQLValueString($_POST['tipi'], "int"),
GetSQLValueString(isset($_POST['asansor']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['cam']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['cam_mozaik']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['guvenlik']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['kapici']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['otopark']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['pvc']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['yangin']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['bahce']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['bahce_ortak']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['alarm']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['fitnes']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['hidrafor']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['mutfak']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['celik']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['kabin']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['gdolap']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['hali']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['hbanyo']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['kpiyer']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['panjur']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['laminant']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['ankestre_mutfak']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['asma_tavan']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['balkon']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['barbeku']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['esyali']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['dkagit']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['faxtel']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['gordiafon']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['isicam']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['jakuzi']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['kablouydu']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['balkonkapali']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['klima']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['laminatmutfak']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['marley']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['mermer']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['dogalgaz']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['panelkapi']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['parke']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['snayielek']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['satenalci']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['satenboya']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['sauna']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['spot']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['sofben']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['somine']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['teras']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['yerdenisit']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['vestiyer']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['jenarator']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['siteicinde']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['sudepo']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['tenis']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['havuz']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['ebeveyn']) ? "true" : "", "defined","1","0"));
$Result3 = $dba->query($insertSQL3);
$insertSQL34 = sprintf("INSERT INTO ozellikler1 (ilan_id,tipi, denizmanzara, manzsehir,cadcephe,dogamanzara,okula, ocaga, otobana, ulasim, metro, havaalani,harfi, maki, muhtelifyapi, harfisiz, kanalz, elektrik, su, projeli, marinaprojeli, yolalti, yolustu, parkcepheli, kosearsa, artezyen, temel, plan, kayalik, toprak, zeytin, muhtelifagac, sicaksukaynak) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,%s, %s)",
GetSQLValueString($ilanid, "int"),
GetSQLValueString($_POST['tipi'], "int"),
GetSQLValueString(isset($_POST['denizmanzara']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['manzsehir']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['cadcephe']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['dogamanzara']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['okula']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['ocaga']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['otobana']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['ulasim']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['metro']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['havaalani']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['harfi']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['maki']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['muhtelifyapi']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['harfisiz']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['kanalz']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['elektrik']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['su']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['projeli']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['marinaprojeli']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['yolalti']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['yolustu']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['parkcepheli']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['kosearsa']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['artezyen']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['temel']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['plan']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['kayalik']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['toprak']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['zeytin']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['muftelifagac']) ? "true" : "", "defined","1","0"),
GetSQLValueString(isset($_POST['sicaksukaynak']) ? "true" : "", "defined","1","0"));
$Result34 = $dba->query($insertSQL34);
if ($_POST['tipi'] =='3' and $_POST['durum'] =='7' ) {
die("<META HTTP-EQUIV="REFRESH" CONTENT="0;URL=ilanbitti.php?id=$ilanid"><script type=text/javascript>parent.leftFrame.window.location.reload ();</script>");}
if ($_POST['tipi'] =='3' and $_POST['durum'] =='0' ) {
die("<META HTTP-EQUIV="REFRESH" CONTENT="0;URL=ilanbitti.php?id=$ilanid"><script type=text/javascript>parent.leftFrame.window.location.reload ();</script>");}
if ($_POST['tipi'] =='2' and $_POST['durum'] =='7' ) {
die("<META HTTP-EQUIV="REFRESH" CONTENT="0;URL=ilanbitti.php?id=$ilanid"><script type=text/javascript>parent.leftFrame.window.location.reload ();</script>");}
if ($_POST['tipi'] =='2' and $_POST['durum'] =='0' ) {
die("<META HTTP-EQUIV="REFRESH" CONTENT="0;URL=ilanbitti.php?id=$ilanid"><script type=text/javascript>parent.leftFrame.window.location.reload ();</script>");}
if ($_POST['tipi'] =='1' and $_POST['durum'] =='7' ) {
die("<META HTTP-EQUIV="REFRESH" CONTENT="0;URL=ilanbitti.php?id=$ilanid"><script type=text/javascript>parent.leftFrame.window.location.reload ();</script>");}
if ($_POST['tipi'] =='1' and $_POST['durum'] =='0' ) {
die("<META HTTP-EQUIV="REFRESH" CONTENT="0;URL=ilanbitti.php?id=$ilanid"><script type=text/javascript>parent.leftFrame.window.location.reload ();</script>");}
} ?>