Welcome to Our Community

Registration on our forums are now open for some days! Feel free to sign up today.

[xenForo Tips/Guide] Approve all moderated posts (queries)

Useful when you have a backlog of moderated posts.

  1. XenForo Rocks
    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...
    You do not have permission to view the full content of this resource.
  • About Us

    Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.
  • Like us on Facebook

  • Buy us a beer!

    The management works very hard to make sure the community is running the best software, best designs, and all the other bells and whistles. Care to buy us a beer? We'd really appreciate it!

    Donate to us!