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

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

用phpMyAdmin批量删广告和不良信息帖子和待审核帖子：

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

批量删除未审核的主题
delete from 表前缀_threads where displayorder=-2;

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

批量删除未审核的回复
delete from 表前缀_posts where invisible=-2;

新手小心操作，建议删除之前先备份一下：）

删除审核主题

delete from cdb_threads  where displayorder=-2;

删除审核帖子

delete from cdb_posts where invisible=-2;