X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fccbs.sql;fp=sql%2Fccbs.sql;h=0463f742014ea9517ae9195403497d0028c96bba;hp=4cdf07b9c32b3892c5dbda59a7bd2c345ac7f20e;hb=af28b2b29c24341e97916d347d475b7f21816707;hpb=a317762dab2b775334cc85a43b6fe2e3c2097eab

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index 4cdf07b..0463f74 100644
--- a/sql/ccbs.sql
+++ b/sql/ccbs.sql
@@ -251,7 +251,7 @@ CREATE FUNCTION get_max_score_for_players(integer, integer, varchar) RETURNS SET
              )
              AND playmode=$3
              ORDER BY feetrating DESC LIMIT 1
-	  ) * 1000 AS max_score FROM tournamentparticipation;
+	  ) * 1000 AS max_score FROM tournamentparticipation WHERE tournament=$1;
 $$
     LANGUAGE SQL
     STABLE
@@ -293,7 +293,7 @@ BEGIN
 				IF ts.song IS NOT NULL THEN
 					ret.max_score := ret.max_score + ( SELECT max_score FROM get_max_score_for_songs($1, $4) WHERE song=ts.song );
 				ELSE
-					ret.max_score := ret.max_score + ( SELECT max_score FROM get_max_score_for_players($1, $4) WHERE song=tp.player );
+					ret.max_score := ret.max_score + ( SELECT max_score FROM get_max_score_for_players($1, $2, $4) WHERE song=tp.player );
 				END IF;
 			END IF;
 		END LOOP;