#!/usr/bin/env php
<?php
	$root = substr(__DIR__, 0, strrpos(__DIR__, '/'));
	require_once( $root . '/dronebl.config.php');
	require_once( $frameworks_path . '/DroneBL/Database.framework');
	require_once( $frameworks_path . '/DroneBL/Validation.framework');
	require_once( $frameworks_path . '/DroneBL/Cron.framework');
	require_once( $frameworks_path . '/DroneBL/Logging.framework');

	chkprog('Regular Cleanup');
	
	// Tor Cache
	$res = get_db_rows("DELETE FROM torcache WHERE ts < now()::abstime::int4 - 300");
	conlog(db_affected_rows($res)." entries removed from torcache");
	
	// Whois Cache
	$res = get_db_rows("DELETE FROM whoiscache WHERE ts < now()::abstime::int4 - 86400");
	conlog(db_affected_rows($res)." entries removed from whois");
	
	// Sessions
	$res = get_db_rows("DELETE FROM sessions WHERE ts < now()::abstime::int4 - ".(30*86400));
	conlog(db_affected_rows($res)." entries removed from sessions");

	// ASN Reassign
	$res = get_db_rows("SELECT * FROM asn_reassign");
	$c = 0;
	while ($row = get_db_tuple($res))
	{
		conlog('Reassigning '.$row['cidr'].' to AS'.$row['asn']);
		$res2 = get_db_rows("UPDATE blacklist SET asn=".$row['asn']." WHERE ip::inet << '".$row['cidr']."'::cidr AND asn != ".$row['asn']);
		$c += db_affected_rows($res2);
	}
	conlog($c." entries reassigned to other AS");

	endprog();
?>
