1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Approve all moderated profile posts (queries)

Here are the queries to soft delete all moderated profile posts

  1. dono
    Compatible XF Versions:
    • 1.4
    License:
    BSD License
    Backup first.

    Here are the queries to soft delete all moderated profile posts:

    Code:
    DELETE
    FROM xf_moderation_queue
    WHERE content_type = 'profile_post';
    
    UPDATE xf_profile_post
    SET message_state = 'visible'
    WHERE message_state = 'moderated';
    
    maszd likes this.