diff -r fda7286871f2 -r 318aab371497 www/import/from_brouwhulp.php --- a/www/import/from_brouwhulp.php Sun Jan 27 17:39:53 2019 +0100 +++ b/www/import/from_brouwhulp.php Sun Jan 27 20:40:24 2019 +0100 @@ -515,7 +515,22 @@ $sql .= "', style_letter='" . mysqli_real_escape_string($db, $style->STYLE_LETTER); if ($style->STYLE_GUIDE) $sql .= "', style_guide='" . mysqli_real_escape_string($db, $style->STYLE_GUIDE); - $sql .= "', type='" . $style->TYPE; + + if ($style->TYPE == 'Lager') + $sql .= "', type='0"; + else if ($style->TYPE == 'Ale') + $sql .= "', type='1"; + else if ($style->TYPE == 'Mead') + $sql .= "', type='2"; + else if ($style->TYPE == 'Wheat') + $sql .= "', type='3"; + else if ($style->TYPE == 'Mixed') + $sql .= "', type='4"; + else if ($style->TYPE == 'Cider') + $sql .= "', type='5"; + else + echo "Unknown TYPE " . $style->TYPE . PHP_EOL; + $sql .= "', og_min='" . floatval($style->OG_MIN); $sql .= "', og_max='" . floatval($style->OG_MAX); $sql .= "', fg_min='" . floatval($style->FG_MIN); @@ -631,8 +646,21 @@ $sql .= "', st_category='" . mysqli_real_escape_string($db, $recipe->STYLE->CATEGORY); if ($recipe->STYLE->CATEGORY_NUMBER) $sql .= "', st_category_number='" . floatval($recipe->STYLE->CATEGORY_NUMBER); - if ($recipe->STYLE->TYPE) - $sql .= "', st_type='" . mysqli_real_escape_string($db, $recipe->STYLE->TYPE); + if ($recipe->STYLE->TYPE == 'Lager') + $sql .= "', st_type='0"; + else if ($recipe->STYLE->TYPE == 'Ale') + $sql .= "', st_type='1"; + else if ($recipe->STYLE->TYPE == 'Mead') + $sql .= "', st_type='2"; + else if ($recipe->STYLE->TYPE == 'Wheat') + $sql .= "', st_type='3"; + else if ($recipe->STYLE->TYPE == 'Mixed') + $sql .= "', st_type='4"; + else if ($recipe->STYLE->TYPE == 'Cider') + $sql .= "', st_type='5"; + else + echo "Unknown TYPE " . $recipe->STYLE->TYPE . PHP_EOL; + if ($recipe->STYLE->OG_MIN) $sql .= "', st_og_min='" . floatval($recipe->STYLE->OG_MIN); if ($recipe->STYLE->OG_MAX)