54 $sql .= "', brew_aeration_time='0', brew_aeration_speed='0', brew_aeration_type='0"; |
54 $sql .= "', brew_aeration_time='0', brew_aeration_speed='0', brew_aeration_type='0"; |
55 $sql .= "', brew_fermenter_volume='" . floatval($row['batch_size']) - 0.5; |
55 $sql .= "', brew_fermenter_volume='" . floatval($row['batch_size']) - 0.5; |
56 $sql .= "', brew_fermenter_extrawater='0', brew_fermenter_tcloss='0.5', brew_fermenter_sg='0"; |
56 $sql .= "', brew_fermenter_extrawater='0', brew_fermenter_tcloss='0.5', brew_fermenter_sg='0"; |
57 $sql .= "', brew_fermenter_ibu='0', brew_fermenter_color='0', brew_date_end=NULL, og='0', fg='0"; |
57 $sql .= "', brew_fermenter_ibu='0', brew_fermenter_color='0', brew_date_end=NULL, og='0', fg='0"; |
58 $sql .= "', primary_start_temp='0', primary_max_temp='0', primary_end_temp='0', primary_end_date=NULL, primary_end_sg='0"; |
58 $sql .= "', primary_start_temp='0', primary_max_temp='0', primary_end_temp='0', primary_end_date=NULL, primary_end_sg='0"; |
59 $sql .= "', secondary_temp='0', secondary_end_date=NULL, tertiary_temp='0"; |
59 $sql .= "', secondary_temp='0', secondary_end_sg='0', secondary_end_date=NULL, tertiary_temp='0"; |
60 $sql .= "', package_date=NULL"; |
60 $sql .= "', package_date=NULL, package_volume='0', package_infuse_amount='0', package_infuse_abv='0', package_infuse_notes='"; |
61 $sql .= ", bottle_amount='0', bottle_carbonation='0', bottle_priming_sugar='0', bottle_priming_amount='0', bottle_carbonation_temp='23"; |
61 $sql .= "', package_abv='0', package_ph='0"; |
62 $sql .= "', keg_amount='0', keg_carbonation='0', keg_priming_sugar='0', keg_priming_amount='0', keg_carbonation_temp='23"; |
62 $sql .= "', bottle_amount='0', bottle_carbonation='0', bottle_priming_water='0', bottle_priming_amount='0', bottle_carbonation_temp='23"; |
|
63 $sql .= "', keg_amount='0', keg_carbonation='0', keg_priming_water='0', keg_priming_amount='0', keg_carbonation_temp='23"; |
63 $sql .= "', keg_forced_carb='0', keg_pressure='0"; |
64 $sql .= "', keg_forced_carb='0', keg_pressure='0"; |
64 $sql .= "', taste_notes='"; |
65 $sql .= "', taste_notes='"; |
65 $sql .= "', taste_rate='0"; |
66 $sql .= "', taste_rate='0"; |
66 $sql .= "', taste_date=NULL"; |
67 $sql .= "', taste_date=NULL"; |
67 $sql .= ", taste_color='"; |
68 $sql .= ", taste_color='"; |
134 $sql .= "', w2_ph='" . $row['w2_ph']; |
135 $sql .= "', w2_ph='" . $row['w2_ph']; |
135 $sql .= "', w2_cost='" . $row['w2_cost']; |
136 $sql .= "', w2_cost='" . $row['w2_cost']; |
136 $sql .= "', wa_acid_name='" . $row['wa_acid_name']; |
137 $sql .= "', wa_acid_name='" . $row['wa_acid_name']; |
137 $sql .= "', wa_acid_perc='" . $row['wa_acid_perc']; |
138 $sql .= "', wa_acid_perc='" . $row['wa_acid_perc']; |
138 $sql .= "', wa_base_name='" . $row['wa_base_name']; |
139 $sql .= "', wa_base_name='" . $row['wa_base_name']; |
|
140 $sql .= "', starter_enable='0', starter_type='0', starter_sg='1.040', starter_viability='97"; |
|
141 $sql .= "', prop1_type='0', prop1_volume='0', prop2_type='0', prop2_volume='0"; |
|
142 $sql .= "', prop3_type='0', prop3_volume='0', prop4_type='0', prop4_volume='0"; |
139 $sql .= "', json_fermentables='" . str_replace($rescapers,$rreplacements,$row['json_fermentables']); |
143 $sql .= "', json_fermentables='" . str_replace($rescapers,$rreplacements,$row['json_fermentables']); |
140 $sql .= "', json_hops='" . str_replace($rescapers,$rreplacements,$row['json_hops']); |
144 $sql .= "', json_hops='" . str_replace($rescapers,$rreplacements,$row['json_hops']); |
141 $sql .= "', json_miscs='" . str_replace($rescapers,$rreplacements,$row['json_miscs']); |
145 $sql .= "', json_miscs='" . str_replace($rescapers,$rreplacements,$row['json_miscs']); |
142 $sql .= "', json_yeasts='" . str_replace($rescapers,$rreplacements,$row['json_yeasts']); |
146 $sql .= "', json_yeasts='" . str_replace($rescapers,$rreplacements,$row['json_yeasts']); |
143 $sql .= "', json_mashs='" . str_replace($rescapers,$rreplacements,$row['json_mashs']); |
147 $sql .= "', json_mashs='" . str_replace($rescapers,$rreplacements,$row['json_mashs']); |