$save_depth) { $reply .= "A"; } else if ($row[depth] == $save_depth) { $ch = substr($reply, -1); $reply = substr($reply,0,strlen($reply)-1) . chr(ord($ch) + 1); } else { $reply = substr($reply,0,strlen($reply)-1); $ch = substr($reply, -1); $reply = substr($reply,0,strlen($reply)-1) . chr(ord($ch) + 1); } } else { $reply = "A"; } } $num = $row[headnum]; if ($row[headnum] <= -2000000000) { $notice = -1; $num = 1; } else { $notice = 0; } if ($row[ismember]) { $sql1 = " select user_id from zetyx_member_table where no = '$row[ismember]' "; $row1 = sql_fetch_array($sql1); $mb_id = $row1[user_id]; } else { $mb_id = ""; } $subject = preg_replace("/\'/", "'", addslashes($row[subject])); $memo = preg_replace("/\'/", "'", addslashes($row[memo])); $name = preg_replace("/\'/", "'", addslashes($row[name])); $html = ""; if ($row[use_html]) $html = ",html{$row[use_html]}"; $secret = ""; if ($row[is_secret]) $secret = ",secret"; $recv_email = ""; if ($row[reply_email]) $mail = ",mail"; $sql2 = " insert into $tmp_target set ca_name = '{$category[$row[ca_id]]}', wr_option = '$html,$secret,$mail', wr_num = '$num', wr_reply = '$reply', wr_subject = '$subject', wr_content = '$memo', wr_link1 = '$row[sitelink1]', wr_link2 = '$row[sitelink1]', wr_hit = '$row[hit]', wr_good = '$row[vote]', mb_id = '$mb_id', wr_password = '$row[password]', wr_name = '$name', wr_email = '$row[email]', wr_homepage = '$row[homepage]', wr_datetime = '$reg_date', wr_ip = '$row[ip]', wr_is_comment = 0, wr_comment = '$row[total_comment]', // wr_1 = '$row[x]', // wr_2 = '$row[y]', wr_1 = '', wr_2 = '', wr_3 = '', wr_4 = '', wr_5 = '', wr_6 = '', wr_7 = '', wr_8 = '', wr_9 = '', wr_10 = '' "; sql_query($sql2); $id = mysql_insert_id(); sql_query(" update $tmp_target set wr_parent = '$id' where wr_id = '$id' "); // 코멘트 $comment = 1; $sql2 = " select * from zetyx_board_comment_{$src} where parent = '$row[no]' order by reg_date "; $res2 = sql_query($sql2); for ($k=0; $row2=sql_fetch_array($res2); $k++) { $sql3 = " select user_id from zetyx_member_table where no = '$row2[ismember]' "; $row3 = sql_fetch_array($sql3); $mb_id = $row3[user_id]; $memo = trim(preg_replace("/\'/", "'", addslashes($row2[memo]))); $name = trim(preg_replace("/\'/", "'", addslashes($row2[name]))); $sql = " insert into $tmp_target set wr_num = '$num', wr_parent = '$id', wr_is_comment = 1, wr_comment = '$comment', wr_content = '$memo', mb_id = '$mb_id', wr_password = '$row2[password]', wr_name = '$name', wr_datetime = '".date("Y-m-d H:i:s", $row2[reg_date])."', wr_ip = '$row2[ip]' "; sql_query($sql); //$comment--; $comment++; echo "c----------------------------------------

"; $cnt++; if ($cnt%50==0) { echo "
"; flush(); } $count_comment++; } $gb_cnt=0; for ($k=0; $k<2; $k++) { $m = $k+1; if ($row["s_file_name{$m}"]) { /////////// // 디렉토리가 없다면 생성합니다. (퍼미션도 변경하구요.) @mkdir("$g4[path]/data/file/$dst", 0707); @chmod("$g4[path]/data/file/$dst", 0707); // 파일이름 확인 $zb_file_name=addslashes($row["file_name{$m}"]); //원본파일이름 $g4_file_name=abs(ip2long($_SERVER[REMOTE_ADDR])).'_'.substr(md5(uniqid($g4[server_time])),0,8).'_'.str_replace('%', '', urlencode($row["file_name{$m}"])); // 파일위치 확인 $zb_file=$zb_path.$zb_file_name; $g4_file=$g4[path]."data/file/".$dst."/".$g4_file_name; // 파일카피 copy($zb_file, $g4_file); // 화면표시 echo "($zb_file) ->($g4_file)
" ; ////////// // 윤경진님께서 알려주셨습니다. $sql3 = " insert into $g4[board_file_table] set bo_table = '$dst', wr_id = '$id', bf_no = '$k', bf_source = '".addslashes($row["s_file_name{$m}"])."', bf_file = '".$g4_file_name."', bf_download = '".$row["download{$m}"]."' "; sql_query($sql3); } $gb_cnt++;//레볼루션파일을 넣기 위한 전초작업 } echo "레볼루션 파일도 옮기자
"; $dq_query="select * from dq_revolution where zb_id='$src' and zb_no='$row[no]' "; $dq_result=mysql_query($dq_query); $dq_cnt=mysql_affected_rows(); if($dq_cnt){ $dq=mysql_fetch_array($dq_result); $dq_file=explode(",", $dq[s_file_names]); $dq_dirfile=explode(",", $dq[file_names]); //추가 $dq_file_descript=explode("|", (str_replace("[use]","",$dq[file_descript]))); //추가 //SQL 문에 bf_datetime = '".$reg_date."', bf_content = '".addslashes($dq_file_descript[$kk])."', 추가 + 파일 카피 code 추가 for($kk=0;$kk ($dqG4_file)
"; //////////// $sql4 = " insert into $g4[board_file_table] set bo_table = '$dst', wr_id = '$id', bf_no = '$gb_cnt', bf_source = '".addslashes($dq_file[$kk])."', bf_file = '".$dqG4_file_name."', bf_datetime = '".$reg_date."', bf_content = '".addslashes($dq_file_descript[$kk])."', bf_download = 0 "; sql_query($sql4); } $gb_cnt++; } } echo "W===============================

"; $cnt++; if ($cnt%50==0) { echo "
"; flush(); } $count_write++; } $sql = " update $g4[board_table] set bo_count_write = '$count_write', bo_count_comment = '$count_comment' where bo_table = '$dst' "; sql_query($sql); echo "

".($count_write+$count_comment)."건 변환 완료

뒤로"; ?>