2013-04-26, 10:49 PM
2013-04-27, 01:17 AM
Just tested it on a test forum.
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.
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.
2013-04-27, 02:19 AM
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?
2013-04-27, 02:42 AM
(2013-04-27, 02:19 AM)theezy Wrote: [ -> ]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.
2013-04-27, 05:18 AM
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
I think the option to delete all of a member's sent PM's at once should be a standard option in the ACP
2013-04-27, 11:12 AM
(2013-04-27, 05:18 AM)theezy Wrote: [ -> ]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.
2013-04-27, 01:38 PM
Matt's MyBB - Goodbye Spammer is an additional option which you can use. This plugin deletes spammer's PM's when you bam him.