--- 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;
?>
<!DOCTYPE html>
<html lang=nl-NL>
@@ -58,6 +92,7 @@
var theme = "<?php echo $my_style; ?>";
var my_record = "<?php echo $my_record; ?>";
var my_return = "<?php echo $my_return; ?>";
+ var my_brewery_name = "<?php echo $my_brewery_name; ?>";
</script>
<script src="js/jquery-1.11.1.min.js"></script>
<script src="jqwidgets/jqxcore.js"></script>