From 9388a47c2f9263593f10ce826cb748e4ce56d8c7 Mon Sep 17 00:00:00 2001
From: Vainsocial root <root@vainsocial>
Date: Fri, 24 Mar 2017 18:57:22 +0000
Subject: use minions killed / min not avg farm

---
 minionlivesmatter/templates/index.html | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/minionlivesmatter/templates/index.html b/minionlivesmatter/templates/index.html
index 2f5aad7..e6b6ee1 100644
--- a/minionlivesmatter/templates/index.html
+++ b/minionlivesmatter/templates/index.html
@@ -261,9 +261,9 @@
     
 
     <script type="text/javascript">
-        var minions_per_second = {{ sql_val("SELECT SUM(minion_kills)/SUM(match.duration)::FLOAT FROM participant JOIN roster ON participant.roster_api_id=roster.api_id JOIN match ON roster.match_api_id=match.api_id WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }};
+        var minions_per_second = {{ sql_val("SELECT SUM(minion_kills)/(24*60*60)::FLOAT FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }};
         var minions = 0;
-        // sum(minions killed) / sum(game lengh s)
+        // sum(minions killed) / (seconds per day)
         setInterval(() => {
             minions += minions_per_second;
             $("#minions-killed-now").text(Math.floor(minions));
-- 
cgit v1.3.1