SQL export
CS:DM allows you to export essential data, such as kills, players, rounds, etc, into JSON or XLSX files.
While this is enough for most users, you may want to export more specific data.
Because it would be impossible to fit everyone's needs, you can benefit from data being stored in a database and creating custom exports using SQL.
If you are unfamiliar with SQL, you can use the W3Schools course to learn the basics.
Here is an example of a query that returns the most bought rifles per map:
SELECT weapon_name, map_name, COUNT(player_buys.id) AS "buy_count"
FROM player_buys
JOIN matches
ON matches.checksum = player_buys.match_checksum
WHERE weapon_type = 'rifle'
GROUP BY map_name, weapon_name
ORDER BY map_name, buy_count DESC
Example result:
weapon_name | map_name | buy_count |
---|---|---|
AK-47 | de_ancient | 112 |
M4A1 | de_ancient | 85 |
Galil AR | de_ancient | 13 |
AK-47 | de_inferno | 102 |
M4A1 | de_inferno | 91 |
AK-47 | de_nuke | 123 |
M4A1 | de_nuke | 88 |
To make it easier, it's recommended to use a database tool such as DBeaver, HeidiSQL, TablePlus, DataGrip etc. to run your queries and export the results more easily.
You should only read from the database, not modify it!
It could create potential issues in the application, please do not open an issue in that case.