게시판 합치기소스구했는데 그누보드5 에 맞게쓰렴 어디를 수정해야하는지 좀 알려주심 감사할게요
본문
밑에 게시판 합치기소스구했는데요
그누보드5 에 맞게쓰렴 어디를 수정해야하는지 좀 알려주심 감사할게요
<?
include_once("_common.php");
//////////////////////////////////////////////////
//
// 다시 정렬할 게시판을 입력해주세요.
//
$bo_table = "";
//////////////////////////////////////////////////
if ($is_admin != 'super') die("로그인 해주세요.");
if (!$bo_table) die("bo_table 값이 없습니다.");
$write_table = $g4[write_prefix].$bo_table;
$data = array();
$sql = "select wr_id, wr_num from {$write_table} where wr_is_comment=0 and wr_reply='' order by wr_datetime";
$qry = sql_query($sql);
while ($row = sql_fetch_array($qry)) $data[] = $row;
sql_query("update {$write_table} set wr_num = wr_num * -1");
$wr_num = 0;
foreach ($data as $row)
{
$wr_num--;
$row[wr_num] *= -1;
$sql = "update {$write_table} set wr_num = '{$wr_num}' where wr_num = '{$row[wr_num]}'";
echo "$sql<br>";
sql_query($sql);
}
echo "완료하였습니다.";
?>
<?
include "_common.php";
$bo_tableA="testA;
$bo_tableB="testB";
$write_tableA=$g4[write_prefix].$bo_tableA;
$write_tableB=$g4[write_prefix].$bo_tableB;
sql_query("lock tables $write_tableA write,$write_tableB write ", false);
$row=sql_fetch("select max(wr_id) as cnt from $write_tableA");
$plusCnt= $row[cnt] + 100;
echo $write_tableB.'==>'.$write_tableA.'<p>';
echo "<hr>";
sql_query("INSERT INTO $write_tableA (wr_id ,wr_num, wr_reply, wr_parent ,wr_is_comment, wr_comment ,wr_comment_reply ,ca_name,wr_option,wr_subject,wr_content,wr_link1,wr_link2,wr_link1_hit,wr_link2_hit,wr_trackback,wr_hit,wr_good,wr_nogood,mb_id,wr_password,wr_name,wr_email,wr_homepage,wr_datetime,wr_last,wr_ip,wr_1,wr_2,wr_3,wr_4,wr_5,wr_6,wr_7,wr_8,wr_9,wr_10 )
select wr_id+$plusCnt, wr_num-$plusCnt,wr_reply, wr_parent+$plusCnt,wr_is_comment,wr_comment,wr_comment_reply,ca_name,wr_option,wr_subject,wr_content,wr_link1,wr_link2,wr_link1_hit,wr_link2_hit,wr_trackback,wr_hit,wr_good,wr_nogood,mb_id,wr_password,wr_name,wr_email,wr_homepage,wr_datetime,wr_last,wr_ip,wr_1,wr_2,wr_3,wr_4,wr_5,wr_6,wr_7,wr_8,wr_9,wr_10 from $write_tableB ");
sql_query(" unlock tables ", false);
$filePathA=$g4[path].'/data/file/'.$bo_tableA;
$filePathB=$g4[path].'/data/file/'.$bo_tableB;
$dir=@opendir($filePathB);
while($file=readdir($dir)) {
if ($file=='.' || $file=='..') continue;
echo 'file copy : '.$file.'<br>';
@copy($filePathB.'/'.$file, $filePathA.'/'.$file);
// @unlink($filePathB.'/'.$file); 주석풀면 삭제
}
sql_query("update $g4[board_file_table] set bo_table='$bo_tableA', wr_id = wr_id + $plusCnt where bo_table='$bo_tableB'");
?>
<hr>
OK
답변을 작성하시기 전에 로그인 해주세요.
