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.
  • About Us

    Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.
  • Like us on Facebook

  • Buy us a beer!

    The management works very hard to make sure the community is running the best software, best designs, and all the other bells and whistles. Care to buy us a beer? We'd really appreciate it!

    Donate to us!