diff -r a7f25be71ba8 -r b558f3dfcda3 www/includes/db_product.php --- 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']);