Mark all PM's read for single user

[MagicPID]

I recently used ImpEx to transfer a MyBB forum to vBulletin. I had approximately 3,500 PM's in my inbox which for the time being I do NOT want to delete or remove. However, vBulletin has marked all of these as unread. What is the easiest way to to mark all of my PM's as read?

Thanks for your suggestions!

[Disasterpiece]

you need to run 2 sql queries.

This sets new pm count for every user to 0:
UPDATE vb4_user SET pmunread = 0

To mark the pms as unread as well inside the mailbox, use this query:
UPDATE vb4_pm SET messageread = 1

If you want to run it only for a single user, the queries are as follows:


This sets new pm count for the user with id 42 to 0:
UPDATE vb4_user SET pmunread = 0 WHERE userid = 42

To mark the pms belonging to user #42 as unread inside the mailbox, use this query:
UPDATE vb4_pm SET messageread = 1 WHERE userid = 42

Substitute vb4_ for the table prefix you're using and 42 for the userid you want to run the queries for.
It's safer to test these in a safe environment first, I suggest to copy the table before trying to run those queries.

[MagicPID]

Disasterpiece,

Thanks a ton for that! It worked perfectly. Much appreciated.