VIP MysteryBoxes | Loot Boxes, Crafting, Cosmetics, Upgrades, Songs & MORE 1.21.05-release

GENERAL INFORMATION
The menu system has been updated. Changes have been made to quality of life.

BUG FIXES
Fixed a bug that was causing an infinite "Data Synchronization" status.

THEMES

• New theme: Witch Brewing
  • "Bubbling cauldrons, potions stew, a witch's craft, in Minecraft's hue."
• New theme: Bee Hive
  • "Buzzing bees in honeyed hives, Sweet nectar flows, the hive thrives."

DATA SYNCHRONIZATION WITH MYSQL

• Introducing a new feature that allows you to upload boxes and loots to your MySQL database.
• Connected MysteryBoxes plugins will update their boxes and loots in real time.
• Eliminates the need for manual configuration on multiple servers.
• Two tables are used: "MB_BOX_FILES" for boxes and "MB_LOOT_FILES" for loot.
• Import boxes, loot, or both.
• The plugin creates a session ID on load and compares it to the database.
• If the session id does not match, boxes and loot are synchronized from the database.
• Use the "/mb release" command to get the new session into the database.
• All connected MysteryBoxes will update their boxes and loot.

Updated config.yml: # ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ - Pastebin.com

• COMMAND
  • The tab completion system has been completely redesigned.
  • With this update, the plugin will now offer many more options.
  • Improved error and invalid syntax checking.
  • The plugin will now warn you if you entered an invalid number or specified the wrong range syntax.
  • Tab completion is now supported:
    • Players
    • Boxes/Gifts
    • Song
    • Themes
    • Any arguments related to numbers
    • Range Syntax

BUG FIXES

• Fixed: Inability to enable/disable Vault Editor
• Fixed: Stats were not being translated properly.
• Fixed: Some menus were not opening properly

GENERAL​

• Spigot 1.20.4 support.
• Optimized plugin.
• Fixed some bugs.

HEX COLORS​

• Using hex color formatting in the plugin is easier than ever! Previously, you had to type the following: <SOLID:4287f5>, but with this update, you can just use #4287f5.

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.

MYSQL DATABASE

• Upgrade to a new system to improve performance and reliability.
• Adjusted log messages to more accurately track bugs in the future.
• Fixed an issue where data was unintentionally loaded.
• Fixed an issue where data would sometimes fail to load or save.
• Attention! In this update, the configuration for MySQL has been changed:
• Please adjust your config.yml: https://pastebin.com/raw/M7ScrusX.

BUG FIXES​

• Fixed a bug that caused debug messages to appear when opening the mailbox.