Flarum论坛批量审核帖子 – mysql数据库批量审核Flarum论坛待审发帖

Flarum发帖内容长时间不管理，待审理数量过多，可以操作数据库进行批量审核，这里发一下脚本内容，涉及的数据库表有3个：tb_discussions(主题表)、tb_posts(回复表)、tb_flags(标记表)。

脚本：

-- 操作tb_discussions表
UPDATE tb_discussions td
JOIN tb_posts tp ON td.id = tp.discussion_id
JOIN tb_flags tf ON tp.id = tf.post_id
SET td.is_private = 0, td.is_approved = 1
WHERE td.is_private = 1 AND tf.type = 'approval' and td.id = 80338;


-- 操作tb_posts表 
UPDATE tb_posts tp
JOIN tb_flags tf ON tp.id = tf.post_id
SET tp.is_private = 0, tp.is_approved = 1
WHERE tf.type = 'approval' and tp.is_private = 1 and tp.id = 89730;

-- 操作表tb_flags
DELETE FROM tb_flags
WHERE type = 'approval' and post_id = 89730;

说明：tb_flags表中 type = 'approval' 代表待审核， type = 'user'代表举报内容。