191 // syslog(LOG_NOTICE, $sql2); |
191 // syslog(LOG_NOTICE, $sql2); |
192 $result2 = mysqli_query($connect, $sql2); |
192 $result2 = mysqli_query($connect, $sql2); |
193 $ar = mysqli_affected_rows($connect); |
193 $ar = mysqli_affected_rows($connect); |
194 if ($ar == 1) { |
194 if ($ar == 1) { |
195 syslog(LOG_NOTICE, "Reduced water `".$row['w2_name']."' to 0 liters"); |
195 syslog(LOG_NOTICE, "Reduced water `".$row['w2_name']."' to 0 liters"); |
196 } else { |
|
197 syslog(LOG_NOTICE, "Reduced water `".$row['w2_name']."' failed or tapwater"); |
|
198 } |
196 } |
199 } |
197 } |
200 } |
198 } |
201 |
199 |
202 syslog(LOG_NOTICE, "Finished reducing inventory from ". $row['code'].' '.$row['name']); |
200 syslog(LOG_NOTICE, "Finished reducing inventory from ". $row['code'].' '.$row['name']); |