Database - Revision history

Ckras: /* CSV Stats */

2024-08-29T08:19:40Z

CSV Stats

← Older revision		Revision as of 10:19, 29 August 2024
Line 38:		Line 38:

	=== CSV Stats ===		=== 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 ==		== phpMyAdmin ==

Ckras: /* Using MySQL Database with MatchZy */

2024-08-23T08:34:50Z

Using MySQL Database with MatchZy

← Older revision		Revision as of 10:34, 23 August 2024
Line 31:		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].		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",		"DatabaseType": "MySQL",
	"MySqlHost": "~~your_mysql_host~~",		"MySqlHost": "gamingsql.ckras.com",
	"MySqlDatabase": "your_mysql_database",		"MySqlDatabase": "your_mysql_database",
	"MySqlUsername": "your_mysql_username",		"MySqlUsername": "your_mysql_username",

Ckras: /* phpMyAdmin */

2024-07-16T07:15:21Z

phpMyAdmin

← Older revision		Revision as of 09:15, 16 July 2024
Line 45:		Line 45:
	https://sqladmin.ckras.com/gamingsql/		https://sqladmin.ckras.com/gamingsql/

	phpMyAdmin Panel		You can manage your Database in the phpMyAdmin Panel

	[[Webinterface]] \| [[CS2]] \| [[MatchZy]]		[[Webinterface]] \| [[CS2]] \| [[MatchZy]]
	[[Category:CS2]]		[[Category:CS2]]

Ckras: /* Webinterface */

2024-07-10T07:55:46Z

Webinterface

← Older revision		Revision as of 09:55, 10 July 2024
Line 6:		Line 6:

	Click on this link in the [[webinterface]] and you can view the settings of your MySQL server for your [[gameserver]].		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]]		[[File:Db-create.png\|alt=DB CREATE\|750x750px]]

Ckras: /* Webinterface */

2024-07-03T13:22:42Z

Webinterface

← Older revision		Revision as of 15:22, 3 July 2024
Line 23:		Line 23:
	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.		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 ===
	Example:

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

	== 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, you can edit this file via [https://wiki-en.ckras.com/wiki/index.php?title=CS2#FTP_Usage FTP].		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",		"DatabaseType": "MySQL",
Line 37:		Line 35:
	"MySqlPort": 3306		"MySqlPort": 3306

	== CSV Stats ==		=== 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>.

Ckras at 08:27, 3 July 2024

2024-07-03T08:27:38Z

← Older revision		Revision as of 10:27, 3 July 2024
Line 28:		Line 28:
	https://shobhit-pathak.github.io/MatchZy/database_stats/		https://shobhit-pathak.github.io/MatchZy/database_stats/

	=== 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, you can edit this file via [https://wiki-en.ckras.com/wiki/index.php?title=CS2#FTP_Usage FTP].		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",		"DatabaseType": "MySQL",
Line 37:		Line 37:
	"MySqlPort": 3306		"MySqlPort": 3306

	=== CSV Stats ===		== 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>.

	=== phpMyAdmin ===		== phpMyAdmin ==
	[[File:Phpmyadmin-sql.png\|alt=PHP MY ADMIN\|400x400px]]		[[File:Phpmyadmin-sql.png\|alt=PHP MY ADMIN\|400x400px]]

Ckras at 08:27, 3 July 2024

2024-07-03T08:27:05Z

← Older revision		Revision as of 10:27, 3 July 2024
Line 1:		Line 1:
	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]]		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 ==		== Webinterface ==

Ckras at 08:25, 3 July 2024

2024-07-03T08:25:54Z

← Older revision		Revision as of 10:25, 3 July 2024
Line 1:		Line 1:
	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]].		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 ==		== Webinterface ==

Ckras at 04:29, 3 July 2024

2024-07-03T04:29:52Z

← Older revision		Revision as of 06:29, 3 July 2024
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]].

	== Webinterface ==		== Webinterface ==

Ckras at 14:33, 2 July 2024

2024-07-02T14:33:45Z

← Older revision		Revision as of 16:33, 2 July 2024
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 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]].

			== 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]].

			[[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:

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