summaryrefslogtreecommitdiff
path: root/Aktywator/TeamNamesSettings.cs
diff options
context:
space:
mode:
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 ae7f4e9..40b8613 100644
--- a/Aktywator/TeamNamesSettings.cs
+++ b/Aktywator/TeamNamesSettings.cs
@@ -92,7 +92,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)), ' 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;