MyBB Community Forums

I've banned an user who sent spam PM's.

Now I see that even after banning the user his/her PM's are still available to be read by other users to whom he/she sent it.

How do I delete all those PM's?

NOTE: Remember to backup the database before performing or running this query.

Am not sure, not tried but you could run some query like this in phpmyadmin:

DELETE FROM `mybb_privatemessages` where uid=X

where X is the user id (uid) of the user whom you banned and want to delete.

The query you'll want is:

DELETE FROM `mybb_privatemessages` WHERE `fromid` = '1'

But make sure you change the 1 to whatever the bad user's uid was.

Install GoodByeSpammer plugin, it has the option to delete PMs aswell.