• 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
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';
 
Top