Patched Database Connection Leak At

DynamicTradeStorageService.java

• Prevents connection pool exhaustion

Patched AdaptiveCache Executor Leak

Patched Missing Shutdown Calls

Improved Performance

• Optimized findNearestPlayer() with spatial queries
• Reduced complexity from O(n×m) to O(k)
• Added fallback for older API versions

Overall Patched Many Performance Issues

Villager Trade Manager v12 - Advanced Minecraft Villager Economy Control (1.20.x-1.21.x Folia/Paper/Spigot)

Ultimate villager trade plugin: Custom pricing/bans, leveling, stock mgmt, wandering traders, dynamic economy, multi-DB (SQLite/PG/Supabase), AI help, Vault integration. Folia optimized.

🎯 Key Features

• 💰 Custom Trades: Price any trade/profession (/vtrade setprice armorer diamond_helmet 25)
• 🚫 Item Bans: Block OP items (/vtrade banitem netherite_sword)
• 📈 Leveling: XP progression, unlocks (/vtrade level set)
• 📦 Stock/Restock: Limits, auto-refill (/vtrade stock inspect)
• 🐪 Wanderers: Custom trades (/vtrade wanderer add)
• 🗄️ DBs: SQLite/PG/Supabase w/ pooling
• 🤖 AI Help: /vtrade help ask "setup guide?"
• 📊 Metrics: Health/prometheus

Keywords: minecraft villager trade plugin 1.21, custom villager trades paper, folia villager manager, spigot economy plugin.

📋 Commands Summary

⚙️ Config Highlights

database: sqlite  # or postgresql/supabase
level_progression.enabled: true
trade_enhancements.enabled: true
ai_assistant.groq.api_key: "key"

Transform your villager economy today! ⭐ Download v12.

Changelog

[11.1.0] - 2025-11-06

🐛 Bug Fixes

Folia Compatibility Fix ⭐ CRITICAL

• Plugin Loading Failure: Fixed UnsupportedOperationException that prevented plugin from loading on Folia 1.21.8
• Scheduler Compatibility: Replaced raw Bukkit.getScheduler() calls with platform-aware TaskScheduler
• PerformanceMonitorService: Updated to use TaskScheduler.runAsyncRepeating() instead of runTaskTimerAsynchronously()
• MigrationCommand: Updated to use TaskScheduler.runSyncRepeating() instead of runTaskTimer()
• Constructor Updates: Modified service constructors to accept TaskScheduler dependency injection

🔧 Technical Improvements

Dependency Injection

• TaskScheduler Injection: Services now properly receive TaskScheduler instances instead of accessing raw schedulers
• Platform Abstraction: Enhanced use of platform-aware scheduling throughout the codebase
• Code Consistency: Unified scheduler usage patterns across all components

[11.0.0] - 2025-11-06

🎉 Major Features

Item Banning System ⭐ NEW

• Complete Item Control: Ban entire items from appearing in any villager trades
• Smart Filtering: Automatically prevents enchanted variants when base item is banned
• Database Persistence: Banned items stored in database with audit trail
• Commands Added:
  • /vt banitem <item_type> - Ban items from all villager trades
  • /vt unbanitem <item_type> - Remove item bans
  • /vt listbanneditems - Display all currently banned items
• Examples: /vt banitem diamond_sword, /vt banitem enchanted_golden_apple

PostgreSQL Database Support ⭐ NEW

• Direct JDBC Connections: Support for PostgreSQL databases beyond Supabase
• Connection String Config: Full PostgreSQL connection string support
• Enhanced Compatibility: Works with Supabase, AWS RDS, Google Cloud SQL, etc.
• Configuration:

  database:
    type: "postgresql"
    postgresql:
      connectionString: "postgresql://user:password@host:5432/database"
  

🔧 Enhancements

Command System Improvements

• Enhanced Tab Completion: Full autocomplete for all commands and parameters
• Better Error Messages: Improved feedback for invalid commands and parameters
• Enchantment Guidance: Special help messages for enchantment-related commands
• Profession Validation: Real-time validation of profession names and trade IDs

Database Architecture

• Multi-Database Support: SQLite, Supabase REST API, PostgreSQL JDBC
• Automatic Fallback: Seamless fallback to SQLite if cloud databases fail
• Connection Management: Improved connection pooling and lifecycle management
• Schema Validation: Enhanced database schema validation and migration

Performance Optimizations

• Memory Usage: Reduced memory footprint for large trade registries
• Database Queries: Optimized query performance and caching
• Async Operations: Improved asynchronous database operations
• Resource Management: Better cleanup and resource disposal

