Announcement

Collapse
No announcement yet.

How do I prune all IPs and PMs on 3.0.5 ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do I prune all IPs and PMs on 3.0.5 ?

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

    mili

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

    Code:
    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):

    Code:
    DELETE FROM pm
    
    DELETE FROM pmreceipt
    
    DELETE FROM pmtext
    
    UPDATE user SET pmtotal = 0, pmunread = 0

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X