function plugin_certificates_install()
{
global $DB;
include_once GLPI_ROOT . "/plugins/certificates/inc/profile.class.php";
$install = false;
$update78 = false;
$update80 = false;
if (!TableExists("glpi_plugin_certificates") && !TableExists("glpi_plugin_certificates_certificatetypes")) {
$install = true;
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/empty-1.8.0.sql");
} else {
if (TableExists("glpi_plugin_certificates_mailing") && !FieldExists("glpi_plugin_certificates", "recursive")) {
$update78 = true;
$update80 = true;
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.4.sql");
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.5.0.sql");
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.5.1.sql");
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.6.0.sql");
} else {
if (TableExists("glpi_plugin_certificates_profiles") && FieldExists("glpi_plugin_certificates_profiles", "interface")) {
$update78 = true;
$update80 = true;
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.5.0.sql");
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.5.1.sql");
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.6.0.sql");
} else {
if (TableExists("glpi_plugin_certificates") && !FieldExists("glpi_plugin_certificates", "date_mod")) {
$update78 = true;
$update80 = true;
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.5.1.sql");
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.6.0.sql");
} else {
if (!TableExists("glpi_plugin_certificates_certificatetypes")) {
$update78 = true;
$update80 = true;
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.6.0.sql");
}
}
}
}
}
//from 1.6 version
if (TableExists("glpi_plugin_certificates_certificates") && !FieldExists("glpi_plugin_certificates_certificates", "users_id_tech")) {
$DB->runFile(GLPI_ROOT . "/plugins/certificates/sql/update-1.8.0.sql");
}
if ($install || $update78) {
//Do One time on 0.78
$query_id = "SELECT `id` FROM `glpi_notificationtemplates` WHERE `itemtype`='PluginCertificatesCertificate' AND `name` = 'Alert Certificates'";
$result = $DB->query($query_id) or die($DB->error());
$itemtype = $DB->result($result, 0, 'id');
$query = "INSERT INTO `glpi_notificationtemplatetranslations`\n VALUES(NULL, " . $itemtype . ", '','##certificate.action## : ##certificate.entity##',\n '##lang.certificate.entity## :##certificate.entity##\n ##FOREACHcertificates##\n ##lang.certificate.name## : ##certificate.name## - ##lang.certificate.dateexpiration## : ##certificate.dateexpiration##\n ##ENDFOREACHcertificates##',\n '<p>##lang.certificate.entity## :##certificate.entity##<br /> <br />\n ##FOREACHcertificates##<br />\n ##lang.certificate.name## : ##certificate.name## - ##lang.certificate.dateexpiration## : ##certificate.dateexpiration##<br /> \n ##ENDFOREACHcertificates##</p>');";
$result = $DB->query($query);
$query = "INSERT INTO `glpi_notifications`\n VALUES (NULL, 'Alert Expired Certificates', 0, 'PluginCertificatesCertificate', 'ExpiredCertificates',\n 'mail'," . $itemtype . ",\n '', 1, 1, '2010-02-17 22:36:46');";
$result = $DB->query($query);
$query = "INSERT INTO `glpi_notifications`\n VALUES (NULL, 'Alert Certificates Which Expire', 0, 'PluginCertificatesCertificate', 'CertificatesWhichExpire',\n 'mail'," . $itemtype . ",\n '', 1, 1, '2010-02-17 22:36:46');";
$result = $DB->query($query);
}
if ($update78) {
$query_ = "SELECT *\n FROM `glpi_plugin_certificates_profiles` ";
$result_ = $DB->query($query_);
if ($DB->numrows($result_) > 0) {
while ($data = $DB->fetch_array($result_)) {
$query = "UPDATE `glpi_plugin_certificates_profiles`\n SET `profiles_id` = '" . $data["id"] . "'\n WHERE `id` = '" . $data["id"] . "';";
$result = $DB->query($query);
}
}
$query = "ALTER TABLE `glpi_plugin_certificates_profiles`\n DROP `name` ;";
$result = $DB->query($query);
Plugin::migrateItemType(array(1700 => 'PluginCertificatesCertificate'), array("glpi_bookmarks", "glpi_bookmarks_users", "glpi_displaypreferences", "glpi_documents_items", "glpi_infocoms", "glpi_logs", "glpi_tickets"), array("glpi_plugin_certificates_certificates_items"));
Plugin::migrateItemType(array(1200 => "PluginAppliancesAppliance", 1300 => "PluginWebapplicationsWebapplication"), array("glpi_plugin_certificates_certificates_items"));
}
CronTask::Register('PluginCertificatesCertificate', 'CertificatesAlert', DAY_TIMESTAMP);
PluginCertificatesProfile::createFirstAccess($_SESSION['glpiactiveprofile']['id']);
return true;
}
function plugin_certificates_uninstall() {
global $DB;
include_once (GLPI_ROOT."/plugins/certificates/inc/profile.class.php");
include_once (GLPI_ROOT."/plugins/certificates/inc/menu.class.php");
$tables = array("glpi_plugin_certificates_certificates",
"glpi_plugin_certificates_certificates_items",
"glpi_plugin_certificates_certificatetypes",
"glpi_plugin_certificates_certificatestates",
"glpi_plugin_certificates_configs",
"glpi_plugin_certificates_notificationstates");
foreach($tables as $table)
$DB->query("DROP TABLE IF EXISTS `$table`;");
//old versions
$tables = array("glpi_plugin_certificates",
"glpi_plugin_certificates_profiles",
"glpi_plugin_certificates_device",
"glpi_dropdown_plugin_certificates_type",
"glpi_dropdown_plugin_certificates_status",
"glpi_plugin_certificates_config",
"glpi_plugin_certificates_mailing",
"glpi_plugin_certificates_default");
foreach($tables as $table)
$DB->query("DROP TABLE IF EXISTS `$table`;");
$notif = new Notification();
$options = array('itemtype' => 'PluginCertificatesCertificate',
'event' => 'ExpiredCertificates',
'FIELDS' => 'id');
foreach ($DB->request('glpi_notifications', $options) as $data) {
$notif->delete($data);
}
$options = array('itemtype' => 'PluginCertificatesCertificate',
'event' => 'CertificatesWhichExpire',
'FIELDS' => 'id');
foreach ($DB->request('glpi_notifications', $options) as $data) {
$notif->delete($data);
}
//templates
$template = new NotificationTemplate();
$translation = new NotificationTemplateTranslation();
$options = array('itemtype' => 'PluginCertificatesCertificate',
'FIELDS' => 'id');
foreach ($DB->request('glpi_notificationtemplates', $options) as $data) {
$options_template = array('notificationtemplates_id' => $data['id'],
'FIELDS' => 'id');
foreach ($DB->request('glpi_notificationtemplatetranslations', $options_template) as $data_template) {
$translation->delete($data_template);
}
$template->delete($data);
}
$tables_glpi = array("glpi_displaypreferences",
"glpi_documents_items",
"glpi_bookmarks",
"glpi_logs",
"glpi_tickets",
"glpi_contracts_items",
"glpi_notepads");
foreach($tables_glpi as $table_glpi)
$DB->query("DELETE FROM `$table_glpi` WHERE `itemtype` = 'PluginCertificatesCertificate';");
//Delete rights associated with the plugin
$profileRight = new ProfileRight();
foreach (PluginCertificatesProfile::getAllRights() as $right) {
$profileRight->deleteByCriteria(array('name' => $right['field']));
}
PluginCertificatesMenu::removeRightsFromSession();
PluginCertificatesProfile::removeRightsFromSession();
return true;
}
Copyright (C) 2003-2011 by the certificates Development Team.
https://forge.indepnet.net/projects/certificates
-------------------------------------------------------------------------
LICENSE
This file is part of certificates.
Certificates 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.
Certificates 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 Certificates. If not, see <http://www.gnu.org/licenses/>.
--------------------------------------------------------------------------
*/
include '../../../inc/includes.php';
Session::checkRight("profile", "r");
$prof = new PluginCertificatesProfile();
//Save profile
if (isset($_POST['update'])) {
$prof->update($_POST);
Html::back();
}
