1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Registration Email Allowed In Our Database :  Yahoo * Gmail * Hotmail * Outlook * yandex * live * are allowed to register in our database. [ We Will Approve Manually After Review It ]

Tips & Guides Mark all PMs as read (queries)

Sometimes useful after an import.

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