Sat, 23 Feb 2019 21:07:14 +0100
The product and recipe editors disable the top menu so the user is forced to exit using the buttons on the first tab.
<?php require_once('config.php'); $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); $query = "UPDATE products SET stage=7 WHERE stage = 6 AND DATEDIFF(CURDATE(), package_date) > 0"; $result = $mysqli->query($query); $query = "UPDATE products SET stage=8 WHERE stage = 7 AND DATEDIFF(CURDATE(), package_date) > 13"; $result = $mysqli->query($query); $query = "UPDATE products SET stage=9 WHERE stage = 8 AND DATEDIFF(CURDATE(), package_date) > 41"; $result = $mysqli->query($query);