diff -r 98c2afc88780 -r c0ca21cdd291 www/rec_toproduct.php --- 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'];