vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   how do i clear IPs logged (https://vborg.vbsupport.ru/showthread.php?t=107302)

yayvb 02-06-2006 04:41 PM

how do i clear IPs logged
 
Hi,

https://vborg.vbsupport.ru/showthread.php?p=892363

As you can see from the above thread and the marijuana online communities, overgrow.com and some other websites have been closed and records have been seized by canadian government officials.

My website is of similar content, and I just want to ensure my users that there is limited liability. I have IP logs set to display only to admin, but I am looking to no longer log ip addresses and delete existing logs.

How do I get rid of IPs logged in the database?

Paul M 02-06-2006 05:00 PM

vBulletin Options > Message Posting and Editing Options > Log IP Addresses - set to "Do no Log".

You will need to run an sql query to clear old ip addresses, and delete all old database backups (or keep them where no one can find them except you).

[sql]update post set ipaddress = '';[/sql]

nitro 02-06-2006 06:47 PM

Dont forget the webserver itself logs aswell.

yayvb 02-06-2006 07:48 PM

Hmm, and I suppose my cpanel webalizer and other various preintalled stat scripts store this info too, to some extent. Atleast it doesn't make it super easy and associate a username with ip address.

I'm not so sure any government parties in the U.S. would actually use the IP information. But I guess we could all speculate.

PaulM thanks for the help, I'm doing this now. I wonder if their IP addresses will still be stored in the database for each member or whatever.

I just searched for some IP addresses and found all the places they are stored. I use vbgallery so I ran
Code:

UPDATE adv_gallery_images SET ipaddress ='';
UPDATE adv_gallery_posts SET ipaddress='';

Then I ran this. Obviously if you don't use the gallery above don't bother running the above queries, they won't succeed. Of course these 2 queries are in addition to what paul said above. Just to be thorough.
Code:

UPDATE search SET ipaddress='';
UPDATE user SET ipaddress='';

I'm sure you can't be thorough enough, this is only to make things not so easy in the event your site winds up like overgrow.

yayvb 02-11-2006 04:05 AM

Then to stop the registration section from updating the new users user table with the ipaddress you find this in your register.php file:

Code:

$userdata->set('ipaddress', IPADDRESS);
& replace it with this

Code:

$userdata->set('ipaddress','');
save upload, be sure to rerun the update on your user table above......


All times are GMT. The time now is 03:55 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01040 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete