moderated

  1. ENXF NET

    XF 1 Tip Approve all moderated profile posts (queries)

    Backup first. Here are the queries to soft delete all moderated profile posts: DELETE FROM xf_moderation_queue WHERE content_type = 'profile_post'; UPDATE xf_profile_post SET message_state = 'visible' WHERE message_state = 'moderated';
  2. ENXF NET

    XF 1 Tip Approve all moderated posts (queries)

    You can run these two queries to approve all moderated posts: 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: DELETE FROM xf_moderation_queue...
    • ENXF NET
    • Resource
    • content delete discussion message moderated moderation queries queue state update visible where
    • Category: XenForo Tips & Guides
Top