--- a/www/includes/db_product.php Thu Feb 07 15:35:32 2019 +0100
+++ b/www/includes/db_product.php Thu Feb 07 16:40:28 2019 +0100
@@ -40,10 +40,10 @@
$sql .= "', birth='" . $_POST['birth'];
$sql .= "', stage='" . $_POST['stage'];
$sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']);
- ($_POST['log_brew'] == 'true') ? $sql .= "', log_brew='1" : $sql .= "', log_brew='0";
- ($_POST['log_fermentation'] == 'true') ? $sql .= "', log_fermentation='1" : $sql .= "', log_fermentation='0";
- ($_POST['inventory_reduced'] == 'true') ? $sql .= "', inventory_reduced='1" : $sql .= "', inventory_reduced='0";
- ($_POST['locked'] == 'true') ? $sql .= "', locked='1" : $sql .= "', locked='0";
+ $sql .= "', log_brew='" . $_POST['log_brew'];
+ $sql .= "', log_fermentation='" . $_POST['log_fermentation'];
+ $sql .= "', inventory_reduced='" . $_POST['inventory_reduced'];
+ $sql .= "', locked='" . $_POST['locked'];
// Equipment
$sql .= "', eq_name='" . mysqli_real_escape_string($connect, $_POST['eq_name']);
$sql .= "', eq_boil_size='" . $_POST['eq_boil_size'];
@@ -106,7 +106,6 @@
syslog(LOG_NOTICE, "write brewdate data end");
$sql .= "', brew_date_end='" . $_POST['brew_date_end'];
}
- ($_POST['brew_log_available'] == 'true') ? $sql .= "', brew_log_available='1" : $sql .= "', brew_log_available='0";
}
$sql .= "', og='" . $_POST['og'];
$sql .= "', fg='" . $_POST['fg'];
@@ -140,7 +139,7 @@
$sql .= "', keg_priming_sugar='" . $_POST['keg_priming_sugar'];
$sql .= "', keg_priming_amount='" . $_POST['keg_priming_amount'];
$sql .= "', keg_carbonation_temp='" . $_POST['keg_carbonation_temp'];
- ($_POST['keg_forced_carb'] == 'true') ? $sql .= "', keg_forced_carb='1" : $sql .= "', keg_forced_carb='0";
+ $sql .= "', keg_forced_carb='" . $_POST['keg_forced_carb'];
$sql .= "', keg_pressure='" . $_POST['keg_pressure'];
}
@@ -201,7 +200,7 @@
$sql .= "', sparge_acid_amount='" . $_POST['sparge_acid_amount'];
$sql .= "', mash_ph='" . $_POST['mash_ph'];
$sql .= "', mash_name='" . $_POST['mash_name'];
- ($_POST['calc_acid'] == 'true') ? $sql .= "', calc_acid='1" : $sql .= "', calc_acid='0";
+ $sql .= "', calc_acid='" . $_POST['calc_acid'];
if (isset($_POST['w1_name'])) {
$sql .= "', w1_name='" . mysqli_real_escape_string($connect, $_POST['w1_name']);
$sql .= "', w1_amount='" . $_POST['w1_amount'];
@@ -532,8 +531,7 @@
$brew .= ',"brew_fermenter_sg":' . floatval($row['brew_fermenter_sg']);
$brew .= ',"brew_fermenter_ibu":' . floatval($row['brew_fermenter_ibu']);
$brew .= ',"brew_date_end":"' . $row['brew_date_end'];
- $brew .= '","brew_log_available":' . $row['brew_log_available'];
- $brew .= ',"og":' . floatval($row['og']);
+ $brew .= '","og":' . floatval($row['og']);
$brew .= ',"fg":' . floatval($row['fg']);
$brew .= ',"primary_start_temp":' . floatval($row['primary_start_temp']);
$brew .= ',"primary_max_temp":' . floatval($row['primary_max_temp']);