Delete all PM's!!!

[MentaL]

How do i go about deleting all pms from every single user?

[Zachery]

Originally Posted by mentalrz

How do i go about deleting all pms from every single user?

Empty the pm tables O.o

notice i said empty and not drop.

[AN-net]

use a truncate query on the pm tables

and make sure to reset every users pm count then

[MentaL]

whats the query plz ;(

[rake]

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

[MentaL]

code didnt work ;(

[Zachery]

Originally Posted by mentalrz

code didnt work ;(

what was the error message?

[Princeton]

I recommend creating an Official "Queries List" (STICKY) ... it would help a lot of people. Plus, minimize the same questions being asked over and over again.

[AN-net]

but there is a danger in giving that because hackers/users(if they got access) could destroy an entire database

[MentaL]

thanks, worked