Mercurial > bms / file diff

--- a/www/import/from_brouwhulp.php	Wed Nov 21 21:17:18 2018 +0100
+++ b/www/import/from_brouwhulp.php	Thu Nov 22 22:27:42 2018 +0100
@@ -982,10 +982,13 @@
 		$psql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME);
 		$rsql .= "', name='" . mysqli_real_escape_string($db, $recipe->NAME);
 
-                if ($recipe->NOTES)
-                        $rsql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES);
-                else
-                        $rsql .= "', notes='";
+                if ($recipe->NOTES) {
+			$rsql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES);		// Duplicate the notes
+			$psql .= "', notes='" . mysqli_real_escape_string($db, $recipe->NOTES);
+		} else {
+			$rsql .= "', notes='";
+			$psql .= "', notes='";
+		}
                 if ($recipe->TYPE)
                         $rsql .= "', type='" . mysqli_real_escape_string($db, $recipe->TYPE);
                 else
@@ -1149,6 +1152,7 @@
 
 		if ($recipe->EQUIPMENT) {
 			$psql .= "', eq_name='" . mysqli_real_escape_string($db, $recipe->EQUIPMENT->NAME);
+			$psql .= "', eq_notes='" . mysqli_real_escape_string($db, $recipe->EQUIPMENT->NOTES);
 			$psql .= "', eq_boil_size='" . floatval($recipe->EQUIPMENT->BOIL_SIZE);
 			$psql .= "', eq_batch_size='" . floatval($recipe->EQUIPMENT->BATCH_SIZE);
 			$psql .= "', eq_tun_volume='" . floatval($recipe->EQUIPMENT->TUN_VOLUME);