function plugin_routetables_install() { global $DB; include_once GLPI_ROOT . "/plugins/routetables/inc/profile.class.php"; $update = false; if (!TableExists("glpi_plugin_routetable_profiles") && !TableExists("glpi_plugin_routetables_profiles")) { $DB->runFile(GLPI_ROOT . "/plugins/routetables/sql/empty-1.2.0.sql"); } else { if (TableExists("glpi_plugin_routetable_profiles") && FieldExists("glpi_plugin_routetable_profiles", "interface")) { $update = true; $DB->runFile(GLPI_ROOT . "/plugins/routetables/sql/update-1.1.0.sql"); $DB->runFile(GLPI_ROOT . "/plugins/routetables/sql/update-1.1.1.sql"); $DB->runFile(GLPI_ROOT . "/plugins/routetables/sql/update-1.2.0.sql"); } else { if (TableExists("glpi_plugin_routetable") && !FieldExists("glpi_plugin_routetable", "helpdesk_visible")) { $update = true; $DB->runFile(GLPI_ROOT . "/plugins/routetables/sql/update-1.1.1.sql"); $DB->runFile(GLPI_ROOT . "/plugins/routetables/sql/update-1.2.0.sql"); } else { if (!TableExists("glpi_plugin_routetables_profiles")) { $update = true; $DB->runFile(GLPI_ROOT . "/plugins/routetables/sql/update-1.2.0.sql"); } } } } if ($update) { $query_ = "SELECT *\n FROM `glpi_plugin_routetables_profiles` "; $result_ = $DB->query($query_); if ($DB->numrows($result_) > 0) { while ($data = $DB->fetch_array($result_)) { $query = "UPDATE `glpi_plugin_routetables_profiles`\n SET `profiles_id` = '" . $data["id"] . "'\n WHERE `id` = '" . $data["id"] . "';"; $result = $DB->query($query); } } $query = "ALTER TABLE `glpi_plugin_routetables_profiles`\n DROP `name` ;"; $result = $DB->query($query); Plugin::migrateItemType(array(5100 => 'PluginRoutetablesRoutetable'), array("glpi_bookmarks", "glpi_bookmarks_users", "glpi_displaypreferences", "glpi_documents_items", "glpi_infocoms", "glpi_logs", "glpi_tickets"), array("glpi_plugin_routetables_routetables_items")); } PluginRoutetablesProfile::createFirstAccess($_SESSION['glpiactiveprofile']['id']); return true; }