1319 $sql2 .= "' AND unlimited_stock=0 AND inventory < ".$_POST['w2_amount']." LIMIT 1;"; |
1319 $sql2 .= "' AND unlimited_stock=0 AND inventory < ".$_POST['w2_amount']." LIMIT 1;"; |
1320 $result2 = mysqli_query($connect, $sql2); |
1320 $result2 = mysqli_query($connect, $sql2); |
1321 $ar = mysqli_affected_rows($connect); |
1321 $ar = mysqli_affected_rows($connect); |
1322 if ($ar == 1) { |
1322 if ($ar == 1) { |
1323 syslog(LOG_NOTICE, "Reduced water `".$_POST['w2_name']."' to 0 liters"); |
1323 syslog(LOG_NOTICE, "Reduced water `".$_POST['w2_name']."' to 0 liters"); |
1324 } else { |
|
1325 syslog(LOG_NOTICE, "Reduce water `".$_POST['w2_name']."' failed"); |
|
1326 } |
1324 } |
1327 } |
1325 } |
1328 } |
1326 } |
1329 |
1327 |
1330 $inventory_reduced = 3; |
1328 $inventory_reduced = 3; |