Search found 7 matches
- Wed Jul 08, 2020 8:21 am
- Forum: Official Discussions
- Topic: DoNe does data analysis
- Replies: 14
- Views: 24356
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...
- Wed Jul 08, 2020 7:41 am
- Forum: Official Discussions
- Topic: DoNe does data analysis
- Replies: 14
- Views: 24356
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...
- Tue Jul 07, 2020 8:32 pm
- Forum: Official Discussions
- Topic: DoNe does data analysis
- Replies: 14
- Views: 24356
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.
- Tue Jul 07, 2020 11:59 am
- Forum: Official Discussions
- Topic: DoNe does data analysis
- Replies: 14
- Views: 24356
- Tue Jul 07, 2020 5:54 am
- Forum: Official Discussions
- Topic: DoNe does data analysis
- Replies: 14
- Views: 24356
- Tue Jul 07, 2020 5:35 am
- Forum: Official Discussions
- Topic: DDNet SQL dumps analysis
- Replies: 16
- Views: 50202
Re: DDNet SQL dumps analysis
Ah, i tought its possible with SQL.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
- Mon Jul 06, 2020 3:12 pm
- Forum: Official Discussions
- Topic: DDNet SQL dumps analysis
- Replies: 16
- Views: 50202
Re: DDNet SQL dumps analysis
Nice, how get last week/month points ?