Resource icon

Approve all moderated posts (queries)

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 =...
You do not have permission to view the full content of this resource. Log in or register now.
Author
Jake Bunce
First release
Last update
Rating
5.00 star(s) 2 ratings

More resources from Jake Bunce

Latest reviews

Great, thank you..
5/5 That's some high quality queries, would definitely query again
Top