diff -r 217ba4596c4d -r 3c680d1dea35 www/includes/db_inventory_miscs.php --- 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'],