Welcome to Our Community

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

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.