www/upl_recipe.php

changeset 709
e251cceec547
parent 308
a59413ba4057
equal deleted inserted replaced
708:60d28976286c 709:e251cceec547
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')

mercurial