comparison: www/crontasks.php
www/crontasks.php
- branch
- stable
- changeset 426
- beb1a83af4e7
- parent 422
- 7943afc0fcde
- child 460
- 046ff5fdc96c
equal
deleted
inserted
replaced
| 418:5e9cbf2bb46f | 426:beb1a83af4e7 |
|---|---|
| 11 } | 11 } |
| 12 mysqli_set_charset($connect, "utf8" ); | 12 mysqli_set_charset($connect, "utf8" ); |
| 13 syslog(LOG_NOTICE, "crontasks.php started"); | 13 syslog(LOG_NOTICE, "crontasks.php started"); |
| 14 | 14 |
| 15 | 15 |
| 16 | |
| 17 /* | |
| 18 * Upgrade package values. | |
| 19 */ | |
| 20 $query = "UPDATE products SET package_volume = bottle_amount + keg_amount WHERE package_volume='0';"; | |
| 21 $result = mysqli_query($connect, $query); | |
| 22 $changed = mysqli_affected_rows($connect); | |
| 23 if ($changed > 0) { | |
| 24 syslog(LOG_NOTICE, "Updated ".$changed." products to new package_volume value"); | |
| 25 } | |
| 26 $query = "UPDATE products SET bottle_priming_water = bottle_amount * bottle_priming_amount / 500 WHERE bottle_priming_water = 0;"; | |
| 27 $result = mysqli_query($connect, $query); | |
| 28 $changed = mysqli_affected_rows($connect); | |
| 29 if ($changed > 0) { | |
| 30 syslog(LOG_NOTICE, "Updated ".$changed." products to new package_volume value"); | |
| 31 } | |
| 32 $query = "UPDATE products SET keg_priming_water = keg_amount * keg_priming_amount / 500 WHERE keg_priming_water = 0;"; | |
| 33 $result = mysqli_query($connect, $query); | |
| 34 $changed = mysqli_affected_rows($connect); | |
| 35 if ($changed > 0) { | |
| 36 syslog(LOG_NOTICE, "Updated ".$changed." products to new package_volume value"); | |
| 37 } | |
| 16 | 38 |
| 17 /* | 39 /* |
| 18 * Upgrade inventory_reduced value from old boolean to tiny integer value. | 40 * Upgrade inventory_reduced value from old boolean to tiny integer value. |
| 19 */ | 41 */ |
| 20 $query = "UPDATE products SET inventory_reduced=stage WHERE inventory_reduced = 1"; | 42 $query = "UPDATE products SET inventory_reduced=stage WHERE inventory_reduced = 1"; |
