How do I delete *all* private messages?

[z0diac]

Is it possible to delete *all* private messages for all users?

[Steve Machol]

To delete all PMs, run these 5 queries:

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

Of course, backup your database first.

[z0diac]

To delete all PMs, run these 5 queries:

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

Of course, backup your database first.

THANK you.

[stuarttunstall]

Will this work on v 3.7.0?

[Steve Machol]

It should.

[Jose Amaral Rego]

Will this work on v 3.7.0?

If you want to know, then link back to this thread for a question you can ask in 3.7.0 forums. It would seem that it will work, but then you always have to create a working database backup prior to run these queries.

http://www.vbulletin.com/forum/showpost.php?p=1526062&postcount=8