[Forum] Delete IP address log

[sweetpotato]

I want to protect my forum members private information and have set the forum did not log IP address but there are still IP address loged in the database. How can I delete the loged IP address?
Thanks,

[Steve Machol]

This cannot be undone so if you really want to do this, run these queries (assuming no table prefix):

1. To remove IPs from the User registration:

UPDATE user SET ipaddress='';

2. To remove all IPs from posts:

UPDATE post SET ipaddress='';

Note: Those are single quotes, not a double-quote.

Also vB will continue to log IPs on registration. Changing this requires modifying the code. We cannot officially support code modifications or forums running modified code, however you can try searching or asking for help with this over at www.vbulletin.org.

[sweetpotato]

Thank you Sir,

That all the thing I need!

[Neil]

Steve, could you please write a query to delete posts and registration IPs of one specific user?

[Hawk2]

Steve, could you please write a query to delete posts and registration IPs of one specific user?

you can delete the users posts from the admin panel

[Neil]

I mean to delete "posts IPs", not just "post"..

[Trevor Hannant]

UPDATE post SET ipaddress='' WHERE userid = x;