update

[OzzModz] XFRM: Update Comments 2.2.0

Simple addon that will show the date addons were installed/updated on your site. Note that this only shows dates of addons installed/updated after installing this addon.

Description: Easily update your profile status on What's new page. Screenshot:

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...

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...

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;

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)...