Mercurial > bms / changeset

--- a/www/upl_recipe.php	Fri Jul 31 15:58:30 2020 +0200
+++ b/www/upl_recipe.php	Fri Aug 14 11:38:58 2020 +0200
@@ -79,17 +79,23 @@
 		$sql .= "', st_letter='" . mysqli_real_escape_string($db, $recipe->STYLE->STYLE_LETTER);
 	if ($recipe->STYLE->STYLE_GUIDE) {
 		if ($recipe->STYLE->STYLE_GUIDE == "Biertypengids Derek Walsh") {
-			$sql .= "', st_guide='BKG 2015";
+			$sql .= "', st_guide='BKG 2019";
 		} else if ($recipe->STYLE->STYLE_GUIDE == "BKG Biertypen") {
-			$sql .= "', st_guide='BKG 2015";
+			$sql .= "', st_guide='BKG 2019";
+		} else if ($recipe->STYLE->STYLE_GUIDE == "BKG 2015") {
+			$sql .= "', st_guide='BKG 2019";
 		} else {
 			$sql .= "', st_guide='" . mysqli_real_escape_string($db, $recipe->STYLE->STYLE_GUIDE);
 		}
+	} else {
+		$sql .= "', st_guide='BKG 2019";
 	}
 	if ($recipe->STYLE->CATEGORY)
 		$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);
+	else
+		$sql .= "', st_category_number='0";
 	if ($recipe->STYLE->TYPE == 'Lager')
 		$sql .= "', st_type='0";
 	else if (($recipe->STYLE->TYPE == 'Ale') || ($recipe->STYLE->TYPE == 'Strong Ale'))