From ce3a667fec62393ae9ca9dc51778d6c24e8c57d1 Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Date: Thu, 7 Jun 2012 17:55:55 +0200
Subject: [PATCH] Properly take locale into account when calculating division
 averages.

---
 www/rating.pl | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/www/rating.pl b/www/rating.pl
index 38768d4..9580fb6 100755
--- 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) {
-- 
2.39.2