Database: Difference between revisions
No edit summary |
No edit summary |
||
| Line 15: | Line 15: | ||
Once a match is over, data is pulled from the database and a CSV file is written in the folder: <code>/csgo/MatchZy_Stats</code>. This folder will contain CSV file for each match (file name pattern: <code>match_data_map{mapNumber}_{matchId}.csv</code>) and it will have the same data which is present in <code>matchzy_stats_players</code>. | Once a match is over, data is pulled from the database and a CSV file is written in the folder: <code>/csgo/MatchZy_Stats</code>. This folder will contain CSV file for each match (file name pattern: <code>match_data_map{mapNumber}_{matchId}.csv</code>) and it will have the same data which is present in <code>matchzy_stats_players</code>. | ||
=== phpMyAdmin === | |||
[[File:Phpmyadmin-sql.png|alt=PHP MY ADMIN|400x400px]] | |||
https://sqladmin.ckras.com/gamingsql/ | |||
phpMyAdmin Panel | |||
[[Webinterface]] | [[CS2]] | [[MatchZy]] | [[Webinterface]] | [[CS2]] | [[MatchZy]] | ||
[[Category:CS2]] | [[Category:CS2]] | ||
Revision as of 16:27, 1 July 2024
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.
phpMyAdmin
https://sqladmin.ckras.com/gamingsql/
phpMyAdmin Panel
Webinterface | CS2 | MatchZy
