Delete all PM's!!!

[MentaL]

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

[Zachery]

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]

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

[laborer75]

When I run the query...

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

I get this error message...

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
TRUNCATE TABLE pmtext;
TRUNCATE TABLE pmreceipt;
UPDATE us

What am i doing wrong? Just want to mass delete all the pms from whole message board...Thanx in advance..:)

[tnguy3n]

When I run the query...

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

I get this error message...

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
TRUNCATE TABLE pmtext;
TRUNCATE TABLE pmreceipt;
UPDATE us

What am i doing wrong? Just want to mass delete all the pms from whole message board...Thanx in advance..:)
Try to run those queries in phpMyAdmin instead or enter one query a time in AdminCP, Execute mysql Query.

[laborer75]

Try to run those queries in phpMyAdmin instead or enter one query a time in AdminCP, Execute mysql Query.

Thanx a million...that did it...:D