comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 781
- 4bb28e67f2b7
- parent 780
- 69545bdc2890
- child 840
- ba607babc468
equal
deleted
inserted
replaced
| 780:69545bdc2890 | 781:4bb28e67f2b7 |
|---|---|
| 1268 $sql2 .= "' AND unlimited_stock=0 AND inventory < ".$_POST['w1_amount']." LIMIT 1;"; | 1268 $sql2 .= "' AND unlimited_stock=0 AND inventory < ".$_POST['w1_amount']." LIMIT 1;"; |
| 1269 $result2 = mysqli_query($connect, $sql2); | 1269 $result2 = mysqli_query($connect, $sql2); |
| 1270 $ar = mysqli_affected_rows($connect); | 1270 $ar = mysqli_affected_rows($connect); |
| 1271 if ($ar == 1) { | 1271 if ($ar == 1) { |
| 1272 syslog(LOG_NOTICE, "Reduced water `".$_POST['w1_name']."' to 0 liters"); | 1272 syslog(LOG_NOTICE, "Reduced water `".$_POST['w1_name']."' to 0 liters"); |
| 1273 } else { | |
| 1274 syslog(LOG_NOTICE, "Reduce water `".$_POST['w1_name']."' not reduced is maybe tapwater"); | |
| 1275 } | 1273 } |
| 1276 } | 1274 } |
| 1277 } | 1275 } |
| 1278 if ($_POST['w2_name'] != '') { | 1276 if ($_POST['w2_name'] != '') { |
| 1279 $sql2 = "UPDATE inventory_waters SET inventory = inventory - ".$_POST['w2_amount']; | 1277 $sql2 = "UPDATE inventory_waters SET inventory = inventory - ".$_POST['w2_amount']; |
