diff -r 0bc45502144b -r 7943afc0fcde www/crontasks.php --- 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.