ÿØÿà JFIF ` ` ÿþ
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/toadmin/hotel_event/ |
Upload File : |
<? include "../include/top_proc.html";//공통파일 인클루드 include "_common.php"; $table = "TB_HOTEL_EVENT"; $upload = "../../FileData/hotel_event/";//이미지업로드경로 $upload_thum = "../../FileData/hotel_event_thumb/";//썸네일 이미지업로드경로 //추천 정보등록 if($SqlType=="event_ins"){ if(!$title)exit; $up_img1 = @FileUploadName( "", $upload, $_FILES['img1']['tmp_name'], $_FILES['img1']['name'] ,"");//파일 업로드 @make_thum($upload.$up_img1,$upload_thum.$up_img1);//이미지썸네일 생성 $up_img2 = @FileUploadName( "", $upload, $_FILES['img2']['tmp_name'], $_FILES['img2']['name'] ,"");//파일 업로드 $sql = "insert into {$table} set "; $sql .= " title='{$title}'"; $sql .= " ,areaa_cd='{$areaa_cd}'"; $sql .= " ,areab_cd='{$areab_cd}'"; $sql .= " ,areac_cd='{$areac_cd}'"; $sql .= " ,img1='{$up_img1}'"; $sql .= " ,img2='{$up_img2}'"; $sql .= " ,url='{$url}'"; $sql .= " ,event_brief='{$event_brief}'"; $sql .= " ,event_intro='{$event_intro}'"; $sql .= " ,event_ing='{$event_ing}'"; $sql .= " ,zipcode='{$zipcode}'"; $sql .= " ,address='{$address}'"; $sql .= " ,address_d='{$address_d}'"; $sql .= " ,dt_s='{$dt_s}'"; $sql .= " ,dt_e='{$dt_e}'"; $sql .= " ,ins_dt=now()"; db_query($sql); error_msg("document.location.href='event_list.html';","script"); // 추천정보 수정 }else if($SqlType=="event_edit"){ if(!$title)exit; $data = hotelevent_fetch(" and seq = '{$seq}' "); //업로드 파일이 있으면 기존 파일 삭제 if($_FILES['img1']['name']) { @unlink($upload.$data[0]['img1']); @unlink($upload_thum.$data[0]['img1']); //이미지 업로드 $up_img1 = @FileUploadName( "", $upload, $_FILES['img1']['tmp_name'], $_FILES['img1']['name'] ,"");//파일 업로드 @make_thum($upload.$up_img1,$upload_thum.$up_img1);//이미지썸네일 생성 } if($_FILES['img2']['name']) { @unlink($upload.$data[0]['img2']); //이미지 업로드 $up_img2 = @FileUploadName( "", $upload, $_FILES['img2']['tmp_name'], $_FILES['img2']['name'] ,"");//파일 업로드 } $sql = "update {$table} set "; $sql .= " title='{$title}'"; $sql .= " ,areaa_cd='{$areaa_cd}'"; $sql .= " ,areab_cd='{$areab_cd}'"; $sql .= " ,areac_cd='{$areac_cd}'"; $sql .= " ,url='{$url}'"; if($up_img1) $sql .= " ,img1='{$up_img1}'"; if($up_img2) $sql .= " ,img2='{$up_img2}'"; $sql .= " ,event_brief='{$event_brief}'"; $sql .= " ,event_intro='{$event_intro}' "; $sql .= " ,event_ing='{$event_ing}'"; $sql .= " ,zipcode='{$zipcode}'"; $sql .= " ,address='{$address}'"; $sql .= " ,address_d='{$address_d}'"; $sql .= " ,dt_s='{$dt_s}'"; $sql .= " ,dt_e='{$dt_e}'"; $sql .= " where seq = '{$seq}'"; db_query($sql); error_msg("document.location.href='event_edit.html?{$_href}&seq={$seq}';","script"); // 추천 정보 노출 수정 }elseif($SqlType=="event_disp_yn"){ if(!$seq or !$disp_yn) exit; $sql = "update {$table} set disp_yn='{$disp_yn}' where seq='{$seq}' "; db_query($sql); $data = hotelevent_fetch(" and seq='{$seq}' "); $row = $data[0]; echo "<img src='../image/btn/{$row['disp_yn2']}' onClick=\"ajax_obj_loader('event_proc.php?SqlType=event_disp_yn&seq={$row['seq']}&disp_yn={$row['disp_yn_opp']}','disp_yn_{$seq}');\" style=\"cursor:pointer;\">"; exit; // 추천 정보 순서변경 }else if($SqlType=="change_ordernum"){ for($i=0 ; $i < count($seq_arr) ; $i++){ $sql = "update {$table} set order_num='{$order_num_arr[$i]}' where seq='$seq_arr[$i]'"; db_query($sql); } error_msg("document.location.reload()","script"); //갤러리 삭제 }else if($SqlType=="img_delete"){ if(!is_array($chkall))exit; for($i=0 ; $i<count($chkall) ; $i++){ $g_seq = $chkall[$i]; $img = ${"img_".$chkall[$i]}; //해당이미지삭제 @unlink($upload.$img); @unlink($upload_thum.$img); $sql = "delete from {$table}_GALLERY where g_seq='{$g_seq}'"; db_query($sql); } error_msg("document.location.reload()","script"); //갤러리 수정 }else if($SqlType=="img_edit"){ if(!is_array($chkall))exit; for($i=0 ; $i<count($chkall) ; $i++){ $g_seq = $chkall[$i]; $title = ${"title_".$chkall[$i]}; $gallery_cd = ${"gallery_cd_".$chkall[$i]}; $sql = "update {$table}_GALLERY set gallery_cd='{$gallery_cd}', title='{$title}' where g_seq='{$g_seq}'"; db_query($sql); } error_msg("document.location.reload()","script"); //지도좌표 }else if($SqlType=="map_edit"){ if(!$seq) exit; $sql = "update {$table} set map_x = '{$map_x}',map_y = '{$map_y}' where seq='{$seq}' "; db_query($sql); error_msg("document.location.href('event_map.html?seq={$seq}&tmp_layer_id={$tmp_layer_id}');","script"); // 메인 추천 관리 }else if($SqlType=="mainchuchun"){ if(!$seq or !$g_main) exit; $sql = "update {$table} set {$g_main} = '{$yn_str}' where seq='{$seq}' "; db_query($sql); exit; } ?>