Mass PM delete

[b00k]

looking for something to clean up all the PMs on the forum. Is there currently a feature or a hack to do so for 3.0.X ?

If not, any thoughts?

[akanevsky]

Just run the following queries:
TRUNCATE TABLE pm
TRUNCATE TABLE pmtext

[baronvonwalz]

Yeah, because even if you make people delete their pm's, it still stays in the database.

[b00k]

Just run the following queries:
TRUNCATE TABLE pm
TRUNCATE TABLE pmtext

Thank you, works perfect.

Is there a way to truncate a specific users PMs?

[Marco van Herwaarden]

Is there a way to truncate a specific users PMs?You can do this from the dropdown menu when viewing a user in your ACP.

[stinger2]

Just run the following queries:
TRUNCATE TABLE pm
TRUNCATE TABLE pmtext

hi
you mean in

Admincp>Maintenance >Execute SQL Query

[stinger2]

pump

[peterska2]

Yes, you would do it there, or in phpmyadmin. Either is good.

[stinger2]

thank you for the response
rgds

sorry again....just one more question

should i run these queries apart or as one

i mean
TRUNCATE TABLE pm

and hit run

then another query
TRUNCATE TABLE pmtext

or i paste both of them and excute as one as
TRUNCATE TABLE pm
TRUNCATE TABLE pmtext

??

[stinger2]

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

queries are run one query at a time

got this answer from vbulletin.com just in case any one is also interested in this subject

credits to Steve Machol