More fun statistics
Forum rules
Please consider wheter there is a more appropiate subforum before creating a new thread here.
This is for offical DDRaceNetwork-related information and discussion only.
Please consider wheter there is a more appropiate subforum before creating a new thread here.
This is for offical DDRaceNetwork-related information and discussion only.
-
- Posts: 350
- Joined: Mon Nov 21, 2016 9:29 pm
- Player profile: https://ddnet.tw/players/SP-32--124--32-Someone/
- Clan: Somepeople
Re: More fun statistics
A list about the most missclicks by ddnet staff
-
- Posts: 153
- Joined: Sun Jul 13, 2014 11:57 am
- Location: Poland
- Player profile: http://ddnet.tw/players/Savander/
- Mapper profile: http://ddnet.tw/mappers/Savander/
- Website: http://codrig.com
Re: More fun statistics
| Care for your Time | Savander-Long | 1440.2200520833333 |
What the ?
What the ?
- stompie
- Posts: 700
- Joined: Thu Jun 18, 2015 2:40 pm
- Player profile: http://ddnet.tw/players/stompie/
- Mapper profile: https://ddnet.tw/mappers/stompie/
Re: More fun statistics
Highest sum of length of all ranks on a map:
select Map, sum(Time)/3600 as Hours from race group by Map order by sum(Time) desc limit 20;
Time Spent in all ranks:
select Name, sum(Time)/3600 as "Time spent in all ranks (in hours)" from race group by Name order by sum(Time) desc limit 20;
That is way to much work for such little result hope someone enjoys it
select Map, sum(Time)/3600 as Hours from race group by Map order by sum(Time) desc limit 20;
Map------------------------------Hours
+
| Kobra------------------------------38765.245122222135
| Kobra 2----------------------------27982.62864444442
| Multimap--------------------------24283.24531111097
| Kobra 4 --------------------------- 23366.235755555634
| Epix--------------------------------15935.16048333331
| Absurd 4-------------------------- 11547.857427777806
| Just2Easy--------------------------11385.69622222234
| Kobra 3 ----------------------------11131.744294444397
| Purple Panic------------------------10418.075322222114
| Light Grey---------------------------6847.598966666679
| Baby Aim 1.0 -----------------------6626.880650000025
| Icebreaker---------------------------6249.058099999973
| Absurd 2---------------------------- 5875.950361111107
| Baby Aim 2.0------------------------5389.1742777777445
| Sunny Land--------------------------5352.0100722222105
| Monster -----------------------------5187.930294444456
| Seasons------------------------------4909.979211111118
| Introduction---------------------------4532.893244444448
| ZeroX-----------------------------------4517.336333333355
Time Spent in all ranks:
select Name, sum(Time)/3600 as "Time spent in all ranks (in hours)" from race group by Name order by sum(Time) desc limit 20;
Name---------------------------------Time spent in all ranks (in hours)
+
| brainless tee -------------------------4838.6630277777485
| nameless tee ------------------------3966.9954055555486
| Starkiller ------------------------------1479.472877777781
| Deathman -----------------------------1465.1695166666639
| Grk0ne -------------------------------1339.2010222222186
| (1) ------------------------------------1321.911116666669
| Cola Dose ----------------------------1218.2997888888913
| HaHAxD* -----------------------------1174.6937055555563
| Soapy Sandwich ---------------------1168.7344499999922
| Beiroc --------------------------------1164.0378611111125
| <BµmM> -----------------------------1154.7299999999989
| bano ----------------------------------1143.1061166666666
| Neko ----------------------------------1072.3265833333353
| Freezestyler -------------------------1020.8300500000024
| gL. | Kenzo --------------------------1001.8979833333314
| tinky ----------------------------------990.6651777777779
| Esckiller -------------------------------989.3825722222196
| triki -----------------------------------971.6235611111098
| Broken --------------------------------963.8762999999997
| Goran ---------------------------------948.9441444444444
That is way to much work for such little result hope someone enjoys it
\,,/(◣_◢)\,,/
- stompie
- Posts: 700
- Joined: Thu Jun 18, 2015 2:40 pm
- Player profile: http://ddnet.tw/players/stompie/
- Mapper profile: https://ddnet.tw/mappers/stompie/
Re: More fun statistics
whats not to understand first group of numbers is the amount of hours spent on that map collectively by all players and the second group of numbers is the amount of hours one player has with all their finishes
\,,/(◣_◢)\,,/
Who is online
Users browsing this forum: No registered users and 24 guests