Fix max score for players; only chosen songs can't be selected twice.
authorSteinar H. Gunderson <sesse@samfundet.no>
Wed, 30 Mar 2005 01:15:58 +0000 (01:15 +0000)
committerSteinar H. Gunderson <sesse@samfundet.no>
Wed, 30 Mar 2005 01:15:58 +0000 (01:15 +0000)
bigscreen/fetch_max_score_for_players.cpp

index 9cc9b2a..3a89541 100644 (file)
@@ -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"