Forum - DDraceNetwork

timakro wrote: ↑Tue Jul 07, 2020 6:47 pm 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 viewtopic.php?p=68411&sid=0c169f82cb9cf ... f5b#p68411 but its with python script.

I have given it a quick try, here you go:

deen wrote: ↑Tue Jul 07, 2020 10:45 pm I have given it a quick try, here you go:

Code: Select all

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 (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 MONTH) as m;

wow cool, is there possible to get top10 last week points with name and points ?

Untested, but it probably takes forever:

deen wrote: ↑Wed Jul 08, 2020 7:56 am Untested, but it probably takes forever:

Code: Select all

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 Name order by sum(Points) desc limit 10;

Thanks, worked fine.