X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=bigscreen%2Ffetch_max_score_for_songs.cpp;h=990d1e8cad9caa94bdea9009fe7706f46b735e3e;hb=4c387786f5c01ee45c3b07709c27f6977c6ef8ab;hp=d9a8841918dfda2a31134e02873668d386201eff;hpb=57c939a53665f808b2429461d547271adf2c5908;p=ccbs

diff --git a/bigscreen/fetch_max_score_for_songs.cpp b/bigscreen/fetch_max_score_for_songs.cpp
index d9a8841..990d1e8 100644
--- a/bigscreen/fetch_max_score_for_songs.cpp
+++ b/bigscreen/fetch_max_score_for_songs.cpp
@@ -7,9 +7,9 @@ void FetchMaxScoreForSongs::operator() (pqxx::transaction<> &t)
 {
 	score->erase(score->begin(), score->end());
 	
-	pqxx::result res( t.exec("SELECT song,MAX(feetrating)*1000 AS max_score FROM songratings WHERE " 
-		" machine=( SELECT machine FROM tournaments WHERE tournament=" + pqxx::to_string(tournament) + ") GROUP BY song") );
-	
+	pqxx::result res( t.exec("SELECT * FROM get_max_score_for_songs("
+		+ pqxx::to_string(tournament) + ", 'single')") );
+
 	for (pqxx::result::const_iterator i = res.begin(); i != res.end(); ++i) {
 		unsigned song, max_score;
 		song = i["song"].as(song);