static function cronCleannetworkportlogs() { global $DB; $pfConfigLogField = new PluginFusioninventoryConfigLogField(); $pfNetworkPortLog = new PluginFusioninventoryNetworkPortLog(); $a_list = $pfConfigLogField->find(); if (count($a_list)) { foreach ($a_list as $data) { $query_delete = "DELETE FROM `" . $pfNetworkPortLog->getTable() . "`\n WHERE `plugin_fusioninventory_mappings_id`='" . $data['plugin_fusioninventory_mappings_id'] . "' "; switch ($data['days']) { case '-1': $DB->query($query_delete); break; case '0': // never delete break; default: $query_delete .= " AND `date_mod` < date_add(now(), interval -" . $data['days'] . " day)"; $DB->query($query_delete); break; } } } }