Welcome to Our Community

Registration on our forums are now open for some days! Feel free to sign up today.

[xenForo Tips/Guide] Mark all PMs as read (queries)

Mark all PMs as read (queries)

  1. XenForo Rocks
    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 =...
    You do not have permission to view the full content of this resource.