Search found 3256 matches

by deen
Wed Jul 08, 2020 7:56 am
Forum: Official Discussions
Topic: DoNe does data analysis
Replies: 14
Views: 1078

Re: DoNe does data analysis

Untested, but it probably takes forever: select Name, sum(Points) from (select record_race.Name, Points from record_race inner join record_maps on record_race.Map = record_maps.Map group by record_race.Map, record_race.Name having min(record_race.Timestamp) >= NOW() - INTERVAL 1 WEEK) as m group by ...
by deen
Tue Jul 07, 2020 10:46 pm
Forum: Official Discussions
Topic: DDNet SQL dumps analysis
Replies: 16
Views: 3548

Re: DDNet SQL dumps analysis

I have given it a quick try, here you go: select sum(Points) from (select Points from record_race inner join record_maps on record_race.Map = record_maps.Map where Name = "murpi" group by record_race.Map having min(record_race.Timestamp) >= NOW() - INTERVAL 1 WEEK) as m; select sum(Points) from (sel...
by deen
Tue Jul 07, 2020 10:45 pm
Forum: Official Discussions
Topic: DoNe does data analysis
Replies: 14
Views: 1078

Re: DoNe does data analysis

I have given it a quick try, here you go: select sum(Points) from (select Points from record_race inner join record_maps on record_race.Map = record_maps.Map where Name = "murpi" group by record_race.Map having min(record_race.Timestamp) >= NOW() - INTERVAL 1 WEEK) as m; select sum(Points) from (sel...
by deen
Tue Jul 07, 2020 11:40 am
Forum: Official Discussions
Topic: DoNe does data analysis
Replies: 14
Views: 1078

Re: DoNe does data analysis

I have asked timakro if the git repo can be uploaded again.
by deen
Mon Jul 06, 2020 10:38 pm
Forum: Official Discussions
Topic: DDNet SQL dumps analysis
Replies: 16
Views: 3548

Re: DDNet SQL dumps analysis

Not so easy straight with SQL I guess (but still possible), we did it in Python: https://github.com/ddnet/ddnet-scripts/ ... #L324-L326
by deen
Sat Jun 27, 2020 12:26 am
Forum: Official Events
Topic: 7th Birthday Tournament: Patchwork
Replies: 3
Views: 398

7th Birthday Tournament: Patchwork

DDNet is turning seven years old soon and I'm proud to present to you another Summer Tournament. This time we are playing on a map that compiles the best of 7 years of DDNet history! Over 130 parts from 59 maps by 45 different mappers! Patchwork.png Join us on Saturday (not Sunday!), July 11 at 18:0...
by deen
Tue Jun 23, 2020 12:39 am
Forum: Events
Topic: Teeworlds Vanilla cup 3vs3
Replies: 3
Views: 427

Re: Teeworlds Vanilla cup 3vs3

Nice! I'll make sure to watch. I announced this on DDNet Discord too btw, hope that's fine.
by deen
Mon Jun 22, 2020 2:11 pm
Forum: Other Problems
Topic: [SOLVED] Stuck in the scoreboard and "tee swap"
Replies: 4
Views: 426

Re: Stuck in the scoreboard and "tee swap"

Yep, I can confirm. This is mostly likely caused by Learath2's sixup change to support Teeworlds 0.7. Progress will be tracked in https://github.com/ddnet/ddnet/issues/2318

Update: Should be fixed once servers are done restarting in ~1 day.
by deen
Sun Jun 21, 2020 10:24 pm
Forum: Other Problems
Topic: [SOLVED] Stuck in the scoreboard and "tee swap"
Replies: 4
Views: 426

Re: Stuck in the scoreboard and "tee swap"

I just tried with Teeworlds 0.6.5 and it works fine for me. Can you describe which DDNet servers it happens with? Maybe it depends on the map?
by deen
Tue Jun 09, 2020 3:06 pm
Forum: Players
Topic: Greetings
Replies: 3
Views: 576

Re: Greetings

Hi Kingston and welcome. Just FYI, most of the activity is on Discord nowadays.

Cheers
deen