DDNet Database SQL Interpreter

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.
lola7
Posts: 14
Joined: Thu Apr 19, 2018 5:09 pm

Re: DDNet Database SQL Interpreter

Post by lola7 »

Lumpy ◐ω◑ wrote: Mon Apr 16, 2018 1:28 pm "Uncaught Error: no such table: race"
mhm
I still have the same error...
Soapy Sandwich
Posts: 97
Joined: Wed Jan 06, 2016 7:50 pm
Player profile: http://ddnet.tw/players/Soapy-32-Sandwich/
Mapper profile: https://ddnet.tw/mappers/Soapy-32-Sandwich/

Re: DDNet Database SQL Interpreter

Post 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?
User avatar
deen
TECHNICAL Team
Posts: 3575
Joined: Mon May 05, 2014 2:30 pm
Player profile: https://ddnet.org/players/deen/
Discord: deen#5910

Re: DDNet Database SQL Interpreter

Post 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.
Soapy Sandwich
Posts: 97
Joined: Wed Jan 06, 2016 7:50 pm
Player profile: http://ddnet.tw/players/Soapy-32-Sandwich/
Mapper profile: https://ddnet.tw/mappers/Soapy-32-Sandwich/

Re: DDNet Database SQL Interpreter

Post 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";
User avatar
Lumpy ◐ω◑
Posts: 243
Joined: Wed Dec 16, 2015 10:53 am
Location: Russia
Player profile: https://ddnet.tw/players/Lumpy-32--9680--969--9681-/

Re: DDNet Database SQL Interpreter

Post by Lumpy ◐ω◑ »

How are you using it? I'm still getting this error: Uncaught Error: no such table: race
User avatar
deen
TECHNICAL Team
Posts: 3575
Joined: Mon May 05, 2014 2:30 pm
Player profile: https://ddnet.org/players/deen/
Discord: deen#5910

Re: DDNet Database SQL Interpreter

Post 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.
User avatar
Lumpy ◐ω◑
Posts: 243
Joined: Wed Dec 16, 2015 10:53 am
Location: Russia
Player profile: https://ddnet.tw/players/Lumpy-32--9680--969--9681-/

Re: DDNet Database SQL Interpreter

Post by Lumpy ◐ω◑ »

I did all as instructions say, but it didn't work, now it works, idk what have changed :D
User avatar
Ryozuki
Posts: 1748
Joined: Tue Feb 24, 2015 7:28 am
Location: Catalonia
Player profile: http://ddnet.tw/players/Ryozuki/
Mapper profile: http://ddnet.tw/mappers/Ryozuki/
Clan: Unique
Website: https://edgarluque.com
Discord: Ryozuki#2188

Re: DDNet Database SQL Interpreter

Post 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;
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests