Order & Auction GUI Plugin v2.0.11

• Blacklist now supports custom plugin items (ItemsAdder, ExecutableItems, Oraxen, Nexo, MMOItems)
• Code:

  # ─────────────────────────────────────────────────────────────────────────────
  # BLACKLIST
  # Players listed here cannot create or fulfill orders.
  # Items listed here cannot be ordered.
  #
  # Item entries support vanilla material names AND custom plugin item IDs:
  #   Vanilla:          DIAMOND_SWORD
  #   ItemsAdder:       itemsadder:mypack:my_sword
  #   ExecutableItems:  executableitems:my_sword_id
  #   Oraxen:           oraxen:my_sword
  #   Nexo:             nexo:my_sword
  #   MMOItems:         mmoitems:SWORD:excalibur
  # ─────────────────────────────────────────────────────────────────────────────

• Auction blacklist (config-auction.yml) is now actually enforced on listings
• Update notification third line replaced with plugin page URL
• URL in update notification is clickable in-game (opens browser on click)
• ExecutableItems hook corrected to match actual SScore API (com.ssomar.score)
• Auction announcement prices now use compact format (e.g. 1.5K, 2.3M)
• Player preferences for auction/order announcements

• Now rebranded as Sigma Orders & Auction
• Added auction module
• Fully refined GUI for better experience
• Improved and more versatile language file
• Permission-based system:   
  • Order count & lifetime   
  • Auction item count & duration
• Important Notice • Support for Head Database plugin has been officially discontinued

• Added /ord admin fulfill <id> — admins can force-complete any order so the buyer can collect it
• Fixed version mismatch that was falsely showing "update available" to ops on login

• Fixed delivery causing all DB calls to timeout (deliverItems never closed its connection)
• Fixed admin refund deducting escrow but never actually paying the player
• Fixed processRefundAsync escrow update silently failing

Bug Fixes​

• Fixed: SQLite connection pool timeout (SQLTransientConnectionException) that occurred frequently during expired order processing
• Fixed: Nested getConnection() calls inside mapOrderFromResultSet and createOrderFromData were requesting a second connection from the pool while the first was still held exhausting the single-connection pool and causing a 10s deadlock
• Fixed: Auto-correct logic for negative escrow balances now reuses the caller's existing connection instead of opening a new one

- Minor DB error fix

1. Full MiniMessage support
2. Improved DB transaction handling

Description
New Features:

• Full item snapshot system special items (Smart Spawner, Ominous Bottles, custom plugin items) are now saved exactly as they are when the order is created and restored identically on delivery. No more data loss for plugin-specific items.
• Ominous Bottle amplifier support (1.21+) amplifier level is stored and matched correctly.
• Central custom item hook system ItemsAdder, Oraxen, Nexo, and MMOItems are now handled through a unified registry. Cleaner integration, better compatibility, backward compatible with existing orders.
• Automatic database migration new snapshot column is added automatically to existing SQLite and MySQL databases on first load. No manual steps needed.

Security Fixes:
- Fixed shulker box / container item delivery exploit orders created with filled shulker boxes now require the delivered shulker to contain matching items. Previously, an empty shulker could be delivered in place of a full one.
Bug Fixes:

• Fixed false Snapshot validation failed log spam for plain vanilla items (e.g. Coal Ore, Dirt) on Paper 1.21+ deliveries worked correctly but generated unnecessary warnings in the server console
• Fixed custom-named items (e.g. Smart Spawner) failing delivery when name/lore differed only by color encoding (§ vs &)
• Fixed order creation GUIs clearing custom names/lore from special plugin items

Performance & Stability:

• SQLite concurrent read performance improved HikariCP pool size increased from 1 to 4 using WAL mode, so reads no longer wait behind writes
• Connection timeout reduced from 30s to 10s for faster error feedback
• Multiple thread-safety fixes for Folia and high-concurrency servers
• Added folia-supported: true to plugin.yml

Discord:
- Webhook messages now display the correct bot username in Discord