Fix for recipe to product mash and water.

Fri, 01 Mar 2019 14:49:33 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Fri, 01 Mar 2019 14:49:33 +0100
changeset 304
c0ca21cdd291
parent 303
98c2afc88780
child 305
bb55e065888a

Fix for recipe to product mash and water.

www/prod_torecipe.php file | annotate | diff | comparison | revisions
www/rec_toproduct.php file | annotate | diff | comparison | revisions
--- a/www/prod_torecipe.php	Fri Mar 01 14:29:09 2019 +0100
+++ b/www/prod_torecipe.php	Fri Mar 01 14:49:33 2019 +0100
@@ -66,7 +66,7 @@
 $sql .= "', sparge_acid_perc='" . $row['sparge_acid_perc'];
 $sql .= "', sparge_acid_amount='0";
 $sql .= "', mash_ph='" . $row['mash_ph'];
-$sql .= "', mash_name='" . $row['mash_name'];
+$sql .= "', mash_name='" . mysqli_real_escape_string($link, $row['mash_name']);
 $sql .= "', calc_acid='" . $row['calc_acid'];
 $sql .= "', w1_name='" . mysqli_real_escape_string($link, $row['w1_name']);
 $sql .= "', w1_amount='" . $row['w1_amount'];
--- a/www/rec_toproduct.php	Fri Mar 01 14:29:09 2019 +0100
+++ b/www/rec_toproduct.php	Fri Mar 01 14:49:33 2019 +0100
@@ -100,29 +100,39 @@
 $sql .= "', color_method='0";
 $sql .= "', est_ibu='0";
 $sql .= "', ibu_method='0";
-$sql .= "', sparge_temp='85";
-$sql .= "', sparge_ph='5.8";
-$sql .= "', sparge_volume='" . floatval($row['boil_size']) / 2;
-$sql .= "', sparge_source='0";
-$sql .= "', sparge_acid_type='0";
-$sql .= "', sparge_acid_perc='80";
+$sql .= "', sparge_temp='" . $row['sparge_temp'];
+$sql .= "', sparge_ph='" . $row['sparge_ph'];
+$sql .= "', sparge_volume='" . $row['sparge_volume'];
+$sql .= "', sparge_source='" . $row['sparge_source'];
+$sql .= "', sparge_acid_type='" . $row['sparge_acid_type'];
+$sql .= "', sparge_acid_perc='" . $row['sparge_acid_perc'];
 $sql .= "', sparge_acid_amount='0";
-$sql .= "', mash_ph='5.4";
-$sql .= "', mash_name='";
+$sql .= "', mash_ph='" . $row['mash_ph'];
+$sql .= "', mash_name='" . $row['mash_name'];
 $sql .= "', calc_acid='1";
-$sql .= "', w1_name='Tap water";
-$sql .= "', w1_amount='18";
-$sql .= "', w1_calcium='0";
-$sql .= "', w1_sulfate='0";
-$sql .= "', w1_chloride='0";
-$sql .= "', w1_sodium='0";
-$sql .= "', w1_magnesium='0";
-$sql .= "', w1_total_alkalinity='0";
-$sql .= "', w1_ph='7.0";
-$sql .= "', w1_cost='0.0";
-$sql .= "', wa_acid_name='0";
-$sql .= "', wa_acid_perc='0";
-$sql .= "', wa_base_name='0";
+$sql .= "', w1_name='" . mysqli_real_escape_string($link, $row['w1_name']);
+$sql .= "', w1_amount='" . $row['w1_amount'];
+$sql .= "', w1_calcium='" . $row['w1_calcium'];
+$sql .= "', w1_sulfate='" . $row['w1_sulfate'];
+$sql .= "', w1_chloride='" . $row['w1_chloride'];
+$sql .= "', w1_sodium='" . $row['w1_sodium'];
+$sql .= "', w1_magnesium='" . $row['w1_magnesium'];
+$sql .= "', w1_total_alkalinity='" . $row['w1_total_alkalinity'];
+$sql .= "', w1_ph='" . $row['w1_ph'];
+$sql .= "', w1_cost='" . $row['w1_cost'];
+$sql .= "', w2_name='" . mysqli_real_escape_string($link, $row['w2_name']);
+$sql .= "', w2_amount='" . $row['w2_amount'];
+$sql .= "', w2_calcium='" . $row['w2_calcium'];
+$sql .= "', w2_sulfate='" . $row['w2_sulfate'];
+$sql .= "', w2_chloride='" . $row['w2_chloride'];
+$sql .= "', w2_sodium='" . $row['w2_sodium'];
+$sql .= "', w2_magnesium='" . $row['w2_magnesium'];
+$sql .= "', w2_total_alkalinity='" . $row['w2_total_alkalinity'];
+$sql .= "', w2_ph='" . $row['w2_ph'];
+$sql .= "', w2_cost='" . $row['w2_cost'];
+$sql .= "', wa_acid_name='" . $row['wa_acid_name'];
+$sql .= "', wa_acid_perc='" . $row['wa_acid_perc'];
+$sql .= "', wa_base_name='" . $row['wa_base_name'];
 $sql .= "', json_fermentables='" . $row['json_fermentables'];
 $sql .= "', json_hops='" . $row['json_hops'];
 $sql .= "', json_miscs='" . $row['json_miscs'];

mercurial