diff options
| author | emkael <emkael@tlen.pl> | 2017-08-23 17:14:37 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2017-08-23 17:14:37 +0200 |
| commit | 0c84fc21f0b7af4468603b10f35da47f13910bcf (patch) | |
| tree | 8ee29ad4eed28b2af4157d4cc6fcdcf14e34872c | |
| parent | b8880c7864f6bb5e8df671eb18247f24f5d3b5d9 (diff) | |
Loading pair numbers for first round in Teamy tournaments to avoid warning flood in case wrong tournament is selected
| -rw-r--r-- | Aktywator/Bws.cs | 5 |
1 files changed, 2 insertions, 3 deletions
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 |