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) |