From 70d29fa5a5ccf53371fb643d40fe9acfa8fa6072 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Tue, 18 Dec 2012 00:11:37 +0100 Subject: [PATCH] Do not show cheaters in the rating list. --- www/rating.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/www/rating.pl b/www/rating.pl index 5572315..48d9859 100755 --- a/www/rating.pl +++ b/www/rating.pl @@ -32,7 +32,7 @@ my $season = wloh_common::get_max_season($dbh, $locale); # 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) { @@ -43,7 +43,7 @@ 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 = (); -- 2.39.2