72 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 9 (Taste)"); |
72 syslog(LOG_NOTICE, "Updated ".$changed." products to stage 9 (Taste)"); |
73 } |
73 } |
74 |
74 |
75 |
75 |
76 /* |
76 /* |
77 * Check fementation logs. |
77 * Check several logs. |
78 */ |
78 */ |
79 $query = "SELECT record,code,name,log_brew,log_fermentation 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 $logfile = "log/fermentation/" . $row['code'] . " " . $row['name'] . ".log"; |
83 if (file_exists($logfile)) |
83 if (file_exists($logfile)) |
84 $ok = 1; |
84 $ok = 1; |
87 if ($ok != $row['log_fermentation']) { |
87 if ($ok != $row['log_fermentation']) { |
88 $query = "UPDATE products SET log_fermentation='" . $ok . "' WHERE record='" . $row['record'] . "';"; |
88 $query = "UPDATE products SET log_fermentation='" . $ok . "' WHERE record='" . $row['record'] . "';"; |
89 syslog(LOG_NOTICE, $query); |
89 syslog(LOG_NOTICE, $query); |
90 $result1 = mysqli_query($connect, $query); |
90 $result1 = mysqli_query($connect, $query); |
91 } |
91 } |
|
92 $logfile = "log/ispindel/" . $row['code'] . " " . $row['name'] . ".log"; |
|
93 if (file_exists($logfile)) |
|
94 $ok = 1; |
|
95 else |
|
96 $ok = 0; |
|
97 if ($ok != $row['log_ispindel']) { |
|
98 $query = "UPDATE products SET log_ispindel='" . $ok . "' WHERE record='" . $row['record'] . "';"; |
|
99 syslog(LOG_NOTICE, $query); |
|
100 $result1 = mysqli_query($connect, $query); |
|
101 } |
|
102 $logfile = "log/co2pressure/" . $row['code'] . " " . $row['name'] . ".log"; |
|
103 if (file_exists($logfile)) |
|
104 $ok = 1; |
|
105 else |
|
106 $ok = 0; |
|
107 if ($ok != $row['log_co2pressure']) { |
|
108 $query = "UPDATE products SET log_co2pressure='" . $ok . "' WHERE record='" . $row['record'] . "';"; |
|
109 syslog(LOG_NOTICE, $query); |
|
110 $result1 = mysqli_query($connect, $query); |
|
111 } |
92 } |
112 } |
93 |
113 |
94 |
114 |
95 /* |
115 /* |
96 * Check and update secondary_end_sg |
116 * Check and update secondary_end_sg |