www/prod_duplicate.php

changeset 458
47b592993dd5
parent 432
99dcd8488b62
child 460
046ff5fdc96c
--- a/www/prod_duplicate.php	Sat Aug 24 21:52:46 2019 +0200
+++ b/www/prod_duplicate.php	Sun Aug 25 13:22:00 2019 +0200
@@ -100,14 +100,20 @@
 $sql .= "', secondary_end_date=NULL";
 $sql .=  ", tertiary_temp='0";
 $sql .= "', package_date=NULL";
-$sql .=  ", bottle_amount='0";
+$sql .=  ", package_volume='" . $row['package_volume'];
+$sql .= "', package_infuse_amount='" . $row['package_infuse_amount'];
+$sql .= "', package_infuse_abv='" . $row['package_infuse_abv'];
+$sql .= "', package_infuse_notes='" . mysqli_real_escape_string($link, $row['package_infuse_notes']);
+$sql .= "', package_abv='0";
+$sql .= "', package_ph='0";
+$sql .= "', bottle_amount='0";
 $sql .= "', bottle_carbonation='" . $row['bottle_carbonation'];
-$sql .= "', bottle_priming_sugar='" . $row['bottle_priming_sugar'];
+$sql .= "', bottle_priming_water='" . $row['bottle_priming_water'];
 $sql .= "', bottle_priming_amount='0";
 $sql .= "', bottle_carbonation_temp='" . $row['bottle_carbonation_temp'];
 $sql .= "', keg_amount='0";
 $sql .= "', keg_carbonation='" . $row['keg_carbonation'];
-$sql .= "', keg_priming_sugar='" . $row['keg_priming_sugar'];
+$sql .= "', keg_priming_water='" . $row['keg_priming_water'];
 $sql .= "', keg_priming_amount='0";
 $sql .= "', keg_carbonation_temp='" . $row['keg_carbonation_temp'];
 $sql .= "', keg_forced_carb='" . $row['keg_forced_carb'];
@@ -190,6 +196,7 @@
 $sql .= "', starter_enable='" . $row['starter_enable'];
 $sql .= "', starter_type='" . $row['starter_type'];
 $sql .= "', starter_sg='" . $row['starter_sg'];
+$sql .= "', starter_viability='97";
 $sql .= "', prop1_type='" . $row['prop1_type'];
 $sql .= "', prop1_volume='" . $row['prop1_volume'];
 $sql .= "', prop2_type='" . $row['prop2_type'];

mercurial