From d25ff2bddd44b9dac1ceb248424109d1782dd211 Mon Sep 17 00:00:00 2001 From: schneefux Date: Sat, 25 Mar 2017 13:13:57 +0100 Subject: add minionlivesmatter as submodule --- minionlivesmatter/templates/index.html | 296 --------------------------------- 1 file changed, 296 deletions(-) delete mode 100644 minionlivesmatter/templates/index.html (limited to 'minionlivesmatter/templates/index.html') diff --git a/minionlivesmatter/templates/index.html b/minionlivesmatter/templates/index.html deleted file mode 100644 index e6b6ee1..0000000 --- a/minionlivesmatter/templates/index.html +++ /dev/null @@ -1,296 +0,0 @@ - - - - - - - - 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. -

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