static function cronCleanlogs()
{
global $DB;
$pmLog = new PluginMonitoringLog();
$pmConfig = new PluginMonitoringConfig();
$id_restart = 0;
$a_restarts = $pmLog->find("`action`='restart'", "`id` DESC", 1);
if (count($a_restarts) > 0) {
$a_restart = current($a_restarts);
$id_restart = $a_restart['id'];
}
$id_reload = 0;
$a_reloads = $pmLog->find("`action`='reload'", "`id` DESC", 1);
if (count($a_reloads) > 0) {
$a_reload = current($a_reloads);
$id_reload = $a_reload['id'];
}
$pmConfig->getFromDB(1);
$secs = $pmConfig->fields['logretention'] * DAY_TIMESTAMP;
$query = "DELETE FROM `" . $pmLog->getTable() . "`\n WHERE UNIX_TIMESTAMP(date_mod) < UNIX_TIMESTAMP()-{$secs}";
if ($id_restart > 0 || $id_reload > 0) {
// Keep last reload or restart command
$id_restart = max($id_restart, $id_reload);
$query .= " AND `id` < '" . $id_restart . "'";
}
$DB->query($query);
// TODO: Delete serviceevents table content ???
$query = "DELETE FROM `glpi_plugin_monitoring_serviceevents`\n WHERE UNIX_TIMESTAMP(date) < UNIX_TIMESTAMP()-{$secs}";
$DB->query($query);
return true;
}
static function cronCleanlogs()
{
global $DB;
$pmLog = new PluginMonitoringLog();
$pmConfig = new PluginMonitoringConfig();
$id_restart = 0;
$a_restarts = $pmLog->find("`action`='restart'", "`id` DESC", 1);
if (count($a_restarts) > 0) {
$a_restart = current($a_restarts);
$id_restart = $a_restart['id'];
}
$pmConfig->getFromDB(1);
$secs = $pmConfig->fields['logretention'] * DAY_TIMESTAMP;
$query = "DELETE FROM `" . $pmLog->getTable() . "`\n WHERE UNIX_TIMESTAMP(date_mod) < UNIX_TIMESTAMP()-{$secs}";
if ($id_restart > 0) {
$query .= " AND `id` < '" . $id_restart . "'";
}
$DB->query($query);
// Clean too events
PluginMonitoringServiceevent::cronUpdaterrd();
$pmUnavaibility = new PluginMonitoringUnavaibility();
$pmUnavaibility->runUnavaibility();
$query = "DELETE FROM `glpi_plugin_monitoring_serviceevents`\n WHERE UNIX_TIMESTAMP(date) < UNIX_TIMESTAMP()-{$secs}";
$DB->query($query);
return true;
}
