[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:

    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.