How do I prune all IPs and PMs on 3.0.5 ?

[mili]

I want to delete all IPs logged and PMs stored in my forums. How Do I do it?

mili

[Jake Bunce]

This query will clear the logged IPs in posts (backup first):

UPDATE post SET ipaddress = ''

Then you can turn off future IP logging in your:

Admin CP -> vBulletin Options -> Message Posting and Editing Options -> Log IP Addresses

And these queries should work to remove all PMs (backup first):

DELETE FROM pm

DELETE FROM pmreceipt

DELETE FROM pmtext

UPDATE user SET pmtotal = 0, pmunread = 0