|
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/board/ |
Upload File : |
<?
include "../include/top_proc.html"; //공통파일 인클루드
include "_common.php";
if($SqlType=="board_group_change_ordernum"){ //2차코드 순서 변경
for($i=0 ; $i < count($GRP_CD_arr) ; $i++){
$sql = "update TB_MDBD01 set OrderNum='{$OrderNum_arr[$i]}' where GRP_CD='$GRP_CD_arr[$i]'";
db_query($sql);
}
error_msg("document.location.reload()","script");
}elseif($SqlType=="board_group_edit"){//2차코드 정보 수정
if(!$GRP_CD or !$GRP_NM) exit;
$sql = "update TB_MDBD01 set GRP_NM='{$GRP_NM}' where GRP_CD='{$GRP_CD}'";
db_query($sql);
error_msg("document.location.reload();","script");
}elseif($SqlType=="board_group_delete"){//2차코드 삭제
if(!$GRP_CD) exit;
$sql = "delete from TB_MDBD01 where GRP_CD='{$GRP_CD}'";
db_query($sql);
error_msg("document.location.reload();","script");
}elseif($SqlType=="board_group_ins"){//2차코드 새로 저장
if(!$GRP_CD or !$GRP_NM) exit;
$GRP_CD = "GRP".$GRP_CD;
$sql = "insert into TB_MDBD01 set GRP_CD='{$GRP_CD}', GRP_NM='{$GRP_NM}',GRP_EM='{$_SESSION['MemberID']}',GRP_DT=now() ";
db_query($sql);
error_msg("document.location.reload();","script");
}else if($SqlType=="board_ins" || $SqlType=="board_edit"){ //3차코드 정보저장
$GRP_CD = $_REQUEST[GRP_CD];//그룹
$BD_CD = $_REQUEST[BD_CD];//게시판코드
$BD_SORT = $_REQUEST[BD_SORT];//게시판타입
$BD_NM = insert_smart($_REQUEST[BD_NM],"text");//게시판명
$BD_PS = $_REQUEST[BD_PS];//페이지 목록
$BD_PM = $_REQUEST[BD_PM];//페이지 이동수
$BD_MG = $_REQUEST[BD_MG];//사용자 글쓰기
if($BD_MG==""){
$BD_MG="N";
}
$BD_NG = $_REQUEST[BD_NG];//고정공지
if($BD_NG==""){
$BD_NG="N";
}
$BD_RG = $_REQUEST[BD_RG];//답변글
if($BD_RG==""){
$BD_RG="N";
}
$BD_OD = $_REQUEST[BD_OD];//순서조정기능
if($BD_OD==""){
$BD_OD="N";
}
$BD_MO = $_REQUEST[BD_MO];//회원전용
if($BD_MO==""){
$BD_MO="N";
}
$BD_CG = $_REQUEST[BD_CG];//코멘트사용뮤우
if($BD_CG==""){
$BD_CG="N";
}
$BD_FL = $_REQUEST[BD_FL];//첨부파일 갯수
if($BD_WE==""){
$BD_WE="0";
}
$BD_WE = $_REQUEST[BD_WE];//웹에디터 사용유무
if($BD_WE==""){
$BD_WE="N";
}
$BD_SC = $_REQUEST[BD_SC];//비밀글
if($BD_SC==""){
$BD_SC="N";
}
//탭분류
for ( $i=0 ; $i <count($BD_TP) ; $i++ ) {
if($i !=0 ){$iStr=",";}else{$iStr="";}
if($BD_TP[$i]){
$arrBD_TP = $arrBD_TP.$iStr.$BD_TP[$i];
}
}
if($SqlType=="board_ins"){
if(!$GRP_CD or !$BD_NM or !$BD_CD or !$BD_SORT) exit;
$TabFindCnt = FindTBNM($BD_CD);
if($TabFindCnt>0){
error_msg('사용중인 게시판 코드 입니다.','end');
error_msg("ajax_loader('board_list_ajax.php?GRP_CD={$GRP_CD}','board_ajax');","script");
}else{
$sql ="INSERT INTO TB_MDBD02 SET \n";
$sql.=" GRP_CD ='".$GRP_CD."' \n";
$sql.=" ,BD_CD ='".$BD_CD."' \n";
$sql.=" ,BD_SORT ='".$BD_SORT."' \n";
$sql.=" ,BD_NM ='".$BD_NM."' \n";
$sql.=" ,BD_EM ='".$_SESSION['MemberID']."' \n";
$sql.=" ,BD_DT =now() \n";
//$sql.=" ,BD_PS ='".$BD_PS."' \n";
//$sql.=" ,BD_PM ='".$BD_PM."' \n";
$sql.=" ,BD_FS ='".$BD_FS."' \n";
$sql.=" ,BD_MG ='".$BD_MG."' \n";
$sql.=" ,BD_NG ='".$BD_NG."' \n";
$sql.=" ,BD_CG ='".$BD_CG."' \n";
$sql.=" ,BD_MO ='".$BD_MO."' \n";
$sql.=" ,BD_RG ='".$BD_RG."' \n";
$sql.=" ,BD_SC ='".$BD_SC."' \n";
$sql.=" ,BD_FL ='".$BD_FL."' \n";
$sql.=" ,BD_WE ='".$BD_WE."' \n";
$sql.=" ,BD_TP ='".$BD_TP."' \n";
$sql.=" ,BD_OD ='".$BD_OD."' \n";
db_query($sql);
$SQL01 = "CREATE TABLE `".$BD_CD."` ( \n";
$SQL01.= " `MSEQ` int(11) NOT NULL auto_increment COMMENT '관리번호', \n";
$SQL01.= " `MTITLE` varchar(100) default NULL COMMENT '제목', \n";
$SQL01.= " `MCONT` mediumtext COMMENT '내용', \n";
$SQL01.= " `MEM_NM` varchar(30) default NULL COMMENT '작성자', \n";
$SQL01.= " `MEM_ID` varchar(30) default NULL COMMENT '아이디', \n";
$SQL01.= " `MEM_EMAIL` varchar(100) default NULL COMMENT '이메일', \n";
$SQL01.= " `MEM_WWW` varchar(100) default NULL COMMENT '홈페이지', \n";
$SQL01.= " `MEM_PWD` varchar(20) default NULL COMMENT '비멀번호', \n";
$SQL01.= " `MREF` int(11) default '0' COMMENT '관련글', \n";
$SQL01.= " `MSTEP` int(11) default '0' COMMENT '응답깊이', \n";
$SQL01.= " `MLEVEL` int(11) default '0' COMMENT '응답레벨', \n";
$SQL01.= " `MSORT_01` varchar(10) default NULL COMMENT '분류1', \n";
$SQL01.= " `MSORT_02` varchar(10) default NULL COMMENT '분류2', \n";
$SQL01.= " `MSORT_03` varchar(10) default NULL COMMENT '분류3', \n";
$SQL01.= " `F_TOUR` varchar(10) default NULL COMMENT '상품분류코드', \n";
$SQL01.= " `NAT_CD` varchar(10) default NULL COMMENT '국가코드', \n";
$SQL01.= " `CITY_CD` varchar(10) default NULL COMMENT '도시코드', \n";
$SQL01.= " `DT_CITY_CD` varchar(10) default NULL COMMENT '세부도시코드', \n";
$SQL01.= " `HR_CODE` varchar(10) default NULL COMMENT '호텔코드', \n";
$SQL01.= " `READCNT` int(11) default '0' COMMENT '조회수', \n";
$SQL01.= " `INSDT` datetime default NULL COMMENT '등록일', \n";
$SQL01.= " `INSIP` varchar(20) default NULL COMMENT '등록아이피', \n";
$SQL01.= " `MFILE1` varchar(100) default NULL COMMENT '파일1', \n";
$SQL01.= " `MFILE2` varchar(100) default NULL COMMENT '파일2', \n";
$SQL01.= " `MFILE3` varchar(100) default NULL COMMENT '파일3', \n";
$SQL01.= " `MFILE4` varchar(100) default NULL COMMENT '파일4', \n";
$SQL01.= " `MFILE5` varchar(100) default NULL COMMENT '파일5', \n";
$SQL01.= " `MFILE6` varchar(100) default NULL COMMENT '파일6', \n";
$SQL01.= " `MFILE7` varchar(100) default NULL COMMENT '파일7', \n";
$SQL01.= " `MFILE8` varchar(100) default NULL COMMENT '파일8', \n";
$SQL01.= " `MFILE9` varchar(100) default NULL COMMENT '파일9', \n";
$SQL01.= " `MFILE10` varchar(100) default NULL COMMENT '파일10', \n";
$SQL01.= " `FIXED_YN` enum('Y','N') default 'N' COMMENT '고정공지여부', \n";
$SQL01.= " `SECRET` enum('Y','N') default 'N' COMMENT '비밀글여부', \n";
$SQL01.= " `LinkType` char(10) default NULL COMMENT '링크타입', \n";
$SQL01.= " `MovieLink1` varchar(255) default NULL COMMENT '링크1', \n";
$SQL01.= " `MovieLink2` varchar(255) default NULL COMMENT '링크2', \n";
$SQL01.= " `MovieFileName` varchar(255) default NULL COMMENT '동영상파일이름', \n";
$SQL01.= " `FAQ_NM` varchar(255) default NULL COMMENT '카테고리분류', \n";
$SQL01.= " `m_uid` int(11) default NULL COMMENT '2차지역분류', \n";
$SQL01.= " `s_uid` int(11) default NULL COMMENT '3차지역분류', \n";
$SQL01.= " `RECOM` int(10) default NULL COMMENT '추천수', \n";
$SQL01.= " `BEST_YN` char(10) default NULL COMMENT '베스트등록', \n";
$SQL01.= " `KEYWORD` varchar(10) default NULL COMMENT '키워드', \n";
$SQL01.= " `ANSWER` text default NULL COMMENT '답변', \n";
$SQL01.= " `W_MOBILE` char(2) default NULL COMMENT '모바일글쓰기(Y)', \n";
$SQL01.= " PRIMARY KEY (`MSEQ`), \n";
$SQL01.= " `OrderNum` int(2) default '99' COMMENT '순서' \n";
$SQL01.= ") ENGINE=MyISAM CHARACTER SET=utf8; \n";
db_query($SQL01);
// $SQL02 = "CREATE TABLE ".$BD_CD."_COMT AS SELECT * FROM TB_MDBD03_COMT ";
$SQL02 = "CREATE TABLE `".$BD_CD."_COMT` ( \n";
$SQL02.= " `MSEQ` int(11) NOT NULL COMMENT '게시판 관리번호', \n";
$SQL02.= " `CSEQ` int(11) NOT NULL auto_increment COMMENT '댓글관리번호', \n";
$SQL02.= " `CTITLE` varchar(100) default NULL COMMENT '제목', \n";
$SQL02.= " `CCONT` text COMMENT '내용', \n";
$SQL02.= " `CMEM_NM` varchar(30) default NULL COMMENT '작성자', \n";
$SQL02.= " `CMEM_ID` varchar(30) default NULL COMMENT '아이디', \n";
$SQL02.= " `CMEM_PWD` varchar(20) default NULL COMMENT '비밀번호', \n";
$SQL02.= " `INSDT` datetime default NULL COMMENT '등록일', \n";
$SQL02.= " `INSIP` varchar(20) default NULL COMMENT '등록아이피', \n";
$SQL02.= " PRIMARY KEY (`CSEQ`) \n";
$SQL02.= ") ENGINE=MyISAM CHARACTER SET=utf8; \n";
db_query($SQL02);
error_msg("ajax_loader('board_list_ajax.php?GRP_CD={$GRP_CD}','board_ajax');","script");
}
exit;
}elseif($SqlType=="board_edit"){ //3차코드 수정
if(!$BD_CD)exit;
$sql = "update TB_MDBD02 SET GRP_CD='{$GRP_CD}' \n";
$sql.= ",BD_NM='{$BD_NM}' \n";
$sql.= ",BD_SORT='{$BD_SORT}' \n";
$sql.= ",BD_PS='{$BD_PS}' \n";
$sql.= ",BD_PM='{$BD_PM}' \n";
$sql.= ",BD_FL='{$BD_FL}' \n";
$sql.= ",BD_WE='{$BD_WE}' \n";
$sql.= ",BD_CG='{$BD_CG}' \n";
$sql.= ",BD_NG='{$BD_NG}' \n";
$sql.= ",BD_OD='{$BD_OD}' \n";
$sql.= ",BD_MG='{$BD_MG}' \n";
$sql.= ",BD_MO='{$BD_MO}' \n";
$sql.= ",BD_RG='{$BD_RG}' \n";
$sql.= ",BD_SC='{$BD_SC}' \n";
$sql.= ",BD_TP='{$arrBD_TP}' \n";
$sql.= "where BD_CD='{$BD_CD}' ";
db_query($sql);
error_msg("to_dialog.close('{$tmp_layer_id}');ajax_loader('board_list_ajax.php?GRP_CD={$GRP_CD}','board_ajax');","script");
}
}elseif($SqlType=="board_delete"){ //3차코드 삭제
/*
if( $AdminLevel < 9 ){
echo ("
<script>
window.alert('권한이 없습니다.')
history.go(-1)
</script>
");
exit;
}
*/
if(!$BD_CD) exit;
$BD_CD2 = $BD_CD."_COMT";
$sql = "delete from TB_MDBD02 where BD_CD='{$BD_CD}' ";
db_query($sql);
$SQL="DROP TABLE ".$BD_CD;
db_query($SQL);
$SQL2="DROP TABLE ".$BD_CD2;
db_query($SQL2);
error_msg("ajax_loader('board_list_ajax.php?GRP_CD={$GRP_CD}&BD_CD={$BD_CD}','board_ajax');","script");
}elseif($SqlType=="board_change_flag"){ //3차코드 상태 수정
if(!$GRP_CD or !$BD_CD or !$delflag) exit;
$sql = "update TB_MDBD02 set DELFLAG='{$delflag}' where BD_CD='{$BD_CD}' ";
db_query($sql);
$data = board_info_list($GRP_CD,$BD_CD);
$row = $data[0];
echo "<img src='../image/btn/{$row['delflag2']}' onClick=\"ajax_obj_loader('board_setting_proc.php?SqlType=board_change_flag&GRP_CD={$GRP_CD}&BD_CD={$BD_CD}&delflag={$row['delflag_opp']}','use_codec_{$BD_CD}');\" style=\"cursor:pointer;\">";
exit;
}elseif($SqlType=="board_change_ordernum"){ //3차코드 순서 수정
for($i=0 ; $i < count($BD_CD_arr) ; $i++){
$sql = "update TB_MDBD02 set OrderNum='{$order_num_arr[$i]}' where BD_CD='$BD_CD_arr[$i]'";
db_query($sql);
}
error_msg("ajax_loader('board_list_ajax.php?GRP_CD={$GRP_CD}&BD_CD={$BD_CD}','board_ajax');","script");
}
?>