복사시 로그,, 채택완료
복사할때 내용에 로그가 기록되는데요,..
저는 내용에 로그가 아니고
a->b게시판에 복사할때
b게시판의 댓글에 복사한 사람의 아이디로 댓글이 달리게 하고 싶습니다.
move_update.php에 이렇게 되어 있는데...
이걸 어떻게 고치면 될까요?
고수님들의 한수를 부탁드려봅니다..
$sql2 = " select * from $write_table where wr_num = '$wr_num' order by wr_parent, wr_is_comment, wr_comment desc, wr_id ";
$result2 = sql_query($sql2);
while ($row2 = sql_fetch_array($result2))
{
$nick = cut_str($member['mb_nick'], $config['cf_cut_name']);
if (!$row2['wr_is_comment'] && $config['cf_use_copy_log']) {
if(strstr($row2['wr_option'], 'html')) {
$log_tag1 = '<div class="content_'.$sw.'">';
$log_tag2 = '</div>';
} else {
$log_tag1 = "\n";
$log_tag2 = '';
}
$row2['wr_content'] .= "\n".$log_tag1.'[이 게시물은 '.$nick.'님에 의해 '.G5_TIME_YMDHIS.' '.$board['bo_subject'].'에서 '.($sw == 'copy' ? '복사' : '이동').' 됨]'.$log_tag2;
}
답변 3개
</p><p> </p><p> </p><p>$sql2 = " select * from $write_table where wr_num = '$wr_num' order by wr_parent, wr_is_comment, wr_comment desc, wr_id "; </p><p>$result2 = sql_query($sql2); </p><p>while ($row2 = sql_fetch_array($result2)) </p><p>{</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// 게시글 추천, 비추천수</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$wr_good = $wr_nogood = 0;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if ($sw == 'move' && $i == 0) {</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$wr_good = $row2['wr_good'];</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$wr_nogood = $row2['wr_nogood'];</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " insert into $move_write_table</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>set wr_num = '$next_wr_num',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_reply = '{$row2['wr_reply']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_is_comment = '{$row2['wr_is_comment']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_comment = '{$row2['wr_comment']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_comment_reply = '{$row2['wr_comment_reply']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> ca_name = '".addslashes($row2['ca_name'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_option = '{$row2['wr_option']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_subject = '".addslashes($row2['wr_subject'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_content = '".addslashes($row2['wr_content'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_link1 = '".addslashes($row2['wr_link1'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_link2 = '".addslashes($row2['wr_link2'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_link1_hit = '{$row2['wr_link1_hit']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_link2_hit = '{$row2['wr_link2_hit']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_hit = '{$row2['wr_hit']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_good = '{$wr_good}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_nogood = '{$wr_nogood}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> mb_id = '{$row2['mb_id']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_password = '{$row2['wr_password']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_name = '".addslashes($row2['wr_name'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_email = '".addslashes($row2['wr_email'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_homepage = '".addslashes($row2['wr_homepage'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_datetime = '{$row2['wr_datetime']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_file = '{$row2['wr_file']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_last = '{$row2['wr_last']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_ip = '{$row2['wr_ip']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_1 = '".addslashes($row2['wr_1'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_2 = '".addslashes($row2['wr_2'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_3 = '".addslashes($row2['wr_3'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_4 = '".addslashes($row2['wr_4'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_5 = '".addslashes($row2['wr_5'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_6 = '".addslashes($row2['wr_6'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_7 = '".addslashes($row2['wr_7'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_8 = '".addslashes($row2['wr_8'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_9 = '".addslashes($row2['wr_9'])."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_10 = '".addslashes($row2['wr_10'])."' ";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>sql_query($sql);</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$insert_id = mysql_insert_id();</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$nick = cut_str($member['mb_nick'], $config['cf_cut_name']); </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if (!$row2['wr_is_comment'] && $config['cf_use_copy_log']) { </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$wr_content = '[이 게시물은 '.$nick.'님에 의해 '.G5_TIME_YMDHIS.' '.($sw == 'copy' ? '복사' : '이동').' 됨]'; </p><p><span class="Apple-tab-span" style="white-space:pre"> </span></p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sub_sql = " select max(wr_comment) as max_comment from $move_write_table where wr_parent = '{$insert_id}' and wr_is_comment = 1 "; </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sub_row = sql_fetch($sub_sql); </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sub_row['max_comment'] += 1; </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$tmp_comment = $sub_row['max_comment']; </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$tmp_comment_reply = ''; </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$wr_subject = get_text(stripslashes($row2['wr_subject'])); </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " insert into $move_write_table </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>set ca_name = '{$row2['ca_name']}', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_option = '$wr_secret', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_num = '{$next_wr_num}', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_reply = '', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_parent = '{$insert_id}', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_is_comment = 1, </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_comment = '$tmp_comment', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_comment_reply = '$tmp_comment_reply', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_subject = '', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_content = '$wr_content', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>mb_id = '{$member['mb_id']}', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>wr_password = '{$row2['wr_password']}', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>wr_name = '$nick', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_email = '{$row2['wr_email']}', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_homepage = '{$row2['wr_homepage']}', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_datetime = '".G5_TIME_YMDHIS."', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_last = '', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_ip = '{$_SERVER['REMOTE_ADDR']}', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_1 = '$wr_1', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_2 = '$wr_2', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_3 = '$wr_3', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_4 = '$wr_4', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_5 = '$wr_5', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_6 = '$wr_6', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_7 = '$wr_7', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_8 = '$wr_8', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_9 = '$wr_9', </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_10 = '$wr_10' "; </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> sql_query($sql); </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> $comment_id = mysql_insert_id(); </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> // 원글에 댓글수 증가 & 마지막 시간 반영 </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> sql_query(" update $move_write_table set wr_comment = wr_comment + 1, wr_last = '".G5_TIME_YMDHIS."' where wr_id = '{$insert_id}' "); </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> // 새글 INSERT </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> sql_query(" insert into {$g5['board_new_table']} ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$move_bo_table', '$comment_id', '{$insert_id}', '".G5_TIME_YMDHIS."', '{$row2['mb_id']}' ) "); </p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> // 댓글 1 증가 </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> sql_query(" update {$g5['board_table']} set bo_count_comment = bo_count_comment + 1 where bo_table = '$move_bo_table' "); </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>// 코멘트가 아니라면</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if (!$row2['wr_is_comment'])</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>{</p><p> </p><p> </p><p> </p><p>
이렇게 수정해 주시면 됩니다~ 답변 채택 부탁 드릴께요~!
답변에 대한 댓글 2개
큰 도움 못되어 죄송합니다!
댓글을 작성하려면 로그인이 필요합니다.
옮겨간 게시물에 덧글이 달리길 원할때는
[CODE]
while ($row2 = sql_fetch_array($result2))
{
$nick = cut_str($member['mb_nick'], $config['cf_cut_name']);
if (!$row2['wr_is_comment'] && $config['cf_use_copy_log']) {
if(strstr($row2['wr_option'], 'html')) {
$log_tag1 = '<div class="content_'.$sw.'">';
$log_tag2 = '</div>';
} else {
$log_tag1 = "\n";
$log_tag2 = '';
}
$row2['wr_content'] .= "\n".$log_tag1.'[이 게시물은 '.$nick.'님에 의해 '.G5_TIME_YMDHIS.' '.$board['bo_subject'].'에서 '.($sw == 'copy' ? '복사' : '이동').' 됨]'.$log_tag2;
}
// 게시글 추천, 비추천수
$wr_good = $wr_nogood = 0;
if ($sw == 'move' && $i == 0) {
$wr_good = $row2['wr_good'];
$wr_nogood = $row2['wr_nogood'];
}
$sql = " insert into $move_write_table
set wr_num = '$next_wr_num',
wr_reply = '{$row2['wr_reply']}',
wr_is_comment = '{$row2['wr_is_comment']}',
wr_comment = '{$row2['wr_comment']}',
wr_comment_reply = '{$row2['wr_comment_reply']}',
ca_name = '".addslashes($row2['ca_name'])."',
wr_option = '{$row2['wr_option']}',
wr_subject = '".addslashes($row2['wr_subject'])."',
wr_content = '".addslashes($row2['wr_content'])."',
wr_link1 = '".addslashes($row2['wr_link1'])."',
wr_link2 = '".addslashes($row2['wr_link2'])."',
wr_link1_hit = '{$row2['wr_link1_hit']}',
wr_link2_hit = '{$row2['wr_link2_hit']}',
wr_hit = '{$row2['wr_hit']}',
wr_good = '{$wr_good}',
wr_nogood = '{$wr_nogood}',
mb_id = '{$row2['mb_id']}',
wr_password = '{$row2['wr_password']}',
wr_name = '".addslashes($row2['wr_name'])."',
wr_email = '".addslashes($row2['wr_email'])."',
wr_homepage = '".addslashes($row2['wr_homepage'])."',
wr_datetime = '{$row2['wr_datetime']}',
wr_file = '{$row2['wr_file']}',
wr_last = '{$row2['wr_last']}',
wr_ip = '{$row2['wr_ip']}',
wr_1 = '".addslashes($row2['wr_1'])."',
wr_2 = '".addslashes($row2['wr_2'])."',
wr_3 = '".addslashes($row2['wr_3'])."',
wr_4 = '".addslashes($row2['wr_4'])."',
wr_5 = '".addslashes($row2['wr_5'])."',
wr_6 = '".addslashes($row2['wr_6'])."',
wr_7 = '".addslashes($row2['wr_7'])."',
wr_8 = '".addslashes($row2['wr_8'])."',
wr_9 = '".addslashes($row2['wr_9'])."',
wr_10 = '".addslashes($row2['wr_10'])."' ";
sql_query($sql);
$insert_id = mysql_insert_id();
[/CODE]
여기 아래 부분에 위에서 알려 드린 코드를 입력 하시면 됩니다.
※ 순정 그누보드 기준 103번 라인 아래에 추가
[CODE]
$sub_sql = " select max(wr_comment) as max_comment from $move_write_table
where wr_parent = '{$insert_id}' and wr_is_comment = 1 ";
$sub_row = sql_fetch($sub_sql);
$sub_row['max_comment'] += 1;
$tmp_comment = $sub_row['max_comment'];
$tmp_comment_reply = '';
$wr_subject = get_text(stripslashes($row2['wr_subject']));
$sql = " insert into $move_write_table
set ca_name = '{$row2['ca_name']}',
wr_option = '$wr_secret',
wr_num = '{$next_wr_num}',
wr_reply = '',
wr_parent = '{$insert_id}',
wr_is_comment = 1,
wr_comment = '$tmp_comment',
wr_comment_reply = '$tmp_comment_reply',
wr_subject = '',
wr_content = '$wr_content',
mb_id = '{$row2['mb_id']}',
wr_password = '{$row2['wr_password']}',
wr_name = '{$row2['wr_name']}',
wr_email = '{$row2['wr_email']}',
wr_homepage = '{$row2['wr_homepage']}',
wr_datetime = '".G5_TIME_YMDHIS."',
wr_last = '',
wr_ip = '{$_SERVER['REMOTE_ADDR']}',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10 = '$wr_10' ";
sql_query($sql);
$comment_id = mysql_insert_id();
// 원글에 댓글수 증가 & 마지막 시간 반영
sql_query(" update $move_write_table set wr_comment = wr_comment + 1, wr_last = '".G5_TIME_YMDHIS."' where wr_id = '{$insert_id}' ");
// 새글 INSERT
sql_query(" insert into {$g5['board_new_table']} ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$move_bo_table', '$comment_id', '{$insert_id}', '".G5_TIME_YMDHIS."', '{$row2['mb_id']}' ) ");
// 댓글 1 증가
sql_query(" update {$g5['board_table']} set bo_count_comment = bo_count_comment + 1 where bo_table = '$move_bo_table' ");
}
.
.
.
.
.
[/CODE]
오류가 생기거나 하면 알려 주세요~!
답변에 대한 댓글 7개
원글작성자의 코멘트가 아니라 복사자의 댓글이 달리는거겟? 그걸원해서요ㅡ
해보겠습니다~
아 해석을 잘못한 ㅠㅠㅠㅠ 코드 한군데를 바꿔 주셔야 합니다 ㅠㅠ
mb_id = '{$row2['mb_id']}',
wr_password = '{$row2['wr_password']}',
wr_name = '{$row2['wr_name']}',
이 부분을
mb_id = '{$member['mb_id']}',
wr_password = '{$row2['wr_password']}',
wr_name = '$nick',
이렇게 수정해 주세요!
마무리까지 해주시는군요,,
복받으실거에요~
다음과 같이 했는데..
피복사글에 댓글이 잘 달립니다~
원본글에도 댓글이 달리네여..이거는 안달리게 할 수 없을까요?
========
여기에 넣었습니다.
========
wr_10 = '".addslashes($row2['wr_10'])."' ";
sql_query($sql);
$insert_id = sql_insert_id();
======================================================
//피복사글에 자동 코멘트 달기1
$sql2 = " select * from $write_table where wr_num = '$wr_num' order by wr_parent, wr_is_comment, wr_comment desc, wr_id ";
$result2 = sql_query($sql2);
while ($row2 = sql_fetch_array($result2))
{
$nick = cut_str($member['mb_nick'], $config['cf_cut_name']);
if (!$row2['wr_is_comment'] && $config['cf_use_copy_log']) {
$wr_content = '[이 게시물은 '.$nick.'님에 의해 '.G5_TIME_YMDHIS.' '.($sw == 'copy' ? '복사' : '이동').' 됨]';
$sub_sql = " select max(wr_comment) as max_comment from $write_table
where wr_parent = '{$row2['wr_id']}' and wr_is_comment = 1 ";
$sub_row = sql_fetch($sub_sql);
$sub_row['max_comment'] += 1;
$tmp_comment = $sub_row['max_comment'];
$tmp_comment_reply = '';
$wr_subject = get_text(stripslashes($row2['wr_subject']));
$sql = " insert into $write_table
set ca_name = '{$row2['ca_name']}',
wr_option = '$wr_secret',
wr_num = '{$row2['wr_num']}',
wr_reply = '',
wr_parent = '{$row2['wr_id']}',
wr_is_comment = 1,
wr_comment = '$tmp_comment',
wr_comment_reply = '$tmp_comment_reply',
wr_subject = '',
wr_content = '$wr_content',
mb_id = '{$member['mb_id']}',
wr_password = '{$row2['wr_password']}',
wr_name = '$nick',
wr_email = '{$row2['wr_email']}',
wr_homepage = '{$row2['wr_homepage']}',
wr_datetime = '".G5_TIME_YMDHIS."',
wr_last = '',
wr_ip = '{$_SERVER['REMOTE_ADDR']}',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10 = '$wr_10' ";
sql_query($sql);
$comment_id = mysql_insert_id();
// 원글에 댓글수 증가 & 마지막 시간 반영
sql_query(" update $write_table set wr_comment = wr_comment + 1, wr_last = '".G5_TIME_YMDHIS."' where wr_id = '{$row2['wr_id']}' ");
// 새글 INSERT
sql_query(" insert into {$g5['board_new_table']} ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$bo_table', '$comment_id', '{$row2['wr_id']}', '".G5_TIME_YMDHIS."', '{$row2['mb_id']}' ) ");
// 댓글 1 증가
sql_query(" update {$g5['board_table']} set bo_count_comment = bo_count_comment + 1 where bo_table = '$bo_table' ");
}
//피복사글에 자동 코멘트 달기2
$sub_sql = " select max(wr_comment) as max_comment from $move_write_table where wr_parent = '{$insert_id}' and wr_is_comment = 1 ";
$sub_row = sql_fetch($sub_sql);
$sub_row['max_comment'] += 1;
$tmp_comment = $sub_row['max_comment'];
$tmp_comment_reply = '';
$wr_subject = get_text(stripslashes($row2['wr_subject']));
$sql = " insert into $move_write_table
set ca_name = '{$row2['ca_name']}',
wr_option = '$wr_secret',
wr_num = '{$next_wr_num}',
wr_reply = '',
wr_parent = '{$insert_id}',
wr_is_comment = 1,
wr_comment = '$tmp_comment',
wr_comment_reply = '$tmp_comment_reply',
wr_subject = '',
wr_content = '$wr_content',
mb_id = '{$member['mb_id']}',
wr_password = '{$row2['wr_password']}',
wr_name = '$nick',
wr_email = '{$row2['wr_email']}',
wr_homepage = '{$row2['wr_homepage']}',
wr_datetime = '".G5_TIME_YMDHIS."',
wr_last = '',
wr_ip = '{$_SERVER['REMOTE_ADDR']}',
wr_1 = '$wr_1',
wr_2 = '$wr_2',
wr_3 = '$wr_3',
wr_4 = '$wr_4',
wr_5 = '$wr_5',
wr_6 = '$wr_6',
wr_7 = '$wr_7',
wr_8 = '$wr_8',
wr_9 = '$wr_9',
wr_10 = '$wr_10' ";
sql_query($sql);
$comment_id = mysql_insert_id();
// 원글에 댓글수 증가 & 마지막 시간 반영
sql_query(" update $move_write_table set wr_comment = wr_comment + 1, wr_last = '".G5_TIME_YMDHIS."' where wr_id = '{$insert_id}' ");
// 새글 INSERT
sql_query(" insert into {$g5['board_new_table']} ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$move_bo_table', '$comment_id', '{$insert_id}', '".G5_TIME_YMDHIS."', '{$row2['mb_id']}' ) ");
// 댓글 1 증가
sql_query(" update {$g5['board_table']} set bo_count_comment = bo_count_comment + 1 where bo_table = '$move_bo_table' ");
}
===============================================================
// 코멘트가 아니라면
if (!$row2['wr_is_comment'])
{
이제 다 된거 같은데..
//피복사글에 자동 코멘트 달기1 을 지우니 코드애러가 나는거 같습니다.
그 아래줄에 다른 코드랑 } 등 뭔가 안맞는거 같은데..
한번 더 봐주시면 안될지요...
댓글을 작성하려면 로그인이 필요합니다.
/bbs/write_comment_update.php
해당 파일의 로직을 참고 / 복사 하여 활용이 가능합니다. write_comment_update.php 는 그누보드의 코멘트를 등록 / 수정하는 기능을 하는 파일로, 이 부분의 코드를 활용 한다면 그누보드 시스템에 따라 코멘트를 등록 할 수 있습니다.
</p><p>$sql = " select max(wr_comment) as max_comment from $write_table</p><p style="margin-left: 0px;"> where wr_parent = '$wr_id' and wr_is_comment = 1 ";</p><p style="margin-left: 0px;"> $row = sql_fetch($sql);</p><p style="margin-left: 0px;"> //$row[max_comment] -= 1;</p><p style="margin-left: 0px;"> $row['max_comment'] += 1;</p><p style="margin-left: 0px;"> $tmp_comment = $row['max_comment'];</p><p style="margin-left: 0px;"> $tmp_comment_reply = '';</p><p style="margin-left: 0px;"> </p><p>$wr_subject = get_text(stripslashes($wr['wr_subject']));</p><p> </p><p> $sql = " insert into $write_table</p><p> set ca_name = '{$wr['ca_name']}',</p><p> wr_option = '$wr_secret',</p><p> wr_num = '{$wr['wr_num']}',</p><p> wr_reply = '',</p><p> wr_parent = '$wr_id',</p><p> wr_is_comment = 1,</p><p> wr_comment = '$tmp_comment',</p><p> wr_comment_reply = '$tmp_comment_reply',</p><p> wr_subject = '',</p><p> wr_content = '$wr_content',</p><p> mb_id = '$mb_id',</p><p> wr_password = '$wr_password',</p><p> wr_name = '$wr_name',</p><p> wr_email = '$wr_email',</p><p> wr_homepage = '$wr_homepage',</p><p> wr_datetime = '".G5_TIME_YMDHIS."',</p><p> wr_last = '',</p><p> wr_ip = '{$_SERVER['REMOTE_ADDR']}',</p><p> wr_1 = '$wr_1',</p><p> wr_2 = '$wr_2',</p><p> wr_3 = '$wr_3',</p><p> wr_4 = '$wr_4',</p><p> wr_5 = '$wr_5',</p><p> wr_6 = '$wr_6',</p><p> wr_7 = '$wr_7',</p><p> wr_8 = '$wr_8',</p><p> wr_9 = '$wr_9',</p><p> wr_10 = '$wr_10' ";</p><p> sql_query($sql);</p><p> </p><p> $comment_id = mysql_insert_id();</p><p> </p><p> // 원글에 댓글수 증가 & 마지막 시간 반영</p><p> sql_query(" update $write_table set wr_comment = wr_comment + 1, wr_last = '".G5_TIME_YMDHIS."' where wr_id = '$wr_id' ");</p><p> </p><p> // 새글 INSERT</p><p> sql_query(" insert into {$g5['board_new_table']} ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$bo_table', '$comment_id', '$wr_id', '".G5_TIME_YMDHIS."', '{$member['mb_id']}' ) ");</p><p> </p><p> // 댓글 1 증가</p><p> sql_query(" update {$g5['board_table']} set bo_count_comment = bo_count_comment + 1 where bo_table = '$bo_table' ");</p><p> </p><p>
이 부분의 소스 코드가 실제 신규 코멘트를 등록 하는 부분이라 볼 수 있는데요, 여기서 필요한 변수가 무엇인지 확인 할 수 있습니다.
1. 게시물 제목
2. 원본 게시물 id
3. 원본 게시물 정보
4. 등록할 코멘트 내용
5. 등록하는 멤버 아이디
4. 등록하는 사람의 이름 등...
올려주신 소스 코드를 보면, 원본 게시물의 정보를 받아 오는 곳은 $row2 로 확인 할 수 있습니다.
이를 응용하여 코드를 수정해 본다면
</p><p>$sql2 = " select * from $write_table where wr_num = '$wr_num' order by wr_parent, wr_is_comment, wr_comment desc, wr_id ";</p><p>$result2 = sql_query($sql2);</p><p>while ($row2 = sql_fetch_array($result2))</p><p>{</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$nick = cut_str($member['mb_nick'], $config['cf_cut_name']);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>if (!$row2['wr_is_comment'] && $config['cf_use_copy_log']) {</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$wr_content = '[이 게시물은 '.$nick.'님에 의해 '.G5_TIME_YMDHIS.' '.$board['bo_subject'].'에서 '.($sw == 'copy' ? '복사' : '이동').' 됨]';</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sub_sql = " select max(wr_comment) as max_comment from $write_table</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> where wr_parent = '<span style="font-size: 14.6667px;">{$row2['wr_id']}</span>' and wr_is_comment = 1 ";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sub_row = sql_fetch($sub_sql);</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sub_row['max_comment'] += 1;</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$tmp_comment = $sub_row['max_comment'];</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$tmp_comment_reply = '';</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$wr_subject = get_text(stripslashes($row2['wr_subject']));</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>$sql = " insert into $write_table</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>set ca_name = '{$row2['ca_name']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_option = '$wr_secret',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_num = '{$row2['wr_num']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_reply = '',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_parent = '{$row2['wr_id']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_is_comment = 1,</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_comment = '$tmp_comment',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_comment_reply = '$tmp_comment_reply',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_subject = '',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_content = '$wr_content',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> mb_id = '{$row2['mb_id']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_password = '{$row2['wr_password']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_name = '{$row2['wr_name']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_email = '{$row2['wr_email']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_homepage = '{$row2['wr_homepage']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_datetime = '".G5_TIME_YMDHIS."',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_last = '',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_ip = '{$_SERVER['REMOTE_ADDR']}',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_1 = '$wr_1',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_2 = '$wr_2',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_3 = '$wr_3',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_4 = '$wr_4',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_5 = '$wr_5',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_6 = '$wr_6',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_7 = '$wr_7',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_8 = '$wr_8',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_9 = '$wr_9',</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> wr_10 = '$wr_10' ";</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> sql_query($sql);</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> $comment_id = mysql_insert_id();</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> // 원글에 댓글수 증가 & 마지막 시간 반영</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> sql_query(" update $write_table set wr_comment = wr_comment + 1, wr_last = '".G5_TIME_YMDHIS."' where wr_id = '{$row2['wr_id']}' ");</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> // 새글 INSERT</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> sql_query(" insert into {$g5['board_new_table']} ( bo_table, wr_id, wr_parent, bn_datetime, mb_id ) values ( '$bo_table', '$comment_id', '{$row2['wr_id']}', '".G5_TIME_YMDHIS."', '{$row2['mb_id']}' ) ");</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span> // 댓글 1 증가</p><p><span class="Apple-tab-span" style="white-space:pre"> </span> sql_query(" update {$g5['board_table']} set bo_count_comment = bo_count_comment + 1 where bo_table = '$bo_table' ");</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>}</p><p> </p><p><span class="Apple-tab-span" style="white-space:pre"> </span>.</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>.</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>.</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>.</p><p><span class="Apple-tab-span" style="white-space:pre"> </span>.</p><p> </p><p>
이렇게 될거 같네요~!
답변에 대한 댓글 2개
근데 내가 뻑나지 않게 할 수 있을지가 걱정이네요,,유유
암튼 열심히 해보겠습니다~ 감사합니다.
해당 부분을 대체하면 되도록 작성해주신거 같군요,,진심 감사합니다.
a->b으로 복사할때 b게시판의 복사되는 글에 댓글이 달리길 원하는데..
a게시판의 원본에 글쓴이의 댓글이 달리네요,,ㅎ
b게시판의 복사되는 글에 복사하는 사람의 댓글이 달리게 하려면 어떻게 할 수 있을까요?..
기왕 도와주시거 바쁘시더라도 알려주시면 감사하겠습니다.
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인
이제 어느쪽도 댓글이 안달리고,,
해당글 삭제도 안되네요..뭔가 애러가 있는거 같습니다.
진심으로 감사드려요~
너무 길어져서 새 글로 다시 질문을 올려봐야 겠습니다~
좋은 주말되세요~