From c49534808361d004fb53f1241e97d306d86e3fc0 Mon Sep 17 00:00:00 2001 From: emkael Date: Sun, 28 Sep 2014 17:59:57 +0200 Subject: * korekta meczów tylko, jeśli są w nich zapisy MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- patton-imp.sql | 4 ++-- 1 file 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; -- cgit v1.2.3