www/import/from_brouwhulp.php

changeset 30
f5ab22446aa5
parent 29
a12d0a4d621e
child 32
8bb369f32ef9
equal deleted inserted replaced
29:a12d0a4d621e 30:f5ab22446aa5
116 $sql .= "', notes='" . mysqli_real_escape_string($db, $hop->NOTES); 116 $sql .= "', notes='" . mysqli_real_escape_string($db, $hop->NOTES);
117 $sql .= "', origin='" . mysqli_real_escape_string($db, $hop->ORIGIN); 117 $sql .= "', origin='" . mysqli_real_escape_string($db, $hop->ORIGIN);
118 $sql .= "', substitutes='" . mysqli_real_escape_string($db, $hop->SUBSTITUTES); 118 $sql .= "', substitutes='" . mysqli_real_escape_string($db, $hop->SUBSTITUTES);
119 ($hop->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; 119 ($hop->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0";
120 if ($hop->INVENTORY) 120 if ($hop->INVENTORY)
121 $sql .= "', inventory='" . $hop->INVENTORY; 121 $sql .= "', inventory='" . $hop->INVENTORY / 1000.0;
122 if ($hop->COST) 122 if ($hop->COST)
123 $sql .= "', cost='" . $hop->COST; 123 $sql .= "', cost='" . $hop->COST;
124 if ($hop->TOTAL_OIL) 124 if ($hop->TOTAL_OIL)
125 $sql .= "', total_oil='" . $hop->TOTAL_OIL; 125 $sql .= "', total_oil='" . $hop->TOTAL_OIL;
126 $sql .= "';"; 126 $sql .= "';";
431 } 431 }
432 } 432 }
433 433
434 434
435 435
436 //do_fermentables(); 436 do_fermentables();
437 //do_hops(); 437 do_hops();
438 //do_yeasts(); 438 //do_yeasts();
439 //do_miscs(); 439 //do_miscs();
440 //do_waters(); 440 //do_waters();
441 //do_equipments(); 441 //do_equipments();
442 do_styles(); 442 do_styles();

mercurial