Database

From CKRAS Wiki

Revision as of 15:17, 1 July 2024 by Ckras (talk | contribs)

CKRAS provides a free database for your gameserver. Certain plugins such as MatchZy offer additional features such as "statistics" when you connect a database. In this guide we will show you what you need to configure and where you can find the access data for the included free database for your gameserver.

https://shobhit-pathak.github.io/MatchZy/database_stats/

Using MySQL Database with MatchZy

To use MySQL Database with MatchZy, open /csgo/cfg/MatchZy/database.json file. It's content will be like this, you can edit this file via FTP.

"DatabaseType": "MySQL",
"MySqlHost": "your_mysql_host",
"MySqlDatabase": "your_mysql_database",
"MySqlUsername": "your_mysql_username",
"MySqlPassword": "your_mysql_password",
"MySqlPort": 3306

CSV Stats

Once a match is over, data is pulled from the database and a CSV file is written in the folder: /csgo/MatchZy_Stats. This folder will contain CSV file for each match (file name pattern: match_data_map{mapNumber}_{matchId}.csv) and it will have the same data which is present in matchzy_stats_players.


Webinterface | CS2 | MatchZy