From 33798d738eb88b893f21818275c2f0f4b7f7562e Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Wed, 30 Mar 2005 01:15:58 +0000 Subject: [PATCH] Fix max score for players; only chosen songs can't be selected twice. --- bigscreen/fetch_max_score_for_players.cpp | 1 + 1 file changed, 1 insertion(+) 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" -- 2.39.2