Discuz! X 批量删除或通过待审核的帖子

执行以下SQL语句即可，为避免出错，建议操作前备份数据库。
注意：有分表时，需要对分表也执行相关语句。仅供参考，谨慎操作！

批量审核通过待审核的主题

update pre_forum_thread set displayorder=0 where displayorder=-2;
update pre_forum_post set invisible=0 where invisible=-2 and first=1;
delete from pre_forum_thread_moderate where status=0;

复制代码

批量审核通过待审核、已忽略的主题

update pre_forum_thread set displayorder=0 where displayorder=-3;
update pre_forum_post set invisible=0 where invisible=-3 and first=1;
delete from pre_forum_thread_moderate where status=1;

复制代码

批量审核通过待审核的回帖

update pre_forum_post set invisible=0 where invisible=-2;
delete from pre_forum_post_moderate where status=0;

复制代码

批量审核通过待审核、已忽略的回帖

update pre_forum_post set invisible=0 where invisible=-3;
delete from pre_forum_post_moderate where status=1;

复制代码

批量执行上述四项操作

update pre_forum_thread set displayorder=0 where displayorder in (-2,-3);
update pre_forum_post set invisible=0 where invisible in (-2,-3);
TRUNCATE pre_forum_thread_moderate;
TRUNCATE pre_forum_post_moderate;

复制代码

批量删除等待审核的主题

delete from pre_forum_thread where displayorder=-2;
delete from pre_forum_thread_moderate where status=0;

复制代码

批量删除等待审核、已忽略的主题

delete from pre_forum_thread where displayorder=-3;
delete from pre_forum_thread_moderate where status=1;

复制代码

批量删除等待审核的回帖

delete from pre_forum_post where invisible=-2;
delete from pre_forum_post_moderate where status=0;

复制代码

批量删除等待审核、已忽略的回帖

delete from pre_forum_post where invisible=-3;
delete from pre_forum_post_moderate where status=1;

复制代码

批量执行上述四项操作

delete from pre_forum_thread where displayorder in (-2,-3);
TRUNCATE pre_forum_thread_moderate;
delete from pre_forum_post where invisible in (-2,-3);
TRUNCATE pre_forum_post_moderate;

复制代码

批量移除待审核、草稿、回收站内容

delete from pre_forum_thread where displayorder<0;
TRUNCATE pre_forum_thread_moderate;
delete from pre_forum_post where invisible<0;
TRUNCATE 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

复制代码

冗余数据清理：
清除主帖已不存在的回帖，即post表中记录的tid在thread表中不存在时清除post表中的该行记录。
pre_forum_thread 有分表时禁用！pre_forum_post 有分表时，需要分别对每个分表执行下列语句（替换pre_forum_post为分表名，例如pre_forum_post_1）。
谨慎操作！！这边清理了一个月，未发现任何异常，但不排除有未知影响！

DELETE pre_forum_post FROM pre_forum_post LEFT JOIN pre_forum_thread ON pre_forum_post.tid=pre_forum_thread.tid WHERE pre_forum_thread.tid IS NULL

复制代码

清除主帖已不存在的分类信息数据

DELETE pre_forum_typeoptionvar FROM pre_forum_typeoptionvar LEFT JOIN pre_forum_thread ON pre_forum_typeoptionvar.tid=pre_forum_thread.tid WHERE pre_forum_thread.tid IS NULL

复制代码

		自动登录	找回密码
密码			立即注册

Discuz! X 批量删除或通过待审核的帖子-Discuz教程下载

Discuz! X 批量删除或通过待审核的帖子

相关文章

全部评论 0

最佳新人

管理/版主

土豪装逼

教程 / CSS+DIV素材

【原创】通过计划任务，实现Sitemap.xml地图制作49人阅读

修改Discuz!X3.5系统内置的DIY幻灯片样式64人阅读

【原创】调用帖子内容页封面图片，提升搜索引擎优化86人阅读

【原创】Discuz!X3.5版本无法访问uc_server中心解决办法436人阅读

【实测】各类meta标签的作用说明569人阅读

【原创】左侧导航栏样式，点击展开一级分类二级分类的DIY+CSS+JS731人阅读

【原创】discuz论坛首页四格，幻灯片+文字列表切换功能DIY+CSS+j2468人阅读

【原创】侧边导航栏样式，点击跳转到对应位置的DIY+CSS模块2230人阅读

【原创】分享一款html5+css3带倒计时效果并跳转指定网址的单页DI2433人阅读

【原创】分享一款横排5格免扣字体素材资源下载风格DIY+JS+CSS模2728人阅读

所属版块