BRC Data Helper

Description:
This plugin helps convert BRC plugin data into readable json.

Requirements:

• Java 21
• Spigot or Paper 1.21.7
• ShopGUIPlus v1.107.0 or higher.
• PlayerShopGUIPlus v1.39.0 or higher.
• BlueSlimeCore v2.9.7 or higher.
• A fully functioning MySQL database previously linked to PlayerShopGUIPlus.

Features:

• Convert original PlayerShopGUIPlus database with base64-binary items into a different table as json items.
• Purchase history table that stores information when players buy items from other players.
• Creation history table that stores information when players add items to their own shop.
• Transaction history table for ShopGUIPlus when players sell or buy items.
  Please send me suggestions for new features or feature changes.

Screenshots:
This plugin was requested and tested by LoVeC119. Click the spoiler below to see some example tables:

Default Configuration:
Click the spoiler below to see the default configuration file.

# DO NOT CHANGE THIS VALUE
generated-by-version: "1.4.2"

# Toggle option for debug mode. Only set this to true if requested by SirBlobman
debug-mode: false

# How often (in ticks) will data be sent to the database?
# Default: 6,000 ticks ~= 5 minutes
data-sync-period: 6000

# Connection settings for the MySQL Database
database:
  host: "localhost"
  port: 3306
  database: "minecraft"
  username: "root"
  password: ""

tables:
  # The original table that is made by PlayerShopGUIPlus
  psgp-original: "psgp_original"

  # The converted data from the original table
  psgp-converted: "psgp_converted"

  # Log for when players buy items from other players
  psgp-purchase-history: "psgp_purchase_history"

  # Log for when players add items to their shop
  psgp-creation: "psgp_creation_history"

  # Log for when players buy items from the admin shop (ShopGUIPlus)
  sgp-transaction-history: "sgp_transaction_history"

Support:
If you need a feature added or are having issues, please join my discord by clicking the image below:

Extra Information:
Please DO NOT leave bugs or error logs as reviews.