xF1 Approve all moderated posts (queries)

  • Downloading from our site will require you to have a paid membership. Upgrade to a Premium Membership today!

    Dont forget read our Rules! Also anyone caught Sharing this content will be banned. By using this site you are agreeing to our rules so read them. Saying I did not know is simply not an excuse! You have been warned.

Radio

    ven0m

    Administrator
    Staff member
    Administrator
    Moderator
    Platinum
    xenForo 2.x.x
    xenForo 1.x.x
    Contributor
    vBulletin All Access Pass
    The Chest
    Verified
    Ultra Platinum VIP
    Platinum VIP
    Gold VIP
    Silver VIP
    Premium
    Member
    Jul 17, 2005
    20,466
    7,708
    321
    localhost
    Heisenberg submitted a new resource:

    - 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 = 'thread';
    
    UPDATE xf_thread
    SET discussion_state = 'visible'
    WHERE discussion_state = 'moderated';

    You also need to run this query to reset the...

     
    Thread starter Similar threads Forum Replies Date
    ven0m xF1 Soft delete all moderated posts (queries) Tips & Guides 0
    luigi86 xF1 Hide Posts From Guests Tips & Guides 5
    Similar threads