XF 1.2 How to mark all conversations read for a single user

[lantek]

Is there anyway to mark all conversations read (1000s) for specific users?

Thanks

 

[Jeremy]

Run the following query, replacing the ID with the specified ID:

UPDATE `xf_conversation_recipient` 
SET `last_read_date`=UNIX_TIMESTAMP() 
WHERE`user_id` = '3'

 

[lantek]

Thanks!