Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Delete IPs within a certain interval Details »
Delete IPs within a certain interval
Mod Version: 1.03, by Patria (Member) Patria is offline
Developer Last Online: Jan 2010 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.5 Rating: (1 vote - 5.00 average) Installs: 20
Released: 02 Feb 2007 Last Update: 16 Mar 2008 Downloads: 161
Not Supported Additional Files  

Description:

The script deletes the IP adresses within the following tables: adminlog, moderatorlog, post, threadrate, user. It doesnt remove the banned IPs (vBulletin Options, User Banning Options, Banned IP Addresses).

Installation:

1) Upload deleteip.php to /includes/cron

2) Login into your AdminCP

3) Go to Scheduled Tasks, Add New Scheduled Task

Varname: deleteip
Title: Delete IPs
Description: Delete IPs within a certain interval.
Log Phrase: Delete IPs

Set Interval.

Filename: ./includes/cron/deleteip.php
Product: vBulletin

Update Instructions:

Replace the file deleteip.php.

History:

Version 1.01: Cron Logging - log_cron_action() added.
Version 1.02: Speed Improvement - Significantly faster without the conditionals.
Version 1.03: Added conditionals again to decrease the database load.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
End-User Options Self Delete: Allow users to self-delete their account calorie vBulletin 3.6 Add-ons 138 29 May 2015 01:50
Moderators Functions Hard Delete (physical delete) By User Group Jafo232 vBulletin 3.7 Add-ons 27 28 Oct 2013 20:08

Comments
  #2  
Old 03 Feb 2007, 01:40
cygy2k cygy2k is offline
 
Join Date: May 2006
Can you explain the benefit of this? I'm sure there must be one but I'm unaware of it.
Reply With Quote
  #3  
Old 03 Feb 2007, 04:48
thincom2000 thincom2000 is offline
 
Join Date: Jun 2006
Real name: Ted
I think it's just to reduce the size of your database...
Reply With Quote
  #4  
Old 03 Feb 2007, 10:02
Patria Patria is offline
 
Join Date: May 2005
Originally Posted by cygy2k View Post
Can you explain the benefit of this?
You support your members to protect their privacy.

If you turn off the IP Address Log within vBulletin - AdminCP, Message Posting and Editing Options, Log IP Addresses, vBulletin still logs the IP Addresses in several other tables except the post table and the IP Addresses are still held in your database from the time before you put down the switch.

Why would someone turn off the IP address logging?

For security and privacy reasons.

Three Scenarios

Copyright Violation: A member posted a direct link to Disneys current movie and Disney asks you for the IP address of the user? You could say sorry, we do not log IP addresses to protect the privacy of our members.

Free Speech: A member posted something your goverment doesnt like and they ask you for the IP address of the user? You could say sorry, we do not log IP addresses to protect the privacy of our members.

Data Theft: Someone hacked your server and does a mysqldump, with the IP addresses he could easily run all IP addresses against a Geolocation database and sell it to markting companies or use it to uncover your members together with the email addresses.

You simply dont have what they try to get. You should also delete your webserver logs within a certain interval and instruct your members to use suitable email providers. Or use secure proxies in general which usual user doesnt do.

Last edited by Patria; 04 Feb 2007 at 16:24.
Reply With Quote
  #5  
Old 03 Feb 2007, 19:28
SCRIPT3R SCRIPT3R is offline
 
Join Date: Jan 2005
Excellent... i've always done this manually.
Reply With Quote
  #6  
Old 04 Feb 2007, 04:40
Hornstar's Avatar
Hornstar Hornstar is offline
 
Join Date: Jun 2005
Real name: Matt
Thanks for sharing the benefits, it now makes more sense, Just one question, If I have a member who I wnat to ban by IP, how will I know what his IP is?
Reply With Quote
  #7  
Old 04 Feb 2007, 12:03
Patria Patria is offline
 
Join Date: May 2005
Originally Posted by hornstar1337 View Post
Thanks for sharing the benefits, it now makes more sense, Just one question, If I have a member who I wnat to ban by IP, how will I know what his IP is?
You still see the IP address via Who's Online (online.php) and you could control the deletion interval of course.

Last edited by Patria; 04 Feb 2007 at 16:24.
Reply With Quote
  #8  
Old 22 Feb 2007, 22:58
JKelleyus JKelleyus is offline
 
Join Date: Oct 2006
I'm curious about this....

I run a somewhat controversial local politics forum where people have become upset and threatened to sue members for their posts.

What effect does deleting the IP's have on vB as a whole? Will it mess with the polling (if enabled for guests)? If I process server logs for statistical data, and then run the cron job, will my stats still be valid (I try and maintain a 7 day stat that includes geo-location by IP)?

Thanks for any answers...

Jake
Reply With Quote
  #9  
Old 23 Feb 2007, 00:22
Patria Patria is offline
 
Join Date: May 2005
Originally Posted by JKelleyus View Post
What effect does deleting the IP's have on vB as a whole?
No effect, vBulletin still dont know the IPs of the members.
Will it mess with the polling (if enabled for guests)?
I dont know how vBulletin handles polls regarding to guests. Backup your database and run the script.
If I process server logs for statistical data, and then run the cron job, will my stats still be valid (I try and maintain a 7 day stat that includes geo-location by IP)?
The script is only responsible for vBulletin, the vBulletin database. Your Webserver logs are independent and the script wouldnt touch them. If you like to remove the logs you need to setup a additional linux cron job - the cron job mention by this plugin means vBulletin cron jobs (Scheduled Tasks).

Last edited by Patria; 23 Feb 2007 at 00:29.
Reply With Quote
  #10  
Old 23 Feb 2007, 00:39
ZomgStuff's Avatar
ZomgStuff ZomgStuff is offline
 
Join Date: Feb 2007
Reserved.
Reply With Quote
  #11  
Old 25 Mar 2007, 05:57
salata salata is offline
 
Join Date: Nov 2003
awesome. do you have any idea how i can make this work for 3.5.4? i tried and i get errors
Reply With Quote
  #12  
Old 31 Mar 2007, 23:41
Patria Patria is offline
 
Join Date: May 2005
Originally Posted by salata View Post
awesome. do you have any idea how i can make this work for 3.5.4? i tried and i get errors
What kind of errors?
Reply With Quote
  #13  
Old 01 Apr 2007, 03:39
salata salata is offline
 
Join Date: Nov 2003
Originally Posted by Patria View Post
What kind of errors?
thanks for responding. Its ok now, i wasnt able to get it to work. But i figured out how to delete them manually just by putting a query in, so i'll just stick with that. i didnt want to complicate things, as this was made for 3.6. great mod though!! i'll be using this for another board i am a admin at
Reply With Quote
  #14  
Old 08 Apr 2007, 14:21
Patria Patria is offline
 
Join Date: May 2005
Originally Posted by salata View Post
thanks for responding. Its ok now, i wasnt able to get it to work. But i figured out how to delete them manually just by putting a query in, so i'll just stick with that. i didnt want to complicate things, as this was made for 3.6. great mod though!! i'll be using this for another board i am a admin at
Dont forget to press install (Mark as Installed).
Reply With Quote
  #15  
Old 22 Apr 2007, 13:49
Masala4india Masala4india is offline
 
Join Date: Jun 2006
Could you please tell the manual way to delete the IP addresses coz i want to see how many IP's are stored.
__________________
Indian Masala Board
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 20:04.

Layout Options | Width: Wide Color: