Mercurial > bms / file diff

--- 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)