update

  1. ENXF NET

    xF2 Add-on [cXF] Status update on What's new page 1.2.2

    Description: Easily update your profile status on What's new page. Screenshot:
  2. 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...
  3. 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...
  4. ENXF NET

    XF 1 Tip Mark all PMs as read (queries)

    You can run these queries on your database to mark all PMs as read: UPDATE xf_conversation_recipient SET last_read_date = UNIX_TIMESTAMP(); UPDATE xf_conversation_user SET is_unread = 0; UPDATE xf_user SET conversations_unread = 0;
  5. 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)...
Top