/** * Delete old licenses software entries * * @param $glpi_computers_id integer : glpi computer id. * * @return nothing. * */ static function resetOfficePack($glpi_computers_id) { global $DB; $query = "SELECT *\n FROM `glpi_computers_softwarelicenses`\n WHERE `computers_id` = '{$glpi_computers_id}' AND `is_dynamic`"; $result = $DB->query($query); if ($DB->numrows($result) > 0) { while ($data = $DB->fetch_assoc($result)) { $query2 = "SELECT COUNT(*)\n FROM `glpi_computers_softwarelicenses`\n WHERE `softwarelicenses_id` = '" . $data['softwarelicenses_id'] . "'"; $result2 = $DB->query($query2); if ($DB->result($result2, 0, 0) == 1) { $license = new SoftwareLicense(); $license->getFromDB($data['softwarelicenses_id']); $query3 = "SELECT COUNT(*)\n FROM `glpi_softwarelicenses`\n WHERE `softwares_id`='" . $license->fields['softwares_id'] . "'"; $result3 = $DB->query($query3); if ($DB->result($result3, 0, 0) == 1) { $soft = new Software(); $soft->delete(array('id' => $license->fields['softwares_id']), 1); } $license->delete(array("id" => $data['softwareversions_id'])); } } $computer_softwarelicenses = new Computer_SoftwareVersion(); $computer_softwarelicenses->deleteByCriteria(array('computers_id' => $glpi_computers_id)); } }