Include data from the Multiplayer Activity Report

[soliton-]

Currently the Multiplayer Activity Report is generated with these queries:
https://github.com/wesnoth/wesnoth/tree/master/utils/mp-server/query-scripts
and published on the forum: https://forums.wesnoth.org/viewtopic.php?t=57533

I think it would be a good fit to add these queries as much as possible into the dashboard. The more complex ones probably as tables as is done in the report and simpler ones as charts like the OOS or client version count which is already included (though the report only counts games longer than 5 minutes).

Ideally this would remove the need to do that report on the forum manually and would allow more flexibility for users to for example choose their own date range to analyze.

[soliton-]

@Pentarctagon maybe you can comment if you would like to see this and if you have any further insights on how it should be done.

[Pentarctagon]

I think this would be useful to have. It does take a couple minutes to run all 29 (so far) queries though, so I don't know if it would make sense to have them all be populated every time someone chooses a new time range. Maybe have similar queries grouped into separate tabs or something.

[max-torch]

I think this would be useful to have. It does take a couple minutes to run all 29 (so far) queries though, so I don't know if it would make sense to have them all be populated every time someone chooses a new time range. Maybe have similar queries grouped into separate tabs or something.

Can you share with me the list of the exact 29 queries in SQL, so that this can be worked on. Do the queries have to be kept private for security? If not, then maybe can post it them in this thread.

We can design this such that the DB is not yet queried when changing the date. We will divide the 29 queries into groups. Then, below the date picker there will be buttons for executing each "group" of queries, considering the chosen date range. This will allow running only some of the queries instead of all, which the user may not care about.

[soliton-]

I linked to the queries https://github.com/wesnoth/wesnoth/tree/master/utils/mp-server/query-scripts. There is one file per query there.