From 1fc1e5656ca737bd1768c3d628f556896e4b65e0 Mon Sep 17 00:00:00 2001 From: Vainsocial root Date: Fri, 24 Mar 2017 18:56:31 +0000 Subject: fix stormcaller using the same id on every html object --- minionlivesmatter/templates/index.html | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) diff --git a/minionlivesmatter/templates/index.html b/minionlivesmatter/templates/index.html index b7d2511..c185fb0 100644 --- a/minionlivesmatter/templates/index.html +++ b/minionlivesmatter/templates/index.html @@ -68,7 +68,7 @@
-

{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}

+

{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}

rebuilt by workers every day

@@ -83,7 +83,7 @@
-

{{ sql_val("SELECT SUM(minion_kills) FROM participant WHERE NOT winner AND created_at > NOW() - '1 day'::INTERVAL") }}
out of {{ sql_val("SELECT SUM(minion_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}

+

{{ sql_val("SELECT SUM(minion_kills) FROM participant WHERE NOT winner AND created_at > NOW() - '1 day'::INTERVAL") }}
out of {{ sql_val("SELECT SUM(minion_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}

died for nothing

@@ -98,7 +98,7 @@
-

{{ sql_val("SELECT COUNT((item_grants->>'*1045_Item_FountainOfRenewal*')::INT)-COUNT((item_uses->>'*1045_Item_FountainOfRenewal*')::INT) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}

+

{{ sql_val("SELECT COUNT((item_grants->>'*1045_Item_FountainOfRenewal*')::INT)-COUNT((item_uses->>'*1045_Item_FountainOfRenewal*')::INT) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}

bought for the looks

@@ -113,7 +113,7 @@
-

{{ sql_val("SELECT SUM(participant.crystal_mine_captures) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}

+

{{ sql_val("SELECT SUM(participant.crystal_mine_captures) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}

slaughtered

@@ -128,7 +128,7 @@
-

{{ sql_val("SELECT SUM((participant.item_sells->>'*1038_Item_Flare*')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}

+

{{ sql_val("SELECT SUM((participant.item_sells->>'*1038_Item_Flare*')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}

thrown in trash

@@ -143,7 +143,7 @@
-

{{ sql_val("SELECT (SUM(match.duration)/60*5) / SUM(roster.kraken_captures) FROM match JOIN roster ON roster.match_api_id=match.api_id WHERE match.created_at > NOW() - '1 day'::INTERVAL") }}

+

{{ sql_val("SELECT (SUM(match.duration)/60*5) / SUM(roster.kraken_captures) FROM match JOIN roster ON roster.match_api_id=match.api_id WHERE match.created_at > NOW() - '1 day'::INTERVAL") }}

are needed to unleash a Kraken

@@ -158,7 +158,7 @@
-

{{ sql_val("SELECT SUM((item_uses->>'*1041_Item_MinionCandy*')::INT) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}

+

{{ sql_val("SELECT SUM((item_uses->>'*1041_Item_MinionCandy*')::INT) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}

Minion parties

@@ -173,7 +173,7 @@
every
-

{{ sql_val("SELECT SUM(match.duration)/60 / (SUM((participant.item_uses->>'*1052_Item_WeaponInfusion*')::INT) + SUM((participant.item_uses->>'*1053_Item_CrystalInfusion*')::INT)) 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") }}
minutes

+

{{ sql_val("SELECT SUM(match.duration)/60 / (SUM((participant.item_uses->>'*1052_Item_WeaponInfusion*')::INT) + SUM((participant.item_uses->>'*1053_Item_CrystalInfusion*')::INT)) 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") }}
minutes

a hero gets high

@@ -189,7 +189,7 @@
-

{{ sql_val("SELECT SUM((item_uses->>'*1054_Item_ScoutTrap*')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}

+

{{ sql_val("SELECT SUM((item_uses->>'*1054_Item_ScoutTrap*')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}

made the Fold a Dangerous Place

@@ -205,7 +205,7 @@
-

{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE hero='*SAW*' AND created_at > NOW() - '1 day'::INTERVAL") }}

+

{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE hero='*SAW*' AND created_at > NOW() - '1 day'::INTERVAL") }}

were pushed by SAW in the last 24h

-- cgit v1.3.1 From fbf08a6c59026957b3b4c3ba13c1450bf697f7bb Mon Sep 17 00:00:00 2001 From: Vainsocial root Date: Fri, 24 Mar 2017 18:57:02 +0000 Subject: do not show matches count for now --- minionlivesmatter/templates/index.html | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/minionlivesmatter/templates/index.html b/minionlivesmatter/templates/index.html index c185fb0..2f5aad7 100644 --- a/minionlivesmatter/templates/index.html +++ b/minionlivesmatter/templates/index.html @@ -220,8 +220,9 @@

- Based on Vainsocial users' data from the past 24 hours that by no means is representative to the whole player base of Vainglory. {{ sql_val("SELECT COUNT(*) FROM match WHERE created_at > NOW() - '1 day'::INTERVAL") }} matches are taken into account for the calculations. + Based on Vainsocial users' data from the past 24 hours that by no means is representative to the whole player base of Vainglory.

+
-- cgit v1.3.1 From 9388a47c2f9263593f10ce826cb748e4ce56d8c7 Mon Sep 17 00:00:00 2001 From: Vainsocial root 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 @@