1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. This forum has been archived. New threads and replies may not be made. All add-ons/resources that are active should be migrated to the Resource Manager. See this thread for more information.

Approve all moderated posts (queries)

Discussion in 'Tips and Guides [Archive]' started by Jake Bunce, Jun 20, 2011.

  1. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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 count in the moderator bar:

    Code:
    DELETE
    FROM xf_data_registry
    WHERE data_key = 'moderationCounts';
    
     

Share This Page