summaryrefslogtreecommitdiff
path: root/Aktywator/TeamNamesSettings.cs
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2017-12-10 13:35:04 +0100
committeremkael <emkael@tlen.pl>2017-12-10 13:35:04 +0100
commitf523e477eff19af281808aa2c403502cb1cfe3bc (patch)
tree4adc668193ae448ad3fc1fbf630ae957b8f5c78a /Aktywator/TeamNamesSettings.cs
parent46f15be10845f2b38c444173c66c3769910c15f0 (diff)
Omit current round in VP results.
Fixes #33
Diffstat (limited to 'Aktywator/TeamNamesSettings.cs')
-rw-r--r--Aktywator/TeamNamesSettings.cs2
1 files changed, 1 insertions, 1 deletions
diff --git a/Aktywator/TeamNamesSettings.cs b/Aktywator/TeamNamesSettings.cs
index c5886b9..d8f8e6e 100644
--- a/Aktywator/TeamNamesSettings.cs
+++ b/Aktywator/TeamNamesSettings.cs
@@ -99,7 +99,7 @@ namespace Aktywator
ret.Append(" GROUP BY teams.id ORDER BY teams.id");
break;
case 2:
- ret.Append("CONCAT(SUM(IF(matches.homet = teams.id, vph+corrh, vpv+corrv)) + teams.score, ' VP') FROM teams LEFT JOIN matches ON (teams.id = matches.homet OR teams.id = matches.visit) AND matches.rnd <= ");
+ ret.Append("CONCAT(SUM(IF(matches.homet = teams.id, vph+corrh, vpv+corrv)) + teams.score, ' VP') FROM teams LEFT JOIN matches ON (teams.id = matches.homet OR teams.id = matches.visit) AND matches.rnd < ");
ret.Append(cbRounds.SelectedItem);
ret.Append(" GROUP BY teams.id ORDER BY teams.id");
break;