PDA

View Full Version : Delete IP address log for certain users


mathforum
12-12-2012, 05:59 AM
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
12-12-2012, 09:20 AM
DELETE FROM `ipdata` WHERE `userid` = 1
just change the userid hope this is what you are looking for

mathforum
12-12-2012, 06:40 PM
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
12-12-2012, 06:45 PM
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
12-12-2012, 06:55 PM
I think you want to remove it from the post table, like maybe

UPDATE post SET ipaddress='' WHERE userid = 1

borbole
12-12-2012, 08:20 PM
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.