/**
* 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));
}
}
