Advertisement
Guest User

adrotate_clean_trackerdata

a guest
Apr 12th, 2012
284
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.72 KB | None | 0 0
  1. Add this line
  2.  
  3.     $wpdb->query("DELETE FROM `".$wpdb->prefix."adrotate_tracker` WHERE `ipaddress` ='unknown';");
  4.  
  5. Function now looks like:
  6.  
  7. /*-------------------------------------------------------------
  8.  Name:      adrotate_clean_trackerdata
  9.  
  10.  Purpose:   Removes old trackerdata
  11.  Receive:   -none-
  12.  Return:    -none-
  13.  Since:     2.0
  14. -------------------------------------------------------------*/
  15. function adrotate_clean_trackerdata() {
  16.     global $wpdb;
  17.  
  18.     $removeme = current_time('timestamp') - 86400;
  19.     $wpdb->query("DELETE FROM `".$wpdb->prefix."adrotate_tracker` WHERE `timer` < ".$removeme." AND `ipaddress` > 0;");
  20.     $wpdb->query("DELETE FROM `".$wpdb->prefix."adrotate_tracker` WHERE `ipaddress` ='unknown';");
  21.  
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement