Page 2 of 2

Re: DDNet Database SQL Interpreter

Posted: Thu Apr 19, 2018 5:36 pm
by lola7
Lumpy ◐ω◑ wrote:
Mon Apr 16, 2018 1:28 pm
"Uncaught Error: no such table: race"
mhm
I still have the same error...

Re: DDNet Database SQL Interpreter

Posted: Tue Aug 21, 2018 12:05 pm
by Soapy Sandwich
As far as I can see the sqlite download file only contains info on map creators and not map finishes.
Is there anyway I can download part of or the whole list of map finishes?

Re: DDNet Database SQL Interpreter

Posted: Tue Aug 21, 2018 1:29 pm
by deen
It contains all map finishes in the race table. More kinds of downloads here: https://ddnet.tw/stats/

Edit: I see something is going wrong with the sql file. Let me fix.

Edit2: Fixed.

You might want to create some indices for performance though.

Re: DDNet Database SQL Interpreter

Posted: Thu Aug 23, 2018 11:55 pm
by Soapy Sandwich
Thanks deen working wonderfully now :)

In case you don't wanna calculate too much, here's a way to check just your total time on all map finishes,just change the "XXXXXXXXXXXXXX" to your name (Keeping the quatation marks).

select Sum(Time)/3600 As "Total Time" from race where Name = "XXXXXXXXXXXXXX";

Re: DDNet Database SQL Interpreter

Posted: Wed Aug 29, 2018 3:36 pm
by Lumpy ◐ω◑
How are you using it? I'm still getting this error: Uncaught Error: no such table: race

Re: DDNet Database SQL Interpreter

Posted: Wed Aug 29, 2018 3:53 pm
by deen
Lumpy ◐ω◑ wrote:
Wed Aug 29, 2018 3:36 pm
How are you using it? I'm still getting this error: Uncaught Error: no such table: race
It's a bit confusing. You have to follow the steps on the site and download and unzip the database file first, then load it into the site. You can also use sqlite on the command line instead of the website to open the sqlite file.

Re: DDNet Database SQL Interpreter

Posted: Wed Aug 29, 2018 7:11 pm
by Lumpy ◐ω◑
I did all as instructions say, but it didn't work, now it works, idk what have changed :D

Re: DDNet Database SQL Interpreter

Posted: Thu Dec 27, 2018 6:51 pm
by Ryozuki

Most dedicated gay players:
SELECT Name, COUNT(*) as "Map finishes" FROM race WHERE Name LIKE "%gay%" GROUP BY Name ORDER BY "Map finishes" DESC LIMIT 20;
Jao:
SELECT Name, COUNT(*) as "Map finishes" FROM race WHERE Name LIKE "%jao%" GROUP BY Name ORDER BY "Map finishes" DESC;