comparison: www/import/from_brouwhulp.php
www/import/from_brouwhulp.php
- changeset 22
- 99c02fa797f9
- parent 21
- acb2d8098f19
- child 23
- 4b157d7a1cee
equal
deleted
inserted
replaced
| 21:acb2d8098f19 | 22:99c02fa797f9 |
|---|---|
| 201 if (($water->NAME == "Gedemineraliseerd water") || ($water->NAME == "Cristalline") || ($water->NAME == "Montille (Delhaize)") || | 201 if (($water->NAME == "Gedemineraliseerd water") || ($water->NAME == "Cristalline") || ($water->NAME == "Montille (Delhaize)") || |
| 202 ($water->NAME == "Spa Reine") || ($water->NAME == "Velsen") || ($water->NAME == "Zutphen") || | 202 ($water->NAME == "Spa Reine") || ($water->NAME == "Velsen") || ($water->NAME == "Zutphen") || |
| 203 ($water->NAME == "Aurele Bronwater (Colruyt)")) { | 203 ($water->NAME == "Aurele Bronwater (Colruyt)")) { |
| 204 $sql = "INSERT INTO inventory_water_sources SET name='" . mysqli_real_escape_string($db, $water->NAME); | 204 $sql = "INSERT INTO inventory_water_sources SET name='" . mysqli_real_escape_string($db, $water->NAME); |
| 205 ($water->DEFAULT_WATER == 'TRUE') ? $sql .= "', default_water='1" : $sql .= "', default_water='0"; | 205 ($water->DEFAULT_WATER == 'TRUE') ? $sql .= "', default_water='1" : $sql .= "', default_water='0"; |
| 206 ($water->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | |
| 206 } else { | 207 } else { |
| 207 $sql = "INSERT INTO inventory_water_profiles SET name='" . mysqli_real_escape_string($db, $water->NAME); | 208 $sql = "INSERT INTO inventory_water_profiles SET name='" . mysqli_real_escape_string($db, $water->NAME); |
| 208 } | 209 } |
| 209 | 210 |
| 210 ($water->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | |
| 211 if ($water->NOTES) | 211 if ($water->NOTES) |
| 212 $sql .= "', notes='" . mysqli_real_escape_string($db, $water->NOTES); | 212 $sql .= "', notes='" . mysqli_real_escape_string($db, $water->NOTES); |
| 213 $sql .= "', calcium='" . $water->CALCIUM; | 213 $sql .= "', calcium='" . $water->CALCIUM; |
| 214 $sql .= "', bicarbonate='" . $water->BICARBONATE; | 214 $sql .= "', bicarbonate='" . $water->BICARBONATE; |
| 215 $sql .= "', sulfate='" . $water->SULFATE; | 215 $sql .= "', sulfate='" . $water->SULFATE; |
