MyBB Community Forums

I did some searching on this, found nothing.

I am looking for some help on removing everyone's "read" PM's. Leaving only their unread and saved messages.
We are moving the board and we want to clean the db as much as posable first.
I know we have 1000's of PMs that users just leave. Even with an email to them about it, they don't listen.

Can some help?

Thanks!

Are you sure?? I mean they might have stuff they want to save... but, here's the query anyway...

DELETE FROM `mybb_privatemessages` WHERE `status` = '1' AND `folder` = '1'

This will delete all read messages from their inbox. Make sure your table prefix, mybb_ here, is correct.

Also, make a backup before doing this, and please, check that everything is as it should be after you run it, and if it's not, revert to the backup, and report back.

ok Matt, thank you.. i'll let you know how we made out once we do it.
A mass email will be sent out again to everyone first warning them about saving any messages they may need.