DDNet Database SQL Interpreter
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.
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.
-
- 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
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?
Is there anyway I can download part of or the whole list of map finishes?
- deen
- Posts: 3576
- Joined: Mon May 05, 2014 2:30 pm
- Player profile: https://ddnet.org/players/deen/
- Discord: deen#5910
Re: DDNet Database SQL Interpreter
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.
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.
-
- 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
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";
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";
- 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
How are you using it? I'm still getting this error: Uncaught Error: no such table: race
- deen
- Posts: 3576
- Joined: Mon May 05, 2014 2:30 pm
- Player profile: https://ddnet.org/players/deen/
- Discord: deen#5910
Re: DDNet Database SQL Interpreter
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.
- 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
I did all as instructions say, but it didn't work, now it works, idk what have changed
- 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
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;
Who is online
Users browsing this forum: No registered users and 9 guests