Mercurial > bms / file diff

--- a/www/upl_styles.php	Sun Sep 12 20:35:04 2021 +0200
+++ b/www/upl_styles.php	Sat Sep 25 10:42:54 2021 +0200
@@ -56,8 +56,12 @@
 		$sql .= "', notes='" . mysqli_real_escape_string($db, $style->NOTES);
 	if ($style->CATEGORY)
 		$sql .= "', category='" . mysqli_real_escape_string($db, $style->CATEGORY);
-	if ($style->CATEGORY_NUMBER)
-		$sql .= "', category_number='" . $style->CATEGORY_NUMBER;
+	if ($style->CATEGORY_NUMBER) {
+		if (strlen($style->CATEGORY_NUMBER))
+			$sql .= "', category_number='" . $style->CATEGORY_NUMBER;
+		else
+			$sql .= "', category_number='0";
+	}
 	if ($style->STYLE_LETTER)
 		$sql .= "', style_letter='" . mysqli_real_escape_string($db, $style->STYLE_LETTER);
 	if ($style->STYLE_GUIDE)