[View IPs for *]

[Glock21]

Is there a way to clear all of the past used IP's for a selected user, or the entire membership?

[Scott MacVicar]

Unfortunately not as they stored in the post table and if you clicked IP on the post you would then get an error.

If that didnt bother you then

UPDATE post SET ipaddress='' WHERE userid=USERID

where USERID is the userid of the person your wanting to delete the IP's for.

[Glock21]

Where do I put this, also couldn't it just be setup such as

UPDATE post SET ipaddress='0.0.0.0' WHERE userid=USERID

?

[Steve Machol]

You enter that query in phpMyAdmin exactly as PPN wrote.

[Glock21]

I was just curious if it would work if you entered 0.0.0.0 or what not so it wouldn't give an error when clicked on, also what is the step to reverse the procedure?


Thanks

[Steve Machol]

You can't reverse it. Once you've cleared the data, it's gone.