DDNet Database SQL Interpreter

More serious discussions, information about official DDNet servers, important announcements.
lola7
Banned
Posts: 14
Joined: Thu Apr 19, 2018 5:09 pm

Re: DDNet Database SQL Interpreter

Post by lola7 » Thu Apr 19, 2018 5:36 pm

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

Soapy Sandwich
User
Posts: 97
Joined: Wed Jan 06, 2016 7:50 pm
Player profile: Soapy Sandwich
Mapper profile: Soapy Sandwich

Re: DDNet Database SQL Interpreter

Post by Soapy Sandwich » Tue Aug 21, 2018 12:05 pm

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?

User avatar
deen
Retired Administrator
Posts: 3274
Joined: Mon May 05, 2014 2:30 pm
Player profile: deen

Re: DDNet Database SQL Interpreter

Post by deen » Tue Aug 21, 2018 1:29 pm

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.

Soapy Sandwich
User
Posts: 97
Joined: Wed Jan 06, 2016 7:50 pm
Player profile: Soapy Sandwich
Mapper profile: Soapy Sandwich

Re: DDNet Database SQL Interpreter

Post by Soapy Sandwich » Thu Aug 23, 2018 11:55 pm

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";

User avatar
Lumpy ◐ω◑
User
Posts: 232
Joined: Wed Dec 16, 2015 10:53 am
Location: Russia, Ekaterinburg
Player profile: Lumpy ◐ω◑

Re: DDNet Database SQL Interpreter

Post by Lumpy ◐ω◑ » Wed Aug 29, 2018 3:36 pm

How are you using it? I'm still getting this error: Uncaught Error: no such table: race

User avatar
deen
Retired Administrator
Posts: 3274
Joined: Mon May 05, 2014 2:30 pm
Player profile: deen

Re: DDNet Database SQL Interpreter

Post by deen » Wed Aug 29, 2018 3:53 pm

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.

User avatar
Lumpy ◐ω◑
User
Posts: 232
Joined: Wed Dec 16, 2015 10:53 am
Location: Russia, Ekaterinburg
Player profile: Lumpy ◐ω◑

Re: DDNet Database SQL Interpreter

Post by Lumpy ◐ω◑ » Wed Aug 29, 2018 7:11 pm

I did all as instructions say, but it didn't work, now it works, idk what have changed :D

User avatar
Ryozuki
User
Posts: 1741
Joined: Tue Feb 24, 2015 7:28 am
Location: Catalonia
Player profile: Ryozuki
Mapper profile: Ryozuki
Clan: Unique
Website: https://ryozuki.xyz/

Re: DDNet Database SQL Interpreter

Post by Ryozuki » Thu Dec 27, 2018 6:51 pm


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;

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest