Áö³ ¹ø¿¡ ÀÛ¼ºÇß´ø ¼Ò½º´Â ´Ü¼øÈ÷ 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);
}
}
[[}}]]
|