static function clean_db()
{
global $DB;
$ptp = new PluginFusioninventoryPort();
$pti = new PluginFusioninventoryIfaddr();
$ptn = new PluginFusioninventoryNetworking2();
$ptpr = new PluginFusioninventoryPrinters();
$ptpc = new PluginFusioninventoryPrintersCartridges();
$ptph = new PluginFusioninventoryPrintersHistory();
// * Clean glpi_plugin_fusioninventory_networking_ports
$query_select = "SELECT `glpi_plugin_fusioninventory_networking_ports`.`ID`\n FROM `glpi_plugin_fusioninventory_networking_ports`\n LEFT JOIN `glpi_networking_ports`\n ON `glpi_networking_ports`.`ID` = `FK_networking_ports`\n LEFT JOIN `glpi_networking` ON `glpi_networking`.`ID` = `on_device`\n WHERE `glpi_networking`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$ptp->deleteFromDB($data["ID"], 1);
}
// * Clean glpi_plugin_fusioninventory_networking_ifaddr
$query_select = "SELECT `glpi_plugin_fusioninventory_networking_ifaddr`.`ID`\n FROM `glpi_plugin_fusioninventory_networking_ifaddr`\n LEFT JOIN `glpi_networking` ON `glpi_networking`.`ID` = `FK_networking`\n WHERE `glpi_networking`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$pti->deleteFromDB($data["ID"], 1);
}
// * Clean glpi_plugin_fusioninventory_networking
$query_select = "SELECT `glpi_plugin_fusioninventory_networking`.`ID`\n FROM `glpi_plugin_fusioninventory_networking`\n LEFT JOIN `glpi_networking` ON `glpi_networking`.`ID` = `FK_networking`\n WHERE `glpi_networking`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$ptn->deleteFromDB($data["ID"], 1);
}
// * Clean glpi_plugin_fusioninventory_printers
$query_select = "SELECT `glpi_plugin_fusioninventory_printers`.`ID`\n FROM `glpi_plugin_fusioninventory_printers`\n LEFT JOIN `glpi_printers` ON `glpi_printers`.`ID` = `FK_printers`\n WHERE `glpi_printers`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$ptpr->deleteFromDB($data["ID"], 1);
}
// * Clean glpi_plugin_fusioninventory_printers_cartridges
$query_select = "SELECT `glpi_plugin_fusioninventory_printers_cartridges`.`ID`\n FROM `glpi_plugin_fusioninventory_printers_cartridges`\n LEFT JOIN `glpi_printers` ON `glpi_printers`.`ID` = `FK_printers`\n WHERE `glpi_printers`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$ptpc->deleteFromDB($data["ID"], 1);
}
// * Clean glpi_plugin_fusioninventory_printers_history
$query_select = "SELECT `glpi_plugin_fusioninventory_printers_history`.`ID`\n FROM `glpi_plugin_fusioninventory_printers_history`\n LEFT JOIN `glpi_printers` ON `glpi_printers`.`ID` = `FK_printers`\n WHERE `glpi_printers`.`ID` IS NULL";
$result = $DB->query($query_select);
while ($data = $DB->fetch_array($result)) {
$ptph->deleteFromDB($data["ID"], 1);
}
}
