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

1. 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).
2. Download MySQL Community Server and optionally the MySQL Workbench.
3. Add/change the "statloggerJAR" config in the HGMGS config.yml to "SQL.jar".
4. Add the following configurations to the HGMGS config.yml file:

Example HGMGS Config File Contents

Located in HGMGS "config.yml":

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