Emptying all private messages

[EasyEasy]

Good evening all.

Question about private messages on vbulletin. Is there a way to empty all private messages in the database. I have something around 65 thousand in there and would love to clean then out as i know members dont even after being told to do so.

In phpBB forum it was a case of emptying the relevant tables but im not sure if its the same on vbulletin. Running 4.1.1 by the way if that helps.

Had a google of the web and came up with this from vbulletin forums however its for 3.8

To delete all PMs for all users, run these 5 queries:

UPDATE `user` SET `pmtotal` = '0';
UPDATE `user` SET `pmunread` = '0';
TRUNCATE TABLE `pm`;
TRUNCATE TABLE `pmtext`;
TRUNCATE TABLE `pmreceipt`;

any help appreciated guys.

---------- Post added 11th December 2011 at 15:56 ---------- Previous post was 10th December 2011 at 22:05 ----------

Anyone help?

 

[Fillip H.]

Those queries should work just fine for vBulletin 4, the tables have not changed since then

 

[EasyEasy]

Those queries should work just fine for vBulletin 4, the tables have not changed since then

Ok thanks for the reply mate.

Ill backup and run them

Cheers