Mark all PM's read for single user

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