diff -r 4415a30b5a36 -r fa82e95d9ddd www/crontasks.php --- a/www/crontasks.php Mon Jul 15 15:06:17 2019 +0200 +++ b/www/crontasks.php Sat Sep 14 10:30:26 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"); +} + +