1. 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)

Useful when you have a backlog of moderated posts.

  1. Jake Bunce
    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.
    Eagle and bousaid like this.

Recent Reviews

  1. Eagle
    Eagle
    5/5,
    Great, thank you..
  2. RobinHood
    RobinHood
    5/5,
    5/5 That's some high quality queries, would definitely query again