www/includes/db_recipes.php

changeset 156
35860890224c
parent 154
ef298b5aa994
child 166
635033a29c48
--- a/www/includes/db_recipes.php	Fri Dec 28 23:18:42 2018 +0100
+++ b/www/includes/db_recipes.php	Sun Dec 30 18:18:22 2018 +0100
@@ -62,12 +62,13 @@
 	$sql .= "', sparge_temp='" . $_POST['sparge_temp'];
 	$sql .= "', sparge_ph='" . $_POST['sparge_ph'];
 	$sql .= "', sparge_volume='" . $_POST['sparge_volume'];
-//	$sql .= "', sparge_acid_type='" . $_POST['sparge_acid_type'];
-//	$sql .= "', sparge_acid_perc='" . $_POST['sparge_acid_perc'];
-//	$sql .= "', sparge_acid_amount='" . $_POST['sparge_acid_amount'];
+	$sql .= "', sparge_source='" . $_POST['sparge_source'];
+	$sql .= "', sparge_acid_type='" . $_POST['sparge_acid_type'];
+	$sql .= "', sparge_acid_perc='" . $_POST['sparge_acid_perc'];
+	$sql .= "', sparge_acid_amount='" . $_POST['sparge_acid_amount'];
 	$sql .= "', mash_ph='" . $_POST['mash_ph'];
 	$sql .= "', mash_name='" . $_POST['mash_name'];
-	$sql .= "', calc_acid='" . $_POST['calc_acid'];
+	($_POST['calc_acid'] == 'true') ? $sql .= "', calc_acid='1" : $sql .= "', calc_acid='0";
 	if (isset($_POST['w1_name'])) {
 		$sql .= "', w1_name='" . mysqli_real_escape_string($connect, $_POST['w1_name']);
 		$sql .= "', w1_amount='" . $_POST['w1_amount'];
@@ -235,7 +236,8 @@
 		$recipes .= '","sparge_temp":' . $row['sparge_temp'];
 		$recipes .= ',"sparge_ph":' . $row['sparge_ph'];
 		$recipes .= ',"sparge_volume":' . $row['sparge_volume'];
-		$recipes .= ',"sparge_acid_type":"' . $row['sparge_acid_type'];
+		$recipes .= ',"sparge_source":"' . $row['sparge_source'];
+		$recipes .= '","sparge_acid_type":"' . $row['sparge_acid_type'];
 		$recipes .= '","sparge_acid_perc":' . $row['sparge_acid_perc'];
 		$recipes .= ',"sparge_acid_amount":' . $row['sparge_acid_amount'];
 		$recipes .= ',"mash_ph":' . $row['mash_ph'];

mercurial