SQLStatLogger
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