comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 240
- a85c1d4c4d12
- parent 238
- 8e7384587a10
- child 241
- e95d2886f49f
equal
deleted
inserted
replaced
| 239:03e81378182d | 240:a85c1d4c4d12 |
|---|---|
| 67 $sql .= "', eq_kettle_volume='" . $_POST['eq_kettle_volume']; | 67 $sql .= "', eq_kettle_volume='" . $_POST['eq_kettle_volume']; |
| 68 $sql .= "', eq_kettle_height='" . $_POST['eq_kettle_height']; | 68 $sql .= "', eq_kettle_height='" . $_POST['eq_kettle_height']; |
| 69 $sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume']; | 69 $sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume']; |
| 70 $sql .= "', eq_mash_max='" . $_POST['eq_mash_max']; | 70 $sql .= "', eq_mash_max='" . $_POST['eq_mash_max']; |
| 71 $sql .= "', eq_efficiency='" . $_POST['eq_efficiency']; | 71 $sql .= "', eq_efficiency='" . $_POST['eq_efficiency']; |
| 72 $sql .= "', brew_date_start='" . $_POST['brew_date_start']; | 72 |
| 73 $sql .= "', brew_mash_ph='" . $_POST['brew_mash_ph']; | 73 if ($stage > 1) { |
| 74 $sql .= "', brew_mash_sg='" . $_POST['brew_mash_sg']; | 74 $sql .= "', brew_date_start='" . $_POST['brew_date_start']; |
| 75 $sql .= "', brew_sparge_temperature='" . $_POST['brew_sparge_temperature']; | 75 $sql .= "', brew_mash_ph='" . $_POST['brew_mash_ph']; |
| 76 $sql .= "', brew_sparge_volume='" . $_POST['brew_sparge_volume']; | 76 $sql .= "', brew_mash_sg='" . $_POST['brew_mash_sg']; |
| 77 $sql .= "', brew_sparge_ph='" . $_POST['brew_sparge_ph']; | 77 $sql .= "', brew_sparge_temperature='" . $_POST['brew_sparge_temperature']; |
| 78 $sql .= "', brew_preboil_volume='" . $_POST['brew_preboil_volume']; | 78 $sql .= "', brew_sparge_volume='" . $_POST['brew_sparge_volume']; |
| 79 $sql .= "', brew_preboil_sg='" . $_POST['brew_preboil_sg']; | 79 $sql .= "', brew_sparge_ph='" . $_POST['brew_sparge_ph']; |
| 80 $sql .= "', brew_preboil_ph='" . $_POST['brew_preboil_ph']; | 80 $sql .= "', brew_preboil_volume='" . $_POST['brew_preboil_volume']; |
| 81 $sql .= "', brew_aboil_volume='" . $_POST['brew_aboil_volume']; | 81 $sql .= "', brew_preboil_sg='" . $_POST['brew_preboil_sg']; |
| 82 $sql .= "', brew_aboil_sg='" . $_POST['brew_aboil_sg']; | 82 $sql .= "', brew_preboil_ph='" . $_POST['brew_preboil_ph']; |
| 83 $sql .= "', brew_aboil_ph='" . $_POST['brew_aboil_ph']; | 83 $sql .= "', brew_aboil_volume='" . $_POST['brew_aboil_volume']; |
| 84 $sql .= "', brew_aboil_efficiency='" . $_POST['brew_aboil_efficiency']; | 84 $sql .= "', brew_aboil_sg='" . $_POST['brew_aboil_sg']; |
| 85 $sql .= "', brew_cooling_method='" . $_POST['brew_cooling_method']; | 85 $sql .= "', brew_aboil_ph='" . $_POST['brew_aboil_ph']; |
| 86 $sql .= "', brew_cooling_time='" . $_POST['brew_cooling_time']; | 86 $sql .= "', brew_aboil_efficiency='" . $_POST['brew_aboil_efficiency']; |
| 87 $sql .= "', brew_cooling_to='" . $_POST['brew_cooling_to']; | 87 $sql .= "', brew_cooling_method='" . $_POST['brew_cooling_method']; |
| 88 $sql .= "', brew_whirlpool9='" . $_POST['brew_whirlpool9']; | 88 $sql .= "', brew_cooling_time='" . $_POST['brew_cooling_time']; |
| 89 $sql .= "', brew_whirlpool7='" . $_POST['brew_whirlpool7']; | 89 $sql .= "', brew_cooling_to='" . $_POST['brew_cooling_to']; |
| 90 $sql .= "', brew_whirlpool6='" . $_POST['brew_whirlpool6']; | 90 $sql .= "', brew_whirlpool9='" . $_POST['brew_whirlpool9']; |
| 91 $sql .= "', brew_whirlpool2='" . $_POST['brew_whirlpool2']; | 91 $sql .= "', brew_whirlpool7='" . $_POST['brew_whirlpool7']; |
| 92 $sql .= "', brew_aeration_time='" . $_POST['brew_aeration_time']; | 92 $sql .= "', brew_whirlpool6='" . $_POST['brew_whirlpool6']; |
| 93 $sql .= "', brew_aeration_speed='" . $_POST['brew_aeration_speed']; | 93 $sql .= "', brew_whirlpool2='" . $_POST['brew_whirlpool2']; |
| 94 $sql .= "', brew_aeration_type='" . $_POST['brew_aeration_type']; | 94 $sql .= "', brew_aeration_time='" . $_POST['brew_aeration_time']; |
| 95 $sql .= "', brew_fermenter_volume='" . $_POST['brew_fermenter_volume']; | 95 $sql .= "', brew_aeration_speed='" . $_POST['brew_aeration_speed']; |
| 96 $sql .= "', brew_fermenter_extrawater='" . $_POST['brew_fermenter_extrawater']; | 96 $sql .= "', brew_aeration_type='" . $_POST['brew_aeration_type']; |
| 97 $sql .= "', brew_fermenter_sg='" . $_POST['brew_fermenter_sg']; | 97 $sql .= "', brew_fermenter_volume='" . $_POST['brew_fermenter_volume']; |
| 98 $sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu']; | 98 $sql .= "', brew_fermenter_extrawater='" . $_POST['brew_fermenter_extrawater']; |
| 99 $sql .= "', brew_date_end='" . $_POST['brew_date_end']; | 99 $sql .= "', brew_fermenter_sg='" . $_POST['brew_fermenter_sg']; |
| 100 ($_POST['brew_log_available'] == 'true') ? $sql .= "', brew_log_available='1" : $sql .= "', brew_log_available='0"; | 100 $sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu']; |
| 101 $sql .= "', brew_date_end='" . $_POST['brew_date_end']; | |
| 102 ($_POST['brew_log_available'] == 'true') ? $sql .= "', brew_log_available='1" : $sql .= "', brew_log_available='0"; | |
| 103 } | |
| 101 $sql .= "', og='" . $_POST['og']; | 104 $sql .= "', og='" . $_POST['og']; |
| 102 $sql .= "', fg='" . $_POST['fg']; | 105 $sql .= "', fg='" . $_POST['fg']; |
| 103 $sql .= "', primary_start_temp='" . $_POST['primary_start_temp']; | 106 |
| 104 $sql .= "', primary_max_temp='" . $_POST['primary_max_temp']; | 107 if ($stage > 2) { |
| 105 $sql .= "', primary_end_temp='" . $_POST['primary_end_temp']; | 108 $sql .= "', primary_start_temp='" . $_POST['primary_start_temp']; |
| 106 $sql .= "', primary_end_sg='" . $_POST['primary_end_sg']; | 109 $sql .= "', primary_max_temp='" . $_POST['primary_max_temp']; |
| 107 $sql .= "', primary_end_date='" . $_POST['primary_end_date']; | 110 $sql .= "', primary_end_temp='" . $_POST['primary_end_temp']; |
| 108 $sql .= "', secondary_temp='" . $_POST['secondary_temp']; | 111 $sql .= "', primary_end_sg='" . $_POST['primary_end_sg']; |
| 109 $sql .= "', secondary_end_date='" . $_POST['secondary_end_date']; | 112 $sql .= "', primary_end_date='" . $_POST['primary_end_date']; |
| 110 $sql .= "', tertiary_temp='" . $_POST['tertiary_temp']; | 113 } |
| 111 $sql .= "', package_date='" . $_POST['package_date']; | 114 |
| 112 $sql .= "', bottle_amount='" . $_POST['bottle_amount']; | 115 if ($stage > 3) { |
| 113 $sql .= "', bottle_carbonation='" . $_POST['bottle_carbonation']; | 116 $sql .= "', secondary_temp='" . $_POST['secondary_temp']; |
| 114 $sql .= "', bottle_priming_sugar='" . $_POST['bottle_priming_sugar']; | 117 $sql .= "', secondary_end_date='" . $_POST['secondary_end_date']; |
| 115 $sql .= "', bottle_priming_amount='" . $_POST['bottle_priming_amount']; | 118 $sql .= "', tertiary_temp='" . $_POST['tertiary_temp']; |
| 116 $sql .= "', bottle_carbonation_temp='" . $_POST['bottle_carbonation_temp']; | 119 } |
| 117 $sql .= "', keg_amount='" . $_POST['keg_amount']; | 120 |
| 118 $sql .= "', keg_carbonation='" . $_POST['keg_carbonation']; | 121 if ($stage > 4) { |
| 119 $sql .= "', keg_priming_sugar='" . $_POST['keg_priming_sugar']; | 122 $sql .= "', package_date='" . $_POST['package_date']; |
| 120 $sql .= "', keg_priming_amount='" . $_POST['keg_priming_amount']; | 123 $sql .= "', bottle_amount='" . $_POST['bottle_amount']; |
| 121 $sql .= "', keg_carbonation_temp='" . $_POST['keg_carbonation_temp']; | 124 $sql .= "', bottle_carbonation='" . $_POST['bottle_carbonation']; |
| 122 ($_POST['keg_forced_carb'] == 'true') ? $sql .= "', keg_forced_carb='1" : $sql .= "', keg_forced_carb='0"; | 125 $sql .= "', bottle_priming_sugar='" . $_POST['bottle_priming_sugar']; |
| 123 $sql .= "', keg_pressure='" . $_POST['keg_pressure']; | 126 $sql .= "', bottle_priming_amount='" . $_POST['bottle_priming_amount']; |
| 124 $sql .= "', taste_notes='" . mysqli_real_escape_string($connect, $_POST['taste_notes']); | 127 $sql .= "', bottle_carbonation_temp='" . $_POST['bottle_carbonation_temp']; |
| 125 $sql .= "', taste_rate='" . $_POST['taste_rate']; | 128 $sql .= "', keg_amount='" . $_POST['keg_amount']; |
| 126 $sql .= "', taste_date='" . $_POST['taste_date']; | 129 $sql .= "', keg_carbonation='" . $_POST['keg_carbonation']; |
| 127 $sql .= "', taste_color='" . mysqli_real_escape_string($connect, $_POST['taste_color']); | 130 $sql .= "', keg_priming_sugar='" . $_POST['keg_priming_sugar']; |
| 128 $sql .= "', taste_transparency='" . mysqli_real_escape_string($connect, $_POST['taste_transparency']); | 131 $sql .= "', keg_priming_amount='" . $_POST['keg_priming_amount']; |
| 129 $sql .= "', taste_head='" . mysqli_real_escape_string($connect, $_POST['taste_head']); | 132 $sql .= "', keg_carbonation_temp='" . $_POST['keg_carbonation_temp']; |
| 130 $sql .= "', taste_aroma='" . mysqli_real_escape_string($connect, $_POST['taste_aroma']); | 133 ($_POST['keg_forced_carb'] == 'true') ? $sql .= "', keg_forced_carb='1" : $sql .= "', keg_forced_carb='0"; |
| 131 $sql .= "', taste_taste='" . mysqli_real_escape_string($connect, $_POST['taste_taste']); | 134 $sql .= "', keg_pressure='" . $_POST['keg_pressure']; |
| 132 $sql .= "', taste_mouthfeel='" . mysqli_real_escape_string($connect, $_POST['taste_mouthfeel']); | 135 } |
| 133 $sql .= "', taste_aftertaste='" . mysqli_real_escape_string($connect, $_POST['taste_aftertaste']); | 136 |
| 137 if ($stage > 8) { | |
| 138 $sql .= "', taste_notes='" . mysqli_real_escape_string($connect, $_POST['taste_notes']); | |
| 139 $sql .= "', taste_rate='" . $_POST['taste_rate']; | |
| 140 $sql .= "', taste_date='" . $_POST['taste_date']; | |
| 141 $sql .= "', taste_color='" . mysqli_real_escape_string($connect, $_POST['taste_color']); | |
| 142 $sql .= "', taste_transparency='" . mysqli_real_escape_string($connect, $_POST['taste_transparency']); | |
| 143 $sql .= "', taste_head='" . mysqli_real_escape_string($connect, $_POST['taste_head']); | |
| 144 $sql .= "', taste_aroma='" . mysqli_real_escape_string($connect, $_POST['taste_aroma']); | |
| 145 $sql .= "', taste_taste='" . mysqli_real_escape_string($connect, $_POST['taste_taste']); | |
| 146 $sql .= "', taste_mouthfeel='" . mysqli_real_escape_string($connect, $_POST['taste_mouthfeel']); | |
| 147 $sql .= "', taste_aftertaste='" . mysqli_real_escape_string($connect, $_POST['taste_aftertaste']); | |
| 148 } | |
| 134 | 149 |
| 135 /* | 150 /* |
| 136 * Recipe part | 151 * Recipe part |
| 137 */ | 152 */ |
| 138 $sql .= "', st_name='" . mysqli_real_escape_string($connect, $_POST['st_name']); | 153 $sql .= "', st_name='" . mysqli_real_escape_string($connect, $_POST['st_name']); |
