|
지난 번에 작성했던 소스는 단순히 headnum 만 변경하는 방식이었습니다만,
생각해보니 next_no, prev_num 문제 등 여러가지가 복합적으로 꼬일 수밖에 없는
방식이었습니다.
그래서 아예 원글을 삭제하고 그 데이터를 가지고 새 글을 입력하는 소스를
새로 작성했습니다.
write_ok.php 386행에 다음과 같은 부분이 있습니다.
[[{{]]
// 일반->일반, 공지->공지 일때
} else {
@mysql_query("update $t_board"."_$id set name='$name',subject='$subject',email='$email',homepage='$homepage',memo='$memo',sitelink1='$sitelink1',sitelink2='$sitelink2',use_html='$use_html',reply_mail='$reply_mail',is_secret='$is_secret',category='$category' $del_que1 $del_que2 where no='$no'") or error(mysql_error());
mysql_query("update $t_category"."_$id set num=num-1 where no='$s_data[category]'",$connect);
mysql_query("update $t_category"."_$id set num=num+1 where no='$category'",$connect);
}
[[}}]]
이것을 삭제하고 다음을 그대로 붙여넣어주시면 됩니다. 원하는 게시판 아이디로 변경해주시구요.
[[{{]]
// 일반->일반, 공지->공지 일때
} else {
// 필요한 데이터 불러옴
$is_son = mysql_fetch_array(mysql_query("select depth,child,total_comment,ismember,name from zetyx_board_".$id." where no=".$no.""));
// 답글이 아니고 답변글이 달려있지도 않아야 함
if($is_son[depth]=="0"&&!$is_son[child]&&$id=="test") {
// 공지사항이 아닐때
if(!$notice) {
$temp=mysql_fetch_array(mysql_query("select max(division) from $t_division"."_$id"));
$max_division=$temp[0];
$temp=mysql_fetch_array(mysql_query("select max(division) from $t_division"."_$id where num>0 and division!='$max_division'"));
if(!$temp[0]) $second_division=0; else $second_division=$temp[0];
$max_headnum=mysql_fetch_array(mysql_query("select min(headnum) from $t_board"."_$id where (division='$max_division' or division='$second_division') and headnum>-2000000000"));
if(!$max_headnum[0]) $max_headnum[0]=0;
$headnum=$max_headnum[0]-1;
$next_data=mysql_fetch_array(mysql_query("select division,headnum,arrangenum from $t_board"."_$id where (division='$max_division' or division='$second_division') and headnum>-2000000000 order by headnum limit 1"));
if(!$next_data[0]) $next_data[0]="0";
else {
$next_data=mysql_fetch_array(mysql_query("select no,headnum,division from $t_board"."_$id where division='$next_data[division]' and headnum='$next_data[headnum]' and arrangenum='$next_data[arrangenum]'"));
}
$prev_data=mysql_fetch_array(mysql_query("select no from $t_board"."_$id where (division='$max_division' or division='$second_division') and headnum<=-2000000000 order by headnum desc limit 1"));
if($prev_data[0]) $prev_no=$prev_data[0]; else $prev_no="0";
// 공지사항일때
} else {
$temp=mysql_fetch_array(mysql_query("select max(division) from $t_division"."_$id"));
$max_division=$temp[0]+1;
$temp=mysql_fetch_array(mysql_query("select max(division) from $t_division"."_$id where num>0 and division!='$max_division'"));
if(!$temp[0]) $second_division=0; else $second_division=$temp[0];
$max_headnum=mysql_fetch_array(mysql_query("select min(headnum) from $t_board"."_$id where division='$max_division' or division='$second_division'"));
$headnum=$max_headnum[0]-1;
if($headnum>-2000000000) $headnum=-2000000000;
$next_data=mysql_fetch_array(mysql_query("select division,headnum from $t_board"."_$id where division='$max_division' or division='$second_division' order by headnum limit 1"));
if(!$next_data[0]) $next_data[0]="0";
else {
$next_data=mysql_fetch_array(mysql_query("select no,headnum,division from $t_board"."_$id where division='$next_data[division]' and headnum='$next_data[headnum]' and arrangenum='0'"));
}
$prev_no=0;
}
$next_no=$next_data[no];
$child="0";
$depth="0";
$arrangenum="0";
$father="0";
// 디비전 정리
$division=add_division();
$new_division=mysql_fetch_array(mysql_query("select num from ".$t_division."_".$id." where no='".$division."'"));
$new_division=$new_division[num] - 1;
mysql_query("update ".$t_division."_".$id." set num='".$new_division."' where no='".$division."'");
// 새 글 데이터 입력
mysql_query("insert into $t_board"."_$id (division,headnum,arrangenum,depth,prev_no,next_no,father,child,ismember,memo,ip,password,name,homepage,email,subject,use_html,reply_mail,category,is_secret,sitelink1,sitelink2,file_name1,file_name2,s_file_name1,s_file_name2,x,y,reg_date,islevel,total_comment) values ('$division','$headnum','$arrangenum','$depth','$prev_no','$next_no','$father','$child','$is_son[ismember]','$memo','$ip','$password','$is_son[name]','$homepage','$email','$subject','$use_html','$reply_mail','$category','$is_secret','$sitelink1','$sitelink2','$file_name1','$file_name2','$s_file_name1','$s_file_name2','$x','$y','$reg_date','$member[is_admin]','$is_son[total_comment]')") or error(mysql_error());
if($prev_no) mysql_query("update $t_board"."_$id set next_no='$no' where no='$prev_no'");
if($next_no) mysql_query("update $t_board"."_$id set prev_no='$no' where headnum='$next_data[headnum]' and division='$next_data[division]'");
mysql_query("update $t_category"."_$id set num=num+1 where no='$category'",$connect);
// 코멘트 이동시킴
$new_no=mysql_fetch_array(mysql_query("select max(no) from ".$t_board."_".$id.""));
mysql_query("update zetyx_board_comment_".$id." set parent='".$new_no[0]."' where parent='".$no."'");
// 이전글삭제
mysql_query("delete from $t_board"."_$id where no='$no'") or Error(mysql_error());
// 번호 정리
$no=mysql_insert_id();
} else {
@mysql_query("update $t_board"."_$id set name='$name',subject='$subject',email='$email',homepage='$homepage',memo='$memo',sitelink1='$sitelink1',sitelink2='$sitelink2',use_html='$use_html',reply_mail='$reply_mail',is_secret='$is_secret',category='$category' $del_que1 $del_que2 where no='$no'") or error(mysql_error());
mysql_query("update $t_category"."_$id set num=num-1 where no='$s_data[category]'",$connect);
mysql_query("update $t_category"."_$id set num=num+1 where no='$category'",$connect);
}
}
[[}}]]
|
명 오늘 
명
PRINT Text
PRINT HTML
