www/import/from_brouwhulp.php

changeset 217
318aab371497
parent 213
b0d484a5525e
child 220
14e349ff2a10
equal deleted inserted replaced
216:fda7286871f2 217:318aab371497
513 $sql .= "', category_number='" . $style->CATEGORY_NUMBER; 513 $sql .= "', category_number='" . $style->CATEGORY_NUMBER;
514 if ($style->STYLE_LETTER) 514 if ($style->STYLE_LETTER)
515 $sql .= "', style_letter='" . mysqli_real_escape_string($db, $style->STYLE_LETTER); 515 $sql .= "', style_letter='" . mysqli_real_escape_string($db, $style->STYLE_LETTER);
516 if ($style->STYLE_GUIDE) 516 if ($style->STYLE_GUIDE)
517 $sql .= "', style_guide='" . mysqli_real_escape_string($db, $style->STYLE_GUIDE); 517 $sql .= "', style_guide='" . mysqli_real_escape_string($db, $style->STYLE_GUIDE);
518 $sql .= "', type='" . $style->TYPE; 518
519 if ($style->TYPE == 'Lager')
520 $sql .= "', type='0";
521 else if ($style->TYPE == 'Ale')
522 $sql .= "', type='1";
523 else if ($style->TYPE == 'Mead')
524 $sql .= "', type='2";
525 else if ($style->TYPE == 'Wheat')
526 $sql .= "', type='3";
527 else if ($style->TYPE == 'Mixed')
528 $sql .= "', type='4";
529 else if ($style->TYPE == 'Cider')
530 $sql .= "', type='5";
531 else
532 echo "Unknown TYPE " . $style->TYPE . PHP_EOL;
533
519 $sql .= "', og_min='" . floatval($style->OG_MIN); 534 $sql .= "', og_min='" . floatval($style->OG_MIN);
520 $sql .= "', og_max='" . floatval($style->OG_MAX); 535 $sql .= "', og_max='" . floatval($style->OG_MAX);
521 $sql .= "', fg_min='" . floatval($style->FG_MIN); 536 $sql .= "', fg_min='" . floatval($style->FG_MIN);
522 $sql .= "', fg_max='" . floatval($style->FG_MAX); 537 $sql .= "', fg_max='" . floatval($style->FG_MAX);
523 $sql .= "', ibu_min='" . floatval($style->IBU_MIN); 538 $sql .= "', ibu_min='" . floatval($style->IBU_MIN);
629 } 644 }
630 if ($recipe->STYLE->CATEGORY) 645 if ($recipe->STYLE->CATEGORY)
631 $sql .= "', st_category='" . mysqli_real_escape_string($db, $recipe->STYLE->CATEGORY); 646 $sql .= "', st_category='" . mysqli_real_escape_string($db, $recipe->STYLE->CATEGORY);
632 if ($recipe->STYLE->CATEGORY_NUMBER) 647 if ($recipe->STYLE->CATEGORY_NUMBER)
633 $sql .= "', st_category_number='" . floatval($recipe->STYLE->CATEGORY_NUMBER); 648 $sql .= "', st_category_number='" . floatval($recipe->STYLE->CATEGORY_NUMBER);
634 if ($recipe->STYLE->TYPE) 649 if ($recipe->STYLE->TYPE == 'Lager')
635 $sql .= "', st_type='" . mysqli_real_escape_string($db, $recipe->STYLE->TYPE); 650 $sql .= "', st_type='0";
651 else if ($recipe->STYLE->TYPE == 'Ale')
652 $sql .= "', st_type='1";
653 else if ($recipe->STYLE->TYPE == 'Mead')
654 $sql .= "', st_type='2";
655 else if ($recipe->STYLE->TYPE == 'Wheat')
656 $sql .= "', st_type='3";
657 else if ($recipe->STYLE->TYPE == 'Mixed')
658 $sql .= "', st_type='4";
659 else if ($recipe->STYLE->TYPE == 'Cider')
660 $sql .= "', st_type='5";
661 else
662 echo "Unknown TYPE " . $recipe->STYLE->TYPE . PHP_EOL;
663
636 if ($recipe->STYLE->OG_MIN) 664 if ($recipe->STYLE->OG_MIN)
637 $sql .= "', st_og_min='" . floatval($recipe->STYLE->OG_MIN); 665 $sql .= "', st_og_min='" . floatval($recipe->STYLE->OG_MIN);
638 if ($recipe->STYLE->OG_MAX) 666 if ($recipe->STYLE->OG_MAX)
639 $sql .= "', st_og_max='" . floatval($recipe->STYLE->OG_MAX); 667 $sql .= "', st_og_max='" . floatval($recipe->STYLE->OG_MAX);
640 if ($recipe->STYLE->FG_MIN) 668 if ($recipe->STYLE->FG_MIN)

mercurial