* korekta meczów tylko, jeśli są w nich zapisy

1 files changed, 2 insertions, 2 deletions

diff --git a/patton-imp.sql b/patton-imp.sql
index 22f766f..c7163f4 100644
--- a/patton-imp.sql
+++ b/patton-imp.sql
@@ -133,8 +133,8 @@ SET @boards_per_segment = (SELECT boardspersegment FROM admin);
 -- Nadpisujemy tabelę VP na wiecznie remisową (6:6 dla 4 rozdań, 4.5:4.5 dla 3 rozdań, 3/2*n:3/2*n dla n rozdań)
 UPDATE tabvp SET vpew = 1.5 * @boards_per_segment WHERE dimp = 0;
 UPDATE tabvp SET vpns = vpew WHERE dimp = 0;
-UPDATE matches SET vph = 1.5 * @boards_per_segment;
-UPDATE matches SET vpv = vph;
+UPDATE matches SET vph = 1.5 * @boards_per_segment WHERE (rnd, tabl) IN (SELECT rnd, tabl FROM patton_boards);
+UPDATE matches SET vpv = vph WHERE (rnd, tabl) IN (SELECT rnd, tabl FROM patton_boards);
 
 -- Wypełniamy tabelę salda.
 DELETE FROM patton_sums;