Delete All PMs.

[Arda MENDES]

I wanna delete all pms on the db.I deleted some sql queries but some problems appeared.

[Wordplay]

i thought you could do that through the admincp? if you can't (which i doubt), just do it for each member individually (you can do that if you go to their profile via the admin cp) unless of course you have 10,000+ members.

[Arda MENDES]

Originally Posted by Wordplay

i thought you could do that through the admincp? if you can't (which i doubt), just do it for each member individually (you can do that if you go to their profile via the admin cp) unless of course you have 10,000+ members.

Just have 70k+ members

Bump =)

[Arda MENDES]

I've found some sql queries.U can use it to delete pms.


Deleting Contents of Messages

PHP Code:

UPDATE `pmtext` SET `pmtextid` = NULL ,
`fromuserid` = '',
`fromusername` = '',
`title` = '',
`message` = '',
`touserarray` = '',
`iconid` = '',
`dateline` = '',
`showsignature` = '',
`allowsmilie` = '' 
WHERE `pmtext`.`pmtextid` > 0 ; 


Deleting Completely

PHP Code:

DELETE FROM `pmtext` WHERE `pmtext`.`pmtextid` > 0 ; 


[libabom]

problem .....

http://www.vbulletin.com/forum/showp...44&postcount=2

PHP Code:

 Steve Machol  Steve Machol is offline
Customer Support Manager
          
Join Date: Jul 2000
Location: Jelsoft InterGalactic HQ
Age: 54
Posts: 96,803
Steve Machol is on a distinguished road
To delete all PMs, run these 4 queries:

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

Of course, backup your database first.