Révision 5804e08b scripts/net2dip.sendtohurlevent.php
| scripts/net2dip.sendtohurlevent.php | ||
|---|---|---|
| 95 | 95 |
$query2 = "SELECT MD5(e.password),os_license_number,os_license_id FROM glpi_computers AS c |
| 96 | 96 |
LEFT JOIN glpi_plugin_anet_epacks AS e ON e.FK_serveur=c.ID |
| 97 | 97 |
WHERE os_license_number!='' AND e.creation_date>'2009-07-06'"; |
| 98 |
//On supprime les epacks qu'on a marque comme n etant plus sous maintenance |
|
| 99 |
$query2 .= " AND e.FK_contract>'0'"; |
|
| 100 |
|
|
| 98 | 101 |
if ( DB::isError($result2 = $dbglpi->query($query2)) ) {
|
| 99 | 102 |
die ("***\n$query2\n" . DB::errorMessage($result2) . "\n***\n\n");
|
| 100 | 103 |
} |
Formats disponibles : Unified diff