comparison: www/import/from_brouwhulp.php
www/import/from_brouwhulp.php
- changeset 20
- 22271f3598ac
- parent 15
- ccbe79db80b8
- child 21
- acb2d8098f19
equal
deleted
inserted
replaced
| 19:057a6256bd7b | 20:22271f3598ac |
|---|---|
| 148 foreach ($yeasts->YEAST as $yeast) { | 148 foreach ($yeasts->YEAST as $yeast) { |
| 149 | 149 |
| 150 $sql = "INSERT INTO inventory_yeasts SET name='" . mysqli_real_escape_string($db, $yeast->NAME); | 150 $sql = "INSERT INTO inventory_yeasts SET name='" . mysqli_real_escape_string($db, $yeast->NAME); |
| 151 $sql .= "', type='" . $yeast->TYPE; | 151 $sql .= "', type='" . $yeast->TYPE; |
| 152 $sql .= "', form='" . $yeast->FORM; | 152 $sql .= "', form='" . $yeast->FORM; |
| 153 if ($yeast->AMOUNT) | |
| 154 $sql .= "', amount='" . $yeast->AMOUNT; | |
| 155 ($yeast->AMOUNT_IS_WEIGHT == 'TRUE') ? $sql .= "', amount_is_weight='Y" : $sql .= "', amount_is_weight='N"; | |
| 156 $sql .= "', laboratory='" . mysqli_real_escape_string($db, $yeast->LABORATORY); | 153 $sql .= "', laboratory='" . mysqli_real_escape_string($db, $yeast->LABORATORY); |
| 157 $sql .= "', product_id='" . mysqli_real_escape_string($db, $yeast->PRODUCT_ID); | 154 $sql .= "', product_id='" . mysqli_real_escape_string($db, $yeast->PRODUCT_ID); |
| 158 if ($yeast->MIN_TEMPERATURE) | 155 if ($yeast->MIN_TEMPERATURE) |
| 159 $sql .= "', min_temperature='" . $yeast->MIN_TEMPERATURE; | 156 $sql .= "', min_temperature='" . $yeast->MIN_TEMPERATURE; |
| 160 if ($yeast->MAX_TEMPERATURE) | 157 if ($yeast->MAX_TEMPERATURE) |
| 162 $sql .= "', flocculation='" . $yeast->FLOCCULATION; | 159 $sql .= "', flocculation='" . $yeast->FLOCCULATION; |
| 163 if ($yeast->ATTENUATION) | 160 if ($yeast->ATTENUATION) |
| 164 $sql .= "', attenuation='" . $yeast->ATTENUATION; | 161 $sql .= "', attenuation='" . $yeast->ATTENUATION; |
| 165 $sql .= "', notes='" . mysqli_real_escape_string($db, $yeast->NOTES); | 162 $sql .= "', notes='" . mysqli_real_escape_string($db, $yeast->NOTES); |
| 166 $sql .= "', best_for='" . mysqli_real_escape_string($db, $yeast->BEST_FOR); | 163 $sql .= "', best_for='" . mysqli_real_escape_string($db, $yeast->BEST_FOR); |
| 167 if ($yeast->TIMES_CULTURED) | |
| 168 $sql .= "', times_cultured='" . $yeast->TIMES_CULTURED; | |
| 169 if ($yeast->MAX_REUSE) | 164 if ($yeast->MAX_REUSE) |
| 170 $sql .= "', max_reuse='" . $yeast->MAX_REUSE; | 165 $sql .= "', max_reuse='" . $yeast->MAX_REUSE; |
| 171 if ($yeast->INVENTORY) | 166 if ($yeast->INVENTORY) |
| 172 $sql .= "', inventory='" . $yeast->INVENTORY; | 167 $sql .= "', inventory='" . $yeast->INVENTORY; |
| 173 if ($yeast->COST) | 168 if ($yeast->COST) |
| 457 | 452 |
| 458 | 453 |
| 459 | 454 |
| 460 //do_fermentables(); | 455 //do_fermentables(); |
| 461 //do_hops(); | 456 //do_hops(); |
| 462 //do_yeasts(); | 457 do_yeasts(); |
| 463 do_waters(); | 458 //do_waters(); |
| 464 //do_miscs(); | 459 //do_miscs(); |
| 465 //do_equipments(); | 460 //do_equipments(); |
| 466 //do_styles(); | 461 //do_styles(); |
| 467 //do_mash(); | 462 //do_mash(); |
| 468 | 463 |
