[BirdOPrey5]

Well I haven't tested this because I like my IP addresses but I pulled code from my other working mods so i expect it should work.

Save this to a php file and upload it to your includes/cron/ directory.

In scheduled task manager make a new one and point it to this file, set what options you want.

Manually run it first to be sure it works, if it does set it to run every 10 minutes...

I'm not sure what other side effects this will have... User's shouldn't get locked out because they will still have their unique IP for a few minutes.

PHP Code:

<?php
/*============================================================================*\
|| # Basic Cron Script                                                      # ||
\*============================================================================*/

error_reporting(E_ALL & ~ E_NOTICE);

global $vbulletin;

//Main Script
 
  $log = "";

  //Erase all post ip addresses
  $SQL = "UPDATE " . TABLE_PREFIX . "post 
  SET ipaddress = '' 
  WHERE ipaddress != '' ";
 
  //RUn query above
  $vbulletin->db->query_write($SQL); 
  
  $aff = $vbulletin->db->affected_rows();
  $log .= "$aff Post IP Addresses Cleared. <br />"; 


  //Erase all user ip addresses
  $SQL = "UPDATE " . TABLE_PREFIX . "user 
  SET ipaddress = '' 
  WHERE ipaddress != '' ";
 
  //RUn query above
  $vbulletin->db->query_write($SQL); 
  
  $aff = $vbulletin->db->affected_rows();
  $log .= "$aff  User IP Addresses Cleared. <br />"; 


  $log .= "IP purge Complete.";
  log_cron_action($log, $nextitem);

?>

Obviously you should backup your database before running any untested code, especially database queries.

I assume this is for the site in your profile which is still very small (< 1000 posts) so I don't see this being a problem.

If you had a big site, like hundreds of thousands of posts and users or more this probably wouldn't run very efficiently trying to clear hundreds of thousands of records. But you should have no issue running it every 10 minutes.


This takes care of posts and user tables... if you have blogs or cms they would probably need to be included in separate queries.