From 54b8482223288a4d5df41267f3c9235bab06c15e Mon Sep 17 00:00:00 2001 From: schneefux Date: Fri, 24 Mar 2017 17:12:23 +0100 Subject: add minionlivesmatter --- minionlivesmatter/templates/index.html | 295 +++++++++++++++++++++++++++++++++ 1 file changed, 295 insertions(+) create mode 100644 minionlivesmatter/templates/index.html (limited to 'minionlivesmatter/templates/index.html') diff --git a/minionlivesmatter/templates/index.html b/minionlivesmatter/templates/index.html new file mode 100644 index 0000000..b7d2511 --- /dev/null +++ b/minionlivesmatter/templates/index.html @@ -0,0 +1,295 @@ + + + + + + + + Vainsocial Fun - Minion Lives Matter + + + + + + + + + + + + + + + + + +
+
+
+
+
+
+

"Minions Lives Matter."

+

shutterfly@vainsocial

+
+ +
+
+
+
+ + +
+ +
+
+

Minions

+ +
+
+
+

0

+
+

have died since you opened this page

+
+
+
+
+ + +
+
+

Turrets

+ +
+
+
+

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

+
+

rebuilt by workers every day

+
+
+
+
+ +
+
+

Minions

+ +
+
+
+

{{ 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

+
+
+
+
+ +
+
+

Fountains

+ +
+
+
+

{{ 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

+
+
+
+
+ +
+
+

Crystal Sentries

+ +
+
+
+

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

+
+

slaughtered

+
+
+
+
+ +
+
+

Flares

+ +
+
+
+

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

+
+

thrown in trash

+
+
+
+
+ +
+
+

Minions

+ +
+
+
+

{{ 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

+
+
+
+
+ +
+
+

Minion Candies

+ +
+
+
+

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

+
+

Minion parties

+
+
+
+
+ +
+
+

Infusions

+ +
+
+
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

+
+

a hero gets high

+
+
+
+
+ + +
+
+

Scout Traps

+ +
+
+
+

{{ 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

+
+
+
+
+ + +
+
+

Turrets

+ +
+
+
+

{{ 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

+
+
+
+
+ + +
+
+

Data

+ +
+

+ 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. +

+
+
+
+
+ + + +
+ +
+ + + + + + + + + + + + + + + + + -- cgit v1.3.1