How to flush/remove IP addresses from certain Users

[thedvs]

I have an old database & have moderators with many different ip addresses in their user profiles dating from years back.

I would like to know how to delete these ip records so that only the latests ip's show from now on.

[joelcont]

good question .. i would like to know too

[Fusion]

Ehm, won't the most recent used show up at the top?
Deleting IP-data may seem trivial, but it can have its uses, historically speaking.

[thedvs]

anyone?

[Steve Machol]

These queries will delete ALL the IP addresses in posts and from user registraions (the only ones vB keeps):

UPDATE user SET ipaddress='';

UPDATE post SET ipaddress='';

NOTE: Those are two single quotes ('), not a double-quote(").

As with any changes to the db, I strongly recommend that you make a good backup of the database first.

[thedvs]

Is there any way to do it for a specific user? eg the Admin?

[Steve Machol]

UPDATE user SET ipaddress='' WHERE userid='xxx';

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

...with 'xxx' being the appropriate userid number, not name.