diff options
| author | Michał Zimniewicz <michzimny@users.noreply.github.com> | 2018-01-04 01:19:50 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-01-04 01:19:50 +0100 |
| commit | fa8e46acc24c5cf8b607531684b4c9858e4ebb33 (patch) | |
| tree | b81ddbc9cef517446232e007b9e287152e504235 /Aktywator/TeamNamesSettings.cs | |
| parent | 80cd31c1c8e7cef2cfbf6148df3d9ec2d2a23279 (diff) | |
| parent | f58213dbf8b1d52f9545a7c3b227cff59a888afb (diff) | |
Merge pull request #36 from michzimny/1.1-betav1.1.3
v1.1.3
Diffstat (limited to 'Aktywator/TeamNamesSettings.cs')
| -rw-r--r-- | Aktywator/TeamNamesSettings.cs | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/Aktywator/TeamNamesSettings.cs b/Aktywator/TeamNamesSettings.cs index 034e362..d8f8e6e 100644 --- a/Aktywator/TeamNamesSettings.cs +++ b/Aktywator/TeamNamesSettings.cs @@ -79,7 +79,7 @@ namespace Aktywator ret.Append("SELECT teams.id, "); if (rbShowTeamNames.Checked) { - ret.Append("fullname, "); + ret.Append("shortname, "); switch (cbSecondRow.SelectedIndex) { case 0: ret.Append("' ' FROM teams ORDER BY teams.id"); @@ -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; |