diff -r 041af8a82d77 -r 35860890224c www/includes/db_recipes.php --- 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'];