🐛 Bug Fixes

Supabase Integration

• URL Construction: Fixed double /rest/v1/ path construction bug
• Authentication: Corrected authorization header usage for service keys
• Connection Status: Fixed isConnected() method to properly track status
• Error Handling: Improved error messages and fallback behavior

Command Processing

• Trade Validation: Fixed validation logic for custom trade pricing
• Parameter Parsing: Improved command argument parsing and validation
• Tab Completion: Fixed tab completion for complex command structures
• Error Feedback: Enhanced error messages for user guidance

Database Operations

• Connection Handling: Fixed connection leak issues in database providers
• Transaction Management: Improved transaction handling and rollback
• Migration System: Enhanced database migration reliability
• Data Integrity: Better validation of database operations

🔒 Security

Database Security

• Connection Encryption: Proper SSL/TLS for database connections
• Credential Handling: Secure storage and transmission of credentials
• Access Control: Improved permission validation
• Audit Trail: Database operation logging for security monitoring

Input Validation

• Command Sanitization: Enhanced input validation for commands
• SQL Injection Prevention: Prepared statements for all database queries
• Path Traversal: Protection against path manipulation attacks
• Resource Limits: Rate limiting and resource usage controls

🏗️ Technical Improvements

Code Architecture

• Database Provider Pattern: Clean abstraction for different database types
• Configuration System: Enhanced configuration parsing and validation
• Error Handling: Comprehensive exception handling and logging
• Code Organization: Better separation of concerns and modularity

Dependencies

• PostgreSQL Driver: Added PostgreSQL JDBC driver support
• HTTP Client: Updated OkHttp for better Supabase communication
• JSON Processing: Enhanced Jackson for complex data structures
• Testing Framework: Improved unit and integration testing

Build System

• Maven Configuration: Updated dependencies and build process
• Plugin Compatibility: Enhanced compatibility with different server platforms
• Resource Management: Better handling of plugin resources
• Deployment: Streamlined build and deployment process

🔄 Migration Guide

From V10.x to V11.0

Database Migration

# V10.x config
database:
  type: "sqlite"

# V11.0 config (unchanged for SQLite users)
database:
  type: "sqlite"
  sqlite:
    file: "villager_data.db"

New Commands Available

• Run /vt listbanneditems to see current banned items (none by default)
• Use /vt banitem <item> to ban items from trades
• Consider /vt setprice improvements with better error messages

Configuration Changes

• No breaking changes for existing configurations
• New postgresql section available for advanced users
• Enhanced logging options in config.yml

📊 Metrics & Monitoring

Health Checks

• HTTP Endpoints: Configurable health check endpoints
• Database Monitoring: Connection pool and query performance metrics
• Memory Tracking: JVM memory usage and garbage collection monitoring
• Trade Statistics: Real-time trade volume and performance analytics

Logging Improvements

• Structured Logging: JSON-formatted logs for better parsing
• Debug Modes: Enhanced debugging options for troubleshooting
• Performance Logs: Query execution time and bottleneck identification
• Error Tracking: Comprehensive error reporting and analysis

[10.x.x] - Previous Versions

See individual release notes for V10.x changes including:

• Universal trade pricing for all professions
• Folia compatibility and region-threaded scheduling
• Advanced restock system with instant restock
• Dynamic trade detection and storage

🤝 Contributing

• Bug Reports: Use GitHub Issues with detailed reproduction steps
• Feature Requests: Describe the use case and expected behavior
• Code Contributions: Follow the existing code style and patterns
• Testing: Ensure all tests pass and add new tests for new features

📞 Support

• Documentation: README.md for complete usage guide
• Issues: GitHub Issues for bug reports and feature requests
• Community: Join our Discord for community support
• Compatibility: Minecraft 1.20.x - 1.21.x, Java 17+

Legend:

• 🎉 Major Features: Significant new functionality
• 🔧 Enhancements: Improvements to existing features
• 🐛 Bug Fixes: Resolved issues and problems
• 📚 Documentation: Documentation and guides
• 🔒 Security: Security-related changes
• 🏗️ Technical: Internal architecture changes

Changelog

[11.0.0] - 2025-11-06

🎉 Major Features

Item Banning System ⭐ NEW

• Complete Item Control: Ban entire items from appearing in any villager trades
• Smart Filtering: Automatically prevents enchanted variants when base item is banned
• Database Persistence: Banned items stored in database with audit trail
• Commands Added:
  • /vt banitem <item_type> - Ban items from all villager trades
  • /vt unbanitem <item_type> - Remove item bans
  • /vt listbanneditems - Display all currently banned items
