diff -r 754c56e785c6 -r d9da6c40dff5 www/includes/db_inventory_mash_profiles.php --- 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'] );