Mercurial > bms / file diff

--- a/www/crontasks.php	Thu Jun 20 16:52:31 2019 +0200
+++ b/www/crontasks.php	Thu Jun 20 19:58:23 2019 +0200
@@ -23,7 +23,18 @@
 if ($changed > 0) {
         syslog(LOG_NOTICE, "Updated ".$changed." products to new package_volume value");
 }
-
+$query = "UPDATE products SET bottle_priming_water = bottle_amount * bottle_priming_amount / 500 WHERE bottle_priming_water = 0;";
+$result = mysqli_query($connect, $query);
+$changed = mysqli_affected_rows($connect);
+if ($changed > 0) {
+        syslog(LOG_NOTICE, "Updated ".$changed." products to new package_volume value");
+}
+$query = "UPDATE products SET keg_priming_water = keg_amount * keg_priming_amount / 500 WHERE keg_priming_water = 0;";
+$result = mysqli_query($connect, $query);
+$changed = mysqli_affected_rows($connect);
+if ($changed > 0) {
+        syslog(LOG_NOTICE, "Updated ".$changed." products to new package_volume value");
+}
 
 /*
  * Upgrade inventory_reduced value from old boolean to tiny integer value.