SQL Inventory

List of all SQL mentioned in the code..

ValueCountFile:Line
'Update needed'1
  • /inc/config.php
'Delete orphan logs'1
  • /tools/deleteorphanlogscommand.class.php
"SHOW DATABASES"1
  • /install/install.php
"Select your language"1
  • /install/install.php
'Update Ticket'1
  • /install/empty_data.php
'Update Followup'1
  • /install/empty_data.php
'Delete Followup'1
  • /install/empty_data.php
'Update Reservation'1
  • /install/empty_data.php
'Delete Reservation'1
  • /install/empty_data.php
"DELETE `duplicated` FROM `glpi_profilerights` AS `duplicated` INNER JOIN `glpi_profilerights` AS `original` WHERE `duplicated`.`profiles_id` = `original`.`profiles_id` AND `original`.`name` = 'queuednotification' AND `duplicated`.`name` = 'queuedmail'"1
  • /install/migrations/update_9.2.0_to_9.2.1.php
"UPDATE glpi_items_operatingsystems AS ios INNER JOIN `$table` as item ON ios.items_id = item.id AND ios.itemtype = '$itemtype' SET ios.entities_id = item.entities_id, ios.is_recursive = item.is_recursive "1
  • /install/migrations/update_9.2.0_to_9.2.1.php
"SELECT COUNT(*) AS CPT, `tickets_id`, `type`, `groups_id` FROM `glpi_groups_tickets` GROUP BY `tickets_id`, `type`, `groups_id` HAVING CPT > 1"1
  • /install/migrations/update_0.80.0_to_0.80.1.php
"SELECT `id` FROM `glpi_groups_tickets` WHERE `tickets_id` = '" . $data['tickets_id'] . "' AND `type` = '" . $data['type'] . "' AND `groups_id` = '" . $data['groups_id'] . "' ORDER BY `id` DESC LIMIT 1,99999"1
  • /install/migrations/update_0.80.0_to_0.80.1.php
"SELECT COUNT(*) AS CPT, `tickets_id`, `type`, `users_id`, `alternative_email` FROM `glpi_tickets_users` GROUP BY `tickets_id`, `type`, `users_id`, `alternative_email` HAVING CPT > 1"1
  • /install/migrations/update_0.80.0_to_0.80.1.php
"SELECT `id` FROM `glpi_tickets_users` WHERE `tickets_id` = '" . $data['tickets_id'] . "' AND `type` = '" . $data['type'] . "' AND `users_id` = '" . $data['users_id'] . "' AND `alternative_email` = '" . $data['alternative_email'] . "' ORDER BY `id` DESC LIMIT 1,99999"1
  • /install/migrations/update_0.80.0_to_0.80.1.php
"UPDATE `glpi_slalevels` SET `entities_id` = $entID, `is_recursive` = 0 WHERE `slas_id` IN (SELECT `id` FROM `glpi_slas` WHERE `entities_id` = $entID AND `is_recursive` = 0)"1
  • /install/migrations/update_0.80.0_to_0.80.1.php
"UPDATE `glpi_slalevels` SET `entities_id` = $entID, `is_recursive` = 1 WHERE `slas_id` IN (SELECT `id` FROM `glpi_slas` WHERE `entities_id` = $entID AND `is_recursive` = 1)"1
  • /install/migrations/update_0.80.0_to_0.80.1.php
"UPDATE `glpi_documents_items`, `glpi_documents` SET `glpi_documents_items`.`users_id` = `glpi_documents`.`users_id` WHERE `glpi_documents_items`.`documents_id` = `glpi_documents`.`id`"1
  • /install/migrations/update_9.1.x_to_9.2.0.php
"INSERT INTO `glpi_notificationtemplatetranslations` (`notificationtemplates_id`, `language`,`subject`, `content_text`, `content_html`) VALUES ($notid, '', '##savedsearch.action## ##savedsearch.name##', '##savedsearch.type## ###savedsearch.id## - ##savedsearch.name## ##savedsearch.message## ##lang.savedsearch.url## ##savedsearch.url## Regards,', '<table> <tbody> <tr><th colspan=\"2\"><a href=\"##savedsearch.url##\">##savedsearch.type## ###savedsearch.id## - ##savedsearch.name##</a></th></tr> <tr><td colspan=\"2\"><a href=\"##savedsearch.url##\">##savedsearch.message##</a></td></tr> <tr> <td>##lang.savedsearch.url##</td> <td>##savedsearch.url##</td> </tr> </tbody> </table> <p><span style=\"font-size: small;\">Hello <br />Regards,</span></p>')"1
  • /install/migrations/update_9.1.x_to_9.2.0.php
"INSERT INTO `glpi_notificationtemplatetranslations` (`notificationtemplates_id`, `language`, `subject`, `content_text`, `content_html`) VALUES ($notid, '', '##certificate.action## ##certificate.entity##', '##lang.certificate.entity## : ##certificate.entity## ##FOREACHcertificates## ##lang.certificate.serial## : ##certificate.serial## ##lang.certificate.expirationdate## : ##certificate.expirationdate## ##certificate.url## ##ENDFOREACHcertificates##','<p> ##lang.certificate.entity## : ##certificate.entity##<br /> ##FOREACHcertificates## <br />##lang.certificate.name## : ##certificate.name##<br /> ##lang.certificate.serial## : ##certificate.serial##<br /> ##lang.certificate.expirationdate## : ##certificate.expirationdate## <br /> <a href=\"##certificate.url##\"> ##certificate.url## </a><br /> ##ENDFOREACHcertificates##</p>')"1
  • /install/migrations/update_9.1.x_to_9.2.0.php
"SHOW INDEX FROM `$table` WHERE Key_name='unicity'"1
  • /install/migrations/update_9.1.x_to_9.2.0.php
