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]

[SQL]
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;
[/SQL]

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