diff -r 578c78abf058 -r dc30801e6961 www/import/from_brouwhulp.php --- a/www/import/from_brouwhulp.php Sat Jan 26 11:59:15 2019 +0100 +++ b/www/import/from_brouwhulp.php Sat Jan 26 15:03:09 2019 +0100 @@ -447,7 +447,16 @@ $sql .= "', tun_volume='" . floatval($equipment->TUN_VOLUME); $sql .= "', tun_weight='" . floatval($equipment->TUN_WEIGHT); $sql .= "', tun_specific_heat='" . floatval($equipment->TUN_SPECIFIC_HEAT); - $sql .= "', tun_material='" . mysqli_real_escape_string($db, $equipment->TUN_MATERIAL); + if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.11) + $sql .= "', tun_material='0"; + else if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.22) + $sql .= "', tun_material='1"; + else if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.46) + $sql .= "', tun_material='2"; + else if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.092) + $sql .= "', tun_material='3"; + else + echo "Unknown TUN_SPECIFIC_HEAT" . $equipment->TUN_SPECIFIC_HEAT . PHP_EOL; $sql .= "', tun_height='" . floatval($equipment->TUN_HEIGHT); $sql .= "', top_up_water='" . floatval($equipment->TOP_UP_WATER); $sql .= "', trub_chiller_loss='" . floatval($equipment->TRUB_CHILLER_LOSS);