Пример #1
0
    die("\nUsage : php -q -f rollbackocs.php --server=# [ --run=1 ]\n");
}
$DBocs = new DBocs($_GET["server"]);
echo "Connecting to " . $DBocs->dbhost . "\n";
if (!PluginOcsinventoryngOcsServer::checkOCSconnection($_GET["server"])) {
    die("Failed connexion to OCS\n");
}
$run = isset($_GET["run"]) && $_GET["run"] > 0;
$debug = isset($_GET["debug"]) && $_GET["debug"] > 0;
// Find Last Machine ID + time
$sql = "SELECT *\n        FROM `hardware`\n        ORDER BY `ID` DESC\n        LIMIT 0,1";
$res = $DBocs->query($sql);
if (!($res && $DBocs->numrows($res) > 0)) {
    die("No data from OCS\n");
}
$data = $DBocs->fetch_array($res);
$maxid = $data["ID"];
$maxti = $data["LASTCOME"];
echo "Last new computer : " . $data["DEVICEID"] . " ({$maxid}, {$maxti})\n";
if (!$maxid) {
    die("Bad value\n");
}
// Computer from OCS : New, ID Changed, Linked
$sql = "SELECT *\n        FROM `glpi_logs`\n        WHERE `date_mod` >= '{$maxti}'\n              AND `itemtype` = 1\n              AND `linked_action` IN (8,10,11)\n        ORDER BY `id` DESC";
$res = $DB->query($sql);
if (!$res) {
    die("No data from GLPI\n");
}
$comp = new Computer();
echo "Start\n";
$tabres = array();
Пример #2
0
function update068to0681()
{
    global $DB, $CFG_GLPI;
    if (TableExists("glpi_repair_item")) {
        $query = "DROP TABLE `glpi_repair_item`";
        $DB->queryOrDie($query, "0.68.1 drop glpi_repair_item");
    }
    $tables = array("computers", "monitors", "networking", "peripherals", "phones", "printers");
    foreach ($tables as $tbl) {
        if (isIndex("glpi_" . $tbl, "type")) {
            $query = "ALTER TABLE `glpi_{$tbl}`\n                   DROP INDEX `type`";
            $DB->queryOrDie($query, "0.68.1 drop index type glpi_{$tbl}");
        }
        if (isIndex("glpi_" . $tbl, "type_2")) {
            $query = "ALTER TABLE `glpi_{$tbl}`\n                   DROP INDEX `type_2`";
            $DB->queryOrDie($query, "0.68.1 drop index type_2 glpi_{$tbl}");
        }
        if (isIndex("glpi_" . $tbl, "model")) {
            $query = "ALTER TABLE `glpi_{$tbl}`\n                   DROP INDEX `model`";
            $DB->queryOrDie($query, "0.68.1 drop index model glpi_{$tbl}");
        }
        if (!isIndex("glpi_" . $tbl, "type")) {
            $query = "ALTER TABLE `glpi_{$tbl}`\n                   ADD INDEX (`type`)";
            $DB->queryOrDie($query, "0.68.1 add index type glpi_{$tbl}");
        }
        if (!isIndex("glpi_" . $tbl, "model")) {
            $query = "ALTER TABLE `glpi_{$tbl}`\n                   ADD INDEX (`model`)";
            $DB->queryOrDie($query, "0.68.1 add index model glpi_{$tbl}");
        }
        if (!isIndex("glpi_" . $tbl, "FK_groups")) {
            $query = "ALTER TABLE `glpi_{$tbl}`\n                   ADD INDEX (`FK_groups`)";
            $DB->queryOrDie($query, "0.68.1 add index on glpi_{$tbl}.FK_groups");
        }
        if (!isIndex("glpi_" . $tbl, "FK_users")) {
            $query = "ALTER TABLE `glpi_{$tbl}`\n                   ADD INDEX ( `FK_users` )";
            $DB->queryOrDie($query, "0.68.1 add index on glpi_{$tbl}.FK_users");
        }
    }
    if (!isIndex("glpi_software", "FK_groups")) {
        $query = "ALTER TABLE `glpi_software`\n                ADD INDEX (`FK_groups`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_software.FK_groups");
    }
    if (!isIndex("glpi_software", "FK_users")) {
        $query = "ALTER TABLE `glpi_software`\n                ADD INDEX ( `FK_users` )";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_software.FK_users");
    }
    if (!isIndex("glpi_cartridges_type", "location")) {
        $query = "ALTER TABLE `glpi_cartridges_type`\n                ADD INDEX (`location`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_cartridges_type.location");
    }
    if (FieldExists("glpi_cartridges_type", "type", false)) {
        $query = "ALTER TABLE `glpi_cartridges_type`\n                CHANGE `type` `type` INT NOT NULL DEFAULT '0'";
        $DB->queryOrDie($query, "0.68.1 alter glpi_cartridges_type.type");
    }
    if (!isIndex("glpi_cartridges_type", "type")) {
        $query = "ALTER TABLE `glpi_cartridges_type`\n               ADD INDEX (`type`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_cartridges_type.type");
    }
    if (!isIndex("glpi_cartridges_type", "alarm")) {
        $query = "ALTER TABLE `glpi_cartridges_type`\n                ADD INDEX (`alarm`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_cartridges_type.alarm");
    }
    if (!isIndex("glpi_computers", "os_sp")) {
        $query = "ALTER TABLE `glpi_computers`\n                ADD INDEX (`os_sp`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_computers.os_sp");
    }
    if (!isIndex("glpi_computers", "os_version")) {
        $query = "ALTER TABLE `glpi_computers`\n                ADD INDEX (`os_version`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_computers.os_version");
    }
    if (!isIndex("glpi_computers", "network")) {
        $query = "ALTER TABLE `glpi_computers`\n                ADD INDEX (`network`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_computers.network");
    }
    if (!isIndex("glpi_computers", "domain")) {
        $query = "ALTER TABLE `glpi_computers`\n                ADD INDEX (`domain`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_computers.domain");
    }
    if (!isIndex("glpi_computers", "auto_update")) {
        $query = "ALTER TABLE `glpi_computers`\n                ADD INDEX (`auto_update`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_computers.auto_update");
    }
    if (!isIndex("glpi_computers", "ocs_import")) {
        $query = "ALTER TABLE `glpi_computers`\n                ADD INDEX (`ocs_import`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_computers.ocs_import");
    }
    if (!isIndex("glpi_consumables", "id_user")) {
        $query = "ALTER TABLE `glpi_consumables`\n                ADD INDEX (`id_user`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_consumables.id_user");
    }
    if (!isIndex("glpi_consumables_type", "location")) {
        $query = "ALTER TABLE `glpi_consumables_type`\n                ADD INDEX (`location`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_consumables_type.location");
    }
    if (!isIndex("glpi_consumables_type", "type")) {
        $query = "ALTER TABLE `glpi_consumables_type`\n                ADD INDEX (`type`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_consumables_type.type");
    }
    if (!isIndex("glpi_consumables_type", "alarm")) {
        $query = "ALTER TABLE `glpi_consumables_type`\n                ADD INDEX (`alarm`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_consumables_type.alarm");
    }
    if (FieldExists("glpi_contacts", "type", false)) {
        $query = "ALTER TABLE `glpi_contacts`\n                CHANGE `type` `type` INT( 11 ) NULL ";
        $DB->queryOrDie($query, "0.68.1 alter glpi_contacts.type");
    }
    if (!isIndex("glpi_contract_device", "device_type")) {
        $query = "ALTER TABLE `glpi_contract_device`\n                ADD INDEX (`device_type`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_contract_device.device_type");
    }
    if (!isIndex("glpi_contract_device", "is_template")) {
        $query = "ALTER TABLE `glpi_contract_device`\n                ADD INDEX (`is_template`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_contract_device.is_template");
    }
    if (!isIndex("glpi_device_hdd", "interface")) {
        $query = "ALTER TABLE `glpi_device_hdd`\n                ADD INDEX (`interface`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_device_hdd.interface");
    }
    if (!isIndex("glpi_device_ram", "type")) {
        $query = "ALTER TABLE `glpi_device_ram`\n                ADD INDEX (`type`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_device_ram.type");
    }
    if (!isIndex("glpi_display", "FK_users")) {
        $query = "ALTER TABLE `glpi_display`\n                ADD INDEX (`FK_users`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_display.FK_users");
    }
    if (!isIndex("glpi_docs", "FK_users")) {
        $query = "ALTER TABLE `glpi_docs`\n                ADD INDEX (`FK_users`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_docs.FK_users");
    }
    if (!isIndex("glpi_docs", "FK_tracking")) {
        $query = "ALTER TABLE `glpi_docs`\n                ADD INDEX (`FK_tracking`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_docs.FK_tracking");
    }
    if (!isIndex("glpi_doc_device", "device_type")) {
        $query = "ALTER TABLE `glpi_doc_device`\n                ADD INDEX (`device_type`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_doc_device.device_type");
    }
    if (!isIndex("glpi_dropdown_tracking_category", "parentID")) {
        $query = "ALTER TABLE `glpi_dropdown_tracking_category`\n                ADD INDEX (`parentID`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_dropdown_tracking_category.parentID");
    }
    if (!isIndex("glpi_history", "device_type")) {
        $query = "ALTER TABLE `glpi_history`\n                ADD INDEX (`device_type`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_history.device_type");
    }
    if (!isIndex("glpi_history", "device_internal_type")) {
        $query = "ALTER TABLE `glpi_history`\n                ADD INDEX (`device_internal_type`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_history.device_internal_type");
    }
    if (!isIndex("glpi_infocoms", "budget")) {
        $query = "ALTER TABLE `glpi_infocoms`\n                ADD INDEX (`budget`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_infocoms.budget");
    }
    if (!isIndex("glpi_infocoms", "alert")) {
        $query = "ALTER TABLE `glpi_infocoms`\n                ADD INDEX (`alert`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_infocoms.alert");
    }
    if (!isIndex("glpi_kbitems", "author")) {
        $query = "ALTER TABLE `glpi_kbitems`\n                ADD INDEX (`author`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_kbitems.author");
    }
    if (!isIndex("glpi_kbitems", "faq")) {
        $query = "ALTER TABLE `glpi_kbitems`\n                ADD INDEX (`faq`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_kbitems.faq");
    }
    if (!isIndex("glpi_licenses", "oem_computer")) {
        $query = "ALTER TABLE `glpi_licenses`\n                ADD INDEX (`oem_computer`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_licenses.oem_computer");
    }
    if (!isIndex("glpi_licenses", "oem")) {
        $query = "ALTER TABLE `glpi_licenses`\n                ADD INDEX (`oem`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_licenses.oem");
    }
    if (!isIndex("glpi_licenses", "buy")) {
        $query = "ALTER TABLE `glpi_licenses`\n                ADD INDEX (`buy`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_licenses.buy");
    }
    if (!isIndex("glpi_licenses", "serial")) {
        $query = "ALTER TABLE `glpi_licenses`\n                ADD INDEX (`serial`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_licenses.serial");
    }
    if (!isIndex("glpi_licenses", "expire")) {
        $query = "ALTER TABLE `glpi_licenses`\n                ADD INDEX (`expire`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_licenses.expire");
    }
    if (!isIndex("glpi_networking", "network")) {
        $query = "ALTER TABLE `glpi_networking`\n                ADD INDEX (`network`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_networking.network");
    }
    if (!isIndex("glpi_networking", "domain")) {
        $query = "ALTER TABLE `glpi_networking`\n                ADD INDEX (`domain`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_networking.domain");
    }
    if (!isIndex("glpi_networking_ports", "iface")) {
        $query = "ALTER TABLE `glpi_networking_ports`\n                ADD INDEX (`iface`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_networking_ports.iface");
    }
    if (FieldExists("glpi_phones", "power", false)) {
        $query = "ALTER TABLE `glpi_phones`\n                CHANGE `power` `power` INT NOT NULL DEFAULT '0'";
        $DB->queryOrDie($query, "0.68.1 alter glpi_phones.power");
    }
    if (!isIndex("glpi_phones", "power")) {
        $query = "ALTER TABLE `glpi_phones`\n                ADD INDEX (`power`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_phones.power");
    }
    if (!isIndex("glpi_reminder", "begin")) {
        $query = "ALTER TABLE `glpi_reminder`\n                ADD INDEX (`begin`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_reminder.begin");
    }
    if (!isIndex("glpi_reminder", "end")) {
        $query = "ALTER TABLE `glpi_reminder`\n                ADD INDEX (`end`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_reminder.end");
    }
    if (!isIndex("glpi_software", "update_software")) {
        $query = "ALTER TABLE `glpi_software`\n                ADD INDEX (`update_software`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_software.update_software");
    }
    if (!isIndex("glpi_state_item", "state")) {
        $query = "ALTER TABLE `glpi_state_item`\n                ADD INDEX (`state`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_state_item.state");
    }
    if (!isIndex("glpi_tracking", "FK_group")) {
        $query = "ALTER TABLE `glpi_tracking`\n                ADD INDEX (`FK_group`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_tracking.FK_group");
    }
    if (!isIndex("glpi_tracking", "assign_ent")) {
        $query = "ALTER TABLE `glpi_tracking`\n                ADD INDEX (`assign_ent`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_tracking.assign_ent");
    }
    if (!isIndex("glpi_tracking", "device_type")) {
        $query = "ALTER TABLE `glpi_tracking`\n                ADD INDEX (`device_type`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_tracking.device_type");
    }
    if (!isIndex("glpi_tracking", "priority")) {
        $query = "ALTER TABLE `glpi_tracking`\n                ADD INDEX (`priority`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_tracking.priority");
    }
    if (!isIndex("glpi_tracking", "request_type")) {
        $query = "ALTER TABLE `glpi_tracking`\n                ADD INDEX (`request_type`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_tracking.request_type");
    }
    if (!isIndex("glpi_users", "location")) {
        $query = "ALTER TABLE `glpi_users`\n                ADD INDEX (`location`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_users.location");
    }
    if (!isIndex("glpi_printers", "network")) {
        $query = "ALTER TABLE `glpi_printers`\n                ADD INDEX (`network`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_printers.network");
    }
    if (!isIndex("glpi_printers", "domain")) {
        $query = "ALTER TABLE `glpi_printers`\n                ADD INDEX (`domain`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_printers.domain");
    }
    if (FieldExists("glpi_device_case", "format", false)) {
        $query = "ALTER TABLE `glpi_device_case`\n                CHANGE `format` `format` ENUM('Grand', 'Moyen', 'Micro', 'Slim', '')\n                                         NULL DEFAULT 'Moyen'";
        $DB->queryOrDie($query, "0.68.1 alter glpi_device_case.format");
    }
    if (FieldExists("glpi_device_gfxcard", "interface", false)) {
        $query = "ALTER TABLE `glpi_device_gfxcard`\n                CHANGE `interface` `interface` ENUM('AGP', 'PCI', 'PCI-X', 'Other', '')\n                                               NULL DEFAULT 'AGP'";
        $DB->queryOrDie($query, "0.68.1 alter glpi_device_gfxcard.interface");
    }
    // Add default values in GLPI_DROPDOWN_HDD_TYPE
    // Rename glpi_dropdown HDD_TYPE -> INTERFACE
    if (!TableExists("glpi_dropdown_interface")) {
        $query = "ALTER TABLE `glpi_dropdown_hdd_type`\n                RENAME `glpi_dropdown_interface` ";
        $DB->queryOrDie($query, "0.68.1 alter dropdown_hdd_type -> dropdown_interface");
        $values = array("SATA", "IDE", "SCSI", "USB");
        $interfaces = array();
        foreach ($values as $val) {
            $query = "SELECT *\n                   FROM `glpi_dropdown_interface`\n                   WHERE `name` LIKE '{$val}'";
            $result = $DB->query($query);
            if ($DB->numrows($result) == 1) {
                $row = $DB->fetch_array($result);
                $interfaces[$val] = $row["ID"];
            } else {
                $query = "INSERT INTO `glpi_dropdown_interface`\n                             (`name`)\n                      VALUES ('{$val}');";
                $DB->query($query);
                $interfaces[$val] = $DB->insert_id();
            }
        }
        // ALTER TABLES
        $query = "ALTER TABLE `glpi_device_control`\n                CHANGE `interface` `interface2` ENUM('IDE', 'SATA', 'SCSI', 'USB') NOT NULL\n                                                DEFAULT 'IDE'";
        $DB->queryOrDie($query, "0.68.1 alter device_control");
        $query = "ALTER TABLE `glpi_device_drive`\n                CHANGE `interface` `interface2` ENUM('IDE', 'SATA', 'SCSI') NOT NULL DEFAULT 'IDE'";
        $DB->queryOrDie($query, "0.68.1 alter device_drive");
        $query = "ALTER TABLE `glpi_device_control`\n                ADD `interface` INT NULL ";
        $DB->queryOrDie($query, "0.68.1 alter device_control");
        $query = "ALTER TABLE `glpi_device_drive`\n                ADD `interface` INT NULL ";
        $DB->queryOrDie($query, "0.68.1 alter device_drive");
        foreach ($interfaces as $name => $ID) {
            $query = "UPDATE `glpi_device_drive`\n                   SET `interface` = '{$ID}'\n                   WHERE `interface2` = '{$name}'";
            $DB->queryOrDie($query, "0.68.1 update data device_drive");
            $query = "UPDATE `glpi_device_control`\n                   SET `interface` = '{$ID}'\n                   WHERE `interface2` = '{$name}'";
            $DB->queryOrDie($query, "0.68.1 update data device_control");
        }
        // DROP TABLES
        $query = "ALTER TABLE `glpi_device_control`\n                DROP `interface2`";
        $DB->queryOrDie($query, "0.68.1 drop interface2 device_drive");
        $query = "ALTER TABLE `glpi_device_drive`\n                DROP `interface2`";
        $DB->queryOrDie($query, "0.68.1 drop interface2 device_drive");
        // ADD INDEX
        $query = "ALTER TABLE `glpi_device_drive`\n                ADD INDEX (`interface`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_device_drive.interface");
        $query = "ALTER TABLE `glpi_device_control`\n                ADD INDEX (`interface`)";
        $DB->queryOrDie($query, "0.68.1 add index on glpi_device_drive.interface");
    }
    if (FieldExists("glpi_profiles", "update", false)) {
        $query = "ALTER TABLE `glpi_profiles`\n                CHANGE `update` `check_update` CHAR( 1 ) NULL DEFAULT NULL";
        $DB->queryOrDie($query, "0.68.1 alter glpi_profiles.update");
    }
    if (FieldExists("glpi_config", "last_update_check", false)) {
        $query = "ALTER TABLE `glpi_config`\n                DROP `last_update_check`";
        $DB->queryOrDie($query, "0.68.1 drop glpi_config.last_update_check");
    }
    if (!FieldExists("glpi_config", "keep_tracking_on_delete", false)) {
        $query = "ALTER TABLE `glpi_config`\n                ADD `keep_tracking_on_delete` INT DEFAULT '1'";
        $DB->queryOrDie($query, "0.68.1 drop glpi_config.keep_tracking_on_delete");
    }
    if (!FieldExists("glpi_config", "show_admin_doc", false)) {
        $query = "ALTER TABLE `glpi_config`\n                ADD `show_admin_doc` INT DEFAULT '0' ";
        $DB->queryOrDie($query, "0.68.1 drop glpi_config.show_admin_doc");
    }
    if (!FieldExists("glpi_config", "time_step", false)) {
        $query = "ALTER TABLE `glpi_config`\n                ADD `time_step` INT DEFAULT '5' ";
        $DB->queryOrDie($query, "0.68.1 drop glpi_config.time_step");
    }
    $query = "UPDATE `glpi_config`\n             SET `time_step` = '5',\n                 `show_admin_doc` = '0',\n                 `keep_tracking_on_delete` = '0'";
    $DB->queryOrDie($query, "0.68.1 update glpi_config data");
    if (!FieldExists("glpi_ocs_config", "cron_sync_number", false)) {
        $query = "ALTER TABLE `glpi_ocs_config`\n                ADD `cron_sync_number` INT DEFAULT '1' ";
        $DB->queryOrDie($query, "0.68.1 drop glpi_ocs_config.cron_sync_number");
    }
    if (!FieldExists("glpi_profiles", "show_group_ticket", false)) {
        $query = "ALTER TABLE `glpi_profiles`\n                ADD `show_group_ticket` char(1) DEFAULT '0' ";
        $DB->queryOrDie($query, "0.68.1 drop glpi_profiles.show_group_ticket");
    }
    if (!FieldExists("glpi_config", "ldap_group_condition", false)) {
        $query = "ALTER TABLE `glpi_config`\n                ADD `ldap_group_condition` VARCHAR( 255 ) NULL ,\n                ADD `ldap_search_for_groups` TINYINT NOT NULL DEFAULT '0',\n                ADD `ldap_field_group_member` VARCHAR( 255 ) NULL ";
        $DB->queryOrDie($query, "0.68.1 add glpi_config.ldap_*_groups");
    }
    if (!FieldExists("glpi_groups", "ldap_group_dn", false)) {
        $query = "ALTER TABLE `glpi_groups`\n                ADD `ldap_group_dn` VARCHAR( 255 ) NULL ";
        $DB->queryOrDie($query, "0.68.1 add glpi_groups.ldap_group_dn");
    }
    if (!FieldExists("glpi_ocs_link", "ocs_deviceid", false)) {
        $query = "ALTER TABLE `glpi_ocs_link`\n                CHANGE `ocs_id` `ocs_deviceid` VARCHAR( 255 ) NOT NULL ";
        $DB->queryOrDie($query, "0.68.1 add glpi_ocs_link.ocs_deviceid");
    }
    if (!FieldExists("glpi_ocs_link", "ocs_id", false)) {
        $query = "ALTER TABLE `glpi_ocs_link`\n                ADD `ocs_id` INT NOT NULL DEFAULT '0' AFTER `glpi_id` ";
        $DB->queryOrDie($query, "0.68.1 add glpi_ocs_link.ocs_id");
    }
    if (!FieldExists("glpi_ocs_link", "last_ocs_update", false)) {
        $query = "ALTER TABLE `glpi_ocs_link`\n                ADD `last_ocs_update` DATETIME NULL AFTER `last_update` ";
        $DB->queryOrDie($query, "0.68.1 add glpi_ocs_link.last_ocs_update");
    }
    if (countElementsInTable("glpi_ocs_link")) {
        $CFG_GLPI["ocs_mode"] = 1;
        $DBocs = new DBocs(1);
        // Get datas to update
        $query = "SELECT *\n                FROM `glpi_ocs_link`";
        $result_glpi = $DB->query($query);
        while ($data_glpi = $DB->fetch_array($result_glpi)) {
            // Get ocs information
            $query_ocs = "SELECT *\n                       FROM `hardware`\n                       WHERE `DEVICEID` = '" . $data_glpi["ocs_deviceid"] . "'\n                       LIMIT 1";
            $result_ocs = $DBocs->queryOrDie($query_ocs, "0.68.1 get ocs infos");
            if ($result_ocs && $DBocs->numrows($result_ocs)) {
                $data_ocs = $DBocs->fetch_array($result_ocs);
                $query_update = "UPDATE `glpi_ocs_link`\n                             SET `ocs_id` = '" . $data_ocs["ID"] . "',\n                                 `last_ocs_update` = '" . $data_ocs["LASTDATE"] . "'\n                             WHERE `ID` = '" . $data_glpi["ID"] . "'";
                $DB->queryOrDie($query_update, "0.68.1 update ocs infos");
            }
        }
    }
    if (!TableExists("glpi_dropdown_case_type")) {
        $query = "CREATE TABLE `glpi_dropdown_case_type` (\n                  `ID` int(11) NOT NULL auto_increment,\n                  `name` varchar(255) NOT NULL,\n                  `comments` text,\n                  PRIMARY KEY (`ID`),\n                  KEY `name` (`name`)\n                ) ENGINE=MyISAM;";
        $DB->queryOrDie($query, "0.68.1 add table dropdown_case_type");
        // ajout du champs type
        $query = "ALTER TABLE `glpi_device_case`\n                ADD   `type` INT(11) default NULL AFTER `designation` ";
        $DB->queryOrDie($query, "0.68.1 add glpi_device_case.type");
        // Ajout des entrees dans la table dropdown_case_type
        $query = "INSERT INTO `glpi_dropdown_case_type`\n                       (`ID` , `name` , `comments`)\n                VALUES ('1' , 'Grand', NULL)";
        $DB->queryOrDie($query, "0.68.1 glpi_device_case");
        $query = "INSERT INTO `glpi_dropdown_case_type`\n                       (`ID` , `name` , `comments`)\n                VALUES ('2' , 'Moyen', NULL)";
        $DB->queryOrDie($query, "0.68.1 glpi_device_case");
        $query = "INSERT INTO `glpi_dropdown_case_type`\n                       (`ID` , `name` , `comments`)\n                VALUES ('3' , 'Micro', NULL)";
        $DB->queryOrDie($query, "0.68.1 glpi_device_case");
        // Mapping format enum / type
        $query = "UPDATE `glpi_device_case`\n                SET `type` = '1'\n                WHERE `format` = 'Grand'";
        $DB->queryOrDie($query, "0.68.1 glpi_device_case");
        $query = "UPDATE `glpi_device_case`\n                SET `type` = '2'\n                WHERE `format` = 'Moyen'";
        $DB->queryOrDie($query, "0.68.1 glpi_device_case");
        $query = "UPDATE `glpi_device_case`\n                SET `type` = '3'\n                 WHERE `format` = 'Micro'";
        $DB->queryOrDie($query, "0.68.1 glpi_device_case");
        // Supression du champ format
        $query = "ALTER TABLE `glpi_device_case`\n                DROP `format`";
        $DB->queryOrDie($query, "0.68.1 drop format from glpi_device_case");
    }
    // Clean state datas
    if (TableExists("glpi_state_item")) {
        $query = "SELECT COUNT(*) AS CPT, `device_type`, `id_device`\n                FROM `glpi_state_item`\n                GROUP BY `device_type`, `id_device`\n                HAVING CPT > 1";
        $result = $DB->query($query);
        if ($DB->numrows($result)) {
            while ($data = $DB->fetch_array($result)) {
                $query2 = "DELETE\n                       FROM `glpi_state_item`\n                       WHERE `device_type` = '" . $data["device_type"] . "'\n                             AND `id_device` = '" . $data["id_device"] . "'\n                       LIMIT " . ($data["CPT"] - 1) . "";
                $DB->queryOrDie($query2, "0.68.1 clean glpi_state_item");
            }
        }
        if (isIndex("glpi_state_item", "device_type")) {
            $query = "ALTER TABLE `glpi_state_item`\n                   DROP INDEX `device_type` ";
            $DB->queryOrDie($query, "0.68.1 drop index glpi_state_item");
        }
        if (isIndex("glpi_state_item", "device_type2")) {
            $query = "ALTER TABLE `glpi_state_item`\n                   DROP INDEX `device_type2` ";
            $DB->queryOrDie($query, "0.68.1 drop index glpi_state_item");
        }
        $query = "ALTER TABLE `glpi_state_item`\n                ADD INDEX (`device_type`) ";
        $DB->queryOrDie($query, "0.68.1 add index glpi_state_item");
        $query = "ALTER TABLE `glpi_state_item`\n                ADD UNIQUE (`device_type`, `id_device`) ";
        $DB->queryOrDie($query, "0.68.1 add unique glpi_state_item");
    }
}
function glpiuImportPrinters($mode, $start = 0)
{
    global $PRINTERSLIST, $UC_OCSIDS, $UC_NAMES, $CFG_GLPI, $LANG;
    $DBocs = new DBocs($_SESSION["ocsservers_id"]);
    $DB = new DB();
    $noPort = 0;
    $numrows = 0;
    $UC_OCSIDS = array();
    // Correspondance UC ocs/glpi
    // Recherche les ports
    $query_ports = "select distinct hardware.NAME as UC_Name, hardware.DEVICEID, printers.NAME, printers.PORT, printers.DRIVER from printers " . "inner join hardware on hardware.ID = printers.HARDWARE_ID  where  printers.DRIVER <> '' order by hardware.DEVICEID, printers.NAME, printers.PORT, printers.DRIVER";
    $result_ports = $DBocs->query($query_ports) or die($DBocs->error());
    if ($DBocs->numrows($result_ports) > 0) {
        // Récupère les UC dans GLPI
        $query_UC = "select distinct glpi_id, ocs_id from glpi_ocs_link order by glpi_id";
        $result_UC = $DB->query($query_UC) or die($DB->error());
        if ($DB->numrows($result_UC) > 0) {
            while ($data = $DB->fetch_array($result_UC)) {
                $UC_OCSIDS[$data["ocs_id"]] = array('glpi_id' => $data["glpi_id"], 'UC_Name' => '', 'driver' => '');
            }
        }
        unset($result_UC);
        // Recherche les UC liés à une imprimante dans OCS
        $query_UC = "select distinct hardware.NAME as UC_Name, hardware.ID as ocs_id from hardware " . "inner join printers on printers.HARDWARE_ID = hardware.ID order by hardware.DEVICEID, hardware.NAME";
        $result_UC = $DBocs->query($query_UC) or die($DBocs->error());
        if ($DBocs->numrows($result_UC) > 0) {
            while ($data = $DBocs->fetch_array($result_UC)) {
                if (array_key_exists($data["ocs_id"], $UC_OCSIDS)) {
                    $UC_OCSIDS[$data["ocs_id"]]['UC_Name'] = strtoupper($data["UC_Name"]);
                }
            }
        }
        unset($result_UC);
        // Suppression des UC sans imprimante
        // création d'une table des UC avec nom pour clé
        foreach ($UC_OCSIDS as $ocs_id => &$item) {
            if ($item['UC_Name'] === '') {
                unset($UC_OCSIDS[$ocs_id]);
            } else {
                $UC_NAMES[$item['UC_Name']] = array('glpi_id' => $item["glpi_id"], 'ocs_id' => $ocs_id);
            }
        }
        unset($UC_OCSIDS);
        // Création des imprimantes
        while ($data = $DBocs->fetch_array($result_ports)) {
            glpiuInsertPrinter($data["PORT"], $data["NAME"], $data["UC_Name"], $data["DRIVER"]);
        }
        unset($result_ports);
        unset($UC_NAMES);
        // Si en mode action, suppression des imprimantes
        /*if ($mode == 1 && count($PRINTERSLIST) > 0)
        		{
        		processObjects(PRINTER_TYPE, DELETE_ACTION);
        		}*/
        // Récupère les imprimantes dans GLPI
        $printer_names = array();
        if (count($PRINTERSLIST) > 0) {
            $query_PRN = "select distinct ID, name from glpi_printers where deleted='0' ";
            $result_PRN = $DB->query($query_PRN) or die($DB->error());
            if ($DB->numrows($result_PRN) > 0) {
                while ($data = $DB->fetch_array($result_PRN)) {
                    $printer_names[$data["name"]] = $data["ID"];
                }
            }
        }
        // Complétion des imprimantes et suppression de celles à ne pas importer
        $numrows = 0;
        foreach ($PRINTERSLIST as $prn_no => &$printer) {
            if ($printer->portType <= PORT_TYPE_USB) {
                $printer->getName();
                if ($printer->server != '' && !isset($printer_names[$printer->name])) {
                    $numrows++;
                } else {
                    unset($PRINTERSLIST[$prn_no]);
                }
            } else {
                unset($PRINTERSLIST[$prn_no]);
            }
        }
        unset($printer_names);
        // Importation
        if ($mode == 1 && isset($_POST['toimport'])) {
            foreach ($_POST['toimport'] as $prn_no => $val) {
                if ($val == "on") {
                    $PRINTERSLIST[$prn_no]->addToDB();
                    unset($PRINTERSLIST[$prn_no]);
                    $numrows--;
                }
            }
        }
        unset($_POST['toimport']);
        // Affichage
        echo "<div align='center'>";
        if ($numrows) {
            $readOnly = !haveRight("ocsng", "w");
            $parameters = "objectType=" . PRINTER_TYPE . "&amp;actionId=" . IMPORT_PRINTERS_ACTION;
            printPager($start, $numrows, $_SERVER["PHP_SELF"], $parameters);
            // delete end
            array_splice($PRINTERSLIST, $start + $_SESSION["glpilist_limit"]);
            // delete begin
            if ($start > 0) {
                array_splice($PRINTERSLIST, 0, $start);
            }
            echo "<form method='post' name='printer_form' id='printer_form' action='" . $_SERVER["PHP_SELF"] . "'>";
            echo "<a href='" . $_SERVER["PHP_SELF"] . "' onclick= \"if ( markAllRows('printer_form') ) return false;\">" . $LANG["buttons"][18] . "</a>&nbsp;/&nbsp;<a href='" . $_SERVER["PHP_SELF"] . "' onclick= \"if ( unMarkAllRows('printer_form') ) return false;\">" . $LANG["buttons"][19] . "</a>";
            echo "<input type='hidden' name='objectType' value='" . PRINTER_TYPE . "'>";
            echo "<input type='hidden' name='actionId' value='" . IMPORT_PRINTERS_ACTION . "'>";
            echo "<table class='tab_cadre'>";
            if (!$readOnly) {
                echo "<tr class='tab_bg_1'><th colspan=8><input class='submit' type='submit' name='do_action' value='" . $LANG["buttons"][37] . "'></th></tr>" . chr(10);
            }
            echo '<tr><th></th><th>Type</th><th>IP</th><th>Nom</th><th width="150px">Port</th><th>Serveurs</th><th>Files d\'impression</th><th>Erreurs</th></tr>' . chr(10);
            foreach ($PRINTERSLIST as &$printer) {
                $printer->display();
            }
            if (!$readOnly) {
                echo "<tr class='tab_bg_1'><th colspan=8><input  class='submit' type='submit' name='do_action' value='" . $LANG["buttons"][37] . "'></th></tr>" . chr(10);
            }
            echo "</table>";
            //echo '<br>'.$numrows.'<br>';
            echo "</form>";
            printPager($start, $numrows, $_SERVER["PHP_SELF"], $parameters);
        } else {
            echo "<strong>" . $LANG["ocsng"][9] . "<br>";
            echo "<a href='../index.php'>" . $LANG["buttons"][13] . "</a></strong>";
        }
        echo "</div>";
    }
    return $numrows;
}