"SELECT * FROM `glpi_configs` WHERE `id` = '1'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_configs` (`context`, `name`, `value`) VALUES ('core', '$name', '" . addslashes($value ?? '') . "');"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT * FROM `origin_glpi_profiles`"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_profilerights` (`profiles_id`, `name`, `rights`) VALUES ('$profiles_id', '$right', '" . $new_right . "')"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . User::IMPORTEXTAUTHUSERS . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'user'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `name` = 'root_rule_ticket' WHERE `name` = 'rule_ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `name` = 'rule_ticket' WHERE `name` = 'entity_rule_ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . RuleTicket::PARENT . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'rule_ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . KnowbaseItem::KNOWBASEADMIN . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'knowbase'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . KnowbaseItem::READFAQ . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'knowbase'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . KnowbaseItem::READFAQ . " | " . KnowbaseItem::PUBLISHFAQ . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'knowbase'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . User::READAUTHENT . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'user'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . User::READAUTHENT . " | " . User::UPDATEAUTHENT . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'user'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Entity::READHELPDESK . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'entity'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Entity::READHELPDESK . " | " . Entity::UPDATEHELPDESK . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'entity'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . ReservationItem::RESERVEANITEM . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'reservation_central'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `name` = 'reservation' WHERE `name` = 'reservation_central'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `name` = 'ticket' WHERE `name` = 'create_ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = " . (CREATE | Ticket::READMY) . " WHERE `name` = 'ticket' AND `rights` = '1'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . UPDATE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . DELETE . " | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::READALL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::READGROUP . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::READASSIGN . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::ASSIGN . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::STEAL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::OWN . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::CHANGEPRIORITY . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `name` = 'followup' WHERE `name` = 'global_add_followups'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = " . ITILFollowup::ADDALLTICKET . " WHERE `name` = 'followup' AND `rights` = '1'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . ITILFollowup::ADDMYTICKET . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . ITILFollowup::ADDGROUPTICKET . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . ITILFollowup::SEEPUBLIC . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . ITILFollowup::SEEPUBLIC . " | " . ITILFollowup::SEEPRIVATE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . READ . " | " . ITILFollowup::UPDATEALL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . READ . " | " . ITILFollowup::UPDATEMY . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `name` = 'task' WHERE `name` = 'global_add_tasks'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = " . CommonITILTask::ADDALLITEM . " WHERE `name` = 'task' AND `rights` = '1'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . READ . " | " . TicketTask::UPDATEALL . " | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'task'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketTask::SEEPUBLIC . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'task'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketTask::SEEPUBLIC . " | " . TicketTask::SEEPRIVATE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'task'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `name` = 'ticketvalidation' WHERE `name` = 'delete_validations'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = " . DELETE . " WHERE `name` = 'ticketvalidation' AND `rights` = '1'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketValidation::CREATEREQUEST . " | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticketvalidation'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketValidation::CREATEINCIDENT . " | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticketvalidation'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketValidation::VALIDATEREQUEST . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticketvalidation'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketValidation::VALIDATEINCIDENT . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticketvalidation'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `name` = 'planning' WHERE `name` = 'show_planning'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Planning::READGROUP . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'planning'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Planning::READALL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'planning'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `name` = 'problem' WHERE `name` = 'show_my_problem'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Problem::READALL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'problem'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . CREATE . " | " . UPDATE . " | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'problem'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . DELETE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'problem'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . DisplayPreference::PERSONAL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'search_config'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . DisplayPreference::GENERAL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'search_config'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . 1024 . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'backup'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . READNOTE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = '$table'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . READNOTE . " | " . UPDATENOTE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = '$table'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
'Update for mailqueue'1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_crontasks` (`itemtype`, `name`, `frequency`, `param`, `state`, `mode`, `allowmode`, `hourmin`, `hourmax`, `logs_lifetime`, `lastrun`, `lastcode`, `comment`) VALUES ('QueuedMail', 'queuedmail', 60, 50, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL)"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_crontasks` (`itemtype`, `name`, `frequency`, `param`, `state`, `mode`, `allowmode`, `hourmin`, `hourmax`, `logs_lifetime`, `lastrun`, `lastcode`, `comment`) VALUES ('QueuedMail', 'queuedmailclean', 86400, 30, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL)"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_crontasks` (`itemtype`, `name`, `frequency`, `param`, `state`, `mode`, `allowmode`, `hourmin`, `hourmax`, `logs_lifetime`, `lastrun`, `lastcode`, `comment`) VALUES ('Crontask', 'temp', 3600, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL)"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
'UPDATE `glpi_entities` SET `delay_send_emails` = 0 WHERE `id` = 0'1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT * FROM `glpi_notificationtemplates` WHERE `itemtype` = 'Change'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Changes', 'Change', NOW())"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notificationtemplatetranslations` (`notificationtemplates_id`, `language`, `subject`, `content_text`, `content_html`) VALUES ($notid, '', '##change.action## ##change.title##', '##IFchange.storestatus=5## ##lang.change.url## : ##change.urlapprove## ##lang.change.solvedate## : ##change.solvedate## ##lang.change.solution.type## : ##change.solution.type## ##lang.change.solution.description## : ##change.solution.description## ##ENDIFchange.storestatus## ##ELSEchange.storestatus## ##lang.change.url## : ##change.url## ##ENDELSEchange.storestatus## ##lang.change.description## ##lang.change.title## :##change.title## ##lang.change.authors## :##IFchange.authors## ##change.authors## ##ENDIFchange.authors## ##ELSEchange.authors##--##ENDELSEchange.authors## ##lang.change.creationdate## :##change.creationdate## ##IFchange.assigntousers## ##lang.change.assigntousers## : ##change.assigntousers## ##ENDIFchange.assigntousers## ##lang.change.status## : ##change.status## ##IFchange.assigntogroups## ##lang.change.assigntogroups## : ##change.assigntogroups## ##ENDIFchange.assigntogroups## ##lang.change.urgency## : ##change.urgency## ##lang.change.impact## : ##change.impact## ##lang.change.priority## : ##change.priority## ##IFchange.category## ##lang.change.category## :##change.category## ##ENDIFchange.category## ##ELSEchange.category## ##lang.change.nocategoryassigned## ##ENDELSEchange.category## ##lang.change.content## : ##change.content## ##IFchange.storestatus=6## ##lang.change.solvedate## : ##change.solvedate## ##lang.change.solution.type## : ##change.solution.type## ##lang.change.solution.description## : ##change.solution.description## ##ENDIFchange.storestatus## ##lang.change.numberofproblems## : ##change.numberofproblems## ##FOREACHproblems## [##problem.date##] ##lang.change.title## : ##problem.title## ##lang.change.content## ##problem.content## ##ENDFOREACHproblems## ##lang.change.numberoftasks## : ##change.numberoftasks## ##FOREACHtasks## [##task.date##] ##lang.task.author## ##task.author## ##lang.task.description## ##task.description## ##lang.task.time## ##task.time## ##lang.task.category## ##task.category## ##ENDFOREACHtasks## ', '<p>##IFchange.storestatus=5##</p> <div>##lang.change.url## : <a href=\"##change.urlapprove##\">##change.urlapprove##</a></div> <div><span style=\"color: #888888;\"><strong><span style=\"text-decoration: underline;\">##lang.change.solvedate##</span></strong></span> : ##change.solvedate##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.change.solution.type##</strong></span> : ##change.solution.type##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.change.solution.description##</strong></span> : ##change.solution.description## ##ENDIFchange.storestatus##</div> <div>##ELSEchange.storestatus## ##lang.change.url## : <a href=\"##change.url##\">##change.url##</a> ##ENDELSEchange.storestatus##</div> <p class=\"description b\"><strong>##lang.change.description##</strong></p> <p><span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.title##</span> :##change.title## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.authors##</span> :##IFchange.authors## ##change.authors## ##ENDIFchange.authors## ##ELSEchange.authors##--##ENDELSEchange.authors## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.creationdate##</span> :##change.creationdate## <br /> ##IFchange.assigntousers## <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.assigntousers##</span> : ##change.assigntousers## ##ENDIFchange.assigntousers##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.change.status## </span> : ##change.status##<br /> ##IFchange.assigntogroups## <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.assigntogroups##</span> : ##change.assigntogroups## ##ENDIFchange.assigntogroups##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.urgency##</span> : ##change.urgency##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.impact##</span> : ##change.impact##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.priority##</span> : ##change.priority## <br />##IFchange.category##<span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.change.category## </span> :##change.category## ##ENDIFchange.category## ##ELSEchange.category## ##lang.change.nocategoryassigned## ##ENDELSEchange.category## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.change.content##</span> : ##change.content##</p> <p>##IFchange.storestatus=6##<br /><span style=\"text-decoration: underline;\"><strong><span style=\"color: #888888;\">##lang.change.solvedate##</span></strong></span> : ##change.solvedate##<br /><span style=\"color: #888888;\"><strong><span style=\"text-decoration: underline;\">##lang.change.solution.type##</span></strong></span> : ##change.solution.type##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.change.solution.description##</strong></span> : ##change.solution.description##<br />##ENDIFchange.storestatus##</p> <div class=\"description b\">##lang.change.numberofproblems## : ##change.numberofproblems##</div> <p>##FOREACHproblems##</p> <div><strong> [##problem.date##] <em>##lang.change.title## : <a href=\"##problem.url##\">##problem.title## </a></em></strong><br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> </span><span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.change.content## </span> ##problem.content## <p>##ENDFOREACHproblems##</p> <div class=\"description b\">##lang.change.numberoftasks## : ##change.numberoftasks##</div> <p>##FOREACHtasks##</p> <div class=\"description b\"><strong>[##task.date##] </strong><br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.author##</span> ##task.author##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.description##</span> ##task.description##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.time##</span> ##task.time##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.task.category##</span> ##task.category##</div> <p>##ENDFOREACHtasks##</p> </div>')"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notifications` (`name`, `entities_id`, `itemtype`, `event`, `mode`, `notificationtemplates_id`, `comment`, `is_recursive`, `is_active`, `date_mod`) VALUES ('" . $notif_names[$type] . "', 0, 'Change', '$type', 'mail', $notid, '', 1, 1, NOW())"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_rules` SET `uuid` = 'STATIC-UUID-$i' WHERE `entities_id` = 0 AND `is_recursive` = 0 AND `sub_type` = '" . $rule['sub_type'] . "' AND `name` = '" . $rule['name'] . "' AND `description` = '" . $rule['description'] . "' AND `match` = '" . $rule['match'] . "' ORDER BY id ASC LIMIT 1"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_rules` SET `uuid` = '$uuid' WHERE `id` = '" . $data['id'] . "'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_slalevels` SET `uuid` = '$uuid' WHERE `id` = '" . $data['id'] . "'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT * FROM `glpi_notifications` WHERE `itemtype` = 'Ticket' AND `event` = 'satisfaction'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notifications` (`name`, `entities_id`, `itemtype`, `event`, `mode`, `notificationtemplates_id`, `comment`, `is_recursive`, `is_active`, `date_mod`) VALUES ('" . addslashes($notif['name']) . " Answer', '" . $notif['entities_id'] . "', 'Ticket', 'replysatisfaction', '" . $notif['mode'] . "', '" . $notif['notificationtemplates_id'] . "', '" . addslashes($notif['comment']) . "', '" . $notif['is_recursive'] . "', '" . $notif['is_active'] . "', NOW());"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notificationtargets` (`notifications_id`, `type`, `items_id`) VALUES ($newID, '" . Notification::USER_TYPE . "', '" . Notification::ASSIGN_TECH . "')"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT * FROM `glpi_slas` WHERE `resolution_time` <= '3000'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_slas` SET `definition_time` = 'minute', `resolution_time` = `resolution_time`/60 WHERE `id` IN (" . implode(",", $a_ids) . ")"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT * FROM `glpi_slas` WHERE `resolution_time` > '3000' AND `resolution_time` <= '82800'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_slas` SET `definition_time` = 'hour', `resolution_time` = `resolution_time`/3600 WHERE `id` IN (" . implode(",", $a_ids) . ")"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT * FROM `glpi_slas` WHERE `resolution_time` > '82800'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_slas` SET `definition_time` = 'day', `resolution_time` = `resolution_time`/86400 WHERE `id` IN (" . implode(",", $a_ids) . ")"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT * FROM `glpi_notificationtemplates` WHERE `itemtype` = 'MailCollector'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Receiver errors', 'MailCollector', NOW())"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notificationtemplatetranslations` (`notificationtemplates_id`, `language`, `subject`, `content_text`, `content_html`) VALUES ($notid, '', '##mailcollector.action##', '##FOREACHmailcollectors## ##lang.mailcollector.name## : ##mailcollector.name## ##lang.mailcollector.errors## : ##mailcollector.errors## ##mailcollector.url## ##ENDFOREACHmailcollectors##', '&lt;p&gt;##FOREACHmailcollectors##&lt;br /&gt;##lang.mailcollector.name## : ##mailcollector.name##&lt;br /&gt; ##lang.mailcollector.errors## : ##mailcollector.errors##&lt;br /&gt;&lt;a href=\"##mailcollector.url##\"&gt;##mailcollector.url##&lt;/a&gt;&lt;br /&gt; ##ENDFOREACHmailcollectors##&lt;/p&gt; &lt;p&gt;&lt;/p&gt;')"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notifications` (`name`, `entities_id`, `itemtype`, `event`, `mode`, `notificationtemplates_id`, `comment`, `is_recursive`, `is_active`, `date_mod`) VALUES ('Receiver errors', 0, 'MailCollector', 'error', 'mail', $notid, '', 1, 1, NOW())"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notificationtargets` (`id`, `notifications_id`, `type`, `items_id`) VALUES (NULL, $notifid, " . Notification::USER_TYPE . ", " . Notification::GLOBAL_ADMINISTRATOR . ");"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_crontasks` (`itemtype`, `name`, `frequency`, `param`, `state`, `mode`, `allowmode`, `hourmin`, `hourmax`, `logs_lifetime`, `lastrun`, `lastcode`, `comment`) VALUES ('MailCollector', 'mailgateerror', " . DAY_TIMESTAMP . ", NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL)"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_crontasks` (`itemtype`, `name`, `frequency`, `param`, `state`, `mode`, `allowmode`, `hourmin`, `hourmax`, `logs_lifetime`, `lastrun`, `lastcode`, `comment`) VALUES ('Crontask', 'circularlogs', " . DAY_TIMESTAMP . ", 4, " . CronTask::STATE_DISABLE . ", 1, 3, 0, 24, 30, NULL, NULL, NULL)"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_documents` SET `tag` = `id`"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_events` SET `type` = 'consumableitems' WHERE `type` = 'consumables'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_events` SET `type` = 'cartridgeitems' WHERE `type` = 'cartridges';"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_configs` (`context`, `name`, `value`) VALUES ('core', 'backcreated', 0)"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"update glpi_configs with backcreated"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_projectstates` (`name`,`color`,`is_finished`) VALUES ('" . addslashes($val['name']) . "','" . addslashes($val['color']) . "', '" . addslashes($val['is_finished']) . "')"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT * FROM `glpi_notificationtemplates` WHERE `itemtype` = 'Project'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Projects', 'Project', NOW())"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notificationtemplatetranslations` (`notificationtemplates_id`, `language`, `subject`, `content_text`, `content_html`) VALUES ($notid, '', '##project.action## ##project.name## ##project.code##', '##lang.project.url## : ##project.url## ##lang.project.description## ##lang.project.name## : ##project.name## ##lang.project.code## : ##project.code## ##lang.project.manager## : ##project.manager## ##lang.project.managergroup## : ##project.managergroup## ##lang.project.creationdate## : ##project.creationdate## ##lang.project.priority## : ##project.priority## ##lang.project.state## : ##project.state## ##lang.project.type## : ##project.type## ##lang.project.description## : ##project.description## ##lang.project.numberoftasks## : ##project.numberoftasks## ##FOREACHtasks## [##task.creationdate##] ##lang.task.name## : ##task.name## ##lang.task.state## : ##task.state## ##lang.task.type## : ##task.type## ##lang.task.percent## : ##task.percent## ##lang.task.description## : ##task.description## ##ENDFOREACHtasks##', '&lt;p&gt;##lang.project.url## : &lt;a href=\"##project.url##\"&gt;##project.url##&lt;/a&gt;&lt;/p&gt; &lt;p&gt;&lt;strong&gt;##lang.project.description##&lt;/strong&gt;&lt;/p&gt; &lt;p&gt;##lang.project.name## : ##project.name##&lt;br /&gt;##lang.project.code## : ##project.code##&lt;br /&gt; ##lang.project.manager## : ##project.manager##&lt;br /&gt;##lang.project.managergroup## : ##project.managergroup##&lt;br /&gt; ##lang.project.creationdate## : ##project.creationdate##&lt;br /&gt;##lang.project.priority## : ##project.priority## &lt;br /&gt;##lang.project.state## : ##project.state##&lt;br /&gt;##lang.project.type## : ##project.type##&lt;br /&gt;##lang.project.description## : ##project.description##&lt;/p&gt; &lt;p&gt;##lang.project.numberoftasks## : ##project.numberoftasks##&lt;/p&gt; &lt;div&gt; &lt;p&gt;##FOREACHtasks##&lt;/p&gt; &lt;div&gt;&lt;strong&gt;[##task.creationdate##] &lt;/strong&gt;&lt;br /&gt; ##lang.task.name## : ##task.name##&lt;br /&gt;##lang.task.state## : ##task.state##&lt;br /&gt;##lang.task.type## : ##task.type##&lt;br /&gt;##lang.task.percent## : ##task.percent##&lt;br /&gt;##lang.task.description## : ##task.description##&lt;/div&gt; &lt;p&gt;##ENDFOREACHtasks##&lt;/p&gt; &lt;/div&gt;')"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notifications` (`name`, `entities_id`, `itemtype`, `event`, `mode`, `notificationtemplates_id`, `comment`, `is_recursive`, `is_active`, `date_mod`) VALUES ('" . $notif_names[$type] . "', 0, 'Project', '$type', 'mail', $notid, '', 1, 1, NOW())"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT * FROM `glpi_notificationtemplates` WHERE `itemtype` = 'ProjectTask'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Project Tasks', 'ProjectTask', NOW())"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notificationtemplatetranslations` (`notificationtemplates_id`, `language`, `subject`, `content_text`, `content_html`) VALUES ($notid, '', '##projecttask.action## ##projecttask.name##', '##lang.projecttask.url## : ##projecttask.url## ##lang.projecttask.description## ##lang.projecttask.name## : ##projecttask.name## ##lang.projecttask.project## : ##projecttask.project## ##lang.projecttask.creationdate## : ##projecttask.creationdate## ##lang.projecttask.state## : ##projecttask.state## ##lang.projecttask.type## : ##projecttask.type## ##lang.projecttask.description## : ##projecttask.description## ##lang.projecttask.numberoftasks## : ##projecttask.numberoftasks## ##FOREACHtasks## [##task.creationdate##] ##lang.task.name## : ##task.name## ##lang.task.state## : ##task.state## ##lang.task.type## : ##task.type## ##lang.task.percent## : ##task.percent## ##lang.task.description## : ##task.description## ##ENDFOREACHtasks##', '&lt;p&gt;##lang.projecttask.url## : &lt;a href=\"##projecttask.url##\"&gt;##projecttask.url##&lt;/a&gt;&lt;/p&gt; &lt;p&gt;&lt;strong&gt;##lang.projecttask.description##&lt;/strong&gt;&lt;/p&gt; &lt;p&gt;##lang.projecttask.name## : ##projecttask.name##&lt;br /&gt;##lang.projecttask.project## : &lt;a href=\"##projecttask.projecturl##\"&gt;##projecttask.project##&lt;/a&gt;&lt;br /&gt;##lang.projecttask.creationdate## : ##projecttask.creationdate##&lt;br /&gt;##lang.projecttask.state## : ##projecttask.state##&lt;br /&gt;##lang.projecttask.type## : ##projecttask.type##&lt;br /&gt;##lang.projecttask.description## : ##projecttask.description##&lt;/p&gt; &lt;p&gt;##lang.projecttask.numberoftasks## : ##projecttask.numberoftasks##&lt;/p&gt; &lt;div&gt; &lt;p&gt;##FOREACHtasks##&lt;/p&gt; &lt;div&gt;&lt;strong&gt;[##task.creationdate##] &lt;/strong&gt;&lt;br /&gt;##lang.task.name## : ##task.name##&lt;br /&gt;##lang.task.state## : ##task.state##&lt;br /&gt;##lang.task.type## : ##task.type##&lt;br /&gt;##lang.task.percent## : ##task.percent##&lt;br /&gt;##lang.task.description## : ##task.description##&lt;/div&gt; &lt;p&gt;##ENDFOREACHtasks##&lt;/p&gt; &lt;/div&gt;')"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notifications` (`name`, `entities_id`, `itemtype`, `event`, `mode`, `notificationtemplates_id`, `comment`, `is_recursive`, `is_active`, `date_mod`) VALUES ('" . $notif_names[$type] . "', 0, 'ProjectTask', '$type', 'mail', $notid, '', 1, 1, NOW())"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT id, notepad FROM `$t` WHERE notepad IS NOT NULL AND notepad <>'';"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"INSERT INTO `glpi_notepads` (`itemtype`, `items_id`, `content`, `date`, `date_mod`) VALUES ('" . getItemTypeForTable($t) . "', '" . $data['id'] . "', '" . addslashes($data['notepad']) . "', NOW(), NOW())"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_ticketvalidations` SET `status` = '$new' WHERE `status` = '$old'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `" . $table . "` SET `global_validation` = '$new' WHERE `global_validation` = '$old'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_tickettemplatepredefinedfields` SET `value` = '$new' WHERE `num` = '52' AND `value` = '$old'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT `glpi_notificationtemplatetranslations`.* FROM `glpi_notificationtemplatetranslations` INNER JOIN `glpi_notificationtemplates` ON (`glpi_notificationtemplates`.`id` = `glpi_notificationtemplatetranslations`.`notificationtemplates_id`) WHERE `glpi_notificationtemplatetranslations`.`content_text` LIKE '%validation.storestatus=%' OR `glpi_notificationtemplatetranslations`.`content_html` LIKE '%validation.storestatus=%' OR `glpi_notificationtemplatetranslations`.`subject` LIKE '%validation.storestatus=%'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_notificationtemplatetranslations` SET `subject` = '" . addslashes($subject) . "', `content_text` = '" . addslashes($text) . "', `content_html` = '" . addslashes($html) . "' WHERE `id` = " . $data['id'] . ""1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT `id`, `number` FROM `glpi_softwarelicenses`"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_softwarelicenses` SET `is_valid` = 0 WHERE `id` = '" . $datal['id'] . "'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT `glpi_softwares`.`id` FROM `glpi_softwares` LEFT JOIN `glpi_softwarelicenses` ON (`glpi_softwarelicenses`.`softwares_id` = `glpi_softwares`.`id`) WHERE `glpi_softwarelicenses`.`is_valid` = 0"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_softwares` SET `is_valid` = 0 WHERE `id` = '" . $datas['id'] . "'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_rules` SET `condition` = 1 WHERE `sub_type` = 'RuleTicket'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_profiles` SET `ticket_status` = '" . exportArrayToDB($newcycle) . "' WHERE `interface` = 'helpdesk'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_ipaddresses` as `ip` INNER JOIN `glpi_networknames` as `netname` ON (`ip`.`items_id` = `netname`.`id` AND `ip`.`itemtype` = 'NetworkName') INNER JOIN `glpi_networkports` as `netport` ON (`netname`.`items_id` = `netport`.`id` AND `netname`.`itemtype` = 'NetworkPort') SET `ip`.`mainitemtype` = `netport`.`itemtype`, `ip`.`mainitems_id` = `netport`.`items_id`"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"SELECT * FROM `glpi_bookmarks` WHERE `type` = '" . Bookmark::SEARCH . "'"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_displaypreferences` SET `num` = 90 WHERE `itemtype` = 'Entity' AND `num` = 28"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_displaypreferences` SET `num` = 200 WHERE `num` = 90"1
  • /install/migrations/update_0.84.x_to_0.85.0.php
