From af28b2b29c24341e97916d347d475b7f21816707 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Tue, 7 Feb 2012 02:29:21 +0100 Subject: [PATCH] Fix some SQL errors that crept in during refactoring. --- sql/ccbs.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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; -- 2.39.2