Mercurial > bms / file diff

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