function transferHistory($itemtype, $ID, $newID) { global $DB; switch ($this->options['keep_history']) { // delete case 0: // Same item -> delete if ($ID == $newID) { $query = "DELETE\n FROM `glpi_logs`\n WHERE `itemtype` = '{$itemtype}'\n AND `items_id` = '{$ID}'"; $result = $DB->query($query); } // Copy -> nothing to do break; // Keep history // Keep history default: // Copy -> Copy datas if ($ID != $newID) { $query = "SELECT *\n FROM `glpi_logs`\n WHERE `itemtype` = '{$itemtype}'\n AND `items_id` = '{$ID}'"; $result = $DB->query($query); if ($result = $DB->query($query)) { if ($DB->numrows($result) != 0) { while ($data = $DB->fetch_assoc($result)) { $data = Toolbox::addslashes_deep($data); $query = "INSERT\n INTO `glpi_logs`\n (`items_id`, `itemtype`, `itemtype_link`, `linked_action`,\n `user_name`, `date_mod`, `id_search_option`, `old_value`,\n `new_value`)\n VALUES ('{$newID}', '{$itemtype}', '" . $data['itemtype_link'] . "',\n '" . $data['linked_action'] . "', '" . $data['user_name'] . "',\n '" . $data['date_mod'] . "', '" . $data['id_search_option'] . "',\n '" . $data['old_value'] . "', '" . $data['new_value'] . "')"; $DB->query($query); } } } } // Same item -> nothing to do break; } }