DDNet Database SQL Interpreter

[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.

[Ryozuki]

nice

[lola]

how this works?

[GG Kid]

how 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.

[lola]

how 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!

[Ryozuki]

how 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.

[lola]

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

[Lumpy ◐ω◑]

"Uncaught Error: no such table: race"
mhm

[lola]

"Uncaught Error: no such table: race"
mhm

omg... you broke it

[Lumpy ◐ω◑]

omg... you broke it

I was following the instructions