From fa764f081167c8c2a5a8324aace495898ec81bbc Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Fri, 16 Feb 2007 17:17:08 +0000 Subject: [PATCH] not max 60 ppl avg anymore --- ND/Web/Pages/Alliances.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/ND/Web/Pages/Alliances.pm b/ND/Web/Pages/Alliances.pm index 69d7c92..48975c1 100644 --- a/ND/Web/Pages/Alliances.pm +++ b/ND/Web/Pages/Alliances.pm @@ -132,7 +132,7 @@ sub render_body { my $query = $DBH->prepare(qq{ SELECT DISTINCT a.id,name,COALESCE(s.score,SUM(p.score)) AS score,COALESCE(s.size,SUM(p.size)) AS size,s.members,count(p.score) AS kmem, COALESCE(SUM(p.score),-1) AS kscore, COALESCE(SUM(p.size),-1) AS ksize, COALESCE(SUM(p.xp),-1) AS kxp,COALESCE(SUM(p.value),-1) AS kvalue, - COALESCE(s.score/LEAST(s.members,60),-1) AS scavg, COALESCE(AVG(p.score)::int,-1) AS kscavg, COALESCE(s.size/s.members,-1) AS siavg, + COALESCE(s.score/s.members,-1) AS scavg, COALESCE(AVG(p.score)::int,-1) AS kscavg, COALESCE(s.size/s.members,-1) AS siavg, COALESCE(AVG(p.size)::int,-1) AS ksiavg, COALESCE(AVG(p.xp)::int,-1) AS kxpavg, COALESCE(AVG(p.value)::int,-1) AS kvalavg FROM alliances a LEFT OUTER JOIN (SELECT * FROM alliance_stats WHERE tick = (SELECT max(tick) FROM alliance_stats)) s ON s.id = a.id -- 2.39.2