More fun statistics

Read and discuss official announcements, information and news about the DDRaceNetwork.
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.
SPSomeone
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

Post by SPSomeone »

A list about the most missclicks by ddnet staff
Image
Savander
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

Post by Savander »

| Care for your Time | Savander-Long | 1440.2200520833333 |


What the ?
User avatar
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

Post by stompie »

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;


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
\,,/(◣_◢)\,,/
User avatar
senpa'
Posts: 189
Joined: Fri Nov 18, 2016 2:05 pm
Clan: nimo
YouTube: user/nickelodeon

Re: More fun statistics

Post by senpa' »

i do not understand this
finish me pls

I want helper
User avatar
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

Post by stompie »

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
\,,/(◣_◢)\,,/
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests