Delete IP address log for certain users

[mathforum]

Hi all,

Is there a way to do this? I don't like having all of my IP addresses over the years logged in the system forever.

Jameson

[ForceHSS]

DELETE FROM `ipdata` WHERE `userid` = 1
just change the userid hope this is what you are looking for

[mathforum]

Originally Posted by ForceHSS

DELETE FROM `ipdata` WHERE `userid` = 1
just change the userid hope this is what you are looking for

I ran the query and it affected over 1,000 rows, but no luck. Data is still there

I'm referring to the IP logs that you can see in the AdminCP. You search for a user and then in the drop-down box click "view IP addresses".

[Max Taxable]

Originally Posted by mathforum

I ran the query and it affected over 1,000 rows, but no luck. Data is still there

I'm referring to the IP logs that you can see in the AdminCP. You search for a user and then in the drop-down box click "view IP addresses".

And you used the correct userID in the query?

[kh99]

I think you want to remove it from the post table, like maybe

UPDATE post SET ipaddress='' WHERE userid = 1

[borbole]

Originally Posted by mathforum

I ran the query and it affected over 1,000 rows, but no luck. Data is still there

I'm referring to the IP logs that you can see in the AdminCP. You search for a user and then in the drop-down box click "view IP addresses".

To remove it there run this query:

UPDATE vb_adminlog SET ipaddress = WHERE userid = 1;

2 things to note. First replace the standard vb_ prefix with whatever prefix you use for your db tables. And 1 with your user id if it is something else then 1. Hope it helped.