diff -r 92d6bc8a4cdd -r f433193f7bb6 www/includes/db_inventory_water.php --- a/www/includes/db_inventory_water.php Fri Nov 16 16:20:17 2018 +0100 +++ b/www/includes/db_inventory_water.php Sat Nov 17 15:58:13 2018 +0100 @@ -10,19 +10,6 @@ } mysqli_set_charset($connect, "utf8" ); -/* - * If a new default will be set, clear the old default. - */ -function clear_default() { - global $connect; - - $usql = "UPDATE inventory_waters SET default_water='0' WHERE (default_water = '1');"; - $result = mysqli_query($connect, $usql); - if (! $result) { - syslog(LOG_NOTICE, "db_inventory_waters: " . $usql . " result: ".mysqli_error($connect)); - } -} - // get data and store in a json array $query = "SELECT * FROM inventory_waters ORDER BY name"; @@ -39,12 +26,6 @@ $sql .= "', ph='" . $_GET['ph']; $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); $sql .= "', total_alkalinity='" . $_GET['total_alkalinity']; - if ($_GET['default_water'] == 'true') { - clear_default(); - $sql .= "', default_water='1"; - } else { - $sql .= "', default_water='0"; - } $sql .= "', inventory='" . $_GET['inventory']; $sql .= "', cost='" . $_GET['cost']; $sql .= "';"; @@ -69,12 +50,6 @@ $sql .= "', ph='" . $_GET['ph']; $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); $sql .= "', total_alkalinity='" . $_GET['total_alkalinity']; - if ($_GET['default_water'] == 'true') { - clear_default(); - $sql .= "', default_water='1"; - } else { - $sql .= "', default_water='0"; - } $sql .= "', inventory='" . $_GET['inventory']; $sql .= "', cost='" . $_GET['cost']; $sql .= "' WHERE record='" . $_GET['record'] . "';"; @@ -114,7 +89,6 @@ 'ph' => $row['ph'], 'notes' => $row['notes'], 'total_alkalinity' => $row['total_alkalinity'], - 'default_water' => $row['default_water'], 'inventory' => $row['inventory'], 'cost' => $row['cost'] );