517 /* |
517 /* |
518 * Save only if something was reduced. |
518 * Save only if something was reduced. |
519 */ |
519 */ |
520 if ($savethis == 1) { |
520 if ($savethis == 1) { |
521 $sql2 = "UPDATE products SET inventory_reduced=".$row['inventory_reduced']." WHERE uuid = '" . $row['uuid'] . "';"; |
521 $sql2 = "UPDATE products SET inventory_reduced=".$row['inventory_reduced']." WHERE uuid = '" . $row['uuid'] . "';"; |
522 // syslog(LOG_NOTICE, $sql2); |
522 syslog(LOG_NOTICE, $sql2); |
523 $result2 = mysqli_query($connect, $sql2); |
523 $result2 = mysqli_query($connect, $sql2); |
524 $ar = mysqli_affected_rows($connect); |
524 $ar = mysqli_affected_rows($connect); |
525 if ($ar != 1) { |
525 if ($ar != 1) { |
526 syslog(LOG_NOTICE, $sql2." error, affected rows: ".$ar); |
526 syslog(LOG_NOTICE, $sql2." error, affected rows: ".$ar); |
527 } |
527 } |