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]

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 :rolleyes:

Bump =)

[Arda MENDES]

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


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


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

[libabom]

problem .....

http://www.vbulletin.com/forum/showpost.php?p=1280744&postcount=2




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.