XF 1 Tip Mark all PMs as read (queries)

[ENXF NET]

LQD submitted a new resource:

Mark all PMs as read (queries) - Mark all PMs as read (queries)

You can run these queries on your database to mark all PMs as read:

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