This resource is not affiliated with XenForo Ltd.
These queries will update the privacy preferences for all existing members, overriding what they have already set.
These queries would typically be used after an import to reset any incorrect or unwanted values.
Copy and paste the code below...
You can run these two queries to approve all moderated posts:
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:
DELETE
FROM xf_moderation_queue...