복사 로그 ->댓글로 (98% 됐는데 2% 부족합니다) 채택완료
간단하지 않는 내용인데 http://sir.kr/bbs/profile.php?mb_id=google_h28epxzg" class="sv_member" title="HyeonPark 자기소개" target="_blank" style="color: rgb(0, 0, 0); text-decoration: none; font-family: 돋움, Dotum, sans-serif; font-size: 12px; line-height: normal;">HyeonPark 님의 도움으로 98% 완성되었습니다.
진심 갑사드립니다.
즉 A게시판의 글을 B게시판에 복사할때
A 게시판 -----------------> B게시판
(이때 내용에 누구님에 의해 복사되었습니다고 로그남는데..)
이 로그 대신 피복사글에 복사자의 댓글이 달리고 "복사자님에 의해 00:00에 복사되었습니다"
라고 하려는 것입니다.
그런데 원본글에도 복사자의 댓글이 달리네여..이거는 안달리게 할 수 없을까요?
========
여기에 넣었습니다.
========
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/move_update.php
</p><p><?php</p><p>include_once('./_common.php');</p><p> </p><p>// 게시판 관리자 이상 복사, 이동 가능</p><p>if ($is_admin != 'board' && $is_admin != 'group' && $is_admin != 'super')</p><p> alert_close('게시판 관리자 이상 접근이 가능합니다.');</p><p> </p><p>if ($sw != 'move' && $sw != 'copy')</p><p> alert('sw 값이 제대로 넘어오지 않았습니다.');</p><p> </p><p>if(!count($_POST['chk_bo_table']))</p><p> alert('게시물을 '.$act.'할 게시판을 한개 이상 선택해 주십시오.', $url);</p><p> </p><p>// 원본 파일 디렉토리</p><p>$src_dir = G5_DATA_PATH.'/file/'.$bo_table;</p><p> </p><p>$save = array();</p><p>$save_count_write = 0;</p><p>$save_count_comment = 0;</p><p>$cnt = 0;</p><p> </p><p>$sql = " select distinct wr_num from $write_table where wr_id in ({$wr_id_list}) order by wr_id ";</p><p>$result = sql_query($sql);</p><p>while ($row = sql_fetch_array($result))</p><p>{</p><p> $wr_num = $row['wr_num'];</p><p> for ($i=0; $i<count($_POST['chk_bo_table']); $i++)</p><p> {</p><p> $move_bo_table = $_POST['chk_bo_table'][$i];</p><p> $move_write_table = $g5['write_prefix'] . $move_bo_table;</p><p> </p><p> $src_dir = G5_DATA_PATH.'/file/'.$bo_table; // 원본 디렉토리</p><p> $dst_dir = G5_DATA_PATH.'/file/'.$move_bo_table; // 복사본 디렉토리</p><p> </p><p> $count_write = 0;</p><p> $count_comment = 0;</p><p> </p><p> $next_wr_num = get_next_num($move_write_table);</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> $nick = cut_str($member['mb_nick'], $config['cf_cut_name']);</p><p> if (!$row2['wr_is_comment'] && $config['cf_use_copy_log']) {</p><p> $move_message = '[이 게시물은 '.$nick.'님에 의해 '.G5_TIME_YMDHIS.' '.$board['bo_subject'].'에서 '.($sw == 'copy' ? '복사' : '이동').' 됨]';</p><p> }</p><p> </p><p> // 게시글 추천, 비추천수</p><p> $wr_good = $wr_nogood = 0;</p><p> if ($sw == 'move' && $i == 0) {</p><p> $wr_good = $row2['wr_good'];</p><p> $wr_nogood = $row2['wr_nogood'];</p><p> }</p><p> </p><p> $sql = " insert into $move_write_table</p><p> set wr_num = '$next_wr_num',</p><p> wr_reply = '{$row2['wr_reply']}',</p><p> wr_is_comment = '{$row2['wr_is_comment']}',</p><p> wr_comment = '{$row2['wr_comment']}',</p><p> wr_comment_reply = '{$row2['wr_comment_reply']}',</p><p> ca_name = '".addslashes($row2['ca_name'])."',</p><p> wr_option = '{$row2['wr_option']}',</p><p> wr_subject = '".addslashes($row2['wr_subject'])."',</p><p> wr_content = '".addslashes($row2['wr_content'])."',</p><p> wr_link1 = '".addslashes($row2['wr_link1'])."',</p><p> wr_link2 = '".addslashes($row2['wr_link2'])."',</p><p> wr_link1_hit = '{$row2['wr_link1_hit']}',</p><p> wr_link2_hit = '{$row2['wr_link2_hit']}',</p><p> wr_hit = '{$row2['wr_hit']}',</p><p> wr_good = '{$wr_good}',</p><p> wr_nogood = '{$wr_nogood}',</p><p> mb_id = '{$row2['mb_id']}',</p><p> wr_password = '{$row2['wr_password']}',</p><p> wr_name = '".addslashes($row2['wr_name'])."',</p><p> wr_email = '".addslashes($row2['wr_email'])."',</p><p> wr_homepage = '".addslashes($row2['wr_homepage'])."',</p><p> wr_datetime = '{$row2['wr_datetime']}',</p><p> wr_file = '{$row2['wr_file']}',</p><p> wr_last = '{$row2['wr_last']}',</p><p> wr_ip = '{$row2['wr_ip']}',</p><p> wr_1 = '".addslashes($row2['wr_1'])."',</p><p> wr_2 = '".addslashes($row2['wr_2'])."',</p><p> wr_3 = '".addslashes($row2['wr_3'])."',</p><p> wr_4 = '".addslashes($row2['wr_4'])."',</p><p> wr_5 = '".addslashes($row2['wr_5'])."',</p><p> wr_6 = '".addslashes($row2['wr_6'])."',</p><p> wr_7 = '".addslashes($row2['wr_7'])."',</p><p> wr_8 = '".addslashes($row2['wr_8'])."',</p><p> wr_9 = '".addslashes($row2['wr_9'])."',</p><p> wr_10 = '".addslashes($row2['wr_10'])."' ";</p><p> sql_query($sql);</p><p> </p><p> $insert_id = mysql_insert_id();</p><p> </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 = '$move_message', </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><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><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> </p><p> </p><p> </p><p> // 코멘트가 아니라면</p><p> if (!$row2['wr_is_comment'])</p><p> {</p><p> $save_parent = $insert_id;</p><p> </p><p> $sql3 = " select * from {$g5['board_file_table']} where bo_table = '$bo_table' and wr_id = '{$row2['wr_id']}' order by bf_no ";</p><p> $result3 = sql_query($sql3);</p><p> for ($k=0; $row3 = sql_fetch_array($result3); $k++)</p><p> {</p><p> if ($row3['bf_file'])</p><p> {</p><p> // 원본파일을 복사하고 퍼미션을 변경</p><p> @copy($src_dir.'/'.$row3['bf_file'], $dst_dir.'/'.$row3['bf_file']);</p><p> @chmod($dst_dir/$row3['bf_file'], G5_FILE_PERMISSION);</p><p> }</p><p> </p><p> $sql = " insert into {$g5['board_file_table']}</p><p> set bo_table = '$move_bo_table',</p><p> wr_id = '$insert_id',</p><p> bf_no = '{$row3['bf_no']}',</p><p> bf_source = '".addslashes($row3['bf_source'])."',</p><p> bf_file = '{$row3['bf_file']}',</p><p> bf_download = '{$row3['bf_download']}',</p><p> bf_content = '".addslashes($row3['bf_content'])."',</p><p> bf_filesize = '{$row3['bf_filesize']}',</p><p> bf_width = '{$row3['bf_width']}',</p><p> bf_height = '{$row3['bf_height']}',</p><p> bf_type = '{$row3['bf_type']}',</p><p> bf_datetime = '{$row3['bf_datetime']}' ";</p><p> sql_query($sql);</p><p> </p><p> if ($sw == 'move' && $row3['bf_file'])</p><p> $save[$cnt]['bf_file'][$k] = $src_dir.'/'.$row3['bf_file'];</p><p> }</p><p> </p><p> $count_write++;</p><p> </p><p> if ($sw == 'move' && $i == 0)</p><p> {</p><p> // 스크랩 이동</p><p> sql_query(" update {$g5['scrap_table']} set bo_table = '$move_bo_table', wr_id = '$save_parent' where bo_table = '$bo_table' and wr_id = '{$row2['wr_id']}' ");</p><p> </p><p> // 최신글 이동</p><p> sql_query(" update {$g5['board_new_table']} set bo_table = '$move_bo_table', wr_id = '$save_parent', wr_parent = '$save_parent' where bo_table = '$bo_table' and wr_id = '{$row2['wr_id']}' ");</p><p> </p><p> // 추천데이터 이동</p><p> sql_query(" update {$g5['board_good_table']} set bo_table = '$move_bo_table', wr_id = '$save_parent' where bo_table = '$bo_table' and wr_id = '{$row2['wr_id']}' ");</p><p> }</p><p> }</p><p> else</p><p> {</p><p> $count_comment++;</p><p> </p><p> if ($sw == 'move')</p><p> {</p><p> // 최신글 이동</p><p> sql_query(" update {$g5['board_new_table']} set bo_table = '$move_bo_table', wr_id = '$insert_id', wr_parent = '$save_parent' where bo_table = '$bo_table' and wr_id = '{$row2['wr_id']}' ");</p><p> }</p><p> }</p><p> </p><p> sql_query(" update $move_write_table set wr_parent = '$save_parent' where wr_id = '$insert_id' ");</p><p> </p><p> if ($sw == 'move')</p><p> $save[$cnt]['wr_id'] = $row2['wr_parent'];</p><p> </p><p> $cnt++;</p><p> }</p><p> </p><p> sql_query(" update {$g5['board_table']} set bo_count_write = bo_count_write + '$count_write' where bo_table = '$move_bo_table' ");</p><p> sql_query(" update {$g5['board_table']} set bo_count_comment = bo_count_comment + '$count_comment' where bo_table = '$move_bo_table' ");</p><p> </p><p> delete_cache_latest($move_bo_table);</p><p> }</p><p> </p><p> $save_count_write += $count_write;</p><p> $save_count_comment += $count_comment;</p><p>}</p><p> </p><p>delete_cache_latest($bo_table);</p><p> </p><p>if ($sw == 'move')</p><p>{</p><p> for ($i=0; $i<count($save); $i++)</p><p> {</p><p> for ($k=0; $k<count($save[$i]['bf_file']); $k++)</p><p> @unlink($save[$i]['bf_file'][$k]);</p><p> </p><p> sql_query(" delete from $write_table where wr_parent = '{$save[$i]['wr_id']}' ");</p><p> sql_query(" delete from {$g5['board_new_table']} where bo_table = '$bo_table' and wr_id = '{$save[$i]['wr_id']}' ");</p><p> sql_query(" delete from {$g5['board_file_table']} where bo_table = '$bo_table' and wr_id = '{$save[$i]['wr_id']}' ");</p><p> }</p><p> sql_query(" update {$g5['board_table']} set bo_count_write = bo_count_write - '$save_count_write', bo_count_comment = bo_count_comment - '$save_count_comment' where bo_table = '$bo_table' ");</p><p>}</p><p> </p><p>$msg = '해당 게시물을 선택한 게시판으로 '.$act.' 하였습니다.';</p><p>$opener_href = './board.php?bo_table='.$bo_table.'&page='.$page.'&'.$qstr;</p><p>$opener_href1 = str_replace('&', '&', $opener_href);</p><p> </p><p>echo <<<HEREDOC</p><p><meta http-equiv="content-type" content="text/html; charset=utf-8"></p><p><script></p><p>alert("$msg");</p><p>opener.document.location.href = "$opener_href1";</p><p>window.close();</p><p></script></p><p><noscript></p><p><p></p><p> "$msg"</p><p></p></p><p><a href="$opener_href">돌아가기</a></p><p></noscript></p><p>HEREDOC;</p><p>?></p><div>
</div><p>
▼ 적용 후 복사 처리 화면
답변에 대한 댓글 2개
멋진 사이트 만드세요~!
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인
너무 잘됩니다.
코드상 어떤 차이가 있는지를 볼줄 몰라 이해못하는 제가 한스럽니다.
진심으로 감사드립니다. 꾸벅