diff -r 395833e20f88 -r 057a6256bd7b www/includes/db_inventory_hops.php --- a/www/includes/db_inventory_hops.php Thu Aug 16 16:01:13 2018 +0200 +++ b/www/includes/db_inventory_hops.php Thu Aug 16 16:38:20 2018 +0200 @@ -3,7 +3,6 @@ require($_SERVER['DOCUMENT_ROOT']."/config.php"); require($_SERVER['DOCUMENT_ROOT']."/version.php"); -syslog(LOG_NOTICE, "db_inventory_hops: script start"); #Connect to the database $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); @@ -23,7 +22,6 @@ $sql .= "', cohumulone='" . $_GET['cohumulone']; $sql .= "', myrcene='" . $_GET['myrcene']; $sql .= "', hsi='" . $_GET['hsi']; - $sql .= "', useat='" . $_GET['useat']; $sql .= "', type='" . $_GET['type']; $sql .= "', form='" . $_GET['form']; $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); @@ -34,8 +32,7 @@ $sql .= "', cost='" . $_GET['cost']; $sql .= "', production_date='" . $_GET['production_date']; $sql .= "', tht_date='" . $_GET['tht_date']; - $sql .= "', supplier_rec='" . $_GET['supplier_rec']; - $sql .= "', total_oil'" . $_GET['total_oil']; + $sql .= "', total_oil='" . $_GET['total_oil']; $sql .= "';"; $result = mysqli_query($connect, $sql); if (! $result) { @@ -55,7 +52,6 @@ $sql .= "', cohumulone='" . $_GET['cohumulone']; $sql .= "', myrcene='" . $_GET['myrcene']; $sql .= "', hsi='" . $_GET['hsi']; - $sql .= "', useat='" . $_GET['useat']; $sql .= "', type='" . $_GET['type']; $sql .= "', form='" . $_GET['form']; $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); @@ -66,8 +62,7 @@ $sql .= "', cost='" . $_GET['cost']; $sql .= "', production_date='" . $_GET['production_date']; $sql .= "', tht_date='" . $_GET['tht_date']; - $sql .= "', supplier_rec='" . $_GET['supplier_rec']; - $sql .= "', total_oil'" . $_GET['total_oil']; + $sql .= "', total_oil='" . $_GET['total_oil']; $sql .= "' WHERE record='" . $_GET['record'] . "';"; $result = mysqli_query($connect, $sql); if (! $result) { @@ -102,7 +97,6 @@ 'cohumulone' => $row['cohumulone'], 'myrcene' => $row['myrcene'], 'hsi' => $row['hsi'], - 'useat' => $row['useat'], 'type' => $row['type'], 'form' => $row['form'], 'notes' => $row['notes'], @@ -113,7 +107,6 @@ 'cost' => $row['cost'], 'production_date' => $row['production_date'], 'tht_date' => $row['tht_date'], - 'supplier_rec' => $row['supplier_rec'], 'total_oil' => $row['total_oil'] ); }