Mercurial > bms / file diff

--- a/www/includes/db_inventory_miscs.php	Mon Oct 14 23:13:40 2019 +0200
+++ b/www/includes/db_inventory_miscs.php	Wed Oct 16 21:05:03 2019 +0200
@@ -2,6 +2,7 @@
 
 require($_SERVER['DOCUMENT_ROOT']."/config.php");
 require($_SERVER['DOCUMENT_ROOT']."/version.php");
+require($_SERVER['DOCUMENT_ROOT']."/includes/constants.php");
 
 #Connect to the database
 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME);
@@ -19,8 +20,8 @@
 	}
 
 	$sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']);
-	$sql .= "', type='" . $_POST['type'];
-	$sql .= "', use_use='" . $_POST['use_use'];
+	$sql .= "', type='" . array_search($_POST['type'], $misctype);
+	$sql .= "', use_use='" . array_search($_POST['use_use'], $miscuse);
 	$sql .= "', time='" . $_POST['time'];
 	($_POST['amount_is_weight'] == 'true') ? $sql .= "', amount_is_weight='1" : $sql .= "', amount_is_weight='0";
 	$sql .= "', use_for='" . mysqli_real_escape_string($connect, $_POST['use_for']);
@@ -77,8 +78,8 @@
 		$miscs[] = array(
 			'record' => $row['record'],
 			'name' => $row['name'],
-			'type' => $row['type'],
-			'use_use' => $row['use_use'],
+			'type' => $misctype[$row['type']],
+			'use_use' => $miscuse[$row['use_use']],
 			'time' => $row['time'],
 			'amount_is_weight' => $row['amount_is_weight'],
 			'use_for' => $row['use_for'],