state

  1. ENXF NET

    xF2 Add-on [MMO] Disable User State 2.1.0

    Adds the ability to disable your account.
  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
  3. ENXF NET

    XF 1 Tip Soft delete all moderated posts (queries)

    You can run these queries to soft delete all moderated posts. You need to change the red pieces to attribute these deletions to a user_id and username, as well as give the reason. These things are recorded in the deletion log: INSERT INTO xf_deletion_log (content_type, content_id, delete_date...
  4. ENXF NET

    XF 1 Tip Rebuild user post counts (query)

    This will recalculate and update the post counts for all users at once. This is a large query that may take a while to finish. UPDATE xf_user AS user SET message_count = ( SELECT COUNT(*) FROM xf_post AS post LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)...
    • ENXF NET
    • Resource
    • count discussion encounter errors group large message query select settings state these thread timeout update visible where
    • Category: XenForo Tips & Guides
Top