diff -r d51b05838ac4 -r aa79acfdf8a9 www/includes/db_profile_water.php --- a/www/includes/db_profile_water.php Sun Feb 06 20:06:46 2022 +0100 +++ b/www/includes/db_profile_water.php Thu Feb 10 22:15:10 2022 +0100 @@ -23,7 +23,13 @@ $sql = "UPDATE `profile_water` SET "; } - $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); + if (isset($_POST['uuid']) && (strlen($_POST['uuid']) == 36)) { + $sql .= "uuid='" . $_POST['uuid']; + } else { + $uuid = str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); + $sql .= "uuid='" . $uuid; + } + $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']); $sql .= "', calcium='" . $_POST['calcium']; $sql .= "', bicarbonate='" . $_POST['bicarbonate']; $sql .= "', sulfate='" . $_POST['sulfate']; @@ -65,6 +71,7 @@ while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $waters[] = array( 'record' => $row['record'], + 'uuid' => $row['uuid'], 'name' => $row['name'], 'calcium' => $row['calcium'], 'bicarbonate' => $row['bicarbonate'],