--- a/www/includes/db_inventory_mash_profiles.php Sat Aug 18 17:40:24 2018 +0200
+++ b/www/includes/db_inventory_mash_profiles.php Sat Aug 18 19:40:30 2018 +0200
@@ -14,14 +14,7 @@
if (isset($_GET['insert'])) {
// INSERT COMMAND
$sql = "INSERT INTO `inventory_mash_profiles` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);
- $sql .= "', grain_temp='" . $_GET['grain_temp'];
$sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
- $sql .= "', tun_temp='" . $_GET['tun_temp'];
- $sql .= "', sparge_temp='" . $_GET['sparge_temp'];
- $sql .= "', ph='" . $_GET['ph'];
- $sql .= "', tun_weight='" . $_GET['tun_weight'];
- $sql .= "', tun_specific_heat='" . $_GET['tun_specific_heat'];
- ($_GET['equip_adjust'] == 'true') ? $sql .= "', equip_adjust='1" : $sql .= "', equip_adjust='0";
$sql .= "', steps='" . mysqli_real_escape_string($connect, $_GET['steos']);
$sql .= "';";
$result = mysqli_query($connect, $sql);
@@ -35,14 +28,7 @@
} else if (isset($_GET['update'])) {
// UPDATE COMMAND
$sql = "UPDATE `inventory_mash_profiles` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);
- $sql .= "', grain_temp='" . $_GET['grain_temp'];
$sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
- $sql .= "', tun_temp='" . $_GET['tun_temp'];
- $sql .= "', sparge_temp='" . $_GET['sparge_temp'];
- $sql .= "', ph='" . $_GET['ph'];
- $sql .= "', tun_weight='" . $_GET['tun_weight'];
- $sql .= "', tun_specific_heat='" . $_GET['tun_specific_heat'];
- ($_GET['equip_adjust'] == 'true') ? $sql .= "', equip_adjust='1" : $sql .= "', equip_adjust='0";
$sql .= "', steps='" . mysqli_real_escape_string($connect, $_GET['steos']);
$sql .= "' WHERE record='" . $_GET['record'] . "';";
$result = mysqli_query($connect, $sql);
@@ -71,13 +57,6 @@
$suppliers[] = array(
'record' => $row['record'],
'name' => $row['name'],
- 'grain_temp' => $row['grain_temp'],
- 'tun_temp' => $row['tun_temp'],
- 'sparge_temp' => $row['sparge_temp'],
- 'ph' => $row['ph'],
- 'tun_weight' => $row['tun_weight'],
- 'tun_specific_heat' => $row['tun_specific_heat'],
- 'equip_adjust' => $row['equip_adjust'],
'notes' => $row['notes'],
'steps' => $row['steps']
);