www/includes/db_recipes.php

changeset 148
c0f0bbfefd63
parent 147
e6e5d007eb54
child 154
ef298b5aa994
--- a/www/includes/db_recipes.php	Mon Dec 17 22:24:32 2018 +0100
+++ b/www/includes/db_recipes.php	Wed Dec 19 21:58:21 2018 +0100
@@ -68,6 +68,30 @@
 	$sql .= "', mash_ph='" . $_POST['mash_ph'];
 	$sql .= "', mash_name='" . $_POST['mash_name'];
 	$sql .= "', calc_acid='" . $_POST['calc_acid'];
+	if (isset($_POST['w1_name'])) {
+		$sql .= "', w1_name='" . mysqli_real_escape_string($connect, $_POST['w1_name']);
+		$sql .= "', w1_amount='" . $_POST['w1_amount'];
+		$sql .= "', w1_calcium='" . $_POST['w1_calcium'];
+		$sql .= "', w1_sulfate='" . $_POST['w1_sulfate'];
+		$sql .= "', w1_chloride='" . $_POST['w1_chloride'];
+		$sql .= "', w1_sodium='" . $_POST['w1_sodium'];
+		$sql .= "', w1_magnesium='" . $_POST['w1_magnesium'];
+		$sql .= "', w1_total_alkalinity='" . $_POST['w1_total_alkalinity'];
+		$sql .= "', w1_ph='" . $_POST['w1_ph'];
+		$sql .= "', w1_cost='" . $_POST['w1_cost'];
+	}
+	if (isset($_POST['w2_name'])) {
+		$sql .= "', w2_name='" . mysqli_real_escape_string($connect, $_POST['w2_name']);
+		$sql .= "', w2_amount='" . $_POST['w2_amount'];
+		$sql .= "', w2_calcium='" . $_POST['w2_calcium'];
+		$sql .= "', w2_sulfate='" . $_POST['w2_sulfate'];
+		$sql .= "', w2_chloride='" . $_POST['w2_chloride'];
+		$sql .= "', w2_sodium='" . $_POST['w2_sodium'];
+		$sql .= "', w2_magnesium='" . $_POST['w2_magnesium'];
+		$sql .= "', w2_total_alkalinity='" . $_POST['w2_total_alkalinity'];
+		$sql .= "', w2_ph='" . $_POST['w2_ph'];
+		$sql .= "', w2_cost='" . $_POST['w2_cost'];
+	}
 	syslog(LOG_NOTICE, $sql);
 
 	if (isset($_POST['fermentables'])) {
@@ -114,17 +138,6 @@
 		$sql .= "', json_yeasts='" . str_replace($rescapers,$rreplacements,json_encode($array));
 	}
 
-	if (isset($_POST['waters'])) {
-		$array = $_POST['waters'];
-		foreach($array as $key => $item){
-			foreach ($disallowed as $disallowed_key) {
-				unset($array[$key]["$disallowed_key"]);
-			}
-		}
-		syslog(LOG_NOTICE, "json_waters: ".str_replace($rescapers,$rreplacements,json_encode($array)));
-		$sql .= "', json_waters='" . str_replace($rescapers,$rreplacements,json_encode($array));
-	}
-
 	if (isset($_POST['mashs'])) {
 		$array = $_POST['mashs'];
 		foreach($array as $key => $item){
@@ -228,11 +241,30 @@
 		$recipes .= ',"mash_ph":' . $row['mash_ph'];
 		$recipes .= ',"mash_name":"' . $row['mash_name'];
 		$recipes .= '","calc_acid":' . $row['calc_acid'];
+		$recipes .= ',"w1_name":"' . str_replace($escapers, $replacements, $row['w1_name']);
+		$recipes .= '","w1_amount":' . $row['w1_amount'];
+		$recipes .= ',"w1_calcium":' . $row['w1_calcium'];
+		$recipes .= ',"w1_sulfate":' . $row['w1_sulfate'];
+		$recipes .= ',"w1_chloride":' . $row['w1_chloride'];
+		$recipes .= ',"w1_sodium":' . $row['w1_sodium'];
+		$recipes .= ',"w1_magnesium":' . $row['w1_magnesium'];
+		$recipes .= ',"w1_total_alkalinity":' . $row['w1_total_alkalinity'];
+		$recipes .= ',"w1_ph":' . $row['w1_ph'];
+		$recipes .= ',"w1_cost":' . $row['w1_cost'];
+		$recipes .= ',"w2_name":"' . str_replace($escapers, $replacements, $row['w2_name']);
+		$recipes .= '","w2_amount":' . $row['w2_amount'];
+		$recipes .= ',"w2_calcium":' . $row['w2_calcium'];
+		$recipes .= ',"w2_sulfate":' . $row['w2_sulfate'];
+		$recipes .= ',"w2_chloride":' . $row['w2_chloride'];
+		$recipes .= ',"w2_sodium":' . $row['w2_sodium'];
+		$recipes .= ',"w2_magnesium":' . $row['w2_magnesium'];
+		$recipes .= ',"w2_total_alkalinity":' . $row['w2_total_alkalinity'];
+		$recipes .= ',"w2_ph":' . $row['w2_ph'];
+		$recipes .= ',"w2_cost":' . $row['w2_cost'];
 		$recipes .= ',"fermentables":' . $row['json_fermentables'];
 		$recipes .= ',"hops":' . $row['json_hops'];
 		$recipes .= ',"miscs":' . $row['json_miscs'];
 		$recipes .= ',"yeasts":' . $row['json_yeasts'];
-		$recipes .= ',"waters":' . $row['json_waters'];
 		$recipes .= ',"mashs":' . $row['json_mashs'];
 		$recipes .= '}';
 	}

mercurial