1 <?php |
|
2 require($_SERVER['DOCUMENT_ROOT']."/config.php"); |
|
3 require($_SERVER['DOCUMENT_ROOT']."/version.php"); |
|
4 |
|
5 #Connect to the database |
|
6 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); |
|
7 if (! $connect) { |
|
8 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
|
9 } |
|
10 mysqli_set_charset($connect, "utf8" ); |
|
11 |
|
12 $escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c"); |
|
13 $replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b"); |
|
14 |
|
15 $response = array( |
|
16 'error' => false, |
|
17 'msg' => 'Ok', |
|
18 ); |
|
19 |
|
20 $query = "SELECT * FROM profile_setup WHERE record='1'"; |
|
21 |
|
22 if (isset($_POST['update'])) { |
|
23 /* Search water record */ |
|
24 $result = mysqli_query($connect, "SELECT record FROM inventory_waters WHERE name='".$_POST['default_water']."';"); |
|
25 if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) |
|
26 $default_water = $row['record']; |
|
27 else |
|
28 $default_water = 0; |
|
29 $sql = "UPDATE `profile_setup` SET "; |
|
30 $sql .= "brewery_name='" . mysqli_real_escape_string($connect, $_POST['brewery_name']); |
|
31 $sql .= "', factor_mashhop='" . $_POST['factor_mashhop']; |
|
32 $sql .= "', factor_fwh='" . $_POST['factor_fwh']; |
|
33 $sql .= "', factor_pellet='" . $_POST['factor_pellet']; |
|
34 $sql .= "', factor_plug='" . $_POST['factor_plug']; |
|
35 $sql .= "', factor_wethop='" . $_POST['factor_wethop']; |
|
36 $sql .= "', factor_cryohop='" . $_POST['factor_cryohop']; |
|
37 $sql .= "', color_method='" . $_POST['color_method']; |
|
38 $sql .= "', ibu_method='" . $_POST['ibu_method']; |
|
39 $sql .= "', brix_correction='" . $_POST['brix_correction']; |
|
40 $sql .= "', grain_absorbtion='" . $_POST['grain_absorbtion']; |
|
41 $sql .= "', default_water='" . $default_water; |
|
42 $sql .= "', my_yeastlab='" . $_POST['my_yeastlab']; |
|
43 $sql .= "' WHERE record='1';"; |
|
44 $result = mysqli_query($connect, $sql); |
|
45 if (! $result) { |
|
46 syslog(LOG_NOTICE, "db_profile_setup: ".$sql." result: ".mysqli_error($connect)); |
|
47 $response['error'] = true; |
|
48 $response['msg'] = "SQL fout: ".mysqli_error($connect); |
|
49 } |
|
50 exit(json_encode($response)); |
|
51 |
|
52 } else { |
|
53 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
|
54 if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
|
55 /* search water name */ |
|
56 $wresult = mysqli_query($connect, "SELECT name FROM inventory_waters WHERE record='".$row['default_water']."';"); |
|
57 if ($wrow = mysqli_fetch_array($wresult, MYSQLI_ASSOC)) |
|
58 $default_water = $wrow['name']; |
|
59 else |
|
60 $default_water = ''; |
|
61 $data = '{"record":' . $row['record']; |
|
62 $data .= ',"brewery_name":"' . str_replace($escapers, $replacements, $row['brewery_name']); |
|
63 $data .= '","factor_mashhop":' . $row['factor_mashhop']; |
|
64 $data .= ',"factor_fwh":' . $row['factor_fwh']; |
|
65 $data .= ',"factor_pellet":' . $row['factor_pellet']; |
|
66 $data .= ',"factor_plug":' . $row['factor_plug']; |
|
67 $data .= ',"factor_wethop":' . $row['factor_wethop']; |
|
68 $data .= ',"factor_cryohop":' . $row['factor_cryohop']; |
|
69 $data .= ',"ibu_method":' . $row['ibu_method']; |
|
70 $data .= ',"color_method":' . $row['color_method']; |
|
71 $data .= ',"brix_correction":' . floatval($row['brix_correction']); |
|
72 $data .= ',"grain_absorbtion":' . floatval($row['grain_absorbtion']); |
|
73 $data .= ',"default_water":"' . str_replace($escapers, $replacements, $default_water); |
|
74 $data .= '","my_yeastlab":"' . str_replace($escapers, $replacements, $row['my_yeastlab']); |
|
75 $data .= '"}'; |
|
76 } |
|
77 header("Content-type: application/json"); |
|
78 exit($data); |
|
79 } |
|
80 ?> |
|