PlayTimeMySQL

PlayTimesMySQL is a plugin made to store player playtime data on your Minecraft Server. This plugin only currently supports 1.15+.

What does it do?:

The plugin stores playtime data using CodedRed's Playtimes into a MySQL database (that you own and host yourself) for each day and each player. It only stores data if the player has:

• Played on the server during its current session.

If a server restarts for any reason, players need to join the server again to get their data checked. This is to avoid creating server lag. If you have 100 concurrent players on your server, it will create issues if it constantly checks all players, all the time.

Dependencies:

• PlayTimes by CodedRed

Installation:

1. Download the plugin.
2. Put it into your "plugin" folder.
3. Restart your server to generate configuration files.
4. Go to the "PlayTimeMySQL" folder, then to "config.yml".
5. For step 5, you will need to make sure you set ALL config fields to suit your timezone/database.
6. Go to the console for your database, and create a table with the fields "date", "name", "uuid", "time", "secs"; (CREATE TABLE table_name (date TEXT(1000), name TEXT(1000), uuid TEXT(1000), time TEXT(1000), secs TEXT(1000))).
7. Save your config.yml file (after all options are set to suit your timezone/database), and restart your server.
8. The system is now active! You can use a discord bot (you will need to self-host) and discord console (Using DiscordSRV) to be able to achieve this. I am willing to share my source code for a command that fetches playtime data if you join my discord server.

Images: