IP address field, want to wipe it clean.

[TORON]

I would like to remove all the IPaddress enteries for a specific user.

Looking at mysql database I see the IP address for someone when they made a post.

I would like to remove all records of an IP address for a specific user.

Any hacks or suggestion on how to do this?

Thanks.

[Andreas]

UPDATE post SET ipaddress='' WHERE userid=1234;
UPDATE search SET ipaddress='' WHERE userid=1234;
UPDATE threadrate SET ipaddress='' WHERE userid=1234;
UPDATE user SET ipaddress='' WHERE userid=1234;


1234 should be replaced by the real UID of course ;)

[TORON]

Thank you, works great, I'm starting to understand this now.

One more area people should check is
adminlog

How about removing them all? Wildcard rather then a value for userID?

[Xenon]

for removing all ip's you just have to remove the WHERE clause :)