Copyright (C) 2003-2011 by the databases Development Team. https://forge.indepnet.net/projects/databases ------------------------------------------------------------------------- LICENSE This file is part of databases. Databases is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. Databases is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with Databases. If not, see <http://www.gnu.org/licenses/>. -------------------------------------------------------------------------- */ include '../../../inc/includes.php'; Session::checkRight("profile", "r"); $prof = new PluginDatabasesProfile(); //Save profile if (isset($_POST['update'])) { $prof->update($_POST); Html::back(); }
function plugin_databases_uninstall() { global $DB; include_once GLPI_ROOT . "/plugins/databases/inc/profile.class.php"; include_once GLPI_ROOT . "/plugins/databases/inc/menu.class.php"; $tables = array("glpi_plugin_databases_databases", "glpi_plugin_databases_databasetypes", "glpi_plugin_databases_databasecategories", "glpi_plugin_databases_servertypes", "glpi_plugin_databases_scripttypes", "glpi_plugin_databases_instances", "glpi_plugin_databases_scripts", "glpi_plugin_databases_databases_items"); foreach ($tables as $table) { $DB->query("DROP TABLE IF EXISTS `{$table}`;"); } //old versions $tables = array("glpi_plugin_sgbd", "glpi_dropdown_plugin_sgbd_type", "glpi_dropdown_plugin_sgbd_server_type", "glpi_plugin_sgbd_device", "glpi_plugin_sgbd_profiles", "glpi_dropdown_plugin_sgbd_script_type", "glpi_plugin_sgbd_instances", "glpi_plugin_sgbd_scripts", "glpi_dropdown_plugin_sgbd_category", "glpi_plugin_databases_profiles"); foreach ($tables as $table) { $DB->query("DROP TABLE IF EXISTS `{$table}`;"); } $tables_glpi = array("glpi_displaypreferences", "glpi_documents_items", "glpi_bookmarks", "glpi_logs", "glpi_items_tickets", "glpi_notepads"); foreach ($tables_glpi as $table_glpi) { $DB->query("DELETE FROM `{$table_glpi}` WHERE `itemtype` = 'PluginDatabasesDatabase' ;"); } if (class_exists('PluginDatainjectionModel')) { PluginDatainjectionModel::clean(array('itemtype' => 'PluginDatabasesDatabase')); } //Delete rights associated with the plugin $profileRight = new ProfileRight(); foreach (PluginDatabasesProfile::getAllRights() as $right) { $profileRight->deleteByCriteria(array('name' => $right['field'])); } PluginDatabasesMenu::removeRightsFromSession(); PluginDatabasesProfile::removeRightsFromSession(); return true; }
function plugin_databases_install() { global $DB; include_once GLPI_ROOT . "/plugins/databases/inc/profile.class.php"; $update = false; if (!TableExists("glpi_plugin_sgbd") && !TableExists("glpi_plugin_databases_databases")) { $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/empty-1.5.0.sql"); } else { if (TableExists("glpi_plugin_sgbd") && !TableExists("glpi_plugin_sgbd_instances")) { $update = true; $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.1.sql"); $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.2.0.sql"); $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.2.1.sql"); $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.3.0.sql"); } else { if (TableExists("glpi_plugin_sgbd") && !TableExists("glpi_dropdown_plugin_sgbd_category")) { $update = true; $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.2.0.sql"); $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.2.1.sql"); $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.3.0.sql"); } else { if (TableExists("glpi_plugin_sgbd") && !FieldExists("glpi_plugin_sgbd", "helpdesk_visible")) { $update = true; $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.2.1.sql"); $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.3.0.sql"); } else { if (!TableExists("glpi_plugin_databases_databases")) { $update = true; $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.3.0.sql"); } } } } } //from 1.3 version if (TableExists("glpi_plugin_databases_databases") && !FieldExists("glpi_plugin_databases_databases", "users_id_tech")) { $DB->runFile(GLPI_ROOT . "/plugins/databases/sql/update-1.5.0.sql"); } if ($update) { $query_ = "SELECT *\n FROM `glpi_plugin_databases_profiles` "; $result_ = $DB->query($query_); if ($DB->numrows($result_) > 0) { while ($data = $DB->fetch_array($result_)) { $query = "UPDATE `glpi_plugin_databases_profiles`\n SET `profiles_id` = '" . $data["id"] . "'\n WHERE `id` = '" . $data["id"] . "';"; $result = $DB->query($query); } } $query = "ALTER TABLE `glpi_plugin_databases_profiles`\n DROP `name` ;"; $result = $DB->query($query); $query = "SELECT `entities_id`,`is_recursive`,`id` FROM `glpi_plugin_databases_databases` "; $result = $DB->query($query); $number = $DB->numrows($result); if ($number) { while ($data = $DB->fetch_array($result)) { $query = "UPDATE `glpi_plugin_databases_instances`\n SET `entities_id` = '" . $data["entities_id"] . "'\n AND `is_recursive` = '" . $data["is_recursive"] . "'\n WHERE `plugin_databases_databases_id` = '" . $data["id"] . "' "; $DB->query($query) or die($DB->error()); $query = "UPDATE `glpi_plugin_databases_scripts`\n SET `entities_id` = '" . $data["entities_id"] . "'\n AND `is_recursive` = '" . $data["is_recursive"] . "'\n WHERE `plugin_databases_databases_id` = '" . $data["id"] . "' "; $DB->query($query) or die($DB->error()); } } Plugin::migrateItemType(array(2400 => 'PluginDatabasesDatabase'), array("glpi_bookmarks", "glpi_bookmarks_users", "glpi_displaypreferences", "glpi_documents_items", "glpi_infocoms", "glpi_logs", "glpi_tickets"), array("glpi_plugin_databases_databases_items")); Plugin::migrateItemType(array(1200 => "PluginAppliancesAppliance", 1300 => "PluginWebapplicationsWebapplication"), array("glpi_plugin_databases_databases_items")); } PluginDatabasesProfile::createFirstAccess($_SESSION['glpiactiveprofile']['id']); return true; }