discuz! 批量删除未审核的主题和回复的办法

先查询一下与后台的未审核的主题数是否一致
SELECT count(*) FROM `bbs_threads` WHERE `displayorder` = -2;

批量删除未审核的主题
delete from `bbs_threads` WHERE `displayorder` = -2;

先查询一下与后台的未审核的回复数是否一致
SELECT count(*) FROM `bbs_posts` WHERE `invisible` = -2;


批量删除未审核的回复
delete FROM `bbs_posts` WHERE `invisible` = -2;