www/import/from_brouwhulp.php

changeset 105
d06ddc4d1af0
parent 104
0c6ad9e0f143
child 106
c64d979613ab
equal deleted inserted replaced
104:0c6ad9e0f143 105:d06ddc4d1af0
475 $boil_size = 22; 475 $boil_size = 22;
476 $pCara = 0; 476 $pCara = 0;
477 $pSugar = 0; 477 $pSugar = 0;
478 $svg = 77; 478 $svg = 77;
479 $colorw = 0; 479 $colorw = 0;
480 $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid'));
480 481
481 if ($brews) 482 if ($brews)
482 $sql = "INSERT INTO production SET name='" . mysqli_real_escape_string($db, $recipe->NAME); 483 $sql = "INSERT INTO brews SET uuid='" . $uuid;
483 else 484 else
484 $sql = "INSERT INTO recipes SET name='" . mysqli_real_escape_string($db, $recipe->NAME); 485 $sql = "INSERT INTO recipes SET uuid='" . $uuid;
486 $sql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME);
487 $sql .= "', locked='0";
485 if ($recipe->NOTES) 488 if ($recipe->NOTES)
486 $sql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES); 489 $sql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES);
487 else 490 else
488 $sql .= "', notes='"; 491 $sql .= "', notes='";
489 if ($recipe->TYPE) 492 if ($recipe->TYPE)

mercurial