query("update est_prime set status=4 where idx=$idx"); } if($dellmode){ $dbconn->query("select estphoto, estphoto2, estphoto3 from est_prime where idx=$idx"); if($dbconn->next_record()){ $delphoto1 = $dbconn->f("estphoto"); $delphoto2 = $dbconn->f("estphoto2"); $delphoto3 = $dbconn->f("estphoto3"); } ###### 업체기본이미지를 삭제한다. ######## $savedir = "./coimg"; if($delphoto1){ $del_img_name = "$savedir/$delphoto1"; unlink($del_img_name); } if($delphoto2){ $del_img_name = "$savedir/$delphoto2"; unlink($del_img_name); } if($delphoto3){ $del_img_name = "$savedir/$delphoto3"; unlink($del_img_name); } $dbconn->query("delete from est_prime where idx=$idx"); $lib->move_url("/estate/estate_all_l.html?page=$page&dmode=$dmode&searchv=$searchv&searchsell=$searchsell&propertytype=$propertytype&spay=$spay&sarea=$sarea&stuja=$stuja&sbed=$sbed&ret_prog=$ret_prog"); exit; } $query = "select a.tuja, a.addr, a.city,a.state, a.zip, a.regi_id, a.status as status, a.regi_phone, a.regi_email, "; $query = $query. " code1.code_name as property_name,code1.code_idx as property_idx,"; $query = $query. " code2.code_name as selltype_name, code2.code_idx as selltype_idx, "; $query = $query. " a.price, a.prodyear, a.bedroom, a.bathroom, a.mbb, a.stories, a.garages, a.tache, "; $query = $query. " a.heat, a.air, a.basement, a.bb, a.intersize, a.lotsize, a.grade, a.junior,a.high, a.otherschool,"; $query = $query. " a.intfeatures, a.profreatures, a.estphoto, a.estphoto2, a.estphoto3, a.apendinfo, a.imfrom, a.imto, "; $query = $query. " a.pronote, a.rentperiod, a.ipjuil, a.monthpay, a.deposit, a.furnished, a.manage_pay as managepay,"; $query = $query. " a.r_date as r_date, a.regi_name as regi_name, a.property2, a.cookable, a.solowash, a.estsex "; $query = $query. " from $table a "; $query = $query. " inner join $code_table code1 on a.property = code1.code_idx"; $query = $query. " inner join $code_table code2 on a.selltype = code2.code_idx"; $query = $query. " and a.idx = $idx"; $dbconn->query($query); $dbconn->next_record(); $tuja = $dbconn->f("tuja"); $r_phone = $dbconn->f("regi_phone"); $r_email = $dbconn->f("regi_email"); $ppt = $dbconn->f("property_idx"); $slt = $dbconn->f("selltype_idx"); $status = $dbconn->f("status"); $regi_id = $dbconn->f("regi_id"); $addr = $dbconn->f("addr"); $city = $dbconn->f("city"); $state = $dbconn->f("state"); $zip = $dbconn->f("zip"); $price = number_format($dbconn->f("price")); $prodyear = $dbconn->f("prodyear"); $bedroom = $dbconn->f("bedroom"); $bathroom = $dbconn->f("bathroom"); $mbb = $dbconn->f("mbb"); $stories = $dbconn->f("stories"); $garages = $dbconn->f("garages"); $tache = $dbconn->f("tache"); $heat = $dbconn->f("heat"); $air = $dbconn->f("air"); $tmpair = split(":",$air); $basement = $dbconn->f("basement"); $tmpbase = split(":",$basement); $bb = $dbconn->f("bb"); if($bb=="1"){$bb = "Yes";}elseif($bb=="2"){$bb = "No";} $intersize = $dbconn->f("intersize"); $lotsize = $dbconn->f("lotsize"); $grade = $dbconn->f("grade"); $junior = $dbconn->f("junior"); $high = $dbconn->f("high"); $otherschool = $dbconn->f("otherschool"); $intfeatures = $dbconn->f("intfeatures"); if($intfeatures){ $tmpint = split(":",$intfeatures); $i=0; $dbconn2 = new cjDB; $intval=""; while($tmpint[$i]){ $dbconn2->query("select code_name from codes where code_idx=$tmpint[$i]"); if($dbconn2->next_record()){ if($i%5==0 && $i != 0){ $intval = $intval. $dbconn2->f("code_name")."
"; }else{ $intval = $intval. $dbconn2->f("code_name")."    "; } } $i++; } $dbconn2->disconnect(); } $profreatures = $dbconn->f("profreatures"); if($profreatures){ $tmprof = split(":",$profreatures); $j=0; $dbconn3 = new cjDB; $intprof=""; while($tmprof[$j]){ $dbconn3->query("select code_name from codes where code_idx=$tmprof[$j]"); if($dbconn3->next_record()){ if($j%5==0 && $j != 0){ $profval = $profval. $dbconn3->f("code_name")."
"; }else{ $profval = $profval. $dbconn3->f("code_name")."    "; } } $j++; } $dbconn3->disconnect(); } $property2 = $dbconn->f("property2"); if($property2){ $dbconn4 = new cjDB; $dbconn4->query("select code_name from codes where code_idx=$property2"); if($dbconn4->next_record()) $property2 = $dbconn4->f("code_name"); $dbconn4->disconnect(); } $photo = $dbconn->f("estphoto"); $img_h=50; $img_w=70; if($photo){ $photo="coimg/".$photo; $imgsize=GetImageSize($photo); $imgh = $imgsize[1]; $imgw = $imgsize[0]; if($imgsize[1] > $imgsize[0]){ //********************************* 세로큼 if($imgsize[1] > $img_h){ $ratio=$img_h/$imgsize[1]; $imgsize[1] = $img_h; $imgsize[0] = $imgsize[0]*$ratio; } }else{ if($imgsize[0] > $img_w){ $ratio=$img_w/$imgsize[0]; $imgsize[0] = $img_w; $imgsize[1] = $imgsize[1]*$ratio; } } } $photo2 = $dbconn->f("estphoto2"); if($photo2){ $photo2="coimg/".$photo2; $imgsize2=GetImageSize($photo2); $imgh2 = $imgsize2[1]; $imgw2 = $imgsize2[0]; if($imgsize2[1] > $imgsize2[0]){ //********************************* 세로큼 if($imgsize2[1] > $img_h){ $ratio2=$img_h/$imgsize2[1]; $imgsize2[1] = $img_h; $imgsize2[0] = $imgsize2[0]*$ratio2; } }else{ if($imgsize2[0] > $img_w){ $ratio2=$img_w/$imgsize2[0]; $imgsize2[0] = $img_w; $imgsize2[1] = $imgsize2[1]*$ratio2; } } } $photo3 = $dbconn->f("estphoto3"); if($photo3){ $photo3="coimg/".$photo3; $imgsize3=GetImageSize($photo3); $imgh3 = $imgsize3[1]; $imgw3 = $imgsize3[0]; if($imgsize3[1] > $imgsize3[0]){ //********************************* 세로큼 if($imgsize3[1] > $img_h){ $ratio3=$img_h/$imgsize[1]; $imgsize3[1] = $img_h; $imgsize3[0] = $imgsize3[0]*$ratio; } }else{ if($imgsize3[0] > $img_w){ $ratio3=$img_w/$imgsize3[0]; $imgsize3[0] = $img_w; $imgsize3[1] = $imgsize3[1]*$ratio3; } } } $apendinfo = nl2br(stripslashes($dbconn->f("apendinfo"))); $pronote = nl2br(stripslashes($dbconn->f("pronote"))); $ptype = $dbconn->f("property_name"); $stype = $dbconn->f("selltype_name"); $ptype_no = $dbconn->f("property_idx"); $stype_no = $dbconn->f("selltype_idx"); $r_name = $dbconn->f("regi_name"); $r_date = date("Y-m-d",$dbconn->f("r_date")); $rentperiod = $dbconn->f("rentperiod"); $ipjuil = $dbconn->f("ipjuil"); if($ipjuil) $ipjuil = date("Y-m-d",$dbconn->f("ipjuil")); $monthpay = $dbconn->f("monthpay"); $deposit = $dbconn->f("deposit"); $furnished = $dbconn->f("furnished"); if($furnished=="Y"){ $furnished="Yes"; }elseif($furnished=="N"){ $furnished="No"; } $imfrom = $dbconn->f("imfrom"); if($imfrom) $imfrom = date("Y-m-d",$dbconn->f("imfrom")); $imto = $dbconn->f("imto"); if($imto) $imto = date("Y-m-d",$dbconn->f("imto")); $managepay = $dbconn->f("managepay"); if($managepay){ $tmpmanpy = split(":",$managepay); $i=0; $dbconn5 = new cjDB; $manpyval=""; while($tmpmanpy[$i]){ $dbconn5->query("select code_name from codes where code_idx=$tmpmanpy[$i]"); if($dbconn5->next_record()){ if($i%8==0 && $i != 0){ $manpyval = $manpyval.$dbconn5->f("code_name")."
"; }else{ $manpyval = $manpyval.$dbconn5->f("code_name")."    "; } } $i++; } $dbconn5->disconnect(); } $cookable = $dbconn->f("cookable"); if($cookable=="Y"){ $cookable = "Yes"; }elseif($cookable=="N"){ $cookable = "No"; } $solowash = $dbconn->f("solowash"); if($solowash=="Y"){ $solowash = "Yes"; }elseif($solowash=="N"){ $solowash = "No"; } $estsex = $dbconn->f("estsex"); if($estsex=="1"){ $estsex="남"; }elseif($estsex=="2"){ $estsex="여"; }elseif($estsex=="3"){ $estsex="상관없음"; } //************************************************************************ if(!$nopage){ // 이전글, 다음글 구하기 $dbconn6 = new cjDB; $nextno = 0; $prevno = 0; $temp = 0; $query6 = "SELECT a.idx, a.r_date "; $query6 = $query6. " FROM est_prime a "; $query6 = $query6. " inner join member m on a.regi_id = m.user_id"; if($dmode=="D"){ $query6 = $query6. " and m.grade2='E' and m.status=1"; } if($ret_prog=="estate_myhome.html"){ $query6 = $query6. " and a.regi_id = '$login_id' "; } if($searchv){ if($searchsell){ $query6 = $query6. " and a.selltype = $searchsell "; } if($propertytype){ $query6 = $query6. " and a.property = $propertytype "; } if($spay){ $tmpspay = split(":",$spay); $query6 = $quer6y. " and ( a.price >= $tmpspay[0] and price <= $tmpspay[1] ) "; } if($sarea){ $query6 = $query6. " and (a.city like '%$sarea%' || a.state like '%$sarea%' || a.addr like '%$sarea%') "; } if($sbed){ $query6 = $query6. " and a.bedroom = '$sbed' "; } if($stuja){ $query6 = $query6. " and a.tuja = 1 "; } } $query6 = $query6." order by a.r_date desc"; $dbconn6->query($query6); $dbconn6->next_record(); while($dbconn6->f("idx")){ if($idx == $dbconn6->f("idx")){ $nextno = $temp; $dbconn6->next_record(); if($dbconn6->f("idx")){ $prevno = $dbconn6->f("idx"); }else{ $dbconn6->pre_record(); } break; }else{ $temp = $dbconn6->f("idx"); } $dbconn6->next_record(); } $dbconn6->disconnect(); } // 이전글 구하기 끝 //***************************************************************** ?> "findchicago.com" 에 오신 것을 환영합니다.
ppt +----------+--------------+--------------------+--------+--------+ | code_idx | code | code_name | parent | filter | +----------+--------------+--------------------+--------+--------+ | * 370 | est-ptype1 | 주택(House) | 0 | 108 | | ** 374 | eptype1-1 | Single House | 370 | 108 | | ** 375 | eptype1-2 | Apartment | 370 | 108 | | ** 376 | eptype1-3 | Condo | 370 | 108 | | ** 377 | eptype1-4 | Town House | 370 | 108 | | * 371 | est-ptype2 | 상가(Commercial) | 0 | 109 | | ** 384 | eptype2-2 | 상업용(Commercial) | 371 | 109 | | *** 443 | eptype2-2-3 | 공업용(Industrial) | 384 | 109 | | *** 441 | eptype2-2-1 | 사무용(Official) | 384 | 109 | | *** 442 | eptype2-2-2 | 상업용(Retail) | 384 | 109 | | * 372 | est-ptype3 | 대지(Land) | 0 | 110 | | ** 387 | eptype3-1 | 대지(Land) | 372 | 110 | | *** 447 | eptype3-1-2 | 방목장 | 387 | 110 | | *** 448 | eptype3-1-3 | 매개발 | 387 | 110 | | *** 444 | eptype3-1-1 | 농장(Farm) | 387 | 110 | | * 373 | est-ptype4 | other | 0 | 111 | | ** 440 | est-ptype4-1 | Other | 373 | 111 | +----------+--------------+--------------------+--------+--------+ type ==> slt +----------+------------+-----------+ | code_idx | code | code_name | +----------+------------+-----------+ | 391 | selling | 매매 | | 392 | Rent | 임대 | | 393 | sub-lease | 서브리스 | | 394 | Roommate | 룸메이트 | | 395 | short-term | 하숙 | +----------+------------+-----------+ ***********************************************************/ if($ppt=="374" || $ppt=="375" || $ppt=="376" || $ppt=="377"){ $ppt="370"; } if($ppt=="370" && $slt=="391"){ //**************주택/매매 include "$DOCUMENT_ROOT/estate/estate_dt02_1.inc"; }elseif($ppt=="371" && $slt=="391"){ //**************상가/매매 include "$DOCUMENT_ROOT/estate/estate_dt02_2.inc"; }elseif($ppt=="372" && $slt=="391"){ //**************대지/매매 include "$DOCUMENT_ROOT/estate/estate_dt02_3.inc"; }elseif($ppt=="370" && ($slt=="392" ||$slt=="393")){ //**************주택/임대.리스 include "$DOCUMENT_ROOT/estate/estate_dt02_4.inc"; }elseif($ppt=="371" && ($slt=="392" ||$slt=="393")){ //**************상가/임대.리스 include "$DOCUMENT_ROOT/estate/estate_dt02_5.inc"; }elseif($ppt=="370" && ($slt=="394" ||$slt=="395")){ //**************주택/룸매이트.하숙 include "$DOCUMENT_ROOT/estate/estate_dt02_6.inc"; }else{ //**************기타 include "$DOCUMENT_ROOT/estate/estate_dt02_1.inc"; } ?>
수정 "; } echo $modilink.""; if(($login_grade=="A") || ($regi_id == $login_id) && ($status == "1")){ ?> 판매완료   삭제    





disconnect();?>