From: Steinar H. Gunderson <sesse@samfundet.no>
Date: Wed, 30 Mar 2005 01:15:58 +0000 (+0000)
Subject: Fix max score for players; only chosen songs can't be selected twice.
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=33798d738eb88b893f21818275c2f0f4b7f7562e

Fix max score for players; only chosen songs can't be selected twice.
---

diff --git a/bigscreen/fetch_max_score_for_players.cpp b/bigscreen/fetch_max_score_for_players.cpp
index 9cc9b2a..3a89541 100644
--- a/bigscreen/fetch_max_score_for_players.cpp
+++ b/bigscreen/fetch_max_score_for_players.cpp
@@ -18,6 +18,7 @@ void FetchMaxScoreForPlayers::operator() (pqxx::transaction<> &t)
 		"         WHERE tournament=" + pqxx::to_string(tournament) +
  		"         AND song IS NOT NULL"
  		"         AND parallel=0"
+ 		"         AND chosen='f'"
 		"     )"
  		"     AND (player,song) NOT IN ("             // not a song the player has chosen before, or is a random song in this round
 		"       SELECT player,song FROM scores"