• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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