diff -r f433193f7bb6 -r 08c92cb740b9 www/includes/global.inc.php --- a/www/includes/global.inc.php Sat Nov 17 15:58:13 2018 +0100 +++ b/www/includes/global.inc.php Sat Nov 17 19:44:39 2018 +0100 @@ -39,11 +39,45 @@ else $my_return = ''; +$escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); +$replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); + +/* Load setup record */ +#Connect to the database +$connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); +if (! $connect) { + die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); +} +mysqli_set_charset($connect, "utf8" ); +$my_default_water = $my_brewery_name = $my_ibu_method = $my_color_method = ''; +$my_factor_mashhop = $my_factor_fwh = $my_factor_pellet = $my_factor_plug = 0; +$my_brix_correction = $my_grain_absorbtion = 1.0; + +$result = mysqli_query($connect, "SELECT * FROM profile_setup WHERE record='1'") or die("SQL Error 1: " . mysqli_error($connect)); +if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { + /* search water name */ + $wresult = mysqli_query($connect, "SELECT name FROM inventory_waters WHERE record='".$row['default_water']."';"); + if ($wrow = mysqli_fetch_array($wresult, MYSQLI_ASSOC)) + $my_default_water = str_replace($escapers, $replacements, $wrow['name']); + $my_brewery_name = str_replace($escapers, $replacements, $row['brewery_name']); + $my_factor_mashhop = floatval($row['factor_mashhop']); + $my_factor_fwh= floatval($row['factor_fwh']); + $my_factor_pellet= floatval($row['factor_pellet']); + $my_factor_plug= floatval($row['factor_plug']); + $my_ibu_method = str_replace($escapers, $replacements, $row['ibu_method']); + $my_color_method = str_replace($escapers, $replacements, $row['color_method']); + $my_brix_correction = floatval($row['brix_correction']); + $my_grain_absorbtion = floatval($row['grain_absorbtion']); +} +//mysqli_free_result($result); + + function page_header($title, $loadjs) { global $my_style; global $my_version; global $my_record; global $my_return; + global $my_brewery_name; ?> @@ -58,6 +92,7 @@ var theme = ""; var my_record = ""; var my_return = ""; + var my_brewery_name = "";