Search found 3 matches

by miamia
Wed Jul 24, 2019 9:52 pm
Forum: Official Discussions
Topic: DDNet SQL dumps analysis
Replies: 16
Views: 33805

Re: DDNet SQL dumps analysis

How did you do the connected graph for rank team? First, create a server_mapping table that will be used to "sanitize" the data. We will map GER2 to GER, and we won't take into account the servers that had a short life (FRA, KSA, vanilla...). CREATE TABLE server_mapping ( Server char(4) C...
by miamia
Tue Jul 23, 2019 11:55 pm
Forum: Official Discussions
Topic: DDNet SQL dumps analysis
Replies: 16
Views: 33805

Re: DDNet SQL dumps analysis

Care for your Time manipulates your race time when you fail (it adds some seconds). So the 380 hours on that map are not actual playtime, you might want to exclude this map for the worst time award. Oh right ! I didn't know these tiles existed. So yes, the official "play time" record is 4...
by miamia
Sat Jul 20, 2019 10:27 pm
Forum: Official Discussions
Topic: DDNet SQL dumps analysis
Replies: 16
Views: 33805

DDNet SQL dumps analysis

Hi everyone, We all know that under the Freedom Of Information Act, the Congress have indicted the ddnet admin to release the SQL dumps of the race records (https://forum.ddnet.tw/viewtopic.php?f=3&t=1852). Unfortunately, the latest try to analyze the data is quite old (https://forum.ddnet.tw/vi...