Révision fa2eb127 plugins/anet_epacks/front/plugin_anet_epacks.generate_odt_client2_8_to_9.form.php
| plugins/anet_epacks/front/plugin_anet_epacks.generate_odt_client2_8_to_9.form.php | ||
|---|---|---|
| 71 | 71 |
} |
| 72 | 72 |
|
| 73 | 73 |
//Un pack non attribué |
| 74 |
$query="SELECT * FROM glpi_plugin_anet_epacks WHERE FK_clientderyxeo='0' AND creation_date='0000-00-00' AND code LIKE 'ABE10%' LIMIT 1;";
|
|
| 74 |
$query="SELECT * FROM glpi_plugin_anet_epacks WHERE FK_clientderyxeo='0' AND creation_date='0000-00-00' AND code LIKE 'ABE11%' LIMIT 1;";
|
|
| 75 | 75 |
//$DB->query($query) or die($DB->error()); |
| 76 | 76 |
$result = $DB->query($query); |
| 77 | 77 |
$data=$DB->fetch_array($result); |
| ... | ... | |
| 81 | 81 |
print "<p>Génération automatique d'un nouveau epack, actualisez la page et tout devrait marcher ...</p>"; |
| 82 | 82 |
global $DB; |
| 83 | 83 |
$nb_packs = 1; |
| 84 |
$prefix = "ABE10-01-";
|
|
| 84 |
$prefix = "ABE11-01-";
|
|
| 85 | 85 |
for($i = 0; $i < $nb_packs; $i++) {
|
| 86 | 86 |
srand(); |
| 87 | 87 |
$code=$prefix . rand(1000,9999) . "-" . chr(rand(65,90)) . chr(rand(65,90)) . chr(rand(65,90)) . chr(rand(65,90)) . "-" . rand(1000,9999); |
| 88 | 88 |
$password=rand(1000,9999) . "-" . rand(1000,9999); |
| 89 |
$query="INSERT into glpi_plugin_anet_epacks(creation_date,expiration_date,code,password) values( '0000-00-00' ,'2010-12-31','$code','$password');";
|
|
| 89 |
$query="INSERT into glpi_plugin_anet_epacks(creation_date,expiration_date,code,password) values( '0000-00-00' ,'2011-12-31','$code','$password');";
|
|
| 90 | 90 |
// print $query; |
| 91 | 91 |
$DB->query($query);// or die($DB->error()); |
| 92 | 92 |
} |
Formats disponibles : Unified diff