37 if (isset($_GET['return'])) |
37 if (isset($_GET['return'])) |
38 $my_return = $_GET['return']; |
38 $my_return = $_GET['return']; |
39 else |
39 else |
40 $my_return = ''; |
40 $my_return = ''; |
41 |
41 |
|
42 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); |
|
43 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); |
|
44 |
|
45 /* Load setup record */ |
|
46 #Connect to the database |
|
47 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
|
48 if (! $connect) { |
|
49 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
|
50 } |
|
51 mysqli_set_charset($connect, "utf8" ); |
|
52 $my_default_water = $my_brewery_name = $my_ibu_method = $my_color_method = ''; |
|
53 $my_factor_mashhop = $my_factor_fwh = $my_factor_pellet = $my_factor_plug = 0; |
|
54 $my_brix_correction = $my_grain_absorbtion = 1.0; |
|
55 |
|
56 $result = mysqli_query($connect, "SELECT * FROM profile_setup WHERE record='1'") or die("SQL Error 1: " . mysqli_error($connect)); |
|
57 if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
|
58 /* search water name */ |
|
59 $wresult = mysqli_query($connect, "SELECT name FROM inventory_waters WHERE record='".$row['default_water']."';"); |
|
60 if ($wrow = mysqli_fetch_array($wresult, MYSQLI_ASSOC)) |
|
61 $my_default_water = str_replace($escapers, $replacements, $wrow['name']); |
|
62 $my_brewery_name = str_replace($escapers, $replacements, $row['brewery_name']); |
|
63 $my_factor_mashhop = floatval($row['factor_mashhop']); |
|
64 $my_factor_fwh= floatval($row['factor_fwh']); |
|
65 $my_factor_pellet= floatval($row['factor_pellet']); |
|
66 $my_factor_plug= floatval($row['factor_plug']); |
|
67 $my_ibu_method = str_replace($escapers, $replacements, $row['ibu_method']); |
|
68 $my_color_method = str_replace($escapers, $replacements, $row['color_method']); |
|
69 $my_brix_correction = floatval($row['brix_correction']); |
|
70 $my_grain_absorbtion = floatval($row['grain_absorbtion']); |
|
71 } |
|
72 //mysqli_free_result($result); |
|
73 |
|
74 |
42 function page_header($title, $loadjs) { |
75 function page_header($title, $loadjs) { |
43 global $my_style; |
76 global $my_style; |
44 global $my_version; |
77 global $my_version; |
45 global $my_record; |
78 global $my_record; |
46 global $my_return; |
79 global $my_return; |
|
80 global $my_brewery_name; |
47 ?> |
81 ?> |
48 <!DOCTYPE html> |
82 <!DOCTYPE html> |
49 <html lang=nl-NL> |
83 <html lang=nl-NL> |
50 <head> |
84 <head> |
51 <meta http-equiv="content-type" content="text/html; charset=utf-8" /> |
85 <meta http-equiv="content-type" content="text/html; charset=utf-8" /> |
56 <meta name="viewport" content="width=device-width, initial-scale=1 maximum-scale=1 minimum-scale=1" /> |
90 <meta name="viewport" content="width=device-width, initial-scale=1 maximum-scale=1 minimum-scale=1" /> |
57 <script> |
91 <script> |
58 var theme = "<?php echo $my_style; ?>"; |
92 var theme = "<?php echo $my_style; ?>"; |
59 var my_record = "<?php echo $my_record; ?>"; |
93 var my_record = "<?php echo $my_record; ?>"; |
60 var my_return = "<?php echo $my_return; ?>"; |
94 var my_return = "<?php echo $my_return; ?>"; |
|
95 var my_brewery_name = "<?php echo $my_brewery_name; ?>"; |
61 </script> |
96 </script> |
62 <script src="js/jquery-1.11.1.min.js"></script> |
97 <script src="js/jquery-1.11.1.min.js"></script> |
63 <script src="jqwidgets/jqxcore.js"></script> |
98 <script src="jqwidgets/jqxcore.js"></script> |
64 <script src="jqwidgets/jqxwindow.js"></script> |
99 <script src="jqwidgets/jqxwindow.js"></script> |
65 <script src="jqwidgets/jqxmenu.js"></script> |
100 <script src="jqwidgets/jqxmenu.js"></script> |