Mercurial > bms / file diff

--- 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']
 		);
 	}