diff -r 53fafe474742 -r 046ff5fdc96c www/crontasks.php --- a/www/crontasks.php Sun Aug 25 14:04:25 2019 +0200 +++ b/www/crontasks.php Mon Aug 26 16:01:27 2019 +0200 @@ -91,3 +91,15 @@ } } + +/* + * Check and update secondary_end_sg + */ +$query = "UPDATE products SET secondary_end_sg=fg WHERE stage > 5 AND secondary_end_sg='0';"; +$result = mysqli_query($connect, $query); +$changed = mysqli_affected_rows($connect); +if ($changed > 0) { + syslog(LOG_NOTICE, "Updated ".$changed." products with new secondary_end_sg value"); +} + +