1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. This forum has been archived. New threads and replies may not be made. All add-ons/resources that are active should be migrated to the Resource Manager. See this thread for more information.

Mark all PMs as read (queries)

Discussion in 'Tips and Guides [Archive]' started by Jake Bunce, Jun 20, 2011.

  1. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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;
    
     
  2. GregF

    GregF Active Member

    Thanks for this Jake, just run it on my imported MyBB forum and it worked perfectly :)
     
  3. Floris

    Floris Guest

    I've used this about a gazillion times already with converts. Thanks Jake.
     
  4. yavuz

    yavuz Well-Known Member

    How would we delete all PC with a query?
     
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    yavuz likes this.

Share This Page