Database: Difference between revisions
No edit summary |
No edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
=== Using MySQL Database with MatchZy === | === Using MySQL Database with MatchZy === | ||
To use MySQL Database with MatchZy, open <code>csgo/cfg/MatchZy/database.json</code> file. It's content will be like this: | To use MySQL Database with MatchZy, open <code>/csgo/cfg/MatchZy/database.json</code> file. It's content will be like this, you can edit this file via [https://wiki-en.ckras.com/wiki/index.php?title=CS2#FTP_Usage 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: <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
