From f76e1fa762ad0a6b42146bd81e9ad3ca8281dddf Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Wed, 30 Mar 2005 01:14:29 +0000 Subject: [PATCH] Fix list of finished groups; don't show elimination/seeding groups, show finished parallels even if they are in a non-finished round. --- bigscreen/fetch_list_of_finished_groups.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/bigscreen/fetch_list_of_finished_groups.cpp b/bigscreen/fetch_list_of_finished_groups.cpp index 9d9de95..08f953e 100644 --- a/bigscreen/fetch_list_of_finished_groups.cpp +++ b/bigscreen/fetch_list_of_finished_groups.cpp @@ -10,7 +10,7 @@ void FetchListOfFinishedGroups::operator() (pqxx::transaction<> &t) // find all groups with no empty scores that are not already shown on the bigscreen pqxx::result res( t.exec("SELECT tournament,round,parallel FROM scores WHERE tournament=" + - pqxx::to_string(tournament) + " GROUP BY tournament,round,parallel HAVING COUNT(*)=COUNT(score) AND (tournament,round) NOT IN ( SELECT tournament,round FROM bigscreen.active_groups ) ORDER BY tournament,round,parallel") ); + pqxx::to_string(tournament) + " GROUP BY tournament,round,parallel HAVING COUNT(*)=COUNT(score) AND (tournament,round,parallel) NOT IN ( SELECT tournament,round,parallel FROM bigscreen.active_groups ) AND parallel<>0 ORDER BY tournament,round,parallel") ); for (pqxx::result::const_iterator i = res.begin(); i != res.end(); ++i) { SkeletonGroup g; -- 2.39.2