• Examples: /vt banitem diamond_sword, /vt banitem enchanted_golden_apple

PostgreSQL Database Support ⭐ NEW

• Direct JDBC Connections: Support for PostgreSQL databases beyond Supabase
• Connection String Config: Full PostgreSQL connection string support
• Enhanced Compatibility: Works with Supabase, AWS RDS, Google Cloud SQL, etc.
• Configuration:

  database:
    type: "postgresql"
    postgresql:
      connectionString: "postgresql://user:password@host:5432/database"
  

🔧 Enhancements

Command System Improvements

• Enhanced Tab Completion: Full autocomplete for all commands and parameters
• Better Error Messages: Improved feedback for invalid commands and parameters
• Enchantment Guidance: Special help messages for enchantment-related commands
• Profession Validation: Real-time validation of profession names and trade IDs

Database Architecture

• Multi-Database Support: SQLite, Supabase REST API, PostgreSQL JDBC
• Automatic Fallback: Seamless fallback to SQLite if cloud databases fail
• Connection Management: Improved connection pooling and lifecycle management
• Schema Validation: Enhanced database schema validation and migration

Performance Optimizations

• Memory Usage: Reduced memory footprint for large trade registries
• Database Queries: Optimized query performance and caching
• Async Operations: Improved asynchronous database operations
• Resource Management: Better cleanup and resource disposal

🐛 Bug Fixes

Supabase Integration

• URL Construction: Fixed double /rest/v1/ path construction bug
• Authentication: Corrected authorization header usage for service keys
• Connection Status: Fixed isConnected() method to properly track status
• Error Handling: Improved error messages and fallback behavior

Command Processing

• Trade Validation: Fixed validation logic for custom trade pricing
• Parameter Parsing: Improved command argument parsing and validation
• Tab Completion: Fixed tab completion for complex command structures
• Error Feedback: Enhanced error messages for user guidance

Database Operations

• Connection Handling: Fixed connection leak issues in database providers
• Transaction Management: Improved transaction handling and rollback
• Migration System: Enhanced database migration reliability
• Data Integrity: Better validation of database operations

🔒 Security

Database Security

• Connection Encryption: Proper SSL/TLS for database connections
• Credential Handling: Secure storage and transmission of credentials
• Access Control: Improved permission validation
• Audit Trail: Database operation logging for security monitoring

Input Validation

• Command Sanitization: Enhanced input validation for commands
• SQL Injection Prevention: Prepared statements for all database queries
• Path Traversal: Protection against path manipulation attacks
• Resource Limits: Rate limiting and resource usage controls

🏗️ Technical Improvements

Code Architecture

• Database Provider Pattern: Clean abstraction for different database types
• Configuration System: Enhanced configuration parsing and validation
• Error Handling: Comprehensive exception handling and logging
• Code Organization: Better separation of concerns and modularity

Dependencies

• PostgreSQL Driver: Added PostgreSQL JDBC driver support
• HTTP Client: Updated OkHttp for better Supabase communication
• JSON Processing: Enhanced Jackson for complex data structures
• Testing Framework: Improved unit and integration testing

Build System

• Maven Configuration: Updated dependencies and build process
• Plugin Compatibility: Enhanced compatibility with different server platforms
• Resource Management: Better handling of plugin resources
• Deployment: Streamlined build and deployment process

🔄 Migration Guide

From V10.x to V11.0

Database Migration

# V10.x config
database:
  type: "sqlite"

# V11.0 config (unchanged for SQLite users)
database:
  type: "sqlite"
  sqlite:
    file: "villager_data.db"

New Commands Available

• Run /vt listbanneditems to see current banned items (none by default)
• Use /vt banitem <item> to ban items from trades
• Consider /vt setprice improvements with better error messages

Configuration Changes

• No breaking changes for existing configurations
• New postgresql section available for advanced users
• Enhanced logging options in config.yml

📊 Metrics & Monitoring

Health Checks

• HTTP Endpoints: Configurable health check endpoints
• Database Monitoring: Connection pool and query performance metrics
• Memory Tracking: JVM memory usage and garbage collection monitoring
• Trade Statistics: Real-time trade volume and performance analytics

Logging Improvements

• Structured Logging: JSON-formatted logs for better parsing
• Debug Modes: Enhanced debugging options for troubleshooting
• Performance Logs: Query execution time and bottleneck identification
• Error Tracking: Comprehensive error reporting and analysis

