From 0c84fc21f0b7af4468603b10f35da47f13910bcf Mon Sep 17 00:00:00 2001
From: emkael <emkael@tlen.pl>
Date: Wed, 23 Aug 2017 17:14:37 +0200
Subject: Loading pair numbers for first round in Teamy tournaments to avoid
 warning flood in case wrong tournament is selected

---
 Aktywator/Bws.cs | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'Aktywator')

diff --git a/Aktywator/Bws.cs b/Aktywator/Bws.cs
index e111a4b..31686c9 100644
--- a/Aktywator/Bws.cs
+++ b/Aktywator/Bws.cs
@@ -363,7 +363,7 @@ namespace Aktywator
             int count = 0, countNew = 0, SKOK_STOLOW = 100;
             OleDbDataReader d;
             startRounds = startRounds.Trim();
-
+            string fromRound = sql.selectOne("SELECT min(`Round`) FROM RoundData WHERE NSPair>0");
             if (tournament.type != Tournament.TYPE_TEAMY)
             {
                 if (tournament.type == Tournament.TYPE_PARY && startRounds.Length > 0)
@@ -372,13 +372,12 @@ namespace Aktywator
                 }
                 else
                 {
-                    string fromRound = sql.selectOne("SELECT min(`Round`) FROM RoundData WHERE NSPair>0");
                     d = sql.select("SELECT `Section`, `Table`, NSPair, EWPair FROM RoundData WHERE `Round`=" + fromRound);
                 }
             }
             else
             {
-                d = sql.select("SELECT `Section`, `Table`, NSPair, EWPair FROM RoundData WHERE `Table`<=" + SKOK_STOLOW);
+                d = sql.select("SELECT `Section`, `Table`, NSPair, EWPair FROM RoundData WHERE `Round`=" + fromRound + " AND `Table`<=" + SKOK_STOLOW);
             }
 
             try
-- 
cgit v1.2.3