$_zb_path = "../";
include "../lib.html";
$connect=dbconn();
$member=member_info();
if(!$member[no]||$member[is_admin]>1||$member[level]>1) Error("只限管理员使用.");
$board_info=mysql_fetch_array(mysql_query("select * from $admin_table where no='$no'",$connect));
$id=$board_info[name];
head("bgcolor=black")
?>
![]()
![]()
Category 清理分类:
$s_que="";
$f_cn="";
$temp=mysql_query("select * from $t_category"."_$id order by no asc");
while($no=mysql_fetch_array($temp))
{
if(!$f_cn)$f_cn=$no[no];
$s_que.=" category!='$no[no]' and ";
}
$s_que.=" category!=0";
$check=mysql_query("update $t_board"."_$id set category='$f_cn' where $s_que",$connect) or (mysql_error());
$temp=mysql_query("select * from $t_category"."_$id order by no asc");
while($no=mysql_fetch_array($temp))
{
$c=mysql_fetch_array(mysql_query("select count(*) from $t_board"."_$id where category='$no[no]'",$connect));
mysql_query("update $t_category"."_$id set num='$c[0]' where no='$no[no]'",$connect) or error(mysql_error());
}
echo"成功";
?>
Division 清理:
$temp=mysql_query("select * from $t_division"."_$id order by no asc",$connect);
while($data=mysql_fetch_array($temp))
{
$c=mysql_fetch_array(mysql_query("select count(*) from $t_board"."_$id where division='$data[division]'",$connect));
mysql_query("update $t_division"."_$id set num='$c[0]' where division='$data[division]'",$connect) or Error(mysql_error());
}
$temp=mysql_fetch_array(mysql_query("select count(*) from $t_board"."_$id",$connect));
mysql_query("update $admin_table set total_article='$temp[0]' where no='$no'",$connect) or Error(mysql_error());
echo"成功";
?>