Mercurial > bms / file diff

--- 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']
 		);