You can run these two queries to approve all moderated posts:
And here are the queries to approve all moderated threads:
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 =...
You do not have permission to view the full content of this resource.
Log in or register now.