[10.x.x] - Previous Versions

See individual release notes for V10.x changes including:

• Universal trade pricing for all professions
• Folia compatibility and region-threaded scheduling
• Advanced restock system with instant restock
• Dynamic trade detection and storage

🤝 Contributing

• Bug Reports: Use GitHub Issues with detailed reproduction steps
• Feature Requests: Describe the use case and expected behavior
• Code Contributions: Follow the existing code style and patterns
• Testing: Ensure all tests pass and add new tests for new features

📞 Support

• Documentation: README.md for complete usage guide
• Issues: GitHub Issues for bug reports and feature requests
• Community: Join our Discord for community support
• Compatibility: Minecraft 1.20.x - 1.21.x, Java 17+

Legend:

• 🎉 Major Features: Significant new functionality
• 🔧 Enhancements: Improvements to existing features
• 🐛 Bug Fixes: Resolved issues and problems
• 📚 Documentation: Documentation and guides
• 🔒 Security: Security-related changes
• 🏗️ Technical: Internal architecture changes

Minor Bug Fixes

• Fixed Access global region thread To specific region thread In Folia Compatibility
• Other Minor Bug Fixes

Minecraft Villager Trade Manager — Version 10.0

“Instant Restock Update”

🚀 Key Features Implemented

1. Instant Restock System

• ✅ Added instantRestockEnabled boolean flag for instant restocks.
• ✅ New command: /villagertrade instantrestock on/off.
• ✅ Villager trades automatically replenish immediately after use.
• ✅ Platform-safe execution: Folia uses region-threaded scheduling; other platforms use synchronous execution.

2. Database Integration

• ✅ Instant restock setting persisted in SQLite settings table.
• ✅ Automatic loading and saving of instantRestockEnabled.
• ✅ Fully backward compatible with existing database schema.

3. Enhanced Status Display

• ✅ /villagertrade status now shows Instant Restock status.
• ✅ Clear On/Off indication for administrators.

4. Smart Integration

• ✅ Instant restock takes precedence over interval-based restocks.
• ✅ Normal restock system skips processing while instant restock is enabled.
• ✅ Seamless integration with existing restock features (restocktime, restocklimit, unlimitedrestock).

5. Command System Updates

• ✅ Added instantrestock subcommand.
• ✅ Updated usage help text to include new command.
• ✅ Tab completion for on/off values.
• ✅ Updated main command usage message to reflect new options.

6. Performance Optimizations

• ✅ Efficient instant restock processing with minimal CPU overhead.
• ✅ Minimal performance impact when feature is disabled.
• ✅ Platform-appropriate scheduling for optimal performance on Folia and legacy servers.

🧩 Compatibility

• Fully compatible with: Folia, Paper, Purpur, Spigot, Bukkit
• Minecraft versions: 1.20.x – 1.21.x
• Java: 17+

⚙️ Migration Notes

• Upgrade from v9.0 is seamless.
• Existing settings, prices, and restock data are preserved.
• No server restart required for migration.

📌 Summary

v10.0 introduces Instant Restock, giving server admins full control to replenish villager trades immediately, while maintaining compatibility, thread safety, and performance across all supported platforms.

🧾 Minecraft Villager Trade Manager v9.0

The Folia Expansion Update

🚀 Major Features

Folia Native Compatibility

• Full Region-Threaded Support: Native compatibility with Folia’s region-based concurrency model.
• Automatic Platform Detection: Detects Folia, Paper, Purpur, Spigot, and Bukkit automatically.
• Seamless Integration: Works transparently without configuration changes.
• Backward Compatibility: 100% retained functionality on all legacy platforms.

Advanced Scheduler Abstraction

• Unified TaskScheduler Interface: Single abstraction for scheduling tasks across all supported servers.
• FoliaScheduler Implementation: Region-threaded scheduling using Folia’s APIs.
• BukkitSchedulerWrapper: Legacy scheduler for Paper, Spigot, Purpur, and Bukkit.
• Entity & Location Safe: All entity and location operations respect Folia’s thread-safety rules.

Asynchronous Database Operations

• Thread-Safe Database Executor: Dedicated async thread pool for SQLite operations.
• Non-Blocking I/O: Prevents main-thread lag by running all DB tasks asynchronously.
• Configurable Thread Pool: Adjust thread count for optimal performance.
• Graceful Shutdown: Automatic cleanup of async resources.

🛠️ Technical Improvements

Platform Detection Service

