Database: Difference between revisions

Latest revision as of 09:19, 29 August 2024

CKRAS provides a free database (Gaming SQL) 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. >> Deutsch

Webinterface

Click on this link in the webinterface and you can view the settings of your MySQL server for your gameserver.

NOTE: A database can only be created if a gameserver has been rented!

Access to this page is only possible for the main admin, sub-users cannot view the MySQL page

When connecting to the MySQL Settings page for the first time, you must first create the database by clicking on CREATE.

Once the database has been created, you can copy the MySQL data and paste it into the configurations of your plugins accordingly.

Please pay attention to the respective readme of the programmers and plugin authors when setting up.

If you want to change the password for your MySQL, you can do this with a simple click on "generate new password". please change the configs of your plugins afterwards so that they can continue to run correctly.

Example with MatchZy

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": "gamingsql.ckras.com",
"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. More soon!

phpMyAdmin

https://sqladmin.ckras.com/gamingsql/

You can manage your Database in the phpMyAdmin Panel

Webinterface | CS2 | MatchZy

@@ Line 1: / Line 1: @@
-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]].
+CKRAS provides a free database (Gaming SQL) 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://wiki.ckras.com/wiki/index.php?title=Datenbank Deutsch] [[File:Germany.png|alt=Deutsch|20x20px|link=https://wiki.ckras.com/wiki/index.php?title=Datenbank]]
+== Webinterface ==
+[[File:Gaming-sql.png|alt=Gaming SQL]]
+Click on this link in the [[webinterface]] and you can view the settings of your MySQL server for your [[gameserver]].
+NOTE: A database can only be created if a [[gameserver]] has been rented!
+[[File:Db-create.png|alt=DB CREATE|750x750px]]
+Access to this page is only possible for the main admin, [https://wiki-en.ckras.com/wiki/index.php?title=Webinterface#Sub-User sub-users] cannot view the MySQL page
+When connecting to the MySQL Settings page for the first time, you must first create the database by clicking on CREATE.
+[[File:Db-settings.png|alt=DB SETTINGS|750x750px]]
+Once the database has been created, you can copy the MySQL data and paste it into the configurations of your plugins accordingly.
+Please pay attention to the respective readme of the programmers and [[MatchZy|plugin]] authors when setting up.
+[[File:Db-change-password.png|alt=DB Change Password|750x750px]]
+If you want to change the password for your MySQL, you can do this with a simple click on "generate new password". please change the configs of your plugins afterwards so that they can continue to run correctly.
+===  Example with MatchZy ===
 https://shobhit-pathak.github.io/MatchZy/database_stats/
@@ Line 6: / Line 31: @@
 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",
+  "MySqlHost": "gamingsql.ckras.com",
   "MySqlDatabase": "your_mysql_database",
   "MySqlUsername": "your_mysql_username",
@@ Line 13: / Line 38: @@
 === 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>.
+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>. More soon!
+== phpMyAdmin ==
+[[File:Phpmyadmin-sql.png|alt=PHP MY ADMIN|400x400px]]
+https://sqladmin.ckras.com/gamingsql/
+You can manage your Database in the phpMyAdmin Panel
 [[Webinterface]] | [[CS2]] | [[MatchZy]]
 [[Category:CS2]]