DDNet Database SQL Interpreter
DDNet Database SQL Interpreter
You can now run your own SQL queries against the official DDNet database in SQLite format: https://ddnet.tw/stats/sql.js/
Sample queries:
Feel free to share your own queries here.
Sample queries:
Code: Select all
select * from race order by Timestamp asc limit 30;
select * from race where Timestamp >= "2018-01-01" order by Timestamp asc limit 30;
select Mapper, count(*) from maps group by Mapper order by count(*) desc limit 30;
select Name, Map, count(*) from race group by Name, Map order by count(*) desc limit 30;
select sum(Points) from maps join (select distinct Map from race where Name = "nameless tee") as r on maps.Map = r.Map;
select Name, sum(Time)/3600 as "Time spent in all ranks (in hours)" from race group by Name order by sum(Time) desc limit 30;
select Map, Name, Time/60 as "Time (in minutes)" from race order by Time desc limit 30;
delete from race where Name = "deen";
- Ryozuki
- Posts: 1743
- 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
how this works?
-
- Posts: 254
- Joined: Sun Apr 16, 2017 2:33 am
- Location: U.S.A.
- Player profile: Bolto
- Clan: Kerger
Re: DDNet Database SQL Interpreter
lola it's "How does this work?". well here is a basic answerer; smart people who know programing/Coding stuff can now more easily get a (players) name statistics for there own use. it's not a very accurate description but it should get you A basic understanding.
Last edited by GG Kid on Sun Apr 15, 2018 11:15 pm, edited 1 time in total.
Re: DDNet Database SQL Interpreter
So you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain!GG Kid wrote: ↑Sun Apr 15, 2018 4:18 amlola it's "How does this work?". well here is a basic answerer; smart people who know programing/Coding stuff can now more easily get a (players) name statistics for there own use. it's not a very accurate description but it should get you A basic understanding.

- Ryozuki
- Posts: 1743
- 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
You are just a faker and blocker. Thats all.lola wrote: ↑Sun Apr 15, 2018 2:20 pmSo you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain!GG Kid wrote: ↑Sun Apr 15, 2018 4:18 amlola it's "How does this work?". well here is a basic answerer; smart people who know programing/Coding stuff can now more easily get a (players) name statistics for there own use. it's not a very accurate description but it should get you A basic understanding.![]()
Website: https://ryozuki.xyz
Re: DDNet Database SQL Interpreter
no uRyozuki wrote: ↑Sun Apr 15, 2018 2:22 pmYou are just a faker and blocker. Thats all.lola wrote: ↑Sun Apr 15, 2018 2:20 pmSo you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain!GG Kid wrote: ↑Sun Apr 15, 2018 4:18 amlola it's "How does this work?". well here is a basic answerer; smart people who know programing/Coding stuff can now more easily get a (players) name statistics for there own use. it's not a very accurate description but it should get you A basic understanding.![]()
- Lumpy ◐ω◑
- Posts: 234
- Joined: Wed Dec 16, 2015 10:53 am
- Location: Russia, Ekaterinburg
- Player profile: Lumpy ◐ω◑
Re: DDNet Database SQL Interpreter
"Uncaught Error: no such table: race"
mhm
mhm
Who is online
Users browsing this forum: No registered users and 2 guests