Fri, 01 May 2020 11:56:24 +0200
Version 0.3.32 Inventory water and profile water edit screens updated and added ion balance fields. Moved acid specs to global.js. In prod_edit and rec_edit changed the water calculations, eliminated the double percentage calculation. The pH values in the water tab have now 2 decimal digits. The mash pH field is only shown in auto calculate mode. The calculated acid addition results are now a bit better and compare with several famous spreadsheets.
<?php require_once('config.php'); #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" ); $sql = "UPDATE `mon_co2meters` SET "; $sql .= "beername='" . mysqli_real_escape_string($connect, $_POST['beername']); $sql .= "', beercode='" . mysqli_real_escape_string($connect, $_POST['beercode']); $sql .= "', beeruuid='" . mysqli_real_escape_string($connect, $_POST['beeruuid']); $sql .= "' WHERE uuid='" . $_POST['uuid'] . "';"; $result = mysqli_query($connect, $sql); if (! $result) { syslog(LOG_NOTICE, "cmd_co2meters: result: ".mysqli_error($connect)); } else { syslog(LOG_NOTICE, "cmd_co2meters: updated record ".$_POST['uuid']); } echo $result; ?>