<?php
/*
Plugin Name: History cleanup
Version: 2.1.a 
Description: A background process which cleans your history table on regular basis
Plugin URI: http://piwigo.org/ext/extension_view.php?eid=289
Author: VDigital
Author URI: http://piwigo.org/
*/
if ( !function_exists( 'history_cleanup' ) ) {
	if (!defined('IN_ADMIN') or !IN_ADMIN or (defined('DB_ENGINE') and DB_ENGINE == 'SQLite')) return false;
    add_event_handler('loc_begin_page_tail', 'history_cleanup' );
	function history_cleanup()
	{
		global $conf;
		$w = (isset($conf['history_cleanup'])) ? $conf['history_cleanup']
		    : array( 'each' => 30, 'remove' => 90 ); # DAYs 
		$latest = strtotime('-' . $w['each'] . ' days');
		$previous = pwg_get_session_var('history_check', $latest);
		if ( $previous <= $latest ) {
			$q = '
			DELETE FROM  ' . HISTORY_TABLE . ' 
			 WHERE date < DATE_SUB(NOW(), INTERVAL ' . $w['remove'] . '  DAY) 
			  AND summarized = "true";';

			$r = pwg_query($q);  
			if($r)
			{
			  if (defined('DB_ENGINE') and DB_ENGINE == 'PostgreSQL') 
			       $q = 'VACUUM FULL '.HISTORY_TABLE;
			  else $q = 'OPTIMIZE TABLE '.HISTORY_TABLE;
			  $r=pwg_query($q);
			}
			pwg_set_session_var('history_check', strtotime("now"));
			return $r;
		}
		return false;
	}
}
?>