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 |