From 46f15be10845f2b38c444173c66c3769910c15f0 Mon Sep 17 00:00:00 2001 From: emkael Date: Fri, 8 Dec 2017 15:40:26 +0100 Subject: Display shortname instead of fullname for Teamy tournaments. Fixes #31 --- Aktywator/TeamNamesSettings.cs | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Aktywator/TeamNamesSettings.cs') diff --git a/Aktywator/TeamNamesSettings.cs b/Aktywator/TeamNamesSettings.cs index 034e362..c5886b9 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"); -- cgit v1.2.3 From f523e477eff19af281808aa2c403502cb1cfe3bc Mon Sep 17 00:00:00 2001 From: emkael Date: Sun, 10 Dec 2017 13:35:04 +0100 Subject: Omit current round in VP results. Fixes #33 --- Aktywator/Resources/BuildDate.txt | 2 +- Aktywator/TeamNamesSettings.cs | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'Aktywator/TeamNamesSettings.cs') diff --git a/Aktywator/Resources/BuildDate.txt b/Aktywator/Resources/BuildDate.txt index b287a0f..b357732 100644 --- a/Aktywator/Resources/BuildDate.txt +++ b/Aktywator/Resources/BuildDate.txt @@ -1 +1 @@ -2017-12-08 +2017-12-10 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; -- cgit v1.2.3