1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
|
<?php
$dir = ".";
include_once($dir."/_common.php");
$mode_ok = "Y";
$all_sql = "";
//_pr($_POST);
$begin_arrear = 0; $begin_recvbl = 0;
$begin_arrear = preg_replace("/[^-0-9]/", "", $begin_arrear);
$begin_recvbl = preg_replace("/[^-0-9]/", "", $begin_recvbl);
$b_file_size = preg_replace("/[^0-9]/", "", $b_file_size);
if($sel_del=='preview' && $mode_ok=='Y'){ // 거래처 삭제 프리뷰
$mode = "delete_preview";
foreach($code_idx as $key=>$val){
$b_table = $b_tables[$val];
}
$table_name = "shop_write_".$b_table;
$sql = "select count(*) as cnt from {$table_name}";
$info = sql_fetch($sql,$connect_j3);
$board_cnt = $info['cnt'];
} else if($sel_del=='Y' && $mode_ok=='Y'){ // 거래처 삭제
$mode = "delete";
foreach($code_idx as $key=>$val){
$b_table = $b_tables[$val];
$table_name = "shop_write_".$b_table;
}
if($b_table!='' && $table_name!=''){
update_del_log("shop_bbs", "b_table", $b_table,"del"); // 삭제 로그 처리
$sql = "delete from shop_bbs where b_table = '{$b_table}' "; // 게시판내용 삭제
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
$sql = "select idx from {$table_name}";
$res = mysql_query($sql,$connect_j3);
while($info=mysql_fetch_array($res)){
update_del_log($table_name, "idx", $info['idx'],"del"); // 게시판 게시물들 삭제 로그 처리
}
$sql = "select * from shop_bbs_file where b_table = '{$b_table}' ";
$res = mysql_query($sql,$connect_j3);
while($info=mysql_fetch_array($res)){
unlink("{$j3_data_path}/bbs/{$b_table}/{$info['b_filename']}"); // 첨부파일들 삭제함
}
$sql = "delete from shop_bbs_file where b_table = '{$b_table}' "; // 첨부파일 테이블들 삭제함
$res = mysql_query($sql,$connect_j3);
$sql = "drop table {$table_name}"; // 해당게시판 드랍시킴
$res = mysql_query($sql,$connect_j3);
}
} else if($code!='' && $mode_ok=='Y'){ // 거래처 수정
$mode = "update";
$sql = "update shop_bbs set
b_title = '{$b_title}', b_cate = '{$b_cate}',
b_list_lv = '{$b_list_lv}', b_view_lv = '{$b_view_lv}', b_write_lv = '{$b_write_lv}',
b_reply_lv = '{$b_reply_lv}', b_comt_lv = '{$b_comt_lv}', b_uload_lv = '{$b_uload_lv}',
b_dload_lv = '{$b_dload_lv}', b_secret = '{$b_secret}', b_view_list = '{$b_view_list}',
b_file_cnt = '{$b_file_cnt}', b_file_size = '{$b_file_size}', b_seq = '{$b_seq}',
b_top_cont = '{$b_top_cont}', b_bot_cont = '{$b_bot_cont}', b_subj_size = '{$b_subj_size}',
b_subj_size_m = '{$b_subj_size_m}', b_list_row = '{$b_list_row}', b_list_row_m = '{$b_list_row_m}',
b_cont_img_size = '{$b_cont_img_size}'
where idx = '{$code}'
";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
update_del_log("shop_bbs", "idx", $code,""); // 로그 처리
//_pr($sql); exit;
} else if($mode_ok=='Y'){ // 거래처 신규
$mode = "new";
if (!preg_match("/^([A-Za-z0-9_]{1,20})$/", $b_table)) {
$msg='공백없이 영문자, 숫자, _ 만 사용 가능합니다.';
$mode_ok = "N";
}
$sql = "select count(*) as cnt from shop_bbs where b_table = '$b_table' "; // 테이블 코드 중복 확인
$info = sql_fetch($sql, $connect_j3);
if($info['cnt']>0){
$msg='이미등록된 테이블 코드 입니다.';
$mode_ok = "N";
}
if($mode_ok=='Y'){
$sql = "insert into shop_bbs set
b_table = '{$b_table}', b_title = '{$b_title}', b_cate = '{$b_cate}',
b_list_lv = '{$b_list_lv}', b_view_lv = '{$b_view_lv}', b_write_lv = '{$b_write_lv}',
b_reply_lv = '{$b_reply_lv}', b_comt_lv = '{$b_comt_lv}', b_uload_lv = '{$b_uload_lv}',
b_dload_lv = '{$b_dload_lv}', b_secret = '{$b_secret}', b_view_list = '{$b_view_list}',
b_file_cnt = '{$b_file_cnt}', b_file_size = '{$b_file_size}', b_seq = '{$b_seq}',
b_top_cont = '{$b_top_cont}', b_bot_cont = '{$b_bot_cont}', b_subj_size = '{$b_subj_size}',
b_subj_size_m = '{$b_subj_size_m}', b_list_row = '{$b_list_row}', b_list_row_m = '{$b_list_row_m}',
b_cont_img_size = '{$b_cont_img_size}', b_regdate = '".date("Y-m-d H:i:s",time())."'
";
$res = mysql_query($sql,$connect_j3); $all_sql .= $sql;
$last_idx = mysql_insert_id($connect_j3);
$code = $last_idx;
$sql = "CREATE TABLE `shop_write_{$b_table}` (
`idx` INT(11) NOT NULL AUTO_INCREMENT COMMENT '키',
`w_num` INT(11) NOT NULL DEFAULT '0' COMMENT '순번키',
`w_reply` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '답변글키',
`w_parent` INT(11) NOT NULL DEFAULT '0' COMMENT '부모키',
`w_comment` INT(11) NOT NULL DEFAULT '0' COMMENT '코멘트 여부',
`w_cate` VARCHAR(50) NOT NULL DEFAULT '0' COMMENT '분류',
`w_subject` VARCHAR(250) NOT NULL DEFAULT '0' COMMENT '제목',
`w_content` TEXT NOT NULL COMMENT '내용',
`w_notice` INT(1) NOT NULL DEFAULT '0' COMMENT '게시판 공지사항',
`w_hit` INT(11) NOT NULL DEFAULT '0' COMMENT '조회수',
`w_ecode` INT(11) NOT NULL DEFAULT '0' COMMENT '관리자코드',
`w_ccode` INT(11) NOT NULL DEFAULT '0' COMMENT '거래처코드',
`w_login_id` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '아이디',
`w_passwd` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '비회원 패스워드',
`w_name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '작성자명',
`w_email` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '작성자 이메일',
`w_regdate` DATETIME NOT NULL COMMENT '작성일',
`w_editdate` DATETIME NOT NULL COMMENT '수정일',
`w_file` INT(11) NOT NULL DEFAULT '0' COMMENT '첨부파일 수',
`w_ip` VARCHAR(32) NOT NULL DEFAULT '' COMMENT '작성자 IP',
PRIMARY KEY (`idx`),
INDEX `idx_w_num` (`w_num`),
INDEX `idx_w_reply` (`w_reply`),
INDEX `idx_w_parent` (`w_parent`),
INDEX `idx_w_comment` (`w_comment`),
INDEX `idx_w_cate` (`w_cate`),
INDEX `idx_w_subject` (`w_subject`)
)
COMMENT='{$b_title}'
COLLATE='utf8_general_ci'
ENGINE=InnoDB;
";
$res = mysql_query($sql,$connect_j3); // 게시판 생성
}
}
echo "<?php xml version='1.0' encoding='utf-8'?><output>";
echo "<mode>".$mode."</mode>";
echo "<mode_ok>".$mode_ok."</mode_ok>";
echo "<rtn_url>".$rtn_url."</rtn_url>";
echo "<code>".$code."</code>";
echo "<msg>".$msg."</msg>";
echo "<board_cnt>".$board_cnt."</board_cnt>";
echo "</output>";
?>
|