List of all SQL mentioned in the code..
Value | Count | File:Line |
---|---|---|
'Update needed' | 1 |
|
'Delete orphan logs' | 1 |
|
"SHOW DATABASES" | 1 |
|
"Select your language" | 1 |
|
'Update Ticket' | 1 |
|
'Update Followup' | 1 |
|
'Delete Followup' | 1 |
|
'Update Reservation' | 1 |
|
'Delete Reservation' | 1 |
|
"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 |
|
"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 |
|
"SELECT COUNT(*) AS CPT, `tickets_id`, `type`, `groups_id` FROM `glpi_groups_tickets` GROUP BY `tickets_id`, `type`, `groups_id` HAVING CPT > 1" | 1 |
|
"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 |
|
"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 |
|
"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 |
|
"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 |
|
"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 |
|
"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 |
|
"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 |
|
"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 |
|
"SHOW INDEX FROM `$table` WHERE Key_name='unicity'" | 1 |
|
"SELECT * FROM `glpi_configs` WHERE `id` = '1'" | 1 |
|
"INSERT INTO `glpi_configs` (`context`, `name`, `value`) VALUES ('core', '$name', '" . addslashes($value ?? '') . "');" | 1 |
|
"SELECT * FROM `origin_glpi_profiles`" | 1 |
|
"INSERT INTO `glpi_profilerights` (`profiles_id`, `name`, `rights`) VALUES ('$profiles_id', '$right', '" . $new_right . "')" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . User::IMPORTEXTAUTHUSERS . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'user'" | 1 |
|
"UPDATE `glpi_profilerights` SET `name` = 'root_rule_ticket' WHERE `name` = 'rule_ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `name` = 'rule_ticket' WHERE `name` = 'entity_rule_ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . RuleTicket::PARENT . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'rule_ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . KnowbaseItem::KNOWBASEADMIN . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'knowbase'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . KnowbaseItem::READFAQ . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'knowbase'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . KnowbaseItem::READFAQ . " | " . KnowbaseItem::PUBLISHFAQ . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'knowbase'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . User::READAUTHENT . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'user'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . User::READAUTHENT . " | " . User::UPDATEAUTHENT . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'user'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Entity::READHELPDESK . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'entity'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Entity::READHELPDESK . " | " . Entity::UPDATEHELPDESK . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'entity'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . ReservationItem::RESERVEANITEM . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'reservation_central'" | 1 |
|
"UPDATE `glpi_profilerights` SET `name` = 'reservation' WHERE `name` = 'reservation_central'" | 1 |
|
"UPDATE `glpi_profilerights` SET `name` = 'ticket' WHERE `name` = 'create_ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = " . (CREATE | Ticket::READMY) . " WHERE `name` = 'ticket' AND `rights` = '1'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . UPDATE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . DELETE . " | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::READALL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::READGROUP . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::READASSIGN . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::ASSIGN . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::STEAL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::OWN . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Ticket::CHANGEPRIORITY . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticket'" | 1 |
|
"UPDATE `glpi_profilerights` SET `name` = 'followup' WHERE `name` = 'global_add_followups'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = " . ITILFollowup::ADDALLTICKET . " WHERE `name` = 'followup' AND `rights` = '1'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . ITILFollowup::ADDMYTICKET . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . ITILFollowup::ADDGROUPTICKET . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . ITILFollowup::SEEPUBLIC . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . ITILFollowup::SEEPUBLIC . " | " . ITILFollowup::SEEPRIVATE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . READ . " | " . ITILFollowup::UPDATEALL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . READ . " | " . ITILFollowup::UPDATEMY . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'followup'" | 1 |
|
"UPDATE `glpi_profilerights` SET `name` = 'task' WHERE `name` = 'global_add_tasks'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = " . CommonITILTask::ADDALLITEM . " WHERE `name` = 'task' AND `rights` = '1'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . READ . " | " . TicketTask::UPDATEALL . " | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'task'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketTask::SEEPUBLIC . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'task'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketTask::SEEPUBLIC . " | " . TicketTask::SEEPRIVATE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'task'" | 1 |
|
"UPDATE `glpi_profilerights` SET `name` = 'ticketvalidation' WHERE `name` = 'delete_validations'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = " . DELETE . " WHERE `name` = 'ticketvalidation' AND `rights` = '1'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketValidation::CREATEREQUEST . " | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticketvalidation'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketValidation::CREATEINCIDENT . " | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticketvalidation'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketValidation::VALIDATEREQUEST . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticketvalidation'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . TicketValidation::VALIDATEINCIDENT . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'ticketvalidation'" | 1 |
|
"UPDATE `glpi_profilerights` SET `name` = 'planning' WHERE `name` = 'show_planning'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Planning::READGROUP . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'planning'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Planning::READALL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'planning'" | 1 |
|
"UPDATE `glpi_profilerights` SET `name` = 'problem' WHERE `name` = 'show_my_problem'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . Problem::READALL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'problem'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . CREATE . " | " . UPDATE . " | " . PURGE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'problem'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . DELETE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'problem'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . DisplayPreference::PERSONAL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'search_config'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . DisplayPreference::GENERAL . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'search_config'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . 1024 . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = 'backup'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . READNOTE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = '$table'" | 1 |
|
"UPDATE `glpi_profilerights` SET `rights` = `rights` | " . READNOTE . " | " . UPDATENOTE . " WHERE `profiles_id` = '" . $profrights['profiles_id'] . "' AND `name` = '$table'" | 1 |
|
'Update for mailqueue' | 1 |
|
"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 |
|
"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 |
|
"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 |
|
'UPDATE `glpi_entities` SET `delay_send_emails` = 0 WHERE `id` = 0' | 1 |
|
"SELECT * FROM `glpi_notificationtemplates` WHERE `itemtype` = 'Change'" | 1 |
|
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Changes', 'Change', NOW())" | 1 |
|
"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 |
|
"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 |
|
"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 |
|
"UPDATE `glpi_rules` SET `uuid` = '$uuid' WHERE `id` = '" . $data['id'] . "'" | 1 |
|
"UPDATE `glpi_slalevels` SET `uuid` = '$uuid' WHERE `id` = '" . $data['id'] . "'" | 1 |
|
"SELECT * FROM `glpi_notifications` WHERE `itemtype` = 'Ticket' AND `event` = 'satisfaction'" | 1 |
|
"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 |
|
"INSERT INTO `glpi_notificationtargets` (`notifications_id`, `type`, `items_id`) VALUES ($newID, '" . Notification::USER_TYPE . "', '" . Notification::ASSIGN_TECH . "')" | 1 |
|
"SELECT * FROM `glpi_slas` WHERE `resolution_time` <= '3000'" | 1 |
|
"UPDATE `glpi_slas` SET `definition_time` = 'minute', `resolution_time` = `resolution_time`/60 WHERE `id` IN (" . implode(",", $a_ids) . ")" | 1 |
|
"SELECT * FROM `glpi_slas` WHERE `resolution_time` > '3000' AND `resolution_time` <= '82800'" | 1 |
|
"UPDATE `glpi_slas` SET `definition_time` = 'hour', `resolution_time` = `resolution_time`/3600 WHERE `id` IN (" . implode(",", $a_ids) . ")" | 1 |
|
"SELECT * FROM `glpi_slas` WHERE `resolution_time` > '82800'" | 1 |
|
"UPDATE `glpi_slas` SET `definition_time` = 'day', `resolution_time` = `resolution_time`/86400 WHERE `id` IN (" . implode(",", $a_ids) . ")" | 1 |
|
"SELECT * FROM `glpi_notificationtemplates` WHERE `itemtype` = 'MailCollector'" | 1 |
|
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Receiver errors', 'MailCollector', NOW())" | 1 |
|
"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##', '<p>##FOREACHmailcollectors##<br />##lang.mailcollector.name## : ##mailcollector.name##<br /> ##lang.mailcollector.errors## : ##mailcollector.errors##<br /><a href=\"##mailcollector.url##\">##mailcollector.url##</a><br /> ##ENDFOREACHmailcollectors##</p> <p></p>')" | 1 |
|
"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 |
|
"INSERT INTO `glpi_notificationtargets` (`id`, `notifications_id`, `type`, `items_id`) VALUES (NULL, $notifid, " . Notification::USER_TYPE . ", " . Notification::GLOBAL_ADMINISTRATOR . ");" | 1 |
|
"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 |
|
"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 |
|
"UPDATE `glpi_documents` SET `tag` = `id`" | 1 |
|
"UPDATE `glpi_events` SET `type` = 'consumableitems' WHERE `type` = 'consumables'" | 1 |
|
"UPDATE `glpi_events` SET `type` = 'cartridgeitems' WHERE `type` = 'cartridges';" | 1 |
|
"INSERT INTO `glpi_configs` (`context`, `name`, `value`) VALUES ('core', 'backcreated', 0)" | 1 |
|
"update glpi_configs with backcreated" | 1 |
|
"INSERT INTO `glpi_projectstates` (`name`,`color`,`is_finished`) VALUES ('" . addslashes($val['name']) . "','" . addslashes($val['color']) . "', '" . addslashes($val['is_finished']) . "')" | 1 |
|
"SELECT * FROM `glpi_notificationtemplates` WHERE `itemtype` = 'Project'" | 1 |
|
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Projects', 'Project', NOW())" | 1 |
|
"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##', '<p>##lang.project.url## : <a href=\"##project.url##\">##project.url##</a></p> <p><strong>##lang.project.description##</strong></p> <p>##lang.project.name## : ##project.name##<br />##lang.project.code## : ##project.code##<br /> ##lang.project.manager## : ##project.manager##<br />##lang.project.managergroup## : ##project.managergroup##<br /> ##lang.project.creationdate## : ##project.creationdate##<br />##lang.project.priority## : ##project.priority## <br />##lang.project.state## : ##project.state##<br />##lang.project.type## : ##project.type##<br />##lang.project.description## : ##project.description##</p> <p>##lang.project.numberoftasks## : ##project.numberoftasks##</p> <div> <p>##FOREACHtasks##</p> <div><strong>[##task.creationdate##] </strong><br /> ##lang.task.name## : ##task.name##<br />##lang.task.state## : ##task.state##<br />##lang.task.type## : ##task.type##<br />##lang.task.percent## : ##task.percent##<br />##lang.task.description## : ##task.description##</div> <p>##ENDFOREACHtasks##</p> </div>')" | 1 |
|
"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 |
|
"SELECT * FROM `glpi_notificationtemplates` WHERE `itemtype` = 'ProjectTask'" | 1 |
|
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Project Tasks', 'ProjectTask', NOW())" | 1 |
|
"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##', '<p>##lang.projecttask.url## : <a href=\"##projecttask.url##\">##projecttask.url##</a></p> <p><strong>##lang.projecttask.description##</strong></p> <p>##lang.projecttask.name## : ##projecttask.name##<br />##lang.projecttask.project## : <a href=\"##projecttask.projecturl##\">##projecttask.project##</a><br />##lang.projecttask.creationdate## : ##projecttask.creationdate##<br />##lang.projecttask.state## : ##projecttask.state##<br />##lang.projecttask.type## : ##projecttask.type##<br />##lang.projecttask.description## : ##projecttask.description##</p> <p>##lang.projecttask.numberoftasks## : ##projecttask.numberoftasks##</p> <div> <p>##FOREACHtasks##</p> <div><strong>[##task.creationdate##] </strong><br />##lang.task.name## : ##task.name##<br />##lang.task.state## : ##task.state##<br />##lang.task.type## : ##task.type##<br />##lang.task.percent## : ##task.percent##<br />##lang.task.description## : ##task.description##</div> <p>##ENDFOREACHtasks##</p> </div>')" | 1 |
|
"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 |
|
"SELECT id, notepad FROM `$t` WHERE notepad IS NOT NULL AND notepad <>'';" | 1 |
|
"INSERT INTO `glpi_notepads` (`itemtype`, `items_id`, `content`, `date`, `date_mod`) VALUES ('" . getItemTypeForTable($t) . "', '" . $data['id'] . "', '" . addslashes($data['notepad']) . "', NOW(), NOW())" | 1 |
|
"UPDATE `glpi_ticketvalidations` SET `status` = '$new' WHERE `status` = '$old'" | 1 |
|
"UPDATE `" . $table . "` SET `global_validation` = '$new' WHERE `global_validation` = '$old'" | 1 |
|
"UPDATE `glpi_tickettemplatepredefinedfields` SET `value` = '$new' WHERE `num` = '52' AND `value` = '$old'" | 1 |
|
"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 |
|
"UPDATE `glpi_notificationtemplatetranslations` SET `subject` = '" . addslashes($subject) . "', `content_text` = '" . addslashes($text) . "', `content_html` = '" . addslashes($html) . "' WHERE `id` = " . $data['id'] . "" | 1 |
|
"SELECT `id`, `number` FROM `glpi_softwarelicenses`" | 1 |
|
"UPDATE `glpi_softwarelicenses` SET `is_valid` = 0 WHERE `id` = '" . $datal['id'] . "'" | 1 |
|
"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 |
|
"UPDATE `glpi_softwares` SET `is_valid` = 0 WHERE `id` = '" . $datas['id'] . "'" | 1 |
|
"UPDATE `glpi_rules` SET `condition` = 1 WHERE `sub_type` = 'RuleTicket'" | 1 |
|
"UPDATE `glpi_profiles` SET `ticket_status` = '" . exportArrayToDB($newcycle) . "' WHERE `interface` = 'helpdesk'" | 1 |
|
"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 |
|
"SELECT * FROM `glpi_bookmarks` WHERE `type` = '" . Bookmark::SEARCH . "'" | 1 |
|
"UPDATE `glpi_displaypreferences` SET `num` = 90 WHERE `itemtype` = 'Entity' AND `num` = 28" | 1 |
|
"UPDATE `glpi_displaypreferences` SET `num` = 200 WHERE `num` = 90" | 1 |
|
"UPDATE `glpi_tickettemplatepredefinedfields` SET `value` = '$new' WHERE `value` = '$old' AND `num` = 12" | 1 |
|
"UPDATE `glpi_displaypreferences` SET `num` = 160 WHERE `itemtype` = 'Software' AND `num` = 7" | 1 |
|
"UPDATE `glpi_bookmarks` SET query = '" . addslashes($query) . "' WHERE `id` = '" . $data['id'] . "'" | 1 |
|
"UPDATE `glpi_bookmarks` SET `itemtype` = 'AllAssets', `path` = 'front/allassets.php' WHERE `itemtype` = 'States'" | 1 |
|
"UPDATE `glpi_displaypreferences` SET `itemtype` = 'AllAssets' WHERE `itemtype` = 'States'" | 1 |
|
"UPDATE `glpi_configs` SET `language` = '$new' WHERE `language` = '$old';" | 1 |
|
"UPDATE `glpi_users` SET `language` = '$new' WHERE `language` = '$old';" | 1 |
|
"UPDATE `$table` SET `status` = '$new' WHERE `status` = '$old'" | 1 |
|
"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 |
|
"UPDATE `glpi_notificationtemplatetranslations` SET `subject` = '" . addslashes($subject) . "', `content_text` = '" . addslashes($text) . "', `content_html` = '" . addslashes($html) . "' WHERE `id` = " . $data['id'] . "" | 1 |
|
"UPDATE `glpi_ruleactions` SET `value` = '$new' WHERE `field` = '$field' AND `value` = '$old' AND `rules_id` IN ($rules)" | 1 |
|
"UPDATE `glpi_profiles` SET `$field` = '" . addslashes(exportArrayToDB($newtab)) . "' WHERE `id` = '" . $data['id'] . "'" | 1 |
|
"INSERT INTO `glpi_entities` (`id`, `name`, `completename`, `entities_id`, `level`) VALUES (0,'" . addslashes(__('Root entity')) . "', '" . addslashes(__('Root entity')) . "', '-1', '1');" | 1 |
|
"UPDATE `glpi_entities` SET " . implode(',', $update_fields) . " WHERE `id` = '" . $data['entities_id'] . "'" | 1 |
|
"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 |
|
"SELECT * FROM `glpi_notifications` WHERE `itemtype` = 'Ticket' AND `event` = 'validation'" | 1 |
|
"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 |
|
"SELECT * FROM `glpi_notifications` WHERE `itemtype` = 'Contract' AND `event` = '$from'" | 1 |
|
"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 |
|
"SELECT * FROM `glpi_notificationtargets` WHERE `notifications_id` = '" . $notif['id'] . "'" | 1 |
|
"INSERT INTO `glpi_notificationtargets` (`notifications_id`, `type`, `items_id`) VALUES ('" . $newID . "', '" . $target['type'] . "', '" . $target['items_id'] . "')" | 1 |
|
"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 |
|
"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 |
|
"UPDATE `glpi_profiles` SET `ticketcost` = 'r' WHERE `ticketcost` IS NULL" | 1 |
|
"SELECT * FROM `glpi_notificationtemplates` WHERE `itemtype` = 'PlanningRecall'" | 1 |
|
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Planning recall', 'PlanningRecall', NOW())" | 1 |
|
"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##', '<p>##recall.action##: <a href=\"##recall.item.url##\">##recall.item.name##</a></p> <p>##recall.item.content##</p> <p>##lang.recall.planning.begin##: ##recall.planning.begin##<br />##lang.recall.planning.end##: ##recall.planning.end##<br />##lang.recall.planning.state##: ##recall.planning.state##<br />##lang.recall.item.private##: ##recall.item.private##<br /><br /></p> <p><br /><br /></p>')" | 1 |
|
"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 |
|
"INSERT INTO `glpi_notificationtargets` (`id`, `notifications_id`, `type`, `items_id`) VALUES (NULL, $notifid, " . Notification::USER_TYPE . ", " . Notification::AUTHOR . ");" | 1 |
|
"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 |
|
'UPDATE `glpi_entities` SET `default_consumables_alarm_threshold` = -10 WHERE `default_consumables_alarm_threshold` = -1' | 1 |
|
'UPDATE `glpi_entities` SET `default_cartridges_alarm_threshold` = -10 WHERE `default_cartridges_alarm_threshold` = -1' | 1 |
|
"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 |
|
"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 |
|
"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 |
|
"INSERT INTO `glpi_blacklists` (`type`,`name`,`value`) VALUES ('$type','" . addslashes($name) . "','" . addslashes($value) . "')" | 1 |
|
"SELECT `id` FROM `glpi_rulerightparameters` WHERE `name` = '(LDAP) MemberOf'" | 1 |
|
"INSERT INTO `glpi_rulerightparameters` VALUES (NULL, '(LDAP) MemberOf', 'memberof', '')" | 1 |
|
"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 |
|
"SELECT `existing_auth_server_field` FROM `glpi_configs`" | 1 |
|
"SELECT `id` FROM `glpi_ssovariables` WHERE `name` = '$existing_auth_server_field'" | 1 |
|
"UPDATE `glpi_configs` SET `ssovariables_id` = '" . $DB->result($result, 0, "id") . "'" | 1 |
|
"UPDATE `glpi_rules` SET `sub_type` = 'RuleImportEntity' WHERE `sub_type` = 'RuleOcs'" | 1 |
|
"SELECT GROUP_CONCAT(`id`) FROM `glpi_rules` WHERE `sub_type` = 'RuleImportEntity' GROUP BY `sub_type`" | 1 |
|
"UPDATE `glpi_logs` SET `linked_action` = `linked_action`+1000, `itemtype_link` = 'PluginOcsinventoryngOcslink' WHERE `linked_action` IN (8,9,10,11)" | 1 |
|
"SELECT MIN(id) AS id FROM `glpi_notificationtemplates` WHERE `itemtype` = 'Ticket'" | 1 |
|
"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 |
|
"INSERT INTO `glpi_problems_suppliers` (`suppliers_id`, `type`, `problems_id`) VALUES ('" . $data['suppliers_id_assign'] . "', '" . CommonITILActor::ASSIGN . "', '" . $data['id'] . "')" | 1 |
|
"INSERT INTO `glpi_suppliers_tickets` (`suppliers_id`, `type`, `tickets_id`) VALUES ('" . $data['suppliers_id_assign'] . "', '" . CommonITILActor::ASSIGN . "', '" . $data['id'] . "')" | 1 |
|
"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 |
|
"UPDATE `glpi_ruleactions` SET `value` = '" . $data['newvalue'] . "' WHERE `id` = " . $data['id'] | 1 |
|
"UPDATE `glpi_ticketrecurrents` SET `periodicity` = '$periodicity' WHERE `id` = '" . $data['id'] . "'" | 1 |
|
"UPDATE `glpi_notifications` SET `itemtype` = 'CartridgeItem' WHERE `itemtype` = 'Cartridge'" | 1 |
|
"UPDATE `glpi_notificationtemplates` SET `itemtype` = 'CartridgeItem' WHERE `itemtype` = 'Cartridge'" | 1 |
|
"UPDATE `glpi_notifications` SET `itemtype` = 'ConsumableItem' WHERE `itemtype` = 'Consumable'" | 1 |
|
"UPDATE `glpi_notificationtemplates` SET `itemtype` = 'ConsumableItem' WHERE `itemtype` = 'Consumable'" | 1 |
|
"UPDATE `glpi_displaypreferences` SET `num` = '5' WHERE `itemtype` = 'Budget' AND `num` = '2'" | 1 |
|
"SELECT `id` FROM `glpi_fqdns` WHERE `fqdn` = '$domain'" | 1 |
|
"SELECT `origin_glpi_networkports`.`name`, `origin_glpi_networkports`.`id`, `origin_glpi_networkports`.`mac`, " | 1 |
|
"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 |
|
"INSERT INTO `glpi_networkportmigrations` (SELECT *" . str_repeat(', 0', count(NetworkPortMigration::getMotives( ))) . " FROM `origin_glpi_networkports` WHERE `id` = '$networkports_id')" | 1 |
|
"UPDATE `glpi_networkportmigrations` SET `$motive` = '1' WHERE `id`='$networkports_id'" | 1 |
|
"SELECT DISTINCT LOWER(`name`) AS name, `comment` FROM `glpi_domains`" | 1 |
|
"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 |
|
"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 |
|
"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 |
|
"SELECT `ip`, `id`, `entities_id`, `itemtype`, `items_id` FROM `origin_glpi_networkports` WHERE `ip` <> ''" | 1 |
|
"SELECT * FROM `glpi_networkinterfaces`" | 1 |
|
"UPDATE `glpi_networkports` SET `instantiation_type` = '$instantiation_type' WHERE `id` IN (SELECT `id` FROM `origin_glpi_networkports` WHERE `networkinterfaces_id` = '" . $entry['id'] . "')" | 1 |
|
"UPDATE `glpi_networkports` SET `mac` = LOWER(`mac`)" | 1 |
|
'Update migration of interfaces errors' | 1 |
|
"SELECT id FROM `glpi_networkports` WHERE `instantiation_type` = ''" | 1 |
|
"SELECT * FROM `origin_glpi_networkequipments` WHERE `mac` != '' OR `ip` != ''" | 1 |
|
"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 |
|
"UPDATE `glpi_networkports` SET `mac` = '' WHERE `id` = '$aggregated_networkports_id'" | 1 |
|
'Update connections between IPAddress and IPNetwork' | 1 |
|
"SELECT `id`, `address_3`, `netmask_3` FROM `glpi_ipnetworks`" | 1 |
|
"SELECT `id` FROM `glpi_ipaddresses` WHERE (`glpi_ipaddresses`.`binary_3` & '$netmask') = $address AND `glpi_ipaddresses`.`version` = '4' GROUP BY `items_id`" | 1 |
|
"INSERT INTO `glpi_ipaddresses_ipnetworks` (`ipaddresses_id`, `ipnetworks_id`) VALUES ('" . $link['id'] . "', '$ipnetworks_id')" | 1 |
|
"UPDATE `glpi_logs` SET `itemtype_link` = 'Item_" . $deviceType . "#" . $new_specif . "' WHERE `itemtype_link` = '$deviceType'" | 1 |
|
"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 |
|
"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 |
|
"UPDATE `glpi_notificationtemplatetranslations` SET `subject` = '" . addslashes($subject) . "', `content_text` = '" . addslashes($text) . "', `content_html` = '" . addslashes($html) . "' WHERE `id` = " . $data['id'] . "" | 1 |
|
"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 |
|
"SELECT `glpi_notificationtemplatetranslations`.* FROM `glpi_notificationtemplatetranslations` INNER JOIN `glpi_notificationtemplates` ON (`glpi_notificationtemplates`.`id` = `glpi_notificationtemplatetranslations`.`notificationtemplates_id`) WHERE `glpi_notificationtemplates`.`itemtype` = 'Ticket'" | 1 |
|
"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 |
|
"SELECT * FROM `glpi_notificationtemplates` WHERE `name` = 'Problems'" | 1 |
|
"INSERT INTO `glpi_notificationtemplates` (`name`, `itemtype`, `date_mod`) VALUES ('Problems', 'Problem', NOW())" | 1 |
|
"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##  :##problem.title## ##lang.problem.authors##  :##IFproblem.authors## ##problem.authors## ##ENDIFproblem.authors## ##ELSEproblem.authors##--##ENDELSEproblem.authors## ##lang.problem.creationdate##  :##problem.creationdate## ##IFproblem.assigntousers## ##lang.problem.assigntousers##  : ##problem.assigntousers## ##ENDIFproblem.assigntousers## ##lang.problem.status##  : ##problem.status## ##IFproblem.assigntogroups## ##lang.problem.assigntogroups##  : ##problem.assigntogroups## ##ENDIFproblem.assigntogroups## ##lang.problem.urgency##  : ##problem.urgency## ##lang.problem.impact##  : ##problem.impact## ##lang.problem.priority## : ##problem.priority## ##IFproblem.category## ##lang.problem.category##  :##problem.category## ##ENDIFproblem.category## ##ELSEproblem.category## ##lang.problem.nocategoryassigned## ##ENDELSEproblem.category## ##lang.problem.content##  : ##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## : ##problem.numberoftickets## ##FOREACHtickets## [##ticket.date##] ##lang.problem.title## : ##ticket.title## ##lang.problem.content## ##ticket.content## ##ENDFOREACHtickets## ##lang.problem.numberoftasks## : ##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## ', '<p>##IFproblem.storestatus=solved##</p> <div>##lang.problem.url## : <a href=\"##problem.urlapprove##\">##problem.urlapprove##</a></div> <div><span style=\"color: #888888;\"><strong><span style=\"text-decoration: underline;\">##lang.problem.solvedate##</span></strong></span> : ##problem.solvedate##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.problem.solution.type##</strong></span> : ##problem.solution.type##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.problem.solution.description##</strong></span> : ##problem.solution.description## ##ENDIFproblem.storestatus##</div> <div>##ELSEproblem.storestatus## ##lang.problem.url## : <a href=\"##problem.url##\">##problem.url##</a> ##ENDELSEproblem.storestatus##</div> <p class=\"description b\"><strong>##lang.problem.description##</strong></p> <p><span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.title##</span> :##problem.title## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.authors##</span> :##IFproblem.authors## ##problem.authors## ##ENDIFproblem.authors## ##ELSEproblem.authors##--##ENDELSEproblem.authors## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.creationdate##</span> :##problem.creationdate## <br /> ##IFproblem.assigntousers## <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.assigntousers##</span> : ##problem.assigntousers## ##ENDIFproblem.assigntousers##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.problem.status## </span> : ##problem.status##<br /> ##IFproblem.assigntogroups## <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.assigntogroups##</span> : ##problem.assigntogroups## ##ENDIFproblem.assigntogroups##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.urgency##</span> : ##problem.urgency##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.impact##</span> : ##problem.impact##<br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.priority##</span> : ##problem.priority## <br />##IFproblem.category##<span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\">##lang.problem.category## </span> :##problem.category## ##ENDIFproblem.category## ##ELSEproblem.category## ##lang.problem.nocategoryassigned## ##ENDELSEproblem.category## <br /> <span style=\"color: #8b8c8f; font-weight: bold; text-decoration: underline;\"> ##lang.problem.content##</span> : ##problem.content##</p> <p>##IFproblem.storestatus=closed##<br /><span style=\"text-decoration: underline;\"><strong><span style=\"color: #888888;\">##lang.problem.solvedate##</span></strong></span> : ##problem.solvedate##<br /><span style=\"color: #888888;\"><strong><span style=\"text-decoration: underline;\">##lang.problem.solution.type##</span></strong></span> : ##problem.solution.type##<br /><span style=\"text-decoration: underline; color: #888888;\"><strong>##lang.problem.solution.description##</strong></span> : ##problem.solution.description##<br />##ENDIFproblem.storestatus##</p> <div class=\"description b\">##lang.problem.numberoftickets## : ##problem.numberoftickets##</div> <p>##FOREACHtickets##</p> <div><strong> [##ticket.date##] <em>##lang.problem.title## : <a href=\"##ticket.url##\">##ticket.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.problem.content## </span> ##ticket.content## <p>##ENDFOREACHtickets##</p> <div class=\"description b\">##lang.problem.numberoftasks## : ##problem.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 |
|
"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 |
|
"UPDATE `$table` SET `itemtype` = '$val' WHERE `itemtype` = '$key'" | 1 |
|
"SELECT * FROM `glpi_documenttypes` WHERE `ext` = '$ext'" | 1 |
|
"INSERT INTO `glpi_documenttypes` (`name`, `ext`, `icon`, `is_uploadable`, `date_mod`) VALUES ('" . $data['name'] . "', '$ext', '" . $data['icon'] . "', '1', NOW())" | 1 |
|
"SELECT `id` FROM `glpi_documenttypes` WHERE `ext` = '$ext'" | 1 |
|
"UPDATE `glpi_documenttypes` SET `icon` = '$icon', `date_mod` = NOW() WHERE `id` = '" . $DB->result($result, 0, 0) . "'" | 1 |
|
"SELECT * FROM `glpi_users` WHERE `email` <> '' AND `email` IS NOT NULL" | 1 |
|
"INSERT INTO `glpi_useremails` (`users_id`, `is_default`, `is_dynamic`, `email`) VALUES ('" . $data['id'] . "','1','$is_dynamic','" . addslashes($data['email']) . "')" | 1 |
|
"UPDATE `glpi_fieldunicities` SET `is_active` = '0' WHERE `id` = '" . $data['id'] . "'" | 1 |
|
"SELECT * FROM `glpi_groups` WHERE `users_id` > 0" | 1 |
|
"SELECT `id` FROM `glpi_groups_users` WHERE `groups_id` = '" . $data['id'] . "' AND `users_id` = '" . $data['users_id'] . "'" | 1 |
|
"INSERT INTO`glpi_groups_users` (`users_id`, `groups_id`, `is_manager`) VALUES ('" . $data['users_id'] . "' ,'" . $data['id'] . "', '1')" | 1 |
|
"UPDATE `glpi_groups_users` SET `is_manager` = '1' WHERE `groups_id` = '" . $data['id'] . "' AND `users_id` = '" . $data['users_id'] . "'" | 1 |
|
"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 |
|
"INSERT INTO `glpi_tickettemplates` (`name`, `is_recursive`) VALUES ('Default', 1)" | 1 |
|
"INSERT INTO `glpi_tickettemplatemandatoryfields` (`tickettemplates_id`, `num`) VALUES ('$default_ticket_template', 1)" | 1 |
|
"INSERT INTO `glpi_tickettemplatemandatoryfields` (`tickettemplates_id`, `num`) VALUES ('$default_ticket_template', 21)" | 1 |
|
"INSERT INTO `glpi_tickettemplatemandatoryfields` (`tickettemplates_id`, `num`) VALUES ('$default_ticket_template', 7)" | 1 |
|
"UPDATE `glpi_itilcategories` SET `tickettemplates_id_incident` = '$default_ticket_template', `tickettemplates_id_demand` = '$default_ticket_template'" | 1 |
|
"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 |
|
"INSERT INTO `glpi_profiles` (`" . implode("`, `", array_keys($data)) . "`) VALUES ('" . implode("', '", $data) . "')" | 1 |
|
"SELECT `id` FROM `glpi_reminders` WHERE `is_helpdesk_visible` = 1" | 1 |
|
"INSERT INTO `glpi_profiles_reminders` (`reminders_id`, `profiles_id`) VALUES ('" . $data['id'] . "', '$pid');" | 1 |
|
"SELECT * FROM `glpi_reminders` WHERE `is_private` = 0" | 1 |
|
"INSERT INTO `glpi_entities_reminders` (`reminders_id`, `entities_id`, `is_recursive`) VALUES ('" . $data['id'] . "', '" . $data['entities_id'] . "', '" . $data['is_recursive'] . "');" | 1 |
|
"SELECT * FROM `glpi_knowbaseitems`" | 1 |
|
"INSERT INTO `glpi_entities_knowbaseitems` (`knowbaseitems_id`, `entities_id`, `is_recursive`) VALUES ('" . $data['id'] . "', '" . $data['entities_id'] . "', '" . $data['is_recursive'] . "');" | 1 |
|
"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 |
|
"UPDATE `glpi_entitydatas` SET `tickettemplates_id` = '$default_ticket_template' WHERE `entities_id` = 0 AND `tickettemplates_id` = -2" | 1 |
|
"UPDATE `glpi_entitydatas` SET `entities_id_software` = -10 WHERE `entities_id` = 0 AND `entities_id_software` = -2" | 1 |
|
"UPDATE `glpi_entitydatas` SET `tickettype` = 1 WHERE `entities_id` = 0 AND `tickettype` = 0" | 1 |
|
"UPDATE `glpi_entitydatas` SET `inquest_config` = 1 WHERE `entities_id` = 0 AND `inquest_config` = 0" | 1 |
|
"UPDATE `glpi_entitydatas` SET `inquest_rate` = 0 WHERE `entities_id` = 0 AND `inquest_rate` = '-1'" | 1 |
|
"UPDATE `glpi_entitydatas` SET `inquest_delay` = 0 WHERE `entities_id` = 0 AND `inquest_delay` = '-1'" | 1 |
|
"UPDATE `glpi_entitydatas` SET `$field_0` = '-2' WHERE `$field_0` = '0' AND `entities_id` > 0" | 1 |
|
"UPDATE `glpi_entitydatas` SET `$field_parent` = '-2' WHERE `$field_parent` = '-1'" | 1 |
|
"UPDATE `glpi_entitydatas` SET `$field_config` = '" . $data[$field_config] . "' WHERE `$field_config` = -1" | 1 |
|
"UPDATE `glpi_entitydatas` SET `auto_assign_mode` = -10 WHERE `auto_assign_mode` = 0" | 1 |
|
"UPDATE `glpi_entitydatas` SET `calendars_id` = 0 WHERE `entities_id` = 0;" | 1 |
|
"UPDATE `$table` SET `$field` = '" . $val . "' WHERE `$field` = '" . $key . "'" | 1 |
|
"UPDATE `glpi_displaypreferences` SET `num` = '86' WHERE `itemtype` = 'Group' AND `num` = '6'" | 1 |
|
"SELECT `itemtype`, `items_id`, `id` FROM `glpi_tickets` WHERE `itemtype` IS NOT NULL AND `itemtype` <> '' AND `items_id` != 0" | 1 |
|
"INSERT INTO `glpi_items_tickets` (`id`, `items_id`, `itemtype`, `tickets_id`) VALUES (NULL, '" . $data['items_id'] . "', '" . $data['itemtype'] . "', '" . $data['id'] . "')" | 1 |
|
"UPDATE `glpi_changes` SET `status` = 1 WHERE `status` = 2" | 1 |
|
'UPDATE `glpi_entities` SET `is_notif_enable_default` = 1 WHERE `id` = 0' | 1 |
|
"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 |
|
"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 |
|
"update super-admin profile with UNLOCK right" | 1 |
|
"INSERT IGNORE INTO $quote_tmp_table $select" | 1 |
|
'Update of a reservation' | 1 |
|
'Insert an item here' | 1 |
|
'Select an itemtype: ' | 1 |
|
'Update of a change' | 1 |
|
'Update of a ticket' | 1 |
|
'SELECT @@sql_mode as %s' | 1 |
|
'SELECT * FROM ' . $DB->quoteName(self::getTable( )) | 1 |
|
'Update of a problem' | 1 |
|
'Update (actor)' | 1 |
|
'delete all' | 1 |
|
'delete one' | 1 |
|
'Update of ' . $attributs['short name'] . ' denied' | 1 |
|
'Select the type of the item that must be unlock' | 1 |
|
"Show impact" | 1 |
|
"Show depends" | 1 |
|
"Delete element" | 1 |
|
"SELECT MAX(`id`) AS maxid FROM `glpi_logs`" | 1 |
|
"SELECT UNIX_TIMESTAMP(MAX(`date_mod`)) AS max_date FROM `glpi_logs`" | 1 |
|
"SELECT `tickets_id` FROM `glpi_tickets_users` WHERE `users_id` = '$user' AND type IN ($requester, $obs)" | 1 |
|
"SELECT `id` FROM `glpi_tickets` WHERE `users_id_recipient` = '$user'" | 1 |
|
"SELECT `tickets_id` FROM `glpi_groups_tickets` WHERE `groups_id` IN ($groups) AND type IN ($requester, $obs)" | 1 |
|
"SELECT `tickets_id` FROM `glpi_tickets_users` WHERE `users_id` = '$user' AND type = $assign" | 1 |
|
"SELECT `tickets_id` FROM `glpi_groups_tickets` WHERE `groups_id` IN ($groups) AND type = $assign" | 1 |
|
"SELECT `id` FROM `glpi_tickets` WHERE `status` = '" . CommonITILObject::INCOMING . "'" | 1 |
|
"SELECT `tickets_id` FROM `glpi_ticketvalidations` WHERE `users_id_validate` = '$user'" | 1 |
|
"update entities_id and is_recursive=0 in glpi_infocoms for $name" | 1 |
|
"update entities_id and is_recursive=1 in glpi_infocoms for $name" | 1 |
|
"update entities_id in glpi_infocoms for $name" | 1 |
|
'Update authentification method to' | 1 |
|
'Update auth and sync' | 1 |
|
'Update method for user authentication and synchronization' | 1 |
|
'SELECT * FROM ' . $DB->quoteName(self::getTable( )) . ' ' | 1 |
|
'Delete permanently but keep devices' | 1 |
|
'Delete permanently and remove devices' | 1 |
|
'Delete permanently the relation with selected elements' | 1 |
|
'Delete permanently even if linked items' | 1 |
|
'Select the common field that you want to update' | 1 |
|
'Select the field that you want to update' | 1 |
|
'Update of a project' | 1 |
|
"SELECT DISTINCT `$itemtable`.`id` AS id, '" . Toolbox::addslashes_deep($_SESSION['glpiname']) . "' AS currentuser, " . self::addDefaultSelect($data['itemtype']) | 1 |
|
"SELECT $count, '" . Toolbox::addslashes_deep($_SESSION['glpiname']) . "' AS currentuser FROM `$itemtable`" . $COMMONLEFTJOIN | 1 |
|
'Delete a global rule' | 1 |
|
'Show personnal information in new ticket form (simplified interface)' | 1 |
|
'Show GLPI ID' | 1 |
|
'Show new tickets on the home page' | 1 |
|
"Delete relation between items" | 1 |
|
"Delete the item" | 1 |
|
"Update component" | 1 |
|
"Delete component" | 1 |
|
"Delete all" | 1 |
|
"Delete if older than %s month" | 1 |
|
"Delete if older than %s months" | 1 |
|
'Show list of available tags' | 1 |
|
'Update my password' | 1 |
|
'Update the approval request to %s' | 1 |
|
'Insert a rack here' | 1 |
|
'Update followups (author)' | 1 |
|
"SELECT `$target` FROM `$user_table` WHERE `users_id` = '$user'" | 1 |
|
"SELECT `$target` FROM `$group_table` WHERE `groups_id` IN ($groups)" | 1 |
|
"SELECT `id` FROM `$table` WHERE `users_id_recipient` = '$user'" | 1 |
|
'Update of a project task' | 1 |
|
'Select a peer for %s:' | 1 |
|
'Delete all repetition' | 1 |
|
'Update Source' | 1 |
|
'Update Sources' | 1 |
|
"SHOW COLUMNS FROM `$table`" | 1 |
|
"SELECT @@sql_mode as mode, @@version AS vers, @@version_comment AS stype" | 1 |
|
"SELECT GET_LOCK('$name', 0)" | 1 |
|
"SELECT RELEASE_LOCK('$name')" | 1 |
|
"INSERT INTO " . self::quoteName($table) . " (" | 1 |
|
"UPDATE " . self::quoteName($table) | 1 |
|
'Update would change too many rows!' | 1 |
|
"DELETE " . self::quoteName($table) . " FROM " . self::quoteName($table) | 1 |
|
'SHOW WARNINGS' | 1 |
|
'Update only mac address (mac on switch port)' | 1 |
|
'Update notes' | 1 |
|
"Update the item's notes" | 1 |
|
'Update of the field' | 1 |
|
'Update a field' | 1 |
|
'Delete the item' | 1 |
|
'Delete a component' | 1 |
|
'Update a link with an item' | 1 |
|
'Delete a link with an item' | 1 |
|
'Update an item' | 1 |
|
'Delete an item' | 1 |
|
'Update all bookmarks execution time' | 1 |
|
'Update of a task' | 1 |
|
'Update of a followup' | 1 |
|
"Delete serie" | 1 |
|
"Delete instance" | 1 |
|
'Update parameters' | 1 |
|
'Update helpdesk parameters' | 1 |
|
"SHOW INDEX FROM `$table`" | 1 |
|
'SELECT ' | 1 |
|
"UPDATE `$table` SET `$field` = " . $params['update'] . " " . $params['condition'] . "" | 1 |
|
"INSERT INTO `$newtable` (SELECT * FROM `$oldtable`)" | 1 |
|
"SELECT MAX(`ranking`) AS `rank` FROM `glpi_rules` WHERE `sub_type` = '" . $rule['sub_type'] . "'" | 1 |
|
"SELECT MAX(`rank`) FROM `glpi_displaypreferences` WHERE `users_id` = '" . $data['users_id'] . "' AND `itemtype` = '$type'" | 1 |
|
"SELECT * FROM `glpi_displaypreferences` WHERE `users_id` = '" . $data['users_id'] . "' AND `num` = '$newval' AND `itemtype` = '$type'" | 1 |
|
'Update printer counter' | 1 |
|
'Select the report you want to generate' | 1 |
|
'Select statistics to be displayed' | 1 |
|
'Delete emails' | 1 |
|
'Update date' | 1 |
|
"Delete this dashboard" | 1 |
|
"Delete this card" | 1 |
|
'SHOW COLUMNS FROM ' . $this->db->quoteName($table_name) | 1 |
|
'SHOW INDEX FROM ' . $this->db->quoteName($table_name) | 1 |
|
'SHOW CREATE TABLE ' . $this->db->quoteName($table_name) | 1 |
|
'SHOW DATABASES LIKE ' . $this->db->quoteValue('mysql') | 1 |
|
'SHOW TABLES FROM ' . $this->db->quoteName('mysql') . ' LIKE ' . $this->db->quoteValue('time_zone_name') | 1 |
|
'SELECT @@GLOBAL.' . $this->db->quoteName('innodb_page_size as innodb_page_size') | 1 |
|
"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 |
|
"SELECT COUNT(*) FROM {$DB->quoteName($table)} $join WHERE $where" | 1 |
|
"SELECT COUNT(table_name) FROM information_schema.tables WHERE table_schema = '{$db_name}' AND table_type = 'BASE TABLE' AND table_name LIKE 'glpi\_%'" | 1 |
|
'Update database schema to new version' | 1 |
|
'Update existing users with server "%s"...' | 1 |
|
"UPDATE %s SET helpdesk_item_type = REPLACE(helpdesk_item_type, '%s', '%s')" | 1 |
|
" 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 |
|
'Update of `%s`.`%s` failed with message "(%s) %s".' | 1 |
|
'Update of `%s` failed with message "(%s) %s".' | 1 |
|
'Update Problem' | 2 |
|
'Delete Problem' | 2 |
|
'Delete Ticket' | 2 |
|
'Update Change' | 2 |
|
'Delete Change' | 2 |
|
'Update Project' | 2 |
|
'Delete Project' | 2 |
|
'Update Project Task' | 2 |
|
'Delete Project Task' | 2 |
|
'Update default right assignement rule' | 2 |
|
"SELECT * FROM `glpi_notificationtargets` WHERE `notifications_id` = '" . $notif['id'] . "'" | 2 |
|
"INSERT INTO `glpi_notificationtargets` (`notifications_id`, `type`, `items_id`) VALUES ($newID, '" . $target['type'] . "', '" . $target['items_id'] . "')" | 2 |
|
"SELECT * FROM `glpi_bookmarks`" | 2 |
|
"UPDATE `glpi_ruleactions` SET `field` = '$new' WHERE `field` = '$old' AND `rules_id` IN ($rules)" | 2 |
|
"UPDATE `glpi_rulecriterias` SET `criteria` = '$new' WHERE `criteria` = '$old' AND `rules_id` IN ($rules)" | 2 |
|
"SELECT * FROM `glpi_configs`" | 2 |
|
'SELECT MAX(%s) as %s FROM %s GROUP BY %s, DATE(%s)' | 2 |
|
'Show graphics' | 2 |
|
'Select the desired entity' | 2 |
|
'Update all' | 2 |
|
'Show all' | 2 |
|
"update itemtype of table $table for $name" | 2 |
|
'Show %1$s' | 2 |
|
'Select the type of the item on which applying this action' | 2 |
|
'Delete a rule' | 2 |
|
'Update the item' | 2 |
|
'Show on global GANTT' | 2 |
|
'SELECT version()' | 2 |
|
'SELECT * FROM ' . $DB->quoteName(self::getTable( )) . '' | 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 |
|
"UPDATE `glpi_bookmarks` SET `query` = '" . addslashes(Toolbox::append_params($options)) . "' WHERE `id` = '" . $data['id'] . "'" | 3 |
|
"SELECT GROUP_CONCAT(`id`) FROM `glpi_rules` WHERE `sub_type` = '" . $ruletype . "' GROUP BY `sub_type`" | 3 |
|
'update item previous' | 3 |
|
'update item next' | 3 |
|
'Select default items to show' | 3 |
|
'Update Task' | 5 |
|
'Delete Task' | 5 |
|
"INSERT INTO `glpi_notificationtargets` (`id`, `notifications_id`, `type`, `items_id`) VALUES (NULL, $notifid, " . Notification::USER_TYPE . ", $target);" | 5 |
|
'Update password' | 5 |
|
"SELECT DISTINCT `users_id` FROM `glpi_displaypreferences` WHERE `itemtype` = '$type'" | 9 |
|
"SELECT MAX(`rank`) FROM `glpi_displaypreferences` WHERE `users_id` = '" . $data['users_id'] . "' AND `itemtype` = '$type'" | 9 |
|
"SELECT * FROM `glpi_displaypreferences` WHERE `users_id` = '" . $data['users_id'] . "' AND `num` = '$newval' AND `itemtype` = '$type'" | 9 |
|
"INSERT INTO `glpi_displaypreferences` (`itemtype` ,`num` ,`rank` ,`users_id`) VALUES ('$type', '$newval', '" . $rank++ . "', '" . $data['users_id'] . "')" | 9 |
|
"INSERT INTO `glpi_displaypreferences` (`itemtype` ,`num` ,`rank` ,`users_id`) VALUES ('$type', '$newval', '" . $rank++ . "', '0')" | 9 |
|
'Delete permanently' | 32 |
|
'Update to %s' | 41 |
|