• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.
  • This forum has been archived. New threads and replies may not be made. All add-ons/resources that are active should be migrated to the Resource Manager. See this thread for more information.

Approve all moderated posts (queries)

Jake Bunce

XenForo moderator
Staff member
#1
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 in the moderator bar:

Code:
DELETE
FROM xf_data_registry
WHERE data_key = 'moderationCounts';