• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Approve all moderated posts (queries)

Jake Bunce

XenForo moderator
Staff member
#1
Jake Bunce submitted a new resource:

Approve all moderated posts (queries) (version 1.x) - Useful when you have a backlog of moderated posts.

You can run these two queries to approve all moderated posts:

Code:
DELETE
FROM xf_moderation_queue
WHERE content_type = 'post';

UPDATE xf_post
SET message_state = 'visible'
WHERE message_state = 'moderated';
And here are the queries to approve all moderated threads:

Code:
DELETE
FROM xf_moderation_queue
WHERE content_type = 'thread';

UPDATE xf_thread
SET discussion_state = 'visible'
WHERE discussion_state = 'moderated';
You also need to run this query to reset the count...
Read more about this resource...