Delete IP address log for certain users
 

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

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".

And you used the correct userID in the query?

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

To remove it there run this query:

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.