PDA

View Full Version : Delete All PMs By A Specific User?


CeleronXL
09-14-2002, 11:52 PM
Can someone create a script (it should be very, very basic) that would delete all PMs from a specified userid? This should be a default feature in vB (as is the delete all posts by a user), because spamming posts isn't the only thing spammers do. Very often, they spam mass private messages to all of the other members (usually moderators and admin) and just mass do that. It should be a very basic query where you enter an id and delete it from the table, but I'd like a script set up to do it for me.

Tungsten
06-03-2003, 11:33 PM
I could really use something like this right about now.

filburt1
06-04-2003, 12:09 AM
DELETE FROM privatemessage WHERE fromuserid = userid;