Page 1 of 2
DDNet Database SQL Interpreter
Posted: Fri Apr 13, 2018 7:04 pm
by deen
You can now run your own SQL queries against the official DDNet database in SQLite format:
https://ddnet.tw/stats/sql.js/
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";
Feel free to share your own queries here.
Re: DDNet Database SQL Interpreter
Posted: Fri Apr 13, 2018 7:51 pm
by Ryozuki
nice
Re: DDNet Database SQL Interpreter
Posted: Sat Apr 14, 2018 12:46 am
by lola
how this works?
Re: DDNet Database SQL Interpreter
Posted: Sun Apr 15, 2018 4:18 am
by GG Kid
lola wrote: ↑Sat Apr 14, 2018 12:46 amhow this works?
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.
Re: DDNet Database SQL Interpreter
Posted: Sun Apr 15, 2018 2:20 pm
by lola
GG Kid wrote: ↑Sun Apr 15, 2018 4:18 am
lola wrote: ↑Sat Apr 14, 2018 12:46 amhow this works?
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.
So you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain!
Re: DDNet Database SQL Interpreter
Posted: Sun Apr 15, 2018 2:22 pm
by Ryozuki
lola wrote: ↑Sun Apr 15, 2018 2:20 pm
GG Kid wrote: ↑Sun Apr 15, 2018 4:18 am
lola wrote: ↑Sat Apr 14, 2018 12:46 amhow this works?
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.
So you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain!
You are just a faker and blocker. Thats all.
Re: DDNet Database SQL Interpreter
Posted: Sun Apr 15, 2018 2:23 pm
by lola
Ryozuki wrote: ↑Sun Apr 15, 2018 2:22 pm
lola wrote: ↑Sun Apr 15, 2018 2:20 pm
GG Kid wrote: ↑Sun Apr 15, 2018 4:18 am
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.
So you mean I'm not smart? Oh thank you Mr. smart guy with BIG brain!
You are just a faker and blocker. Thats all.
no u
Re: DDNet Database SQL Interpreter
Posted: Mon Apr 16, 2018 1:28 pm
by Lumpy ◐ω◑
"Uncaught Error: no such table: race"
mhm
Re: DDNet Database SQL Interpreter
Posted: Tue Apr 17, 2018 12:09 am
by lola
Lumpy ◐ω◑ wrote: ↑Mon Apr 16, 2018 1:28 pm
"Uncaught Error: no such table: race"
mhm
omg... you broke it
Re: DDNet Database SQL Interpreter
Posted: Tue Apr 17, 2018 7:30 am
by Lumpy ◐ω◑
lola wrote: ↑Tue Apr 17, 2018 12:09 am
omg... you broke it
I was following the instructions
