Delete all PM's!!!
 

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.

use a truncate query on the pm tables;)

and make sure to reset every users pm count then:)

whats the query plz ;(

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

code didnt work ;(

what was the error message?

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.

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

thanks, worked