Jake Bunce
Well-known member
Jake Bunce submitted a new resource:
Mark all PMs as read (queries) (version 1.x) - Sometimes useful after an import.
Read more about this resource...
Mark all PMs as read (queries) (version 1.x) - Sometimes useful after an import.
You can run these queries on your database to mark all PMs as read:
Code: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;
Read more about this resource...