--- a/www/rec_toproduct.php Fri Oct 18 13:20:35 2019 +0200 +++ b/www/rec_toproduct.php Fri May 01 16:37:31 2020 +0200 @@ -33,7 +33,7 @@ $sql .= "', birth='" . date("Y-m-d"); $sql .= "', stage='1"; $sql .= "', notes='" . mysqli_real_escape_string($link, $row['notes']); -$sql .= "', log_brew='0', log_fermentation='0', inventory_reduced='0', locked='0"; +$sql .= "', log_brew='0', log_fermentation='0', log_ispindel='0', log_co2pressure='0', inventory_reduced='0', locked='0"; // Equipment $sql .= "', eq_name='Kies zelf een installatie!"; $sql .= "', eq_boil_size='" . $row['boil_size']; @@ -46,8 +46,8 @@ $sql .= "', eq_kettle_height='20', eq_mash_volume='18', eq_mash_max='6', eq_efficiency='75"; // brewdate $sql .= "', brew_date_start=NULL, brew_mash_ph='0.0', brew_mash_sg='1.000"; -$sql .= "', brew_sparge_ph='0.0"; -$sql .= "', brew_preboil_volume='0', brew_preboil_sg='0', brew_preboil_ph='0.0"; +$sql .= "', brew_mash_efficiency='0.0', brew_sparge_ph='0.0', brew_sparge_temperature='85.0"; +$sql .= "', brew_preboil_volume='0', brew_preboil_sg='0', brew_preboil_ph='0.0', brew_preboil_efficiency='0"; $sql .= "', brew_aboil_volume='0', brew_aboil_sg='0', brew_aboil_ph='0.0', brew_aboil_efficiency='0"; $sql .= "', brew_cooling_method='0', brew_cooling_time='0', brew_cooling_to='20"; $sql .= "', brew_whirlpool9='0', brew_whirlpool7='0', brew_whirlpool6='0', brew_whirlpool2='0"; @@ -97,6 +97,7 @@ $sql .= "', boil_time='" . $row['boil_time']; $sql .= "', efficiency='" . $row['efficiency']; $sql .= "', est_og='0.000"; +$sql .= "', est_og3='0.000"; $sql .= "', est_fg='0.000"; $sql .= "', est_abv='0.0"; $sql .= "', est_carb='0"; @@ -134,12 +135,28 @@ $sql .= "', w2_total_alkalinity='" . $row['w2_total_alkalinity']; $sql .= "', w2_ph='" . $row['w2_ph']; $sql .= "', w2_cost='" . $row['w2_cost']; +$sql .= "', wg_amount='" . $row['wg_amount']; +$sql .= "', wg_calcium='" . $row['wg_calcium']; +$sql .= "', wg_sulfate='" . $row['wg_sulfate']; +$sql .= "', wg_chloride='" . $row['wg_chloride']; +$sql .= "', wg_sodium='" . $row['wg_sodium']; +$sql .= "', wg_magnesium='" . $row['wg_magnesium']; +$sql .= "', wg_total_alkalinity='" . $row['wg_total_alkalinity']; +$sql .= "', wg_ph='" . $row['wg_ph']; +$sql .= "', wb_calcium='" . $row['wb_calcium']; +$sql .= "', wb_sulfate='" . $row['wb_sulfate']; +$sql .= "', wb_chloride='" . $row['wb_chloride']; +$sql .= "', wb_sodium='" . $row['wb_sodium']; +$sql .= "', wb_magnesium='" . $row['wb_magnesium']; +$sql .= "', wb_total_alkalinity='" . $row['wb_total_alkalinity']; +$sql .= "', wb_ph='" . $row['wb_ph']; $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 .= "', starter_enable='0', starter_type='0', starter_sg='1.037', starter_viability='97"; $sql .= "', prop1_type='0', prop1_volume='0', prop2_type='0', prop2_volume='0"; $sql .= "', prop3_type='0', prop3_volume='0', prop4_type='0', prop4_volume='0"; +$sql .= "', divide_type='0', divide_parts='0', divide_part='0', divide_size='0', divide_factor='1.0"; $sql .= "', json_fermentables='" . str_replace($rescapers,$rreplacements,$row['json_fermentables']); $sql .= "', json_hops='" . str_replace($rescapers,$rreplacements,$row['json_hops']); $sql .= "', json_miscs='" . str_replace($rescapers,$rreplacements,$row['json_miscs']);