980 $rsql = "INSERT INTO prod_recipes SET uuid='" . $uuid; |
980 $rsql = "INSERT INTO prod_recipes SET uuid='" . $uuid; |
981 |
981 |
982 $psql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME); |
982 $psql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME); |
983 $rsql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME); |
983 $rsql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME); |
984 |
984 |
985 if ($recipe->NOTES) |
985 if ($recipe->NOTES) { |
986 $rsql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); |
986 $rsql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); // Duplicate the notes |
987 else |
987 $psql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); |
988 $rsql .= "', notes='"; |
988 } else { |
|
989 $rsql .= "', notes='"; |
|
990 $psql .= "', notes='"; |
|
991 } |
989 if ($recipe->TYPE) |
992 if ($recipe->TYPE) |
990 $rsql .= "', type='" . mysqli_real_escape_string($db, $recipe->TYPE); |
993 $rsql .= "', type='" . mysqli_real_escape_string($db, $recipe->TYPE); |
991 else |
994 else |
992 $rsql .= "', type='"; |
995 $rsql .= "', type='"; |
993 if ($recipe->BATCH_SIZE) |
996 if ($recipe->BATCH_SIZE) |
1147 $psql .= "', log_fermentation='1"; |
1150 $psql .= "', log_fermentation='1"; |
1148 } |
1151 } |
1149 |
1152 |
1150 if ($recipe->EQUIPMENT) { |
1153 if ($recipe->EQUIPMENT) { |
1151 $psql .= "', eq_name='" . mysqli_real_escape_string($db, $recipe->EQUIPMENT->NAME); |
1154 $psql .= "', eq_name='" . mysqli_real_escape_string($db, $recipe->EQUIPMENT->NAME); |
|
1155 $psql .= "', eq_notes='" . mysqli_real_escape_string($db, $recipe->EQUIPMENT->NOTES); |
1152 $psql .= "', eq_boil_size='" . floatval($recipe->EQUIPMENT->BOIL_SIZE); |
1156 $psql .= "', eq_boil_size='" . floatval($recipe->EQUIPMENT->BOIL_SIZE); |
1153 $psql .= "', eq_batch_size='" . floatval($recipe->EQUIPMENT->BATCH_SIZE); |
1157 $psql .= "', eq_batch_size='" . floatval($recipe->EQUIPMENT->BATCH_SIZE); |
1154 $psql .= "', eq_tun_volume='" . floatval($recipe->EQUIPMENT->TUN_VOLUME); |
1158 $psql .= "', eq_tun_volume='" . floatval($recipe->EQUIPMENT->TUN_VOLUME); |
1155 $psql .= "', eq_tun_weight='" . floatval($recipe->EQUIPMENT->TUN_WEIGHT); |
1159 $psql .= "', eq_tun_weight='" . floatval($recipe->EQUIPMENT->TUN_WEIGHT); |
1156 $psql .= "', eq_tun_specific_heat='" . floatval($recipe->EQUIPMENT->TUN_SPECIFIC_HEAT); |
1160 $psql .= "', eq_tun_specific_heat='" . floatval($recipe->EQUIPMENT->TUN_SPECIFIC_HEAT); |