Punish System

DiscordPunishBot - Detailed Changelog

[English](#english-changelog) | [Türkçe](#türkçe-changelog) ---

English Changelog

v2.0.0 - Major Release (September 21, 2025)

Critical Bug Fixes & Stability Improvements

#### Database Connection Overhaul - FIXED: Database connection spam with constant opening/closing connections - FIXED: "Database connection closed" errors during runtime - IMPROVED: Single connection usage with proper transaction management - ADDED: Proper commit/rollback mechanism for data integrity - ADDED: Connection timeout and retry logic - ENHANCED: Synchronized database operations for thread safety #### Discord Integration Fixes - FIXED: "10008: Unknown Message" errors when updating Discord messages - FIXED: Commands not responding due to language manager failures - IMPROVED: Error handling for deleted or invalid Discord messages - ADDED: Automatic cleanup of invalid Discord message IDs from database - ENHANCED: Graceful fallback mechanisms for Discord API errors #### Command System Fixes - FIXED: /appeal status showing blank status (now shows proper Turkish statuses) - FIXED: /report list showing "no reports" despite existing reports - FIXED: Report priority and status displaying as empty fields - IMPROVED: All commands now use hardcoded Turkish messages for reliability - ADDED: Proper Turkish status translations (Bekleniyor, İnceleniyor, Onaylandı, etc.)

New Interactive Discord Features

#### Discord Button System for Reports - NEW: Interactive approval/rejection buttons for report management - NEW: " Approve & Manual Punishment" button - approves report, gives rewards, requires manual punishment - NEW: " Reject" button - marks report as invalid - NEW: " Investigate" button - marks as under investigation while keeping buttons active - NEW: Real-time embed updates with admin tracking and timestamps - NEW: Color-coded status indicators (green=approved, red=rejected, blue=investigating) #### Discord Button System for Appeals - NEW: Complete appeal management via Discord buttons - NEW: " Approve Appeal" button - removes punishment, gives rewards - NEW: " Reject Appeal" button - keeps punishment active - NEW: " Investigate" button - marks for review while preserving buttons - NEW: Automatic punishment removal for approved appeals - NEW: Admin role validation for appeal operations #### Advanced Admin Controls - NEW: Role-based permissions for report and appeal button access - NEW: discord.report-admin-role-id configuration for report management - NEW: discord.appeal-admin-role-id configuration for appeal management - NEW: Admin action logging with username and timestamp tracking - IMPROVED: Button state management (disable after action vs. keep active during investigation)

Configurable Reward System

#### Console Command Execution - NEW: Execute any console command as rewards (eco, essentials, custom plugins) - NEW: reward-system.report-correct-commands - commands for approved reports - NEW: reward-system.appeal-approved-commands - commands for approved appeals - NEW: Player placeholder support (%player% in all reward commands) - NEW: Flexible reward configuration with multiple commands per event #### Reward Distribution - ADDED: Automatic reward distribution upon approval - ADDED: Custom notification messages for rewards - ADDED: reward-system.report-approved-message configuration - ADDED: reward-system.appeal-approved-message configuration - ENHANCED: Async reward processing for better performance

Enhanced Discord Embeds

#### Visual Improvements - ENHANCED: Rich, detailed embed messages with professional appearance - ADDED: Player avatar thumbnails in embeds - ADDED: Status-based color coding throughout all embeds - IMPROVED: Structured field layout with dividers and icons - ADDED: Timestamp tracking for all embed messages - ADDED: Footer branding updates ("Developed by Melut") #### Information Display - IMPROVED: Detailed report information with priority indicators - IMPROVED: Appeal information with punishment ID linking - ADDED: Admin response fields in embeds - ADDED: Processing time tracking and display - ENHANCED: Priority level display with emoji indicators ()

System Architecture Improvements

#### Code Organization - REFACTORED: Removed unnecessary code comments for cleaner codebase - STANDARDIZED: Consistent error handling patterns throughout - IMPROVED: Method naming and code structure - UPDATED: Developer attribution from "MelutCorp" to "Melut" - ORGANIZED: Better separation of concerns between managers #### Performance Enhancements - OPTIMIZED: Database query performance with prepared statements - IMPROVED: Async operations for non-blocking command execution - ENHANCED: Memory management with proper resource cleanup - REDUCED: Discord API rate limiting with smart request batching - STREAMLINED: Event handling and callback processing

Configuration Enhancements

#### New Discord Channel Settings

discord:
  # New channel configurations
  report-log-channel-id: "REPORT_LOG_CHANNEL_ID"    # Admin report management with buttons
  appeal-channel-id: "APPEAL_CHANNEL_ID"            # Appeal notifications with buttons
  
  # New admin role settings  
  report-admin-role-id: "REPORT_ADMIN_ROLE_ID"      # Role for report button access
  appeal-admin-role-id: "APPEAL_ADMIN_ROLE_ID"      # Role for appeal button access

#### Reward System Configuration

reward-system:
  enabled: true
  
  # Console commands to execute for approved reports
  report-correct-commands:
    - "eco give %player% 100"
    - "tellraw %player% {\"text\":\"Thanks for the correct report!\",\"color\":\"green\"}"
  
  # Console commands to execute for approved appeals  
  appeal-approved-commands:
    - "eco give %player% 50"
    - "tellraw %player% {\"text\":\"Your appeal was approved!\",\"color\":\"green\"}"
  
  # Custom reward messages
  report-approved-message: "§a§l[REPORT] §7Your report was correct! You received a reward."
  appeal-approved-message: "§a§l[APPEAL] §7Your appeal was approved! You received a reward."

Database Schema Updates

#### New Tables & Relationships - ENHANCED: reports table with comprehensive fields - ENHANCED: appeals table with foreign key to punishments - ADDED: discord_message_id fields for message tracking - IMPROVED: Proper indexes for performance optimization - ADDED: Status and priority enum handling #### Data Integrity - IMPLEMENTED: Foreign key constraints between tables - ADDED: Transaction support with commit/rollback - IMPROVED: Data validation at database level - ENHANCED: Error recovery mechanisms

Command System Improvements

#### Enhanced Command Responses - IMPROVED: All Turkish messages are now hardcoded for reliability - ADDED: Proper status translations (Bekleniyor, İnceleniyor, Onaylandı, Reddedildi) - FIXED: Empty status and priority displays - ENHANCED: Error messages with helpful troubleshooting information - ADDED: Command usage hints and help text #### Better Error Handling - ADDED: Comprehensive try-catch blocks throughout - IMPROVED: User-friendly error messages - ENHANCED: Logging with stack traces for debugging - ADDED: Graceful degradation when services are unavailable

Manual Punishment System

#### Admin Workflow Changes - CHANGED: Report approval no longer automatically punishes players - NEW: "Manual Punishment Required" workflow