Mercurial > bms / file diff

--- a/www/getmiscsources.php	Mon Jul 05 20:59:10 2021 +0200
+++ b/www/getmiscsources.php	Sun Jul 11 15:55:44 2021 +0200
@@ -1,7 +1,7 @@
 <?php
 require_once('config.php');
 
-$query = "SELECT * FROM inventory_miscs ORDER BY name";
+$query = "SELECT record,name,type,use_use,time,amount_is_weight,inventory,cost FROM inventory_miscs ORDER BY name";
 $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
 if (! $connect) {
 	echo "[]";
@@ -10,16 +10,7 @@
 mysqli_set_charset($connect, "utf8");
 $result = mysqli_query($connect, $query);
 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
-	$miscs[] = array(
-		'record' => $row['record'],
-		'name' => $row['name'],
-		'type' => $row['type'],
-		'use_use' => $row['use_use'],
-		'time' => $row['time'],
-		'amount_is_weight' => $row['amount_is_weight'],
-		'inventory' => $row['inventory'],
-		'cost' => $row['cost']
-	);
+	$miscs[] = $row;
 }
 header("Content-type: application/json");
 echo json_encode($miscs);