이미지갤러리 정보
그누보드 이미지갤러리본문
제가 사용중인 gbmoveupdate.php 입니다.
필드가 wr1~wr12 까지 이고 첨부파일 갯수가 10개 랍니다.
아래 소스중 ....
wr_update_ip = '$row[wr_update_ip]',
(여기부터 ~ 여기까지가 있던 자리 입니다)
wr_update_user_agent = '$row[wr_update_user_agent]' ";
<!--- 여기부터
if ($option) {
$sql2 .= " , wr_1 = '$row[wr_1]'
, wr_2 = '$row[wr_2]'
, wr_3 = '$row[wr_3]'
, wr_4 = '$row[wr_4]'
, wr_5 = '$row[wr_5]'
, wr_6 = '$row[wr_6]'
, wr_7 = '$row[wr_7]'
, wr_8 = '$row[wr_8]'
, wr_9 = '$row[wr_9]'
, wr_10 = '$row[wr_10]'
, wr_11 = '$row[wr_11]'
, wr_12 = '$row[wr_12]' ";
}
여기까지 ---->
위에 있던걸 아래 내려 보내주니 제대로 작동 되던데요.
수정하고 테스트 여러번 했구요. 질문 보고 또 테스트 해
보았습니다. 이전처럼 수정이 잘 되었다 안 되었다 하는
현상은 없어진 상태 랍니다. 참고 하시기 바랍니다.
=============================================================================================
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "NONE");
if (!($w == "c" || $w == "m")) {
alert("w 값이 제대로 넘어오지 않았습니다.");
}
for ($i=0; $i<count($HTTP_POST_VARS[chk]); $i++) {
$copy_bo_table = $HTTP_POST_VARS[chk][$i];
$copy_table = $cfg[write_table_prefix] . $copy_bo_table;
$num = get_next_num($copy_table, $write[wr_notice]);
$save_parent_id = 0;
$sql = " select * from $write_table
where wr_num = '$write[wr_num]'
and wr_notice = '$write[wr_notice]'
order by wr_parent_id, wr_comment ";
$result = sql_query($sql);
while ($row = mysql_fetch_array($result)) {
// 같은 분류가 있는지 검사, 없다면 기본 1 로 설정
$sql1 = " select count(*) from {$copy_table}_cat where ca_id = '$row[ca_id]' ";
$row1 = sql_fetch($sql1);
if ($row1[0] == 0) {
$ca_id = 1;
} else {
$ca_id = $row[ca_id];
}
$s_content = "";
if ($row[wr_comment] == 0) {
$s_content = "\n\n[이 게시물은 {$member[mb_name]}님에 의해 {$now} {$board[bo_subject]}(으)로 부터 ";
if ($w == 'c') {
$s_content .= "복사";
} else {
$s_content .= "이동";
}
$s_content .= "됨]";
}
// wr_1 ~ wr_5 필드가 있는가? ( 3.05 이상 )
$option = false;
$sql2 = " select wr_1, wr_5 from $copy_table limit 1 ";
$result2 = @mysql_query($sql2);
if ($result2) {
$option = true;
}
$sql2= " insert into $copy_table
set wr_num = '$num',
wr_notice = '$row[wr_notice]',
ca_id = '$ca_id',
wr_reply = '$row[wr_reply]',
wr_comment = '$row[wr_comment]',
wr_commentcnt = '$row[wr_commentcnt]',
wr_html = '$row[wr_html]',
wr_secret = '$row[wr_secret]',
wr_recv_email = '$row[wr_recv_email]',
wr_subject = '".addslashes($row[wr_subject])."',
wr_content = '".addslashes($row[wr_content])."$s_content',
wr_link1 = '$row[wr_link1]',
wr_link2 = '$row[wr_link2]',
wr_link1_hit = '$row[wr_link1_hit]',
wr_link2_hit = '$row[wr_link2_hit]',
wr_file1 = '$row[wr_file1]',
wr_file2 = '$row[wr_file2]',
wr_file3 = '$row[wr_file3]',
wr_file4 = '$row[wr_file4]',
wr_file5 = '$row[wr_file5]',
wr_file6 = '$row[wr_file6]',
wr_file7 = '$row[wr_file7]',
wr_file8 = '$row[wr_file8]',
wr_file9 = '$row[wr_file9]',
wr_file10 = '$row[wr_file10]',
wr_file1_source = '$row[wr_file1_source]',
wr_file2_source = '$row[wr_file2_source]',
wr_file3_source = '$row[wr_file3_source]',
wr_file4_source = '$row[wr_file4_source]',
wr_file5_source = '$row[wr_file5_source]',
wr_file6_source = '$row[wr_file6_source]',
wr_file7_source = '$row[wr_file7_source]',
wr_file8_source = '$row[wr_file8_source]',
wr_file9_source = '$row[wr_file9_source]',
wr_file10_source = '$row[wr_file10_source]',
wr_file1_download = '$row[wr_file1_download]',
wr_file2_download = '$row[wr_file2_download]',
wr_file3_download = '$row[wr_file3_download]',
wr_file4_download = '$row[wr_file4_download]',
wr_file5_download = '$row[wr_file5_download]',
wr_file6_download = '$row[wr_file6_download]',
wr_file7_download = '$row[wr_file7_download]',
wr_file8_download = '$row[wr_file8_download]',
wr_file9_download = '$row[wr_file9_download]',
wr_file10_download = '$row[wr_file10_download]',
wr_hit = '$row[wr_hit]',
mb_id = '$row[mb_id]',
wr_passwd = '$row[wr_passwd]',
wr_name = '$row[wr_name]',
wr_email = '$row[wr_email]',
wr_homepage = '$row[wr_homepage]',
wr_datetime = '$row[wr_datetime]',
wr_ip = '$row[wr_ip]',
wr_user_agent = '$row[wr_user_agent]',
wr_update_datetime = '$row[wr_update_datetime]',
wr_update_ip = '$row[wr_update_ip]',
wr_update_user_agent = '$row[wr_update_user_agent]' ";
if ($option) {
$sql2 .= " , wr_1 = '$row[wr_1]'
, wr_2 = '$row[wr_2]'
, wr_3 = '$row[wr_3]'
, wr_4 = '$row[wr_4]'
, wr_5 = '$row[wr_5]'
, wr_6 = '$row[wr_6]'
, wr_7 = '$row[wr_7]'
, wr_8 = '$row[wr_8]'
, wr_9 = '$row[wr_9]'
, wr_10 = '$row[wr_10]'
, wr_11 = '$row[wr_11]'
, wr_12 = '$row[wr_12]' ";
}
sql_query($sql2);
$id = mysql_insert_id();
if ($row[wr_comment] == 0) {
$save_parent_id = $id;
// 복사되는 게시판의 게시글 1 증가
sql_query("update $cfg[table_board] set bo_total_count = bo_total_count + 1 where bo_table = '$copy_bo_table'");
}
$sql3 = " update $copy_table
set wr_parent_id = '$save_parent_id'
where wr_id = '$id' ";
sql_query($sql3);
// 파일 복사
$srcdir = "./data/file/$bo_table";
$dstdir = "./data/file/$copy_bo_table";
@copy("$srcdir/$row[wr_file1]", "$dstdir/$row[wr_file1]");
@copy("$srcdir/$row[wr_file2]", "$dstdir/$row[wr_file2]");
@copy("$srcdir/$row[wr_file3]", "$dstdir/$row[wr_file3]");
@copy("$srcdir/$row[wr_file4]", "$dstdir/$row[wr_file4]");
@copy("$srcdir/$row[wr_file5]", "$dstdir/$row[wr_file5]");
@copy("$srcdir/$row[wr_file6]", "$dstdir/$row[wr_file6]");
@copy("$srcdir/$row[wr_file7]", "$dstdir/$row[wr_file7]");
@copy("$srcdir/$row[wr_file8]", "$dstdir/$row[wr_file8]");
@copy("$srcdir/$row[wr_file9]", "$dstdir/$row[wr_file9]");
@copy("$srcdir/$row[wr_file10]", "$dstdir/$row[wr_file10]");
// 이동일 경우 기존 게시물 삭제
if ($w == 'm') {
sql_query(" delete from $write_table where wr_id = '$row[wr_id]' ");
if ($row[wr_comment] == 0) {
// 보내는 게시판의 게시글 1 감소
sql_query("update $cfg[table_board] set bo_total_count = bo_total_count - 1 where bo_table = '$bo_table'");
}
// 파일 삭제
@unlink("$srcdir/$row[wr_file1]");
@unlink("$srcdir/$row[wr_file2]");
@unlink("$srcdir/$row[wr_file3]");
@unlink("$srcdir/$row[wr_file4]");
@unlink("$srcdir/$row[wr_file5]");
@unlink("$srcdir/$row[wr_file6]");
@unlink("$srcdir/$row[wr_file7]");
@unlink("$srcdir/$row[wr_file8]");
@unlink("$srcdir/$row[wr_file9]");
@unlink("$srcdir/$row[wr_file10]");
}
}
mysql_free_result($result);
}
if ($w == "c") {
$msg = "해당 게시물을 선택한 게시판으로 복사하였습니다.";
$opener_href = "./?doc=$cfg[bbs_dir]/gnuboard.php&$qstr&wr_id=$wr_id&page=$page";
} else if ($w == "m") {
$msg = "해당 게시물을 선택한 게시판으로 이동하였습니다.";
$opener_href = "./?doc=$cfg[bbs_dir]/gnuboard.php&$qstr&page=$page";
}
echo "
<script language='javascript'>
alert(\"$msg\");
opener.document.location.href = '$opener_href';
window.close();
</script>";
?>
필드가 wr1~wr12 까지 이고 첨부파일 갯수가 10개 랍니다.
아래 소스중 ....
wr_update_ip = '$row[wr_update_ip]',
(여기부터 ~ 여기까지가 있던 자리 입니다)
wr_update_user_agent = '$row[wr_update_user_agent]' ";
<!--- 여기부터
if ($option) {
$sql2 .= " , wr_1 = '$row[wr_1]'
, wr_2 = '$row[wr_2]'
, wr_3 = '$row[wr_3]'
, wr_4 = '$row[wr_4]'
, wr_5 = '$row[wr_5]'
, wr_6 = '$row[wr_6]'
, wr_7 = '$row[wr_7]'
, wr_8 = '$row[wr_8]'
, wr_9 = '$row[wr_9]'
, wr_10 = '$row[wr_10]'
, wr_11 = '$row[wr_11]'
, wr_12 = '$row[wr_12]' ";
}
여기까지 ---->
위에 있던걸 아래 내려 보내주니 제대로 작동 되던데요.
수정하고 테스트 여러번 했구요. 질문 보고 또 테스트 해
보았습니다. 이전처럼 수정이 잘 되었다 안 되었다 하는
현상은 없어진 상태 랍니다. 참고 하시기 바랍니다.
=============================================================================================
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가
define("_DOCTYPE_", "NONE");
if (!($w == "c" || $w == "m")) {
alert("w 값이 제대로 넘어오지 않았습니다.");
}
for ($i=0; $i<count($HTTP_POST_VARS[chk]); $i++) {
$copy_bo_table = $HTTP_POST_VARS[chk][$i];
$copy_table = $cfg[write_table_prefix] . $copy_bo_table;
$num = get_next_num($copy_table, $write[wr_notice]);
$save_parent_id = 0;
$sql = " select * from $write_table
where wr_num = '$write[wr_num]'
and wr_notice = '$write[wr_notice]'
order by wr_parent_id, wr_comment ";
$result = sql_query($sql);
while ($row = mysql_fetch_array($result)) {
// 같은 분류가 있는지 검사, 없다면 기본 1 로 설정
$sql1 = " select count(*) from {$copy_table}_cat where ca_id = '$row[ca_id]' ";
$row1 = sql_fetch($sql1);
if ($row1[0] == 0) {
$ca_id = 1;
} else {
$ca_id = $row[ca_id];
}
$s_content = "";
if ($row[wr_comment] == 0) {
$s_content = "\n\n[이 게시물은 {$member[mb_name]}님에 의해 {$now} {$board[bo_subject]}(으)로 부터 ";
if ($w == 'c') {
$s_content .= "복사";
} else {
$s_content .= "이동";
}
$s_content .= "됨]";
}
// wr_1 ~ wr_5 필드가 있는가? ( 3.05 이상 )
$option = false;
$sql2 = " select wr_1, wr_5 from $copy_table limit 1 ";
$result2 = @mysql_query($sql2);
if ($result2) {
$option = true;
}
$sql2= " insert into $copy_table
set wr_num = '$num',
wr_notice = '$row[wr_notice]',
ca_id = '$ca_id',
wr_reply = '$row[wr_reply]',
wr_comment = '$row[wr_comment]',
wr_commentcnt = '$row[wr_commentcnt]',
wr_html = '$row[wr_html]',
wr_secret = '$row[wr_secret]',
wr_recv_email = '$row[wr_recv_email]',
wr_subject = '".addslashes($row[wr_subject])."',
wr_content = '".addslashes($row[wr_content])."$s_content',
wr_link1 = '$row[wr_link1]',
wr_link2 = '$row[wr_link2]',
wr_link1_hit = '$row[wr_link1_hit]',
wr_link2_hit = '$row[wr_link2_hit]',
wr_file1 = '$row[wr_file1]',
wr_file2 = '$row[wr_file2]',
wr_file3 = '$row[wr_file3]',
wr_file4 = '$row[wr_file4]',
wr_file5 = '$row[wr_file5]',
wr_file6 = '$row[wr_file6]',
wr_file7 = '$row[wr_file7]',
wr_file8 = '$row[wr_file8]',
wr_file9 = '$row[wr_file9]',
wr_file10 = '$row[wr_file10]',
wr_file1_source = '$row[wr_file1_source]',
wr_file2_source = '$row[wr_file2_source]',
wr_file3_source = '$row[wr_file3_source]',
wr_file4_source = '$row[wr_file4_source]',
wr_file5_source = '$row[wr_file5_source]',
wr_file6_source = '$row[wr_file6_source]',
wr_file7_source = '$row[wr_file7_source]',
wr_file8_source = '$row[wr_file8_source]',
wr_file9_source = '$row[wr_file9_source]',
wr_file10_source = '$row[wr_file10_source]',
wr_file1_download = '$row[wr_file1_download]',
wr_file2_download = '$row[wr_file2_download]',
wr_file3_download = '$row[wr_file3_download]',
wr_file4_download = '$row[wr_file4_download]',
wr_file5_download = '$row[wr_file5_download]',
wr_file6_download = '$row[wr_file6_download]',
wr_file7_download = '$row[wr_file7_download]',
wr_file8_download = '$row[wr_file8_download]',
wr_file9_download = '$row[wr_file9_download]',
wr_file10_download = '$row[wr_file10_download]',
wr_hit = '$row[wr_hit]',
mb_id = '$row[mb_id]',
wr_passwd = '$row[wr_passwd]',
wr_name = '$row[wr_name]',
wr_email = '$row[wr_email]',
wr_homepage = '$row[wr_homepage]',
wr_datetime = '$row[wr_datetime]',
wr_ip = '$row[wr_ip]',
wr_user_agent = '$row[wr_user_agent]',
wr_update_datetime = '$row[wr_update_datetime]',
wr_update_ip = '$row[wr_update_ip]',
wr_update_user_agent = '$row[wr_update_user_agent]' ";
if ($option) {
$sql2 .= " , wr_1 = '$row[wr_1]'
, wr_2 = '$row[wr_2]'
, wr_3 = '$row[wr_3]'
, wr_4 = '$row[wr_4]'
, wr_5 = '$row[wr_5]'
, wr_6 = '$row[wr_6]'
, wr_7 = '$row[wr_7]'
, wr_8 = '$row[wr_8]'
, wr_9 = '$row[wr_9]'
, wr_10 = '$row[wr_10]'
, wr_11 = '$row[wr_11]'
, wr_12 = '$row[wr_12]' ";
}
sql_query($sql2);
$id = mysql_insert_id();
if ($row[wr_comment] == 0) {
$save_parent_id = $id;
// 복사되는 게시판의 게시글 1 증가
sql_query("update $cfg[table_board] set bo_total_count = bo_total_count + 1 where bo_table = '$copy_bo_table'");
}
$sql3 = " update $copy_table
set wr_parent_id = '$save_parent_id'
where wr_id = '$id' ";
sql_query($sql3);
// 파일 복사
$srcdir = "./data/file/$bo_table";
$dstdir = "./data/file/$copy_bo_table";
@copy("$srcdir/$row[wr_file1]", "$dstdir/$row[wr_file1]");
@copy("$srcdir/$row[wr_file2]", "$dstdir/$row[wr_file2]");
@copy("$srcdir/$row[wr_file3]", "$dstdir/$row[wr_file3]");
@copy("$srcdir/$row[wr_file4]", "$dstdir/$row[wr_file4]");
@copy("$srcdir/$row[wr_file5]", "$dstdir/$row[wr_file5]");
@copy("$srcdir/$row[wr_file6]", "$dstdir/$row[wr_file6]");
@copy("$srcdir/$row[wr_file7]", "$dstdir/$row[wr_file7]");
@copy("$srcdir/$row[wr_file8]", "$dstdir/$row[wr_file8]");
@copy("$srcdir/$row[wr_file9]", "$dstdir/$row[wr_file9]");
@copy("$srcdir/$row[wr_file10]", "$dstdir/$row[wr_file10]");
// 이동일 경우 기존 게시물 삭제
if ($w == 'm') {
sql_query(" delete from $write_table where wr_id = '$row[wr_id]' ");
if ($row[wr_comment] == 0) {
// 보내는 게시판의 게시글 1 감소
sql_query("update $cfg[table_board] set bo_total_count = bo_total_count - 1 where bo_table = '$bo_table'");
}
// 파일 삭제
@unlink("$srcdir/$row[wr_file1]");
@unlink("$srcdir/$row[wr_file2]");
@unlink("$srcdir/$row[wr_file3]");
@unlink("$srcdir/$row[wr_file4]");
@unlink("$srcdir/$row[wr_file5]");
@unlink("$srcdir/$row[wr_file6]");
@unlink("$srcdir/$row[wr_file7]");
@unlink("$srcdir/$row[wr_file8]");
@unlink("$srcdir/$row[wr_file9]");
@unlink("$srcdir/$row[wr_file10]");
}
}
mysql_free_result($result);
}
if ($w == "c") {
$msg = "해당 게시물을 선택한 게시판으로 복사하였습니다.";
$opener_href = "./?doc=$cfg[bbs_dir]/gnuboard.php&$qstr&wr_id=$wr_id&page=$page";
} else if ($w == "m") {
$msg = "해당 게시물을 선택한 게시판으로 이동하였습니다.";
$opener_href = "./?doc=$cfg[bbs_dir]/gnuboard.php&$qstr&page=$page";
}
echo "
<script language='javascript'>
alert(\"$msg\");
opener.document.location.href = '$opener_href';
window.close();
</script>";
?>
댓글 전체
제가 잘못이해하고있는것인지 버전차이라 고쳐진것인지...
저는 기본적인 링크2개 파일2개 이런형식으로 사용중입니다.
3.21버전의 gbmoveupdate.php소스를보니 아래처럼되어있네요... 이렇다면... 다른문제인듯하네요.
wr_update_ip = '$row[wr_update_ip]',
wr_update_user_agent = '$row[wr_update_user_agent]' ";
if ($option) {
$sql2 .= " , wr_1 = '$row[wr_1]'
, wr_2 = '$row[wr_2]'
, wr_3 = '$row[wr_3]'
, wr_4 = '$row[wr_4]'
, wr_5 = '$row[wr_5]' ";
}
sql_query($sql2);
하여튼 답변감사합니다. 좋은밤되세요.
저는 기본적인 링크2개 파일2개 이런형식으로 사용중입니다.
3.21버전의 gbmoveupdate.php소스를보니 아래처럼되어있네요... 이렇다면... 다른문제인듯하네요.
wr_update_ip = '$row[wr_update_ip]',
wr_update_user_agent = '$row[wr_update_user_agent]' ";
if ($option) {
$sql2 .= " , wr_1 = '$row[wr_1]'
, wr_2 = '$row[wr_2]'
, wr_3 = '$row[wr_3]'
, wr_4 = '$row[wr_4]'
, wr_5 = '$row[wr_5]' ";
}
sql_query($sql2);
하여튼 답변감사합니다. 좋은밤되세요.