blob: 61f262e0af37fb5d4b50e041cb94da2be33166e0 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
<!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>
|
