SQLStatLogger v1.1

About

SQLStatLogger is a statistics logger for the HGMGS plugin that allows users to track game statistics and save them to a MySQL database. It supports the /hg rank and /hg games commands to list the top players and previous games. It records the number of wins, losses, games and kills for each player and also the winner, start time, end time and arena name for each game.

How to Use

If not already in the "statistics" folder, download "SQL.jar" and put it in the "statistics" folder (folder is found with "config.yml" for the HGMGS).
Download MySQL Community Server and optionally the MySQL Workbench.
Add/change the "statloggerJAR" config in the HGMGS config.yml to "SQL.jar".
Add the following configurations to the HGMGS config.yml file:

Name	Description	Example
SQLUser	Defines the user name to log in to the MySQL server.	root
SQLPassword	Defines the password which corresponds to the SQLUser.	thepassword
SQLHost	Defines the host location of the MySQL server. This should contain the host name, port and database name.	localhost:3306/myhgdata

Example HGMGS Config File Contents

Located in HGMGS "config.yml":

statloggerJAR: SQL.jar
SQLUser: root
SQLPassword: password123
SQLHost: 3306/myhgdata