• Automatic Recognition: Detects server platform at runtime.
• Adaptive Behavior: Adjusts scheduler and async methods accordingly.
• Detailed Logging: Shows platform information on startup.
• Safe Fallbacks: Gracefully handles missing APIs on unsupported versions.

Thread Safety Enhancements

• Region-Safe Entity Access: All villager actions use Folia-safe execution.
• Concurrent Data Access: Thread-safe operations for restock and trade data.
• Cross-Platform API Safety: Reflection-based compatibility layer.
• Improved Exception Handling: Safe and recoverable async operations.

Performance Optimizations

• Reduced Main Thread Load: All blocking tasks moved to async.
• Efficient Resource Management: Improved thread pooling and connection handling.
• Memory Optimization: Low-overhead caching mechanisms.
• Optimized Scheduling: Best scheduling method automatically selected per platform.

🔄 Compatibility Enhancements

Multi-Platform Support

• ✅ Folia (1.20.x–1.21.x)
• ✅ Paper (1.20.x–1.21.x)
• ✅ Purpur (1.20.x–1.21.x)
• ✅ Spigot (1.20.x–1.21.x)
• ✅ Bukkit (1.20.x–1.21.x)

Version Range

• Minecraft: 1.20.x – 1.21.x
• Java: 17+

API Integration

• Reflection-Based Access: Ensures compatibility across API variants.
• Graceful Fallbacks: Automatically uses the best available scheduler.
• Future-Proof Design: Modular structure ensures easy updates.

📊 System Architecture

Modular Design

• Scheduler Layer: Unified async/sync scheduling.
• Platform Layer: Detection & adaptation services.
• Database Layer: Async persistent storage.
• Business Logic Layer: Core villager trade management.

Resource Management

• Thread Pool Management: Configurable async threads.
• Connection Handling: Automatic open/close cycle for DB connections.
• Memory Optimization: Efficient caching and cleanup.
• Safe Shutdown: Proper termination of all async tasks.

🎯 Feature Preservation

All features from v8.0 are maintained and improved:

• Custom Trade Pricing
• Discount Prevention
• Custom Restock System (intervals, limits, unlimited)
• Command Suite (/villagertrade setprice, /villagertrade restock, etc.)
• SQLite Persistent Data Storage

Enhanced Reliability

• Better error recovery
• Strong data consistency
• Improved async logging

📈 Performance Benefits

Scalability

• Supports servers with 1000+ villagers
• <1% tick usage even under high load
• Fully async database and trade logic

Operational Efficiency

• Fast startup
• No blocking on main thread
• Safe async resource cleanup

🔧 Implementation Details

New Components

• TaskScheduler Interface
• FoliaScheduler (region-threaded scheduler)
• BukkitSchedulerWrapper (legacy scheduler)
• PlatformService (detection and adaptation)
• AsyncDatabaseExecutor (thread-safe DB layer)

Codebase Improvements

• Modularized architecture
• Full backward compatibility
• Comprehensive inline documentation
• Future-ready design

📋 Migration Notes

• Seamless Upgrade: Drop-in replacement, no config changes.
• Data Preservation: Existing settings and prices remain intact.
• Command Compatibility: No breaking command changes.
• Zero Downtime: Upgrade from v8.0 without restart issues.

✅ Summary

Minecraft Villager Trade Manager v9.0 – The Folia Expansion Update
Now supports Folia’s region-threaded architecture while maintaining full compatibility with Paper, Purpur, Spigot, and Bukkit.
Bringing safe async performance, universal scheduling, and next-level stability to villager trade management.

🔁 New in v8.0 — The Restock Update

⚙️ Custom Restock System

Take command of villager restocking behavior with full flexibility:

• /villagertrade restock on/off — Enable or disable the custom restock system.
• /villagertrade restocktime <minutes> — Set the restock interval (default: 30 minutes).
• /villagertrade restocklimit <count> — Set the daily restock limit (default: 5 restocks/day).
• /villagertrade unlimitedrestock on/off — Toggle unlimited villager restocks.

✅ Fully compatible with all villager professions and levels.
✅ Automatically resets restock counts daily.
✅ Smart, lightweight system monitored every minute.

🧩 Database Integration

• SQLite-based persistent storage for all settings and restock data.
• Includes two new tables:
  • settings — Saves custom configuration values.
  • villager_restock_data — Tracks each villager’s individual restock usage.
• Thread-safe operations using ConcurrentHashMap.

📊 Enhanced Status Display

/villagertrade status now shows:

• Restock system status (enabled/disabled).
• Current restock interval and daily limits.
• Unlimited restock toggle state.
• Price system status and stored price configurations.