summaryrefslogtreecommitdiff
path: root/minionlivesmatter/templates/index-2.html
diff options
context:
space:
mode:
authorschneefux <schneefux+commit@schneefux.xyz>2017-03-25 13:13:57 +0100
committerschneefux <schneefux+commit@schneefux.xyz>2017-03-25 13:13:57 +0100
commitd25ff2bddd44b9dac1ceb248424109d1782dd211 (patch)
tree34fcfd824a1a72e7b4d431b688adcea532b62180 /minionlivesmatter/templates/index-2.html
parenta2cbdd1b88ac723e5e441c0a3c22636f0a8c4dfd (diff)
downloadmeta-d25ff2bddd44b9dac1ceb248424109d1782dd211.tar.gz
meta-d25ff2bddd44b9dac1ceb248424109d1782dd211.zip
add minionlivesmatter as submodule
Diffstat (limited to 'minionlivesmatter/templates/index-2.html')
-rw-r--r--minionlivesmatter/templates/index-2.html115
1 files changed, 0 insertions, 115 deletions
diff --git a/minionlivesmatter/templates/index-2.html b/minionlivesmatter/templates/index-2.html
deleted file mode 100644
index 61f262e..0000000
--- a/minionlivesmatter/templates/index-2.html
+++ /dev/null
@@ -1,115 +0,0 @@
-<!DOCTYPE html>
-<html lang="en">
- <head>
- <meta charset="utf-8" />
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <title>Minion Lives Matter</title>
- <meta content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" name="viewport" />
- <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons" />
- <link rel="stylesheet" type="text/css" href="https://fonts.googleapis.com/css?family=Roboto:300,400,500,700" />
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/latest/css/font-awesome.min.css" />
- <link rel="stylesheet" href="assets/tether/dist/css/tether.min.css" />
- <link rel="stylesheet" href="assets/bootstrap/dist/css/bootstrap.min.css" />
- <link rel="stylesheet" href="assets/bootstrap-material-design/dist/bootstrap-material-design.min.css" />
- </head>
- <body>
- <nav class="navbar navbar-inverse bg-inverse fixed-top">
- <a class="navbar-brand" href="alpha.vainsocial.com">Vainsocial</a>
- </nav>
-
- <div class="container" style="padding: 3rem 1.5rem;">
- <div class="container">
- <h1>Minion Lives Matter</h1>
- <p>
- <em>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 this calculation.</em>
- <noscript>This site works without JavaScript! However, be aware that live stats won't update.</noscript>
- </p>
- </div>
-
- <div class="card">
- <div class="card-block">
- <h4 class="card-title"><span id="minions-killed-now">0</span> Minions died</h4>
- <p class="card-text">since you opened this page</p>
- <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 = 0;
- // sum(minions killed) / sum(game lengh s)
- setInterval(() => {
- minions += minions_per_second;
- $("#minions-killed-now").text(Math.floor(minions));
- }, 1000);
- </script>
- </div>
- </div>
- <div class="card">
- <div class="card-block">
- <h4 class="card-title">{{ 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") }} Fountains</h4>
- <!-- sum(FoR bought) - sum(FoR used) -->
- <p class="card-text">did not help their team</p>
- </div>
- </div>
- <div class="card">
- <div class="card-block">
- <h4 class="card-title">{{ 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") }} Minions</h4>
- <p class="card-text">are needed to unleash a Kraken</p>
- <!-- 1 wave = 3m * 1CS/m + 1m * 2CS/m = 5CS, 3 waves/min = 15CS/min = 5m/min -->
- <!-- (sum(game length s / 60)min * 5m/min) / sum(krakens) -->
- </div>
- </div>
- <div class="card">
- <div class="card-block">
- <h4 class="card-title">{{ sql_val("SELECT SUM(participant.crystal_mine_captures) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }} Crystal Sentries</h4>
- <!-- sum(miners) -->
- <p class="card-text">got slaugthered</p>
- </div>
- </div>
- <div class="card">
- <div class="card-block">
- <h4 class="card-title">{{ sql_val("SELECT SUM((participant.item_sells->>'*1038_Item_Flare*')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }} Flares</h4>
- <!-- sum(flares sold) -->
- <p class="card-text">got thrown into the trash</p>
- </div>
- </div>
- <div class="card">
- <div class="card-block">
- <h4 class="card-title">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</h4>
- <!-- sum(game length s)/60 / (sum(infusion wp) + sum(infusion cp)) -->
- <p class="card-text">A hero gets high on infusions</p>
- </div>
- </div>
- <div class="card">
- <div class="card-block">
- <h4 class="card-title">{{ sql_val("SELECT SUM((item_uses->>'*1054_Item_ScoutTrap*')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }} Scout Traps</h4>
- <!-- sum(game length s)/60 / (sum(infusion wp) + sum(infusion cp)) -->
- <p class="card-text">Scout Traps made the Halcyon Fold a dangerous place</p>
- </div>
- </div>
- <div class="card">
- <div class="card-block">
- <h4 class="card-title">{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE hero='*SAW*' AND created_at > NOW() - '1 day'::INTERVAL") }} Turrets</h4>
- <!-- sum(turret_kills) where hero=saw -->
- <p class="card-text">were pushed by a SAW</p>
- </div>
- </div>
- <div class="card">
- <div class="card-block">
- <h4 class="card-title">{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }} Turrets</h4>
- <!-- sum(turret_kills) -->
- <p class="card-text">need to be rebuilt by Minion Workers every day</p>
- </div>
- </div>
- <div class="card">
- <div class="card-block">
- <h4 class="card-title">{{ 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") }} Minions</h4>
- <!-- sum(minions killed) where match lost -->
- <!-- sum(minions killed) -->
- <p class="card-text">died for nothing</p>
- </div>
- </div>
- </div>
- <script src="assets/jquery/dist/jquery.min.js" type="text/javascript"></script>
- <script src="assets/tether/dist/js/tether.min.js" type="text/javascript"></script>
- <script src="assets/bootstrap/dist/js/bootstrap.min.js" type="text/javascript"></script>
- <script src="assets/bootstrap-material-design/dist/bootstrap-material-design.iife.min.js" type="text/javascript"></script>
- </body>
-</html>
generated by cgit v1.3.1 (git 2.54.0) at 2026-08-06 21:39:41 +0000