Delete a certain members PM's?

[.Joe]

It seems I have a PM spammer to deal with...

Is there a way to delete all of a members PM's at once?
Maybe a SQL query?

[iHydra]

Just tested it on a test forum.

DELETE FROM mybb_privatemessages WHERE uid = {UID OF USER}

Seemed to work fine.
As usual, make sure you have a DB Backup in case if something goes wrong.

**Wait, the inbox was gone too. Not sure if it was deleted already. Wait for a confirmation of the above query.

[.Joe]

Yeah when you send a PM it creates two rows in the database, one goes to the recipient and one goes to your sent messages folder. I'd imagine there would be two seperate queries right?

[iHydra]

Yeah when you send a PM it creates two rows in the database, one goes to the recipient and one goes to your sent messages folder. I'd imagine there would be two seperate queries right?

I hope so. There is UID who is the sender, and the TID or something like that which is the receiver.

[.Joe]

I just went into the mybb_privatemessages table and deleted all the spam one by one...

I think the option to delete all of a member's sent PM's at once should be a standard option in the ACP

[Exze]

I just went into the mybb_privatemessages table and deleted all the spam one by one...

I think the option to delete all of a member's sent PM's at once should be a standard option in the ACP

Glad you got it sorted. I think it would be good when you ban a user there is an option to delete all PM's. Might look into it when I have some time.

[Max Payne]

Matt's MyBB - Goodbye Spammer is an additional option which you can use. This plugin deletes spammer's PM's when you bam him.