Properly take locale into account when calculating division averages.

diff --git a/www/rating.pl b/www/rating.pl
index 38768d4673ca281eec5062f8808859be04e52666..9580fb6b5553607c46aa46afa3eda3a4be6b2e18 100755 (executable)
--- a/www/rating.pl
+++ b/www/rating.pl
@@ -101,8 +101,8 @@ while (my $ref = $q->fetchrow_hashref) {
        push @{$subdivision_ratings{$division}}, [ $id, $rating ];
 }
 
-$q = $dbh->prepare('SELECT divisjon,AVG(rating) AS avg_rating,STDDEV(rating) AS stddev_rating FROM ratings NATURAL JOIN siste_divisjon WHERE sesong=? GROUP BY divisjon ORDER BY divisjon');
-$q->execute($season);
+$q = $dbh->prepare('SELECT divisjon,AVG(rating) AS avg_rating,STDDEV(rating) AS stddev_rating FROM ratings NATURAL JOIN siste_divisjon NATURAL JOIN spiller_kultur WHERE kultur=? AND sesong=? GROUP BY divisjon ORDER BY divisjon');
+$q->execute($locale, $season);
 
 my $i = 0;
 while (my $ref = $q->fetchrow_hashref) {