CStatistics::CleanUpEvents

static function CleanUpEvents()
{
	set_time_limit(0);
	ignore_user_abort(true);
	$err_mess = "File: ".__FILE__."
Line: ";
	$DB = CDatabase::GetModuleConnection('statistic');
	$DAYS = intval(COption::GetOptionString("statistic", "EVENTS_DAYS"));

	$strSql = "
		DELETE FROM b_stat_event_list
		WHERE KEEP_DAYS IS NULL
		AND DATE_ENTER <= DATE_SUB(CURDATE(), INTERVAL $DAYS DAY)
	";
	$DB->Query($strSql, false, $err_mess.__LINE__);

	$strSql = "
		DELETE el.* FROM
		b_stat_event e
		STRAIGHT_JOIN b_stat_event_list el
		WHERE e.ID = el.EVENT_ID
		AND e.KEEP_DAYS is not null
		AND el.DATE_ENTER <= DATE_SUB(CURDATE(), INTERVAL e.KEEP_DAYS DAY)
	";
	$DB->Query($strSql, false, $err_mess.__LINE__);

	if(COption::GetOptionString("statistic", "USE_AUTO_OPTIMIZE")=="Y")
	{
		$DB->Query("OPTIMIZE TABLE b_stat_event_list", false, $err_mess.__LINE__);
	}
}