数据库删除discuz 部分数据操作

如何快速清理discuz 3.2 中等待审核的回复数:pre_forum_post_moderate,点击清空

清空回收站的主题帖:DELETE FROM `pre_forum_thread` WHERE `displayorder` = -1
清空回收站回帖:DELETE FROM `pre_forum_post` WHERE `invisible` = -5
清空回收站日志:DELETE FROM `pre_home_blog` WHERE `status` = -1

批量删除DZ论坛中未审核的垃圾贴
delete from pre_forum_thread where displayorder=-2;
delete from pre_forum_post where invisible=-2;

posted @ 2017-11-13 12:05  coolid  阅读(1346)  评论(0编辑  收藏  举报