DEVELOPER'S NOTE
This update overhauls the way MySQL works. During initial testing, everything looked fine, however, there may be some bugs. For the new system to work correctly, row PLAYER_ID must be set as the primary key in each table; otherwise, plugin requests won't work. I've added a script to update pre-existing tables with a primary key, but I'm not sure how it will work on your end. If it doesn't work, you have two options: either manually make PLAYER_ID the primary key, or delete the tables, allowing the plugin to generate new and working tables (note that doing so will reset the players' data).
GENERAL
- The "max-pool-size" parameter has been added to the MySQL settings (by default it is 5).
BUG FIXES
- Fix: MySQL was not closing connections, resulting in "too many joins" error.
- Fix: MySQL didn't sync data properly, especially kit selection.
- Fix: MySQL was not setting PLAYER_IDs as the primary key.
- Fixed: MySQL was executing too many queries, resulting in lag spikes.
- Fix: MySQL synchronization process was taking too long.
- Fix: MySQL executes unsafe queries.