comparison: www/crontasks.php
www/crontasks.php
- changeset 422
- 7943afc0fcde
- parent 419
- 99a7f2a6976e
- child 460
- 046ff5fdc96c
equal
deleted
inserted
replaced
| 421:0bc45502144b | 422:7943afc0fcde |
|---|---|
| 21 $result = mysqli_query($connect, $query); | 21 $result = mysqli_query($connect, $query); |
| 22 $changed = mysqli_affected_rows($connect); | 22 $changed = mysqli_affected_rows($connect); |
| 23 if ($changed > 0) { | 23 if ($changed > 0) { |
| 24 syslog(LOG_NOTICE, "Updated ".$changed." products to new package_volume value"); | 24 syslog(LOG_NOTICE, "Updated ".$changed." products to new package_volume value"); |
| 25 } | 25 } |
| 26 | 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 } | |
| 27 | 38 |
| 28 /* | 39 /* |
| 29 * Upgrade inventory_reduced value from old boolean to tiny integer value. | 40 * Upgrade inventory_reduced value from old boolean to tiny integer value. |
| 30 */ | 41 */ |
| 31 $query = "UPDATE products SET inventory_reduced=stage WHERE inventory_reduced = 1"; | 42 $query = "UPDATE products SET inventory_reduced=stage WHERE inventory_reduced = 1"; |
