comparison: www/crontasks.php
www/crontasks.php
- changeset 257
- 62e294ab94f5
- child 294
- 1e09d1d102a8
equal
deleted
inserted
replaced
| 256:4767a790d1f6 | 257:62e294ab94f5 |
|---|---|
| 1 <?php | |
| 2 | |
| 3 require_once('config.php'); | |
| 4 | |
| 5 $mysqli = new mysqli(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); | |
| 6 $query = "UPDATE products SET stage=7 WHERE stage = 6 AND DATEDIFF(CURDATE(), package_date) > 0"; | |
| 7 $result = $mysqli->query($query); | |
| 8 | |
| 9 $query = "UPDATE products SET stage=8 WHERE stage = 7 AND DATEDIFF(CURDATE(), package_date) > 13"; | |
| 10 $result = $mysqli->query($query); | |
| 11 | |
| 12 $query = "UPDATE products SET stage=9 WHERE stage = 8 AND DATEDIFF(CURDATE(), package_date) > 41"; | |
| 13 $result = $mysqli->query($query); | |
| 14 |
