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?
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.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.