www/import/from_brouwhulp.php

changeset 111
8c4ba91adf58
parent 108
a466373bc23f
child 114
4935e86b2775
equal deleted inserted replaced
110:0f128201a031 111:8c4ba91adf58
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);

mercurial