Added uuid and locked fields to the recipes table.

Mon, 19 Nov 2018 13:44:07 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Mon, 19 Nov 2018 13:44:07 +0100
changeset 105
d06ddc4d1af0
parent 104
0c6ad9e0f143
child 106
c64d979613ab

Added uuid and locked fields to the recipes table.

www/import/from_brouwhulp.php file | annotate | diff | comparison | revisions
--- a/www/import/from_brouwhulp.php	Sun Nov 18 22:15:31 2018 +0100
+++ b/www/import/from_brouwhulp.php	Mon Nov 19 13:44:07 2018 +0100
@@ -477,11 +477,14 @@
 		$pSugar = 0;
 		$svg = 77;
 		$colorw = 0;
+		$uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid'));
 
 		if ($brews)
-			$sql  = "INSERT INTO production SET name='" . mysqli_real_escape_string($db, $recipe->NAME);
+			$sql  = "INSERT INTO brews SET uuid='" . $uuid;
 		else
-			$sql  = "INSERT INTO recipes SET name='" . mysqli_real_escape_string($db, $recipe->NAME);
+			$sql  = "INSERT INTO recipes SET uuid='" . $uuid;
+		$sql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME);
+		$sql .= "', locked='0";
 		if ($recipe->NOTES)
 			$sql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES);
 		else

mercurial