www/crontasks.php

changeset 855
2d328a2a4025
parent 615
9034e65b0d7a
equal deleted inserted replaced
854:548e5e9af0c6 855:2d328a2a4025
77 * Check several logs. 77 * Check several logs.
78 */ 78 */
79 $query = "SELECT record,code,name,log_brew,log_fermentation,log_ispindel,log_co2pressure FROM products;"; 79 $query = "SELECT record,code,name,log_brew,log_fermentation,log_ispindel,log_co2pressure FROM products;";
80 $result = mysqli_query($connect, $query); 80 $result = mysqli_query($connect, $query);
81 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { 81 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
82 $logfile = "log/fermentation/" . $row['code'] . " " . $row['name'] . ".log"; 82 $query1 = "SELECT code FROM log_fermenter WHERE code='" . $row['code'] . "';";
83 if (file_exists($logfile)) 83 $result1 = mysqli_query($connect, $query1);
84 if (mysqli_num_rows($result1) > 0)
84 $ok = 1; 85 $ok = 1;
85 else 86 else
86 $ok = 0; 87 $ok = 0;
87 if ($ok != $row['log_fermentation']) { 88 if ($ok != $row['log_fermentation']) {
88 $query = "UPDATE products SET log_fermentation='" . $ok . "' WHERE record='" . $row['record'] . "';"; 89 $query = "UPDATE products SET log_fermentation='" . $ok . "' WHERE record='" . $row['record'] . "';";
89 syslog(LOG_NOTICE, $query); 90 syslog(LOG_NOTICE, $row['code'] . ": " . $query);
90 $result1 = mysqli_query($connect, $query); 91 $result1 = mysqli_query($connect, $query);
91 } 92 }
92 $logfile = "log/ispindel/" . $row['code'] . " " . $row['name'] . ".log"; 93 $query1 = "SELECT code FROM log_ispindel WHERE code='" . $row['code'] . "';";
93 if (file_exists($logfile)) 94 $result1 = mysqli_query($connect, $query1);
95 if (mysqli_num_rows($result1) > 0)
94 $ok = 1; 96 $ok = 1;
95 else 97 else
96 $ok = 0; 98 $ok = 0;
97 if ($ok != $row['log_ispindel']) { 99 if ($ok != $row['log_ispindel']) {
98 $query = "UPDATE products SET log_ispindel='" . $ok . "' WHERE record='" . $row['record'] . "';"; 100 $query = "UPDATE products SET log_ispindel='" . $ok . "' WHERE record='" . $row['record'] . "';";
99 syslog(LOG_NOTICE, $query); 101 syslog(LOG_NOTICE, $row['code'] . ": " . $query);
100 $result1 = mysqli_query($connect, $query); 102 $result1 = mysqli_query($connect, $query);
101 } 103 }
102 $logfile = "log/co2pressure/" . $row['code'] . " " . $row['name'] . ".log"; 104 $query1 = "SELECT code FROM log_co2pressure WHERE code='" . $row['code'] . "';";
103 if (file_exists($logfile)) 105 $result1 = mysqli_query($connect, $query1);
106 if (mysqli_num_rows($result1) > 0)
104 $ok = 1; 107 $ok = 1;
105 else 108 else
106 $ok = 0; 109 $ok = 0;
107 if ($ok != $row['log_co2pressure']) { 110 if ($ok != $row['log_co2pressure']) {
108 $query = "UPDATE products SET log_co2pressure='" . $ok . "' WHERE record='" . $row['record'] . "';"; 111 $query = "UPDATE products SET log_co2pressure='" . $ok . "' WHERE record='" . $row['record'] . "';";
109 syslog(LOG_NOTICE, $query); 112 syslog(LOG_NOTICE, $row['code'] . ": " . $query);
110 $result1 = mysqli_query($connect, $query); 113 $result1 = mysqli_query($connect, $query);
111 } 114 }
112 } 115 }
113 116
114 117

mercurial