More fun statistics

More serious discussions, information about official DDNet servers, important announcements.
SPSomeone
User
Posts: 326
Joined: Mon Nov 21, 2016 9:29 pm
Player profile: SP | Someone
Clan: Somepeople

Re: More fun statistics

Post by SPSomeone » Wed Apr 26, 2017 1:52 pm

A list about the most missclicks by ddnet staff
Image

Savander
User
Posts: 153
Joined: Sun Jul 13, 2014 11:57 am
Location: Poland
Player profile: Savander
Mapper profile: Savander
Website: http://codrig.com

Re: More fun statistics

Post by Savander » Tue May 02, 2017 3:07 pm

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


What the ?

User avatar
stompie
User
Posts: 686
Joined: Thu Jun 18, 2015 2:40 pm
Player profile: stompie
Mapper profile: stompie

Re: More fun statistics

Post by stompie » Sun Dec 30, 2018 9:19 pm

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'
User
Posts: 190
Joined: Fri Nov 18, 2016 2:05 pm
Clan: nimo
Contact:

Re: More fun statistics

Post by senpa' » Mon Dec 31, 2018 3:51 pm

i do not understand this
finish me pls

I want helper

User avatar
stompie
User
Posts: 686
Joined: Thu Jun 18, 2015 2:40 pm
Player profile: stompie
Mapper profile: stompie

Re: More fun statistics

Post by stompie » Mon Dec 31, 2018 11:09 pm

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: ChillerDragon and 3 guests