"UPDATE `glpi_tickettemplatepredefinedfields` SET `value` = '$new' WHERE `value` = '$old' AND `num` = 12"1
  • /install/migrations/update_0.84.5_to_0.84.6.php
"UPDATE `glpi_displaypreferences` SET `num` = 160 WHERE `itemtype` = 'Software' AND `num` = 7"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_bookmarks` SET query = '" . addslashes($query) . "' WHERE `id` = '" . $data['id'] . "'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_bookmarks` SET `itemtype` = 'AllAssets', `path` = 'front/allassets.php' WHERE `itemtype` = 'States'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_displaypreferences` SET `itemtype` = 'AllAssets' WHERE `itemtype` = 'States'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_configs` SET `language` = '$new' WHERE `language` = '$old';"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_users` SET `language` = '$new' WHERE `language` = '$old';"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `$table` SET `status` = '$new' WHERE `status` = '$old'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `glpi_notificationtemplatetranslations`.* FROM `glpi_notificationtemplatetranslations` INNER JOIN `glpi_notificationtemplates` ON (`glpi_notificationtemplates`.`id` = `glpi_notificationtemplatetranslations`.`notificationtemplates_id`) WHERE `glpi_notificationtemplatetranslations`.`content_text` LIKE '%storestatus=%' OR `glpi_notificationtemplatetranslations`.`content_html` LIKE '%storestatus=%' OR `glpi_notificationtemplatetranslations`.`subject` LIKE '%storestatus=%'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_notificationtemplatetranslations` SET `subject` = '" . addslashes($subject) . "', `content_text` = '" . addslashes($text) . "', `content_html` = '" . addslashes($html) . "' WHERE `id` = " . $data['id'] . ""1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_ruleactions` SET `value` = '$new' WHERE `field` = '$field' AND `value` = '$old' AND `rules_id` IN ($rules)"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_profiles` SET `$field` = '" . addslashes(exportArrayToDB($newtab)) . "' WHERE `id` = '" . $data['id'] . "'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_entities` (`id`, `name`, `completename`, `entities_id`, `level`) VALUES (0,'" . addslashes(__('Root entity')) . "', '" . addslashes(__('Root entity')) . "', '-1', '1');"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_entities` SET " . implode(',', $update_fields) . " WHERE `id` = '" . $data['entities_id'] . "'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_computers_softwareversions` LEFT JOIN `glpi_computers` ON `computers_id`=`glpi_computers`.`id` SET `glpi_computers_softwareversions`.`entities_id` = `glpi_computers`.`entities_id`"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT * FROM `glpi_notifications` WHERE `itemtype` = 'Ticket' AND `event` = 'validation'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_notifications` (`name`, `entities_id`, `itemtype`, `event`, `mode`, `notificationtemplates_id`, `comment`, `is_recursive`, `is_active`, `date_mod`) VALUES ('" . addslashes($notif['name']) . " Answer', '" . $notif['entities_id'] . "', 'Ticket', 'validation_answer', '" . $notif['mode'] . "', '" . $notif['notificationtemplates_id'] . "', '" . addslashes($notif['comment']) . "', '" . $notif['is_recursive'] . "', '" . $notif['is_active'] . "', NOW());"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT * FROM `glpi_notifications` WHERE `itemtype` = 'Contract' AND `event` = '$from'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_notifications` (`name`, `entities_id`, `itemtype`, `event`, `mode`, `notificationtemplates_id`, `comment`, `is_recursive`, `is_active`, `date_mod`) VALUES ('" . addslashes($notif['name']) . " Periodicity', '" . $notif['entities_id'] . "', 'Contract', '$to', '" . $notif['mode'] . "', '" . $notif['notificationtemplates_id'] . "', '" . addslashes($notif['comment']) . "', '" . $notif['is_recursive'] . "', '" . $notif['is_active'] . "', NOW());"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT * FROM `glpi_notificationtargets` WHERE `notifications_id` = '" . $notif['id'] . "'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_notificationtargets` (`notifications_id`, `type`, `items_id`) VALUES ('" . $newID . "', '" . $target['type'] . "', '" . $target['items_id'] . "')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_contractcosts` (`contracts_id`, `name`, `begin_date`, `end_date`, `cost`, `entities_id`, `is_recursive`) VALUES ('" . $data['id'] . "', 'Cost', $begin_to_add, $end_to_add, '" . $data['cost'] . "', '" . $data['entities_id'] . "', '" . $data['is_recursive'] . "')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_ticketcosts` (`tickets_id`, `name`, `begin_date`, `end_date`, `cost_time`,`cost_fixed`, `cost_material`, `entities_id`, `actiontime`) VALUES ('" . $data['id'] . "', 'Cost', $begin_to_add, $end_to_add, '" . $data['cost_time'] . "','" . $data['cost_fixed'] . "', '" . $data['cost_material'] . "', '" . $data['entities_id'] . "', '" . $data['actiontime'] . "')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_profiles` SET `ticketcost` = 'r' WHERE `ticketcost` IS NULL"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT * FROM `glpi_notificationtemplates` WHERE `itemtype` = 'PlanningRecall'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Planning recall', 'PlanningRecall', NOW())"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_notificationtemplatetranslations` (`notificationtemplates_id`, `language`, `subject`, `content_text`, `content_html`) VALUES ($notid, '', '##recall.action##: ##recall.item.name##', '##recall.action##: ##recall.item.name## ##recall.item.content## ##lang.recall.planning.begin##: ##recall.planning.begin## ##lang.recall.planning.end##: ##recall.planning.end## ##lang.recall.planning.state##: ##recall.planning.state## ##lang.recall.item.private##: ##recall.item.private##', '&lt;p&gt;##recall.action##: &lt;a href=\"##recall.item.url##\"&gt;##recall.item.name##&lt;/a&gt;&lt;/p&gt; &lt;p&gt;##recall.item.content##&lt;/p&gt; &lt;p&gt;##lang.recall.planning.begin##: ##recall.planning.begin##&lt;br /&gt;##lang.recall.planning.end##: ##recall.planning.end##&lt;br /&gt;##lang.recall.planning.state##: ##recall.planning.state##&lt;br /&gt;##lang.recall.item.private##: ##recall.item.private##&lt;br /&gt;&lt;br /&gt;&lt;/p&gt; &lt;p&gt;&lt;br /&gt;&lt;br /&gt;&lt;/p&gt;')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_notifications` (`name`, `entities_id`, `itemtype`, `event`, `mode`, `notificationtemplates_id`, `comment`, `is_recursive`, `is_active`, `date_mod`) VALUES ('Planning recall', 0, 'PlanningRecall', 'planningrecall', 'mail', $notid, '', 1, 1, NOW())"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_notificationtargets` (`id`, `notifications_id`, `type`, `items_id`) VALUES (NULL, $notifid, " . Notification::USER_TYPE . ", " . Notification::AUTHOR . ");"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_crontasks` (`itemtype`, `name`, `frequency`, `param`, `state`, `mode`, `allowmode`, `hourmin`, `hourmax`, `logs_lifetime`, `lastrun`, `lastcode`, `comment`) VALUES ('PlanningRecall', 'planningrecall', 300, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL)"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
'UPDATE `glpi_entities` SET `default_consumables_alarm_threshold` = -10 WHERE `default_consumables_alarm_threshold` = -1'1
  • /install/migrations/update_0.83.x_to_0.84.0.php
'UPDATE `glpi_entities` SET `default_cartridges_alarm_threshold` = -10 WHERE `default_cartridges_alarm_threshold` = -1'1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_slalevelactions` SET `action_type` = 'append' WHERE `action_type` = 'assign' AND `field` IN ('_users_id_requester', '_groups_id_requester', '_users_id_assign', '_groups_id_assign', '_suppliers_id_assign', '_users_id_observer', '_groups_id_observer');"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"DELETE FROM `glpi_notificationtargets` WHERE `glpi_notificationtargets`.`type` = '" . Notification::USER_TYPE . "' AND `glpi_notificationtargets`.`items_id` = '" . Notification::OBSERVER . "' AND `notifications_id` IN (SELECT `glpi_notifications`.`id` FROM `glpi_notifications` WHERE `glpi_notifications`.`itemtype` = 'Ticket' AND `glpi_notifications`.`event` = 'satisfaction')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"DELETE FROM `glpi_notificationtargets` WHERE `glpi_notificationtargets`.`type` = '" . Notification::USER_TYPE . "' AND `glpi_notificationtargets`.`items_id` = '" . Notification::USER . "' AND `notifications_id` IN (SELECT `glpi_notifications`.`id` FROM `glpi_notifications` WHERE `glpi_notifications`.`itemtype` = 'FieldUnicity' AND `glpi_notifications`.`event` = 'refuse')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_blacklists` (`type`,`name`,`value`) VALUES ('$type','" . addslashes($name) . "','" . addslashes($value) . "')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `id` FROM `glpi_rulerightparameters` WHERE `name` = '(LDAP) MemberOf'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_rulerightparameters` VALUES (NULL, '(LDAP) MemberOf', 'memberof', '')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_ssovariables` (`id`, `name`, `comment`) VALUES (1, 'HTTP_AUTH_USER', ''), (2, 'REMOTE_USER', ''), (3, 'PHP_AUTH_USER', ''), (4, 'USERNAME', ''), (5, 'REDIRECT_REMOTE_USER', ''), (6, 'HTTP_REMOTE_USER', '')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `existing_auth_server_field` FROM `glpi_configs`"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `id` FROM `glpi_ssovariables` WHERE `name` = '$existing_auth_server_field'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_configs` SET `ssovariables_id` = '" . $DB->result($result, 0, "id") . "'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_rules` SET `sub_type` = 'RuleImportEntity' WHERE `sub_type` = 'RuleOcs'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT GROUP_CONCAT(`id`) FROM `glpi_rules` WHERE `sub_type` = 'RuleImportEntity' GROUP BY `sub_type`"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_logs` SET `linked_action` = `linked_action`+1000, `itemtype_link` = 'PluginOcsinventoryngOcslink' WHERE `linked_action` IN (8,9,10,11)"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT MIN(id) AS id FROM `glpi_notificationtemplates` WHERE `itemtype` = 'Ticket'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_notifications` (`name`, `entities_id`, `itemtype`, `event`, `mode`, `notificationtemplates_id`, `comment`, `is_recursive`, `is_active`, `date_mod`) VALUES ('" . $notif_names[$type] . "', 0, 'Ticket', '$type', 'mail', $notid, '', 1, 1, NOW())"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_problems_suppliers` (`suppliers_id`, `type`, `problems_id`) VALUES ('" . $data['suppliers_id_assign'] . "', '" . CommonITILActor::ASSIGN . "', '" . $data['id'] . "')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_suppliers_tickets` (`suppliers_id`, `type`, `tickets_id`) VALUES ('" . $data['suppliers_id_assign'] . "', '" . CommonITILActor::ASSIGN . "', '" . $data['id'] . "')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `glpi_ruleactions` .`id` AS id, `sub_type`, `glpi_manufacturers`.`name` AS newvalue FROM `glpi_rules` INNER JOIN `glpi_ruleactions` ON (`glpi_rules`.`id` = `glpi_ruleactions`.`rules_id` AND `field` = 'Manufacturer') LEFT JOIN `glpi_manufacturers` ON `glpi_manufacturers`.`id` = `glpi_ruleactions`.`value` WHERE `sub_type` = 'RuleDictionnarySoftware'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_ruleactions` SET `value` = '" . $data['newvalue'] . "' WHERE `id` = " . $data['id']1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_ticketrecurrents` SET `periodicity` = '$periodicity' WHERE `id` = '" . $data['id'] . "'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_notifications` SET `itemtype` = 'CartridgeItem' WHERE `itemtype` = 'Cartridge'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_notificationtemplates` SET `itemtype` = 'CartridgeItem' WHERE `itemtype` = 'Cartridge'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_notifications` SET `itemtype` = 'ConsumableItem' WHERE `itemtype` = 'Consumable'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_notificationtemplates` SET `itemtype` = 'ConsumableItem' WHERE `itemtype` = 'Consumable'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_displaypreferences` SET `num` = '5' WHERE `itemtype` = 'Budget' AND `num` = '2'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `id` FROM `glpi_fqdns` WHERE `fqdn` = '$domain'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `origin_glpi_networkports`.`name`, `origin_glpi_networkports`.`id`, `origin_glpi_networkports`.`mac`, "1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT link.`id` AS link_id, device.`designation` AS name FROM `glpi_devicenetworkcards` as device, `glpi_computers_devicenetworkcards` as link WHERE link.`computers_id` = " . $portInformation['items_id'] . " AND device.`id` = link.`devicenetworkcards_id` AND link.`specificity` = '" . $portInformation['mac'] . "'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_networkportmigrations` (SELECT *" . str_repeat(', 0', count(NetworkPortMigration::getMotives( ))) . " FROM `origin_glpi_networkports` WHERE `id` = '$networkports_id')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_networkportmigrations` SET `$motive` = '1' WHERE `id`='$networkports_id'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT DISTINCT LOWER(`name`) AS name, `comment` FROM `glpi_domains`"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT DISTINCTROW INET_NTOA(INET_ATON(`ip`)&INET_ATON(`netmask`)) AS address, `netmask`, `gateway`, `entities_id` FROM `origin_glpi_networkports` ORDER BY `gateway` DESC"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT id, items_id, itemtype FROM origin_glpi_networkports WHERE INET_NTOA(INET_ATON(`ip`)&INET_ATON(`netmask`)) = '$address' AND `netmask` = '$netmask' AND `gateway` = '$gateway' AND `entities_id` = '$entities_id'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT id, items_id, itemtype FROM origin_glpi_networkports WHERE INET_NTOA(INET_ATON(`ip`)&INET_ATON(`netmask`)) = '" . $entry['address'] . "' AND `netmask` = '$netmask' AND `gateway` = '$gateway' AND `entities_id` = '$entities_id'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `ip`, `id`, `entities_id`, `itemtype`, `items_id` FROM `origin_glpi_networkports` WHERE `ip` <> ''"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT * FROM `glpi_networkinterfaces`"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_networkports` SET `instantiation_type` = '$instantiation_type' WHERE `id` IN (SELECT `id` FROM `origin_glpi_networkports` WHERE `networkinterfaces_id` = '" . $entry['id'] . "')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_networkports` SET `mac` = LOWER(`mac`)"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
'Update migration of interfaces errors'1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT id FROM `glpi_networkports` WHERE `instantiation_type` = ''"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT * FROM `origin_glpi_networkequipments` WHERE `mac` != '' OR `ip` != ''"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `id`, `ip`, `mac` FROM `origin_glpi_networkports` WHERE `itemtype` = 'NetworkEquipment' AND `items_id` = '$networkequipments_id' AND (`ip` = '" . $equipment['ip'] . "' OR `mac` = '" . $equipment['mac'] . "')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_networkports` SET `mac` = '' WHERE `id` = '$aggregated_networkports_id'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
'Update connections between IPAddress and IPNetwork'1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `id`, `address_3`, `netmask_3` FROM `glpi_ipnetworks`"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT `id` FROM `glpi_ipaddresses` WHERE (`glpi_ipaddresses`.`binary_3` & '$netmask') = $address AND `glpi_ipaddresses`.`version` = '4' GROUP BY `items_id`"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_ipaddresses_ipnetworks` (`ipaddresses_id`, `ipnetworks_id`) VALUES ('" . $link['id'] . "', '$ipnetworks_id')"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_logs` SET `itemtype_link` = 'Item_" . $deviceType . "#" . $new_specif . "' WHERE `itemtype_link` = '$deviceType'"1
  • /install/migrations/update_0.83.x_to_0.84.0.php
"UPDATE `glpi_documents_items` as `doc_i` INNER JOIN `glpi_documents` as `doc` ON `doc`.`id` = `doc_i`.`documents_id` SET `doc_i`.`date_mod` = `doc`.`date_mod`"1
  • /install/migrations/update_0.84.0_to_0.84.1.php
"SELECT `glpi_notificationtemplatetranslations`.* FROM `glpi_notificationtemplatetranslations` INNER JOIN `glpi_notificationtemplates` ON (`glpi_notificationtemplates`.`id` = `glpi_notificationtemplatetranslations`.`notificationtemplates_id`) WHERE `glpi_notificationtemplatetranslations`.`content_text` LIKE '%validation.storestatus=%' OR `glpi_notificationtemplatetranslations`.`content_html` LIKE '%validation.storestatus=%' OR `glpi_notificationtemplatetranslations`.`subject` LIKE '%validation.storestatus=%'"1
  • /install/migrations/update_0.84.3_to_0.84.4.php
