Mini Mods - Delete IPs within a certain interval

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.

[salata]

awesome. do you have any idea how i can make this work for 3.5.4? i tried and i get errors

[Patria]

Originally Posted by salata

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?

[salata]

Originally Posted by Patria

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

[Patria]

Originally Posted by salata

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

[Masala4india]

Could you please tell the manual way to delete the IP addresses coz i want to see how many IP's are stored.

[Sparticus_V2]

here is a question, I used this to delete the logs off all the proxy servers that had been used... But just to save time i deleted all intervals, and i figured the true IPs should start showing up as the members logged in... But now no IPs store in the user info section and I want them to, I deleted the Cron, what else must i do? I NEED TO KNOW THE IPs!!

[Patria]

Originally Posted by Masala4india

Could you please tell the manual way to delete the IP addresses coz i want to see how many IP's are stored.

Execute the following lines via PhpMyAdmin for example.

PHP Code:

UPDATE adminlog SET ipaddress = ''
UPDATE moderatorlog SET ipaddress = ''
UPDATE post SET ipaddress = ''
UPDATE threadrate SET ipaddress = ''
UPDATE user SET ipaddress = '' 


Originally Posted by Sparticus_V2

here is a question, I used this to delete the logs off all the proxy servers that had been used... But just to save time i deleted all intervals, and i figured the true IPs should start showing up as the members logged in... But now no IPs store in the user info section and I want them to, I deleted the Cron, what else must i do? I NEED TO KNOW THE IPs!!

If you want to delete the IPs except the IPs in the user info section you should remove the following line:

PHP Code:

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET ipaddress = ''"); 


from the deleteip.php.

[Sparticus_V2]

if i have already run it, and the IPs are no longer comming back, what can i do to have the IPs start being collected agin in the Database?

[Patria]

Originally Posted by Sparticus_V2

if i have already run it, and the IPs are no longer comming back, what can i do to have the IPs start being collected agin in the Database?

You dont need to do something because vB logs the IPs. The plugin only remove the IPs within the specified interval. If you want get the IPs from the User Info dialog back you need to restore you database backup (in detail it would be enough to restore the user table).

[accessdeniedzzz]

thnaks,
we still need sush addons for users privacity