Mercurial > bms / file diff

--- 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");
+}
+
+