"UPDATE `glpi_notificationtemplatetranslations` SET `subject` = '" . addslashes($subject) . "', `content_text` = '" . addslashes($text) . "', `content_html` = '" . addslashes($html) . "' WHERE `id` = " . $data['id'] . ""1
  • /install/migrations/update_0.84.3_to_0.84.4.php
"UPDATE `glpi_tickettasks` SET `begin` = " . ((($data['begin'] == 'NULL') || is_null($data['begin'])) ? 'NULL' : "'" . $data['begin'] . "'") . ", `end` = " . ((($data['end'] == 'NULL') || is_null($data['end'])) ? 'NULL' : "'" . $data['end'] . "'") . ", `users_id_tech` = '" . $data['users_id'] . "', `state` = '" . $data['state'] . "' WHERE `id` = '" . $data['tickettasks_id'] . "'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT `glpi_notificationtemplatetranslations`.* FROM `glpi_notificationtemplatetranslations` INNER JOIN `glpi_notificationtemplates` ON (`glpi_notificationtemplates`.`id` = `glpi_notificationtemplatetranslations`.`notificationtemplates_id`) WHERE `glpi_notificationtemplates`.`itemtype` = 'Ticket'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_notificationtemplatetranslations` SET `subject` = '" . addslashes(str_replace($from, $to, $data['subject'])) . "', `content_text` = '" . addslashes(str_replace($from, $to, $data['content_text'])) . "', `content_html` = '" . addslashes(str_replace($from, $to, $data['content_html'])) . "' WHERE `id` = " . $data['id'] . ""1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT * FROM `glpi_notificationtemplates` WHERE `name` = 'Problems'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Problems', 'Problem', NOW())"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_notificationtemplatetranslations` (`notificationtemplates_id`, `language`, `subject`, `content_text`, `content_html`) VALUES ($notid, '', '##problem.action## ##problem.title##', '##IFproblem.storestatus=solved## ##lang.problem.url## : ##problem.urlapprove## ##lang.problem.solvedate## : ##problem.solvedate## ##lang.problem.solution.type## : ##problem.solution.type## ##lang.problem.solution.description## : ##problem.solution.description## ##ENDIFproblem.storestatus## ##ELSEproblem.storestatus## ##lang.problem.url## : ##problem.url## ##ENDELSEproblem.storestatus## ##lang.problem.description## ##lang.problem.title## &#160;:##problem.title## ##lang.problem.authors## &#160;:##IFproblem.authors## ##problem.authors## ##ENDIFproblem.authors## ##ELSEproblem.authors##--##ENDELSEproblem.authors## ##lang.problem.creationdate## &#160;:##problem.creationdate## ##IFproblem.assigntousers## ##lang.problem.assigntousers## &#160;: ##problem.assigntousers## ##ENDIFproblem.assigntousers## ##lang.problem.status## &#160;: ##problem.status## ##IFproblem.assigntogroups## ##lang.problem.assigntogroups## &#160;: ##problem.assigntogroups## ##ENDIFproblem.assigntogroups## ##lang.problem.urgency## &#160;: ##problem.urgency## ##lang.problem.impact## &#160;: ##problem.impact## ##lang.problem.priority## : ##problem.priority## ##IFproblem.category## ##lang.problem.category## &#160;:##problem.category## ##ENDIFproblem.category## ##ELSEproblem.category## ##lang.problem.nocategoryassigned## ##ENDELSEproblem.category## ##lang.problem.content## &#160;: ##problem.content## ##IFproblem.storestatus=closed## ##lang.problem.solvedate## : ##problem.solvedate## ##lang.problem.solution.type## : ##problem.solution.type## ##lang.problem.solution.description## : ##problem.solution.description## ##ENDIFproblem.storestatus## ##lang.problem.numberoftickets##&#160;: ##problem.numberoftickets## ##FOREACHtickets## [##ticket.date##] ##lang.problem.title## : ##ticket.title## ##lang.problem.content## ##ticket.content## ##ENDFOREACHtickets## ##lang.problem.numberoftasks##&#160;: ##problem.numberoftasks## ##FOREACHtasks## [##task.date##] ##lang.task.author## ##task.author## ##lang.task.description## ##task.description## ##lang.task.time## ##task.time## ##lang.task.category## ##task.category## ##ENDFOREACHtasks## ', '&lt;p&gt;##IFproblem.storestatus=solved##&lt;/p&gt; &lt;div&gt;##lang.problem.url## : &lt;a href=\"##problem.urlapprove##\"&gt;##problem.urlapprove##&lt;/a&gt;&lt;/div&gt; &lt;div&gt;&lt;span style=\"color: #888888;\"&gt;&lt;strong&gt;&lt;span style=\"text-decoration: underline;\"&gt;##lang.problem.solvedate##&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt; : ##problem.solvedate##&lt;br /&gt;&lt;span style=\"text-decoration: underline; color: #888888;\"&gt;&lt;strong&gt;##lang.problem.solution.type##&lt;/strong&gt;&lt;/span&gt; : ##problem.solution.type##&lt;br /&gt;&lt;span style=\"text-decoration: underline; color: #888888;\"&gt;&lt;strong&gt;##lang.problem.solution.description##&lt;/strong&gt;&lt;/span&gt; : ##problem.solution.description## ##ENDIFproblem.storestatus##&lt;/div&gt; &lt;div&gt;##ELSEproblem.storestatus## ##lang.problem.url## : &lt;a href=\"##problem.url##\"&gt;##problem.url##&lt;/a&gt; ##ENDELSEproblem.storestatus##&lt;/div&gt; &lt;p class=\"description b\"&gt;&lt;strong&gt;##lang.problem.description##&lt;/strong&gt;&lt;/p&gt; &lt;p&gt;&lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.problem.title##&lt;/span&gt;&#160;:##problem.title## &lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.problem.authors##&lt;/span&gt;&#160;:##IFproblem.authors## ##problem.authors## ##ENDIFproblem.authors## ##ELSEproblem.authors##--##ENDELSEproblem.authors## &lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.problem.creationdate##&lt;/span&gt;&#160;:##problem.creationdate## &lt;br /&gt; ##IFproblem.assigntousers## &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.problem.assigntousers##&lt;/span&gt;&#160;: ##problem.assigntousers## ##ENDIFproblem.assigntousers##&lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt;##lang.problem.status## &lt;/span&gt;&#160;: ##problem.status##&lt;br /&gt; ##IFproblem.assigntogroups## &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.problem.assigntogroups##&lt;/span&gt;&#160;: ##problem.assigntogroups## ##ENDIFproblem.assigntogroups##&lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.problem.urgency##&lt;/span&gt;&#160;: ##problem.urgency##&lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.problem.impact##&lt;/span&gt;&#160;: ##problem.impact##&lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.problem.priority##&lt;/span&gt; : ##problem.priority## &lt;br /&gt;##IFproblem.category##&lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt;##lang.problem.category## &lt;/span&gt;&#160;:##problem.category## ##ENDIFproblem.category## ##ELSEproblem.category## ##lang.problem.nocategoryassigned## ##ENDELSEproblem.category## &lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.problem.content##&lt;/span&gt;&#160;: ##problem.content##&lt;/p&gt; &lt;p&gt;##IFproblem.storestatus=closed##&lt;br /&gt;&lt;span style=\"text-decoration: underline;\"&gt;&lt;strong&gt;&lt;span style=\"color: #888888;\"&gt;##lang.problem.solvedate##&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt; : ##problem.solvedate##&lt;br /&gt;&lt;span style=\"color: #888888;\"&gt;&lt;strong&gt;&lt;span style=\"text-decoration: underline;\"&gt;##lang.problem.solution.type##&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt; : ##problem.solution.type##&lt;br /&gt;&lt;span style=\"text-decoration: underline; color: #888888;\"&gt;&lt;strong&gt;##lang.problem.solution.description##&lt;/strong&gt;&lt;/span&gt; : ##problem.solution.description##&lt;br /&gt;##ENDIFproblem.storestatus##&lt;/p&gt; &lt;div class=\"description b\"&gt;##lang.problem.numberoftickets##&#160;: ##problem.numberoftickets##&lt;/div&gt; &lt;p&gt;##FOREACHtickets##&lt;/p&gt; &lt;div&gt;&lt;strong&gt; [##ticket.date##] &lt;em&gt;##lang.problem.title## : &lt;a href=\"##ticket.url##\"&gt;##ticket.title## &lt;/a&gt;&lt;/em&gt;&lt;/strong&gt;&lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; &lt;/span&gt;&lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt;##lang.problem.content## &lt;/span&gt; ##ticket.content## &lt;p&gt;##ENDFOREACHtickets##&lt;/p&gt; &lt;div class=\"description b\"&gt;##lang.problem.numberoftasks##&#160;: ##problem.numberoftasks##&lt;/div&gt; &lt;p&gt;##FOREACHtasks##&lt;/p&gt; &lt;div class=\"description b\"&gt;&lt;strong&gt;[##task.date##] &lt;/strong&gt;&lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.task.author##&lt;/span&gt; ##task.author##&lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.task.description##&lt;/span&gt; ##task.description##&lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.task.time##&lt;/span&gt; ##task.time##&lt;br /&gt; &lt;span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"&gt; ##lang.task.category##&lt;/span&gt; ##task.category##&lt;/div&gt; &lt;p&gt;##ENDFOREACHtasks##&lt;/p&gt; &lt;/div&gt;')"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_notifications` (`name`, `entities_id`, `itemtype`, `event`, `mode`, `notificationtemplates_id`, `comment`, `is_recursive`, `is_active`, `date_mod`) VALUES ('" . $notif_names[$type] . "', 0, 'Problem', '$type', 'mail', $notid, '', 1, 1, NOW())"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `$table` SET `itemtype` = '$val' WHERE `itemtype` = '$key'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT * FROM `glpi_documenttypes` WHERE `ext` = '$ext'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_documenttypes` (`name`, `ext`, `icon`, `is_uploadable`, `date_mod`) VALUES ('" . $data['name'] . "', '$ext', '" . $data['icon'] . "', '1', NOW())"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT `id` FROM `glpi_documenttypes` WHERE `ext` = '$ext'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_documenttypes` SET `icon` = '$icon', `date_mod` = NOW() WHERE `id` = '" . $DB->result($result, 0, 0) . "'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT * FROM `glpi_users` WHERE `email` <> '' AND `email` IS NOT NULL"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_useremails` (`users_id`, `is_default`, `is_dynamic`, `email`) VALUES ('" . $data['id'] . "','1','$is_dynamic','" . addslashes($data['email']) . "')"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_fieldunicities` SET `is_active` = '0' WHERE `id` = '" . $data['id'] . "'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT * FROM `glpi_groups` WHERE `users_id` > 0"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT `id` FROM `glpi_groups_users` WHERE `groups_id` = '" . $data['id'] . "' AND `users_id` = '" . $data['users_id'] . "'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO`glpi_groups_users` (`users_id`, `groups_id`, `is_manager`) VALUES ('" . $data['users_id'] . "' ,'" . $data['id'] . "', '1')"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_groups_users` SET `is_manager` = '1' WHERE `groups_id` = '" . $data['id'] . "' AND `users_id` = '" . $data['users_id'] . "'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_documents_items` as `doc_i` INNER JOIN `glpi_documents` as `doc` ON `doc`.`id` = `doc_i`.`documents_id` SET `doc_i`.`entities_id` = `doc`.`entities_id`, `doc_i`.`is_recursive` = `doc`.`is_recursive`"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_tickettemplates` (`name`, `is_recursive`) VALUES ('Default', 1)"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_tickettemplatemandatoryfields` (`tickettemplates_id`, `num`) VALUES ('$default_ticket_template', 1)"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_tickettemplatemandatoryfields` (`tickettemplates_id`, `num`) VALUES ('$default_ticket_template', 21)"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_tickettemplatemandatoryfields` (`tickettemplates_id`, `num`) VALUES ('$default_ticket_template', 7)"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_itilcategories` SET `tickettemplates_id_incident` = '$default_ticket_template', `tickettemplates_id_demand` = '$default_ticket_template'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_crontasks` (`itemtype`, `name`, `frequency`, `param`, `state`, `mode`, `allowmode`, `hourmin`, `hourmax`, `logs_lifetime`, `lastrun`, `lastcode`, `comment`) VALUES ('TicketRecurrent', 'ticketrecurrent', 3600, NULL, 1, 1, 3, 0, 24, 30, NULL, NULL, NULL)"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_profiles` (`" . implode("`, `", array_keys($data)) . "`) VALUES ('" . implode("', '", $data) . "')"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT `id` FROM `glpi_reminders` WHERE `is_helpdesk_visible` = 1"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_profiles_reminders` (`reminders_id`, `profiles_id`) VALUES ('" . $data['id'] . "', '$pid');"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT * FROM `glpi_reminders` WHERE `is_private` = 0"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_entities_reminders` (`reminders_id`, `entities_id`, `is_recursive`) VALUES ('" . $data['id'] . "', '" . $data['entities_id'] . "', '" . $data['is_recursive'] . "');"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT * FROM `glpi_knowbaseitems`"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_entities_knowbaseitems` (`knowbaseitems_id`, `entities_id`, `is_recursive`) VALUES ('" . $data['id'] . "', '" . $data['entities_id'] . "', '" . $data['is_recursive'] . "');"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_entitydatas` (`entities_id`, `entities_id_software`, `autofill_order_date`, `autofill_delivery_date`, `autofill_buy_date`, `autofill_use_date`, `autofill_warranty_date`, `inquest_config`, `inquest_rate`, `inquest_delay`, `tickettype`, `calendars_id`, `tickettemplates_id`, `autoclose_delay`, `auto_assign_mode`, `cartridges_alert_repeat`, `consumables_alert_repeat`, `use_licenses_alert`, `use_infocoms_alert`, `notclosed_delay`, `use_contracts_alert`, `use_reservations_alert`) VALUES (0, -10, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, '$default_ticket_template', -1, -1, -1, -1, -1, -1, -1, -1, -1)"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `tickettemplates_id` = '$default_ticket_template' WHERE `entities_id` = 0 AND `tickettemplates_id` = -2"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `entities_id_software` = -10 WHERE `entities_id` = 0 AND `entities_id_software` = -2"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `tickettype` = 1 WHERE `entities_id` = 0 AND `tickettype` = 0"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `inquest_config` = 1 WHERE `entities_id` = 0 AND `inquest_config` = 0"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `inquest_rate` = 0 WHERE `entities_id` = 0 AND `inquest_rate` = '-1'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `inquest_delay` = 0 WHERE `entities_id` = 0 AND `inquest_delay` = '-1'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `$field_0` = '-2' WHERE `$field_0` = '0' AND `entities_id` > 0"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `$field_parent` = '-2' WHERE `$field_parent` = '-1'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `$field_config` = '" . $data[$field_config] . "' WHERE `$field_config` = -1"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `auto_assign_mode` = -10 WHERE `auto_assign_mode` = 0"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_entitydatas` SET `calendars_id` = 0 WHERE `entities_id` = 0;"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `$table` SET `$field` = '" . $val . "' WHERE `$field` = '" . $key . "'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_displaypreferences` SET `num` = '86' WHERE `itemtype` = 'Group' AND `num` = '6'"1
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT `itemtype`, `items_id`, `id` FROM `glpi_tickets` WHERE `itemtype` IS NOT NULL AND `itemtype` <> '' AND `items_id` != 0"1
  • /install/migrations/update_0.85.0_to_0.85.3.php
"INSERT INTO `glpi_items_tickets` (`id`, `items_id`, `itemtype`, `tickets_id`) VALUES (NULL, '" . $data['items_id'] . "', '" . $data['itemtype'] . "', '" . $data['id'] . "')"1
  • /install/migrations/update_0.85.0_to_0.85.3.php
"UPDATE `glpi_changes` SET `status` = 1 WHERE `status` = 2"1
  • /install/migrations/update_0.85.0_to_0.85.3.php
'UPDATE `glpi_entities` SET `is_notif_enable_default` = 1 WHERE `id` = 0'1
  • /install/migrations/update_0.85.0_to_0.85.3.php
"INSERT INTO `glpi_profiles` (`name`, `interface`, `is_default`, `helpdesk_hardware`, `helpdesk_item_type`, `ticket_status`, `date_mod`, `comment`, `problem_status`, `create_ticket_on_login`, `tickettemplates_id`, `change_status`) VALUES ('Read-Only','central','0','0','[]', '{\"1\":{\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"6\":0},\"2\":{\"1\":0,\"3\":0,\"4\":0,\"5\":0,\"6\":0},\"3\":{\"1\":0,\"2\":0,\"4\":0,\"5\":0,\"6\":0},\"4\":{\"1\":0,\"2\":0,\"3\":0,\"5\":0,\"6\":0},\"5\":{\"1\":0,\"2\":0,\"3\":0,\"4\":0,\"6\":0},\"6\":{\"1\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0}}', NULL, 'This profile defines read-only access. It is used when objects are locked. It can also be used to give to users rights to unlock objects.', '{\"1\":{\"7\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\"7\":{\"1\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\"2\":{\"1\":0,\"7\":0,\"3\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\"3\":{\"1\":0,\"7\":0,\"2\":0,\"4\":0,\"5\":0,\"8\":0,\"6\":0},\"4\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"5\":0,\"8\":0,\"6\":0},\"5\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"4\":0,\"8\":0,\"6\":0},\"8\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"6\":0},\"6\":{\"1\":0,\"7\":0,\"2\":0,\"3\":0,\"4\":0,\"5\":0,\"8\":0}}', 0, 0, '{\"1\":{\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"9\":{\"1\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"10\":{\"1\":0,\"9\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"7\":{\"1\":0,\"9\":0,\"10\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"4\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"11\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"12\":0,\"5\":0,\"8\":0,\"6\":0},\"12\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"5\":0,\"8\":0,\"6\":0},\"5\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"8\":0,\"6\":0},\"8\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"6\":0},\"6\":{\"1\":0,\"9\":0,\"10\":0,\"7\":0,\"4\":0,\"11\":0,\"12\":0,\"5\":0,\"8\":0}}')"1
  • /install/migrations/update_0.90.x_to_9.1.0.php
"INSERT INTO `glpi_profilerights` (`profiles_id`, `name`, `rights`) VALUES ($ro_p_id, 'backup', '1'), ($ro_p_id, 'bookmark_public', '1'), ($ro_p_id, 'budget', '161'), ($ro_p_id, 'calendar', '1'), ($ro_p_id, 'cartridge', '161'), ($ro_p_id, 'change', '1185'), ($ro_p_id, 'changevalidation', '0'), ($ro_p_id, 'computer', '161'), ($ro_p_id, 'config', '1'), ($ro_p_id, 'consumable', '161'), ($ro_p_id, 'contact_enterprise', '161'), ($ro_p_id, 'contract', '161'), ($ro_p_id, 'device', '0'), ($ro_p_id, 'document', '161'), ($ro_p_id, 'domain', '1'), ($ro_p_id, 'dropdown', '1'), ($ro_p_id, 'entity', '1185'), ($ro_p_id, 'followup', '8193'), ($ro_p_id, 'global_validation', '0'), ($ro_p_id, 'group', '129'), ($ro_p_id, 'infocom', '1'), ($ro_p_id, 'internet', '129'), ($ro_p_id, 'itilcategory', '1'), ($ro_p_id, 'knowbase', '2177'), ($ro_p_id, 'knowbasecategory', '1'), ($ro_p_id, 'link', '129'), ($ro_p_id, 'location', '1'), ($ro_p_id, 'logs', '1'), ($ro_p_id, 'monitor', '161'), ($ro_p_id, 'netpoint', '1'), ($ro_p_id, 'networking', '161'), ($ro_p_id, 'notification', '1'), ($ro_p_id, 'password_update', '0'), ($ro_p_id, 'peripheral', '161'), ($ro_p_id, 'phone', '161'), ($ro_p_id, 'planning', '3073'), ($ro_p_id, 'printer', '161'), ($ro_p_id, 'problem', '1185'), ($ro_p_id, 'profile', '129'), ($ro_p_id, 'project', '1185'), ($ro_p_id, 'projecttask', '1'), ($ro_p_id, 'queuedmail', '1'), ($ro_p_id, 'reminder_public', '129'), ($ro_p_id, 'reports', '1'), ($ro_p_id, 'reservation', '1'), ($ro_p_id, 'rssfeed_public', '129'), ($ro_p_id, 'rule_dictionnary_dropdown', '1'), ($ro_p_id, 'rule_dictionnary_printer', '1'), ($ro_p_id, 'rule_dictionnary_software', '1'), ($ro_p_id, 'rule_import', '1'), ($ro_p_id, 'rule_ldap', '1'), ($ro_p_id, 'rule_mailcollector', '1'), ($ro_p_id, 'rule_softwarecategories', '1'), ($ro_p_id, 'rule_ticket', '1'), ($ro_p_id, 'search_config', '0'), ($ro_p_id, 'show_group_hardware', '1'), ($ro_p_id, 'sla', '1'), ($ro_p_id, 'software', '161'), ($ro_p_id, 'solutiontemplate', '1'), ($ro_p_id, 'state', '1'), ($ro_p_id, 'statistic', '1'), ($ro_p_id, 'task', '8193'), ($ro_p_id, 'taskcategory', '1'), ($ro_p_id, 'ticket', '7297'), ($ro_p_id, 'ticketcost', '1'), ($ro_p_id, 'ticketrecurrent', '1'), ($ro_p_id, 'tickettemplate', '1'), ($ro_p_id, 'ticketvalidation', '0'), ($ro_p_id, 'transfer', '1'), ($ro_p_id, 'typedoc', '1'), ($ro_p_id, 'user', '2177')"1
  • /install/migrations/update_0.90.x_to_9.1.0.php
"update super-admin profile with UNLOCK right"1
  • /install/migrations/update_0.90.x_to_9.1.0.php
"INSERT IGNORE INTO $quote_tmp_table $select"1
  • /install/migrations/update_9.5.x_to_10.0.0/reservationitem.php
'Update of a reservation'1
  • /src/NotificationTargetReservation.php
'Insert an item here'1
  • /src/Item_Rack.php
'Select an itemtype: '1
  • /src/Unmanaged.php
'Update of a change'1
  • /src/NotificationTargetChange.php
'Update of a ticket'1
  • /src/NotificationTargetTicket.php
'SELECT @@sql_mode as %s'1
  • /src/Update.php
'SELECT * FROM ' . $DB->quoteName(self::getTable( ))1
  • /src/Reminder.php
'Update of a problem'1
  • /src/NotificationTargetProblem.php
'Update (actor)'1
  • /src/ProjectTask.php
'delete all'1
  • /src/Item_Devices.php
'delete one'1
  • /src/Item_Devices.php
'Update of ' . $attributs['short name'] . ' denied'1
  • /src/Item_Devices.php
'Select the type of the item that must be unlock'1
  • /src/Lock.php
"Show impact"1
  • /src/Impact.php
"Show depends"1
  • /src/Impact.php
"Delete element"1
  • /src/Impact.php
"SELECT MAX(`id`) AS maxid FROM `glpi_logs`"1
  • /src/DBConnection.php
"SELECT UNIX_TIMESTAMP(MAX(`date_mod`)) AS max_date FROM `glpi_logs`"1
  • /src/DBConnection.php
"SELECT `tickets_id` FROM `glpi_tickets_users` WHERE `users_id` = '$user' AND type IN ($requester, $obs)"1
  • /src/Ticket.php
"SELECT `id` FROM `glpi_tickets` WHERE `users_id_recipient` = '$user'"1
  • /src/Ticket.php
"SELECT `tickets_id` FROM `glpi_groups_tickets` WHERE `groups_id` IN ($groups) AND type IN ($requester, $obs)"1
  • /src/Ticket.php
"SELECT `tickets_id` FROM `glpi_tickets_users` WHERE `users_id` = '$user' AND type = $assign"1
  • /src/Ticket.php
"SELECT `tickets_id` FROM `glpi_groups_tickets` WHERE `groups_id` IN ($groups) AND type = $assign"1
  • /src/Ticket.php
"SELECT `id` FROM `glpi_tickets` WHERE `status` = '" . CommonITILObject::INCOMING . "'"1
  • /src/Ticket.php
"SELECT `tickets_id` FROM `glpi_ticketvalidations` WHERE `users_id_validate` = '$user'"1
  • /src/Ticket.php
"update entities_id and is_recursive=0 in glpi_infocoms for $name"1
  • /src/Plugin.php
"update entities_id and is_recursive=1 in glpi_infocoms for $name"1
  • /src/Plugin.php
"update entities_id in glpi_infocoms for $name"1
  • /src/Plugin.php
'Update authentification method to'1
  • /src/User.php
'Update auth and sync'1
  • /src/User.php
'Update method for user authentication and synchronization'1
  • /src/User.php
'SELECT * FROM ' . $DB->quoteName(self::getTable( )) . ' '1
  • /src/RSSFeed.php
'Delete permanently but keep devices'1
  • /src/MassiveAction.php
'Delete permanently and remove devices'1
  • /src/MassiveAction.php
'Delete permanently the relation with selected elements'1
  • /src/MassiveAction.php
'Delete permanently even if linked items'1
  • /src/MassiveAction.php
'Select the common field that you want to update'1
  • /src/MassiveAction.php
'Select the field that you want to update'1
  • /src/MassiveAction.php
'Update of a project'1
  • /src/NotificationTargetProject.php
"SELECT DISTINCT `$itemtable`.`id` AS id, '" . Toolbox::addslashes_deep($_SESSION['glpiname']) . "' AS currentuser, " . self::addDefaultSelect($data['itemtype'])1
  • /src/Search.php
"SELECT $count, '" . Toolbox::addslashes_deep($_SESSION['glpiname']) . "' AS currentuser FROM `$itemtable`" . $COMMONLEFTJOIN1
  • /src/Search.php
'Delete a global rule'1
  • /src/Search.php
'Show personnal information in new ticket form (simplified interface)'1
  • /src/Config.php
'Show GLPI ID'1
  • /src/Config.php
'Show new tickets on the home page'1
  • /src/Config.php
"Delete relation between items"1
  • /src/Config.php
"Delete the item"1
  • /src/Config.php
"Update component"1
  • /src/Config.php
"Delete component"1
  • /src/Config.php
"Delete all"1
  • /src/Config.php
"Delete if older than %s month"1
  • /src/Config.php
"Delete if older than %s months"1
  • /src/Config.php
'Show list of available tags'1
  • /src/NotificationTemplateTranslation.php
'Update my password'1
  • /src/Central.php
'Update the approval request to %s'1
  • /src/CommonITILValidation.php
'Insert a rack here'1
  • /src/Rack.php
'Update followups (author)'1
  • /src/ITILFollowup.php
"SELECT `$target` FROM `$user_table` WHERE `users_id` = '$user'"1
  • /src/ITILFollowup.php
"SELECT `$target` FROM `$group_table` WHERE `groups_id` IN ($groups)"1
  • /src/ITILFollowup.php
"SELECT `id` FROM `$table` WHERE `users_id_recipient` = '$user'"1
  • /src/ITILFollowup.php
'Update of a project task'1
  • /src/NotificationTargetProjectTask.php
'Select a peer for %s:'1
  • /src/CommonDBConnexity.php
'Delete all repetition'1
  • /src/Reservation.php
'Update Source'1
  • /src/AutoUpdateSystem.php
'Update Sources'1
  • /src/AutoUpdateSystem.php
"SHOW COLUMNS FROM `$table`"1
  • /src/DBmysql.php
"SELECT @@sql_mode as mode, @@version AS vers, @@version_comment AS stype"1
  • /src/DBmysql.php
"SELECT GET_LOCK('$name', 0)"1
  • /src/DBmysql.php
"SELECT RELEASE_LOCK('$name')"1
  • /src/DBmysql.php
"INSERT INTO " . self::quoteName($table) . " ("1
  • /src/DBmysql.php
"UPDATE " . self::quoteName($table)1
  • /src/DBmysql.php
'Update would change too many rows!'1
  • /src/DBmysql.php
"DELETE " . self::quoteName($table) . " FROM " . self::quoteName($table)1
  • /src/DBmysql.php
'SHOW WARNINGS'1
  • /src/DBmysql.php
'Update only mac address (mac on switch port)'1
  • /src/RuleImportAsset.php
'Update notes'1
  • /src/CommonDBTM.php
"Update the item's notes"1
  • /src/CommonDBTM.php
'Update of the field'1
  • /src/Log.php
'Update a field'1
  • /src/Log.php
'Delete the item'1
  • /src/Log.php
'Delete a component'1
  • /src/Log.php
'Update a link with an item'1
  • /src/Log.php
'Delete a link with an item'1
  • /src/Log.php
'Update an item'1
  • /src/Log.php
'Delete an item'1
  • /src/Log.php
'Update all bookmarks execution time'1
  • /src/SavedSearch.php
'Update of a task'1
  • /src/NotificationTargetCommonITILObject.php
'Update of a followup'1
  • /src/NotificationTargetCommonITILObject.php
"Delete serie"1
  • /src/PlanningExternalEvent.php
"Delete instance"1
  • /src/PlanningExternalEvent.php
'Update parameters'1
  • /src/Entity.php
'Update helpdesk parameters'1
  • /src/Entity.php
"SHOW INDEX FROM `$table`"1
  • /src/DbUtils.php
'SELECT '1
  • /src/DBmysqlIterator.php
"UPDATE `$table` SET `$field` = " . $params['update'] . " " . $params['condition'] . ""1
  • /src/Migration.php
"INSERT INTO `$newtable` (SELECT * FROM `$oldtable`)"1
  • /src/Migration.php
"SELECT MAX(`ranking`) AS `rank` FROM `glpi_rules` WHERE `sub_type` = '" . $rule['sub_type'] . "'"1
  • /src/Migration.php
"SELECT MAX(`rank`) FROM `glpi_displaypreferences` WHERE `users_id` = '" . $data['users_id'] . "' AND `itemtype` = '$type'"1
  • /src/Migration.php
"SELECT * FROM `glpi_displaypreferences` WHERE `users_id` = '" . $data['users_id'] . "' AND `num` = '$newval' AND `itemtype` = '$type'"1
  • /src/Migration.php
'Update printer counter'1
  • /src/Cartridge.php
'Select the report you want to generate'1
  • /src/Report.php
'Select statistics to be displayed'1
  • /src/Stat.php
'Delete emails'1
  • /src/NotImportedEmail.php
'Update date'1
  • /src/KnowbaseItem_Item.php
"Delete this dashboard"1
  • /src/Dashboard/Grid.php
"Delete this card"1
  • /src/Dashboard/Grid.php
'SHOW COLUMNS FROM ' . $this->db->quoteName($table_name)1
  • /src/System/Diagnostic/AbstractDatabaseChecker.php
'SHOW INDEX FROM ' . $this->db->quoteName($table_name)1
  • /src/System/Diagnostic/AbstractDatabaseChecker.php
'SHOW CREATE TABLE ' . $this->db->quoteName($table_name)1
  • /src/System/Diagnostic/DatabaseSchemaIntegrityChecker.php
'SHOW DATABASES LIKE ' . $this->db->quoteValue('mysql')1
  • /src/System/Requirement/DbTimezones.php
'SHOW TABLES FROM ' . $this->db->quoteName('mysql') . ' LIKE ' . $this->db->quoteValue('time_zone_name')1
  • /src/System/Requirement/DbTimezones.php
'SELECT @@GLOBAL.' . $this->db->quoteName('innodb_page_size as innodb_page_size')1
  • /src/System/Requirement/DbConfiguration.php
"SELECT DISTINCT " . $DB->quoteName("$table.id") . ", " . $DB->quoteName("$table.*") . " FROM " . $DB->quoteName($table) . " $join WHERE $where ORDER BY " . $DB->quoteName($params['sort']) . " " . $params['order'] . " LIMIT " . (int) $params['start'] . ", " . (int) $params['list_limit']1
  • /src/Api/API.php
"SELECT COUNT(*) FROM {$DB->quoteName($table)} $join WHERE $where"1
  • /src/Api/API.php
"SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema = '{$db_name}' AND table_type = 'BASE TABLE' AND table_name LIKE 'glpi\_%'"1
  • /src/Console/Database/InstallCommand.php
'Update database schema to new version'1
  • /src/Console/Database/UpdateCommand.php
'Update existing users with server "%s"...'1
  • /src/Console/Ldap/SynchronizeUsersCommand.php
"UPDATE %s SET helpdesk_item_type = REPLACE(helpdesk_item_type, '%s', '%s')"1
  • /src/Console/Migration/AppliancesPluginToCoreCommand.php
" UPDATE `$table` LEFT JOIN ( SELECT $target_date AS `date_mod`, `itemtype`, `items_id` FROM `$log_table` GROUP BY `itemtype`, `items_id` ) as `logs` ON `logs`.`itemtype` = '$itemtype' AND `logs`.`items_id` = `$table`.`id` SET `$table`.`$column` = `logs`.`date_mod` WHERE `$table`.`$column` IS NULL "1
  • /src/Console/Migration/BuildMissingTimestampsCommand.php
'Update of `%s`.`%s` failed with message "(%s) %s".'1
  • /src/Console/Migration/BuildMissingTimestampsCommand.php
'Update of `%s` failed with message "(%s) %s".'1
  • /src/Console/Migration/TimestampsCommand.php
'Update Problem'2
  • /install/empty_data.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
'Delete Problem'2
  • /install/empty_data.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
'Delete Ticket'2
  • /install/empty_data.php
  • /install/migrations/update_0.83.x_to_0.84.0.php
'Update Change'2
  • /install/empty_data.php
  • /install/migrations/update_0.84.x_to_0.85.0.php
'Delete Change'2
  • /install/empty_data.php
  • /install/migrations/update_0.84.x_to_0.85.0.php
'Update Project'2
  • /install/empty_data.php
  • /install/migrations/update_0.84.x_to_0.85.0.php
'Delete Project'2
  • /install/empty_data.php
  • /install/migrations/update_0.84.x_to_0.85.0.php
'Update Project Task'2
  • /install/empty_data.php
  • /install/migrations/update_0.84.x_to_0.85.0.php
'Delete Project Task'2
  • /install/empty_data.php
  • /install/migrations/update_0.84.x_to_0.85.0.php
'Update default right assignement rule'2
  • /install/migrations/update_9.4.x_to_9.5.0.php (2)
"SELECT * FROM `glpi_notificationtargets` WHERE `notifications_id` = '" . $notif['id'] . "'"2
  • /install/migrations/update_0.84.x_to_0.85.0.php
  • /install/migrations/update_0.83.x_to_0.84.0.php
"INSERT INTO `glpi_notificationtargets` (`notifications_id`, `type`, `items_id`) VALUES ($newID, '" . $target['type'] . "', '" . $target['items_id'] . "')"2
  • /install/migrations/update_0.84.x_to_0.85.0.php
  • /install/migrations/update_0.83.x_to_0.84.0.php
"SELECT * FROM `glpi_bookmarks`"2
  • /install/migrations/update_0.84.x_to_0.85.0.php
  • /install/migrations/update_0.84.1_to_0.84.3.php
"UPDATE `glpi_ruleactions` SET `field` = '$new' WHERE `field` = '$old' AND `rules_id` IN ($rules)"2
  • /install/migrations/update_0.83.x_to_0.84.0.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
"UPDATE `glpi_rulecriterias` SET `criteria` = '$new' WHERE `criteria` = '$old' AND `rules_id` IN ($rules)"2
  • /install/migrations/update_0.83.x_to_0.84.0.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
"SELECT * FROM `glpi_configs`"2
  • /install/migrations/update_0.80.x_to_0.83.0.php (2)
'SELECT MAX(%s) as %s FROM %s GROUP BY %s, DATE(%s)'2
  • /install/migrations/update_9.5.x_to_10.0.0/native_inventory.php (2)
'Show graphics'2
  • /front/stat.location.php
  • /front/stat.tracking.php
'Select the desired entity'2
  • /src/AuthLDAP.php
  • /src/RuleCollection.php
'Update all'2
  • /src/TicketTask.php
  • /src/ITILFollowup.php
'Show all'2
  • /src/Ticket.php (2)
"update itemtype of table $table for $name"2
  • /src/Plugin.php (2)
'Show %1$s'2
  • /src/User.php
  • /src/Dropdown.php
'Select the type of the item on which applying this action'2
  • /src/MassiveAction.php (2)
'Delete a rule'2
  • /src/Search.php (2)
'Update the item'2
  • /src/Config.php
  • /src/NotificationTargetFieldUnicity.php
'Show on global GANTT'2
  • /src/Project.php (2)
'SELECT version()'2
  • /src/DBmysql.php
  • /src/Console/Database/AbstractConfigureCommand.php
'SELECT * FROM ' . $DB->quoteName(self::getTable( )) . ''2
  • /src/KnowbaseItem.php (2)
"UPDATE `glpi_documents_items` as `doc_i` INNER JOIN `glpi_documents` as `doc` ON `doc`.`id` = `doc_i`.`documents_id` SET `doc_i`.`entities_id` = `doc`.`entities_id`, `doc_i`.`is_recursive` = `doc`.`is_recursive`"3
  • /install/migrations/update_0.83.1_to_0.83.3.php
  • /install/migrations/update_0.84.5_to_0.84.6.php
  • /install/migrations/update_0.84.0_to_0.84.1.php
"UPDATE `glpi_bookmarks` SET `query` = '" . addslashes(Toolbox::append_params($options)) . "' WHERE `id` = '" . $data['id'] . "'"3
  • /install/migrations/update_0.84.x_to_0.85.0.php (2)
  • /install/migrations/update_0.84.1_to_0.84.3.php
"SELECT GROUP_CONCAT(`id`) FROM `glpi_rules` WHERE `sub_type` = '" . $ruletype . "' GROUP BY `sub_type`"3
  • /install/migrations/update_0.83.x_to_0.84.0.php (2)
  • /install/migrations/update_0.80.x_to_0.83.0.php
'update item previous'3
  • /src/CommonDBRelation.php (2)
  • /src/CommonDBChild.php
'update item next'3
  • /src/CommonDBRelation.php (2)
  • /src/CommonDBChild.php
'Select default items to show'3
  • /src/NetworkPort.php (3)
'Update Task'5
  • /install/empty_data.php (3)
  • /install/migrations/update_0.84.x_to_0.85.0.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
'Delete Task'5
  • /install/empty_data.php (3)
  • /install/migrations/update_0.84.x_to_0.85.0.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
"INSERT INTO `glpi_notificationtargets` (`id`, `notifications_id`, `type`, `items_id`) VALUES (NULL, $notifid, " . Notification::USER_TYPE . ", $target);"5
  • /install/migrations/update_0.84.x_to_0.85.0.php (3)
  • /install/migrations/update_0.83.x_to_0.84.0.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
'Update password'5
  • /front/updatepassword.php (3)
  • /src/Profile.php (2)
"SELECT DISTINCT `users_id` FROM `glpi_displaypreferences` WHERE `itemtype` = '$type'"9
  • /install/migrations/update_0.83.1_to_0.83.3.php
  • /install/migrations/update_0.83.x_to_0.84.0.php
  • /install/migrations/update_0.84.1_to_0.84.3.php
  • /install/migrations/update_0.84.0_to_0.84.1.php
  • /install/migrations/update_0.84.3_to_0.84.4.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
  • /install/migrations/update_0.85.x_to_0.90.0.php
  • /install/migrations/update_0.85.0_to_0.85.3.php
  • /install/migrations/update_0.83.0_to_0.83.1.php
"SELECT MAX(`rank`) FROM `glpi_displaypreferences` WHERE `users_id` = '" . $data['users_id'] . "' AND `itemtype` = '$type'"9
  • /install/migrations/update_0.83.1_to_0.83.3.php
  • /install/migrations/update_0.83.x_to_0.84.0.php
  • /install/migrations/update_0.84.1_to_0.84.3.php
  • /install/migrations/update_0.84.0_to_0.84.1.php
  • /install/migrations/update_0.84.3_to_0.84.4.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
  • /install/migrations/update_0.85.x_to_0.90.0.php
  • /install/migrations/update_0.85.0_to_0.85.3.php
  • /install/migrations/update_0.83.0_to_0.83.1.php
"SELECT * FROM `glpi_displaypreferences` WHERE `users_id` = '" . $data['users_id'] . "' AND `num` = '$newval' AND `itemtype` = '$type'"9
  • /install/migrations/update_0.83.1_to_0.83.3.php
  • /install/migrations/update_0.83.x_to_0.84.0.php
  • /install/migrations/update_0.84.1_to_0.84.3.php
  • /install/migrations/update_0.84.0_to_0.84.1.php
  • /install/migrations/update_0.84.3_to_0.84.4.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
  • /install/migrations/update_0.85.x_to_0.90.0.php
  • /install/migrations/update_0.85.0_to_0.85.3.php
  • /install/migrations/update_0.83.0_to_0.83.1.php
"INSERT INTO `glpi_displaypreferences` (`itemtype` ,`num` ,`rank` ,`users_id`) VALUES ('$type', '$newval', '" . $rank++ . "', '" . $data['users_id'] . "')"9
  • /install/migrations/update_0.83.1_to_0.83.3.php
  • /install/migrations/update_0.83.x_to_0.84.0.php
  • /install/migrations/update_0.84.1_to_0.84.3.php
  • /install/migrations/update_0.84.0_to_0.84.1.php
  • /install/migrations/update_0.84.3_to_0.84.4.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
  • /install/migrations/update_0.85.x_to_0.90.0.php
  • /install/migrations/update_0.85.0_to_0.85.3.php
  • /install/migrations/update_0.83.0_to_0.83.1.php
"INSERT INTO `glpi_displaypreferences` (`itemtype` ,`num` ,`rank` ,`users_id`) VALUES ('$type', '$newval', '" . $rank++ . "', '0')"9
  • /install/migrations/update_0.83.1_to_0.83.3.php
  • /install/migrations/update_0.83.x_to_0.84.0.php
  • /install/migrations/update_0.84.1_to_0.84.3.php
  • /install/migrations/update_0.84.0_to_0.84.1.php
  • /install/migrations/update_0.84.3_to_0.84.4.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
  • /install/migrations/update_0.85.x_to_0.90.0.php
  • /install/migrations/update_0.85.0_to_0.85.3.php
  • /install/migrations/update_0.83.0_to_0.83.1.php
'Delete permanently'32
  • /src/Transfer.php (4)
  • /src/Item_SoftwareVersion.php (3)
  • /src/DisplayPreference.php (3)
  • /src/MassiveAction.php (2)
  • /src/Socket.php (2)
  • /src/CommonDBTM.php (2)
  • /src/Cartridge.php (2)
  • /src/Item_Ticket.php
  • /src/Notepad.php
  • /src/CommonDBVisible.php
  • /src/Change_Ticket.php
  • /src/Rule.php
  • /src/Problem_Ticket.php
  • /src/Profile_User.php
  • /src/Item_SoftwareLicense.php
  • /src/LevelAgreement.php
  • /src/CommonDBRelation.php
  • /src/Ticket_Contract.php
  • /src/Reservation.php
  • /src/Consumable.php
  • /src/Dashboard/Grid.php
'Update to %s'41
  • /install/migrations/update_9.4.6_to_9.4.7.php
  • /install/migrations/update_9.1.0_to_9.1.1.php
  • /install/migrations/update_9.2.0_to_9.2.1.php
  • /install/migrations/update_9.4.0_to_9.4.1.php
  • /install/migrations/update_0.80.0_to_0.80.1.php
  • /install/migrations/update_9.1.x_to_9.2.0.php
  • /install/migrations/update_0.90.1_to_0.90.5.php
  • /install/migrations/update_9.2.x_to_9.3.0.php
  • /install/migrations/update_9.4.1_to_9.4.2.php
  • /install/migrations/update_9.1.1_to_9.1.3.php
  • /install/migrations/update_9.2.1_to_9.2.2.php
  • /install/migrations/update_9.4.x_to_9.5.0.php
  • /install/migrations/update_0.83.1_to_0.83.3.php
  • /install/migrations/update_0.84.x_to_0.85.0.php
  • /install/migrations/update_0.84.5_to_0.84.6.php
  • /install/migrations/update_9.3.1_to_9.3.2.php
  • /install/migrations/update_0.83.x_to_0.84.0.php
  • /install/migrations/update_9.5.1_to_9.5.2.php
  • /install/migrations/update_9.5.x_to_10.0.0.php
  • /install/migrations/update_9.3.0_to_9.3.1.php
  • /install/migrations/update_9.5.6_to_9.5.7.php
  • /install/migrations/update_0.84.1_to_0.84.3.php
  • /install/migrations/update_9.3.x_to_9.4.0.php
  • /install/migrations/update_0.84.0_to_0.84.1.php
  • /install/migrations/update_0.84.3_to_0.84.4.php
  • /install/migrations/update_0.80.x_to_0.83.0.php
  • /install/migrations/update_9.5.4_to_9.5.5.php
  • /install/migrations/update_9.5.3_to_9.5.4.php
  • /install/migrations/update_9.5.2_to_9.5.3.php
  • /install/migrations/update_0.85.x_to_0.90.0.php
  • /install/migrations/update_0.85.0_to_0.85.3.php
  • /install/migrations/update_9.5.5_to_9.5.6.php
  • /install/migrations/update_0.85.3_to_0.85.5.php
  • /install/migrations/update_9.4.5_to_9.4.6.php
  • /install/migrations/update_0.83.0_to_0.83.1.php
  • /install/migrations/update_0.80.1_to_0.80.3.php
  • /install/migrations/update_9.4.2_to_9.4.3.php
  • /install/migrations/update_0.90.x_to_9.1.0.php
  • /install/migrations/update_9.4.3_to_9.4.5.php
  • /install/migrations/update_0.90.0_to_0.90.1.php
  • /install/migrations/update_9.2.2_to_9.2.3.php