visible

  1. ENXF NET

    XF 1 Tip Apply CSS styling to sticky / pinned threads

    This resource is not affiliated with XenForo Ltd. This is a simple edit to change the css for sticky threads only. Add this to EXTRA.css: .discussionListItem.visible.sticky, .discussionListItem.visible.sticky .posterAvatar, .discussionListItem.visible.sticky .stats { background: @inlineMod...
    • ENXF NET
    • Resource
    • attach background change color colour discussionlistitem gradient italic sticky title visible
    • 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
  3. 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