]> git.sesse.net Git - ccbs/blobdiff - bigscreen/fetch_max_score_for_players.cpp
Hardcode single-only songs for now.
[ccbs] / bigscreen / fetch_max_score_for_players.cpp
index 3a89541aa65a19f50f79145e7ea4cf785eae5ebd..3aa66b7837364ec9e12d6c5d441ffc5a6e9da3ee 100644 (file)
@@ -26,6 +26,7 @@ void FetchMaxScoreForPlayers::operator() (pqxx::transaction<> &t)
                "          AND song IS NOT NULL" +
                "          AND ( chosen='t' OR round=" + pqxx::to_string(round) + " )"
                "       )"
+               "     AND playmode='single'"
                "     ORDER BY feetrating DESC LIMIT 1"      
                "  ) * 1000 AS max_score FROM tournamentparticipation") );