Search found 7 matches

by Nirvana
Wed Jul 08, 2020 8:21 am
Forum: Official Discussions
Topic: DoNe does data analysis
Replies: 14
Views: 15242

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 Nirvana
Wed Jul 08, 2020 7:41 am
Forum: Official Discussions
Topic: DoNe does data analysis
Replies: 14
Views: 15242

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...
by Nirvana
Tue Jul 07, 2020 8:32 pm
Forum: Official Discussions
Topic: DoNe does data analysis
Replies: 14
Views: 15242

Re: DoNe does data analysis

Can't find it on my disk so it's probably lost forever :/ Ah sad news, so maybe you know how can get the mostly "last week/month points" with mysql? I asked for this in https://forum.ddnet.tw/viewtopic.php?p=68411&sid=0c169f82cb9cf2d9b03bc3ae3e1e3f5b#p68411 but its with python script.
by Nirvana
Tue Jul 07, 2020 11:59 am
Forum: Official Discussions
Topic: DoNe does data analysis
Replies: 14
Views: 15242

Re: DoNe does data analysis

deen wrote: Tue Jul 07, 2020 11:40 am I have asked timakro if the git repo can be uploaded again.
Thank you.
by Nirvana
Tue Jul 07, 2020 5:35 am
Forum: Official Discussions
Topic: DDNet SQL dumps analysis
Replies: 16
Views: 33934

Re: DDNet SQL dumps analysis

deen wrote: Mon Jul 06, 2020 10:38 pm Not so easy straight with SQL I guess (but still possible), we did it in Python: https://github.com/ddnet/ddnet-scripts/ ... #L324-L326
Ah, i tought its possible with SQL.
by Nirvana
Mon Jul 06, 2020 3:12 pm
Forum: Official Discussions
Topic: DDNet SQL dumps analysis
Replies: 16
Views: 33934

Re: DDNet SQL dumps analysis

Nice, how get last week/month points ?