queries

  1. ENXF NET

    XF 1 Tip Set user privacy options using SQL queries

    This resource is not affiliated with XenForo Ltd. These queries will update the privacy preferences for all existing members, overriding what they have already set. These queries would typically be used after an import to reset any incorrect or unwanted values. Copy and paste the code below...
    • ENXF NET
    • Resource
    • allow change followed members options privacy profile queries registration replace settings these update values
    • Category: XenForo Tips & Guides
  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