summaryrefslogtreecommitdiff
path: root/templates/index.html
diff options
context:
space:
mode:
Diffstat (limited to 'templates/index.html')
-rw-r--r--templates/index.html47
1 files changed, 31 insertions, 16 deletions
diff --git a/templates/index.html b/templates/index.html
index 8c8a508..f40d425 100644
--- a/templates/index.html
+++ b/templates/index.html
@@ -41,7 +41,7 @@
<div class="wrapper">
<div class="container">
- <div class="card-box col-md-12 col-sm-12">
+ <div class="card-box col-md-6 col-sm-6">
<div class="card card-just-text card-with-border" data-background="image" data-src="assets/images/minion-top.jpg">
<div class="content">
<div class="filter filter-red"></div>
@@ -52,6 +52,20 @@
<div class="filter"></div>
</div> <!-- end card -->
</div>
+
+ <div class="card-box col-md-6 col-sm-6">
+ <div class="card card-just-text">
+ <div class="content">
+ <div class="filter"></div>
+ <h4 class="title title-modern"></h4>
+ <p class="description">
+ Poor Minions! No one thinks about the Minions.
+ We are raising awareness about how ruthless NPCs are treated in Vainglory. The killing needs to stop!
+ </p>
+ </div>
+ <div class="filter"></div>
+ </div> <!-- end card -->
+ </div>
</div>
@@ -80,7 +94,7 @@
<div class="content">
<div class="price">
<h6></h6>
- <h4 id="minions-killed-now">{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}<b class="currency"><br/></b></h4>
+ <h4>{{ data.turrets_rebuilt }}<b class="currency"><br/></b></h4>
</div>
<p class="description">rebuilt by workers every day</p>
</div>
@@ -95,7 +109,7 @@
<div class="content">
<div class="price">
<h6></h6>
- <h4 id="minions-killed-now">{{ sql_val("SELECT SUM(minion_kills) FROM participant WHERE NOT winner AND created_at > NOW() - '1 day'::INTERVAL") }} <b class="currency"><br/>out of {{ sql_val("SELECT SUM(minion_kills) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}<br/></b></h4>
+ <h4>{{ data.minions_for_nothing }} <b class="currency"><br/>out of {{ data.minions_total }}<br/></b></h4>
</div>
<p class="description">died for nothing</p>
</div>
@@ -110,7 +124,7 @@
<div class="content">
<div class="price">
<h6></h6>
- <h4 id="minions-killed-now">{{ 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") }}</h4>
+ <h4>{{ data.fountains_wasted }}</h4>
</div>
<p class="description">bought for the looks</p>
</div>
@@ -125,7 +139,7 @@
<div class="content">
<div class="price">
<h6></h6>
- <h4 id="minions-killed-now">{{ sql_val("SELECT SUM(participant.crystal_mine_captures) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}</h4>
+ <h4>{{ data.crystal_sentries }}</h4>
</div>
<p class="description">slaughtered</p>
</div>
@@ -140,7 +154,7 @@
<div class="content">
<div class="price">
<h6></h6>
- <h4 id="minions-killed-now">{{ sql_val("SELECT SUM((participant.item_sells->>'*1038_Item_Flare*')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}</h4>
+ <h4>{{ data.flares_sold }}</h4>
</div>
<p class="description">thrown in trash</p>
</div>
@@ -155,7 +169,7 @@
<div class="content">
<div class="price">
<h6></h6>
- <h4 id="minions-killed-now">{{ 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") }}</h4>
+ <h4>{{ data.minions_per_kraken }}</h4>
</div>
<p class="description">are needed to unleash a Kraken</p>
</div>
@@ -170,7 +184,7 @@
<div class="content">
<div class="price">
<h6></h6>
- <h4 id="minions-killed-now">{{ sql_val("SELECT SUM((item_uses->>'*1041_Item_MinionCandy*')::INT) FROM participant WHERE created_at > NOW() - '1 day'::INTERVAL") }}</h4>
+ <h4>{{ data.minion_candies }}</h4>
</div>
<p class="description">Minion parties</p>
</div>
@@ -185,7 +199,7 @@
<div class="content">
<div class="price">
<h6>every</h6>
- <h4 id="minions-killed-now">{{ 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") }}<b class="currency"><br/>minutes</b></h4>
+ <h4>{{ data.infusions_min }}<b class="currency"><br/>minutes</b></h4>
</div>
<p class="description">a hero gets high</p>
</div>
@@ -201,7 +215,7 @@
<div class="content">
<div class="price">
<h6></h6>
- <h4 id="minions-killed-now">{{ sql_val("SELECT SUM((item_uses->>'*1054_Item_ScoutTrap*')::INT) FROM participant WHERE participant.created_at > NOW() - '1 day'::INTERVAL") }}<b class="currency"><br/></b></h4>
+ <h4>{{ data.scout_traps }}<b class="currency"><br/></b></h4>
</div>
<p class="description">made the Fold a Dangerous Place</p>
</div>
@@ -217,7 +231,7 @@
<div class="content">
<div class="price">
<h6></h6>
- <h4 id="minions-killed-now">{{ sql_val("SELECT SUM(turret_kills) FROM participant WHERE hero='*SAW*' AND created_at > NOW() - '1 day'::INTERVAL") }}<b class="currency"><br/></b></h4>
+ <h4>{{ data.saw_turrets }}<b class="currency"><br/></b></h4>
</div>
<p class="description">were pushed by SAW in the last 24h</p>
</div>
@@ -232,8 +246,9 @@
<div class="content">
<p class="description">
- 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.
</p>
+ <!-- {{ data.matches }} matches are taken into account for the calculations. -->
</div>
<div class="filter"></div>
</div>
@@ -272,13 +287,13 @@
<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_per_second = {{ data.minions_min }};
var minions = 0;
- // sum(minions killed) / sum(game lengh s)
+ // sum(minions killed) / (seconds per day)
setInterval(() => {
- minions += minions_per_second;
+ minions += minions_per_second / 10;
$("#minions-killed-now").text(Math.floor(minions));
- }, 1000);
+ }, 100);
</script>
<!-- Just for demo -->
generated by cgit v1.3.1 (git 2.54.0) at 2026-09-20 07:12:32 +0000