diff options
| author | Michał Zimniewicz <michzimny@users.noreply.github.com> | 2018-02-14 23:54:19 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-02-14 23:54:19 +0100 |
| commit | 969e3dd244337fc5e9262cb27931159bfeaf6c0c (patch) | |
| tree | 1c0a2ce06509fc4f23ee1d2b7d387d41317d091b /Aktywator/TeamNamesSettings.cs | |
| parent | fa8e46acc24c5cf8b607531684b4c9858e4ebb33 (diff) | |
| parent | 3a7b77ef81cc80e29d4f3f06a0bb66752e79c936 (diff) | |
Merge pull request #40 from emkael/winter-bugfixes
Winter bugfixes
Diffstat (limited to 'Aktywator/TeamNamesSettings.cs')
| -rw-r--r-- | Aktywator/TeamNamesSettings.cs | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/Aktywator/TeamNamesSettings.cs b/Aktywator/TeamNamesSettings.cs index d8f8e6e..23cc865 100644 --- a/Aktywator/TeamNamesSettings.cs +++ b/Aktywator/TeamNamesSettings.cs @@ -58,7 +58,7 @@ namespace Aktywator } if (cbSecondRow.SelectedIndex == 2) { - ret.Append(" + VP"); + ret.Append(" + VP/IMP"); } } else @@ -99,7 +99,9 @@ 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, ' "); + ret.Append(this.tournament.getPointsUnit()); + ret.Append("') 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; |