# Pick up all the subdivisions' ratings.
my %subdivision_ratings = ();
-my $q = $dbh->prepare('SELECT divisjon, avdeling, serie_id, AVG(rating) AS avg_rating FROM ratings NATURAL JOIN siste_divisjon NATURAL JOIN spiller_kultur WHERE kultur=? AND sesong=? GROUP BY divisjon, avdeling, serie_id ORDER BY divisjon, avdeling');
+my $q = $dbh->prepare('SELECT divisjon, avdeling, serie_id, AVG(rating) AS avg_rating FROM ratings NATURAL JOIN siste_divisjon NATURAL JOIN spiller_kultur WHERE kultur=? AND sesong=? AND NOT jukser GROUP BY divisjon, avdeling, serie_id ORDER BY divisjon, avdeling');
$q->execute($locale, $season);
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 NATURAL JOIN spiller_kultur WHERE kultur=? AND sesong=? GROUP BY divisjon ORDER BY divisjon');
+$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=? AND NOT jukser GROUP BY divisjon ORDER BY divisjon');
$q->execute($locale, $season);
my @divisions = ();
while (my $ref = $q->fetchrow_hashref) {
my %division = ();
- $division{'#rank'} = sprintf "%d.", $ref->{'divisjon'};
+ $division{'#rank'} = wloh_common::get_ordinal($ref->{'divisjon'}, $locale);
$division{'#average'} = sprintf "%.1f", $ref->{'avg_rating'};
$division{'#stddev'} = sprintf "%.1f", $ref->{'stddev_rating'};
while (my $ref = $q->fetchrow_hashref) {
my %player = ();
- $player{'#rank'} = sprintf "%d.", ++$i;
+ $player{'#rank'} = wloh_common::get_ordinal(++$i, $locale);
$player{'#user'} = Encode::decode_utf8($ref->{'navn'});
$player{'#user/href'} = sprintf "http://wordfeud.aasmul.net/bruker-%d", $ref->{'id'};
$player{'#rating'} = sprintf "%.1f", $ref->{'rating'};
push @players, \%player;
}
-print CGI->header(-type=>'text/html; charset=utf-8', -expires=>'+5m');
+print CGI->header(-type=>'text/html; charset=utf-8', -expires=>'+75m');
wloh_common::process_template('rating', $locale, {
'#navbar' => wloh_common::get_navbar($cgi, $dbh, $locale),
'iterations' => $aux_parms->{'num_iterations'},