You can run these two queries to approve all moderated posts:
And here are the queries to approve all moderated threads:
DELETE FROM xf_moderation_queue WHERE content_type = 'post'; UPDATE xf_post SET message_state = 'visible' WHERE message_state = 'moderated';
DELETE FROM xf_moderation_queue WHERE content_type =...
You do not have permission to view the full content of this resource. Log in or register now.
Likes: Eagle and bousaid