77 $sql = "', st_name='" . mysqli_real_escape_string($db, $recipe->STYLE->NAME); |
77 $sql = "', st_name='" . mysqli_real_escape_string($db, $recipe->STYLE->NAME); |
78 if ($recipe->STYLE->STYLE_LETTER) |
78 if ($recipe->STYLE->STYLE_LETTER) |
79 $sql .= "', st_letter='" . mysqli_real_escape_string($db, $recipe->STYLE->STYLE_LETTER); |
79 $sql .= "', st_letter='" . mysqli_real_escape_string($db, $recipe->STYLE->STYLE_LETTER); |
80 if ($recipe->STYLE->STYLE_GUIDE) { |
80 if ($recipe->STYLE->STYLE_GUIDE) { |
81 if ($recipe->STYLE->STYLE_GUIDE == "Biertypengids Derek Walsh") { |
81 if ($recipe->STYLE->STYLE_GUIDE == "Biertypengids Derek Walsh") { |
82 $sql .= "', st_guide='BKG 2015"; |
82 $sql .= "', st_guide='BKG 2019"; |
83 } else if ($recipe->STYLE->STYLE_GUIDE == "BKG Biertypen") { |
83 } else if ($recipe->STYLE->STYLE_GUIDE == "BKG Biertypen") { |
84 $sql .= "', st_guide='BKG 2015"; |
84 $sql .= "', st_guide='BKG 2019"; |
|
85 } else if ($recipe->STYLE->STYLE_GUIDE == "BKG 2015") { |
|
86 $sql .= "', st_guide='BKG 2019"; |
85 } else { |
87 } else { |
86 $sql .= "', st_guide='" . mysqli_real_escape_string($db, $recipe->STYLE->STYLE_GUIDE); |
88 $sql .= "', st_guide='" . mysqli_real_escape_string($db, $recipe->STYLE->STYLE_GUIDE); |
87 } |
89 } |
|
90 } else { |
|
91 $sql .= "', st_guide='BKG 2019"; |
88 } |
92 } |
89 if ($recipe->STYLE->CATEGORY) |
93 if ($recipe->STYLE->CATEGORY) |
90 $sql .= "', st_category='" . mysqli_real_escape_string($db, $recipe->STYLE->CATEGORY); |
94 $sql .= "', st_category='" . mysqli_real_escape_string($db, $recipe->STYLE->CATEGORY); |
91 if ($recipe->STYLE->CATEGORY_NUMBER) |
95 if ($recipe->STYLE->CATEGORY_NUMBER) |
92 $sql .= "', st_category_number='" . floatval($recipe->STYLE->CATEGORY_NUMBER); |
96 $sql .= "', st_category_number='" . floatval($recipe->STYLE->CATEGORY_NUMBER); |
|
97 else |
|
98 $sql .= "', st_category_number='0"; |
93 if ($recipe->STYLE->TYPE == 'Lager') |
99 if ($recipe->STYLE->TYPE == 'Lager') |
94 $sql .= "', st_type='0"; |
100 $sql .= "', st_type='0"; |
95 else if (($recipe->STYLE->TYPE == 'Ale') || ($recipe->STYLE->TYPE == 'Strong Ale')) |
101 else if (($recipe->STYLE->TYPE == 'Ale') || ($recipe->STYLE->TYPE == 'Strong Ale')) |
96 $sql .= "', st_type='1"; |
102 $sql .= "', st_type='1"; |
97 else if ($recipe->STYLE->TYPE == 'Mead') |
103 else if ($recipe->STYLE->TYPE == 'Mead') |