pentarctagon
fbaded8c01
Add another query to the MP Activity Report queries
...
count by map and era
2024-04-04 14:56:15 -05:00
pentarctagon
ec0f8f9942
exclude versions too old to have all data populated.
2023-11-11 18:29:46 -06:00
pentarctagon
82408b2131
change sorting.
2023-11-08 18:22:24 -06:00
Pentarctagon
6319401d60
Add new query for MP activity report
...
This gives a rolling count of how many players have played how many games, which is useful for seeing what player retention for MP is.
2023-08-11 12:24:18 -05:00
Pentarctagon
a22da2291b
Store side leader information in the database
...
Fixes #7267
Add new query for getting leader data.
2023-04-21 13:58:17 +02:00
Pentarctagon
8e6df8cd1f
Fix incorrect query for selecting new clients by download source.
...
The old query was:
* Selecting data from 2 months ago instead of 1 month ago for some reason, presumably left over from when I was testing the query out for different time periods.
* Counting non-new players who used a new download source as new players.
2023-04-14 22:32:48 -05:00
Pentarctagon
bc26194e5b
Add era to faction query.
2023-01-09 09:05:44 -06:00
Pentarctagon
fbeae32002
Rename database column SOURCE to ADDON_ID.
...
Also rename VERSION to ADDON_VERSION.
2023-01-06 19:59:26 -06:00
Pentarctagon
2db4add386
Fix column label name.
2022-09-03 02:22:29 -05:00
Pentarctagon
06b29d460d
Add query for new users by download source.
2022-09-03 02:21:37 -05:00
Pentarctagon
135e16e853
Fixup previous renaming.
2022-09-02 22:37:02 -05:00
Pentarctagon
9d5266d624
Add query fetching count of users playing their first game.
2022-08-29 23:27:31 -05:00
Pentarctagon
337894ac7b
Store add-on download count in the database.
...
The idea being that this could then also be included as a sheet in the multiplayer activity report, which would then be an easy way to view add-on downloads over time. This would of course not be especially useful until 1.18, since for 1.17 the database count would be starting at 0 even though existing add-ons would have a non-zero download count.
2022-06-04 11:21:00 -05:00
Pentarctagon
52ad51ab25
Looks like on 1.14 the afterlife bot doesn't always populate client source and version.
2022-05-06 16:41:14 -05:00
Pentarctagon
c9523e809c
Query fixup.
2022-05-06 16:28:40 -05:00
Pentarctagon
0a7ef1edf1
Add SQL to list unique users per day per source.
2022-04-15 10:27:36 -05:00
Pentarctagon
4cae3beea0
Add SQL to list unique users per day.
2022-04-15 09:45:16 -05:00
Pentarctagon
9b7a958e9a
Add a new query to get faction side count.
2021-03-12 00:27:06 -06:00
Pentarctagon
fa53539f37
Rename query output column
2021-02-26 13:59:30 -06:00
Pentarctagon
e43a0d8848
Update query scripts for new table.
2020-10-27 17:07:56 -05:00
Pentarctagon
3c6217fc1c
Update MP query scripts to report source add-on and version.
2020-08-17 16:38:23 -05:00
Pentarctagon
67c169ed80
Add scripts to pull various pieces of information from the MP database.
...
The intent being that I plan to run these once a month and post the results on the forum.
2020-03-26 14:54:53 -05:00
