Security Assistant
All notable changes, fixes, and improvements to Security Assistant Bot.
] 🌍 Multilingual Expansion ✅ 8 Languages now supported - Added German, French, Spanish, Turkish, Russian, Portuguese (Brazilian) ✅ 3000+ translation keys - Complete translations for all 59 sections ✅ First-time setup updated - Language selection now shows all 8 languages with flags ✅ Slash command updated - /language supports all language codes (el/en/de/fr/es/tr/ru/pt) 🆕 New Features Website Overhaul ✅ Complete commands page - New dedicated page with 118+ commands across 17 categories ✅ Billing toggle - Monthly/Yearly pricing switch with up to 40% discount display ✅ Yearly subscription plans - Added all yearly pricing tiers to website ✅ Full i18n support - All website content translatable (English & Greek) ✅ Command search - Real-time search functionality on commands page Pricing & Subscription Updates ✅ Yearly plans added - Starter €44.99, Premium €74.99, VIP €132.99, Business €287.99 ✅ Discount badges - 25%, 30%, 35%, 40% OFF labels for yearly plans ✅ Price synchronization - Website now matches PayPal config exactly Single Instance Lock ✅ Duplicate process prevention - Lock file mechanism prevents multiple bot instances ✅ Automatic cleanup - Stale lock files cleaned on startup 🐛 Bug Fixes Subscription System ✅ Fixed tier display inconsistency - Subscription data now loads before command processing ✅ Race condition fix - Added guard in on_message to ignore commands before initialization ✅ Moved subscription loading to on_ready event for proper async handling PayPal Handler ✅ Fixed fallback tier detection - Corrected price ranges for all tiers ✅ Added missing tiers - Starter and Business tiers now properly detected Webhook Server ✅ Health endpoint fix - Added /health to whitelist (was being blocked) Invite Tracker ✅ NoneType comparison fix - Proper handling when invite uses is None Music Player ✅ Removed debug noise - Cleaned up timeout logging messages 🔧 Improvements Website Content ✅ Expanded commands section - 16 categories on main page (was 4) ✅ Feature cards added - Ticket System and Toxicity Filter cards ✅ Tier corrections - Welcome, Tickets, Invite Tracker now correctly shown as FREE ✅ AI Agent added - Now listed in BUSINESS tier features PayPal Config ✅ Feature list fix - Premium tier now shows "Levels System" instead of "Welcome System" Code Quality ✅ Removed debug logging - Cleaned up subscription command debug output ✅ Better error handling - Improved fallback mechanisms [November 2025] 🆕 New Features AI Agent (BUSINESS) ✅ 200+ Discord actions - Execute any server task with natural language ✅ Channel management - Create, delete, clone, lock, archive channels ✅ Role management - Create, edit, assign, bulk operations ✅ User management - Kick, ban, timeout, mute, deafen ✅ Audit log viewing - Check recent server actions ✅ Raid protection mode - Quick enable/disable Community Brain Enhancements ✅ Mood analysis - AI analyzes community sentiment ✅ Predictions - AI-powered activity predictions ✅ Personality profiles - Member personality insights Template Creator ✅ AI-powered templates - Generate complete server structures ✅ Interview wizard - Step-by-step template creation ✅ Apply templates - One-click server setup 🐛 Bug Fixes Database Stability ✅ Batch operations - 10x faster saving with executemany ✅ No more disconnections - Fixed heartbeat blocking every 12 minutes ✅ Timeout increased - 10 second timeout for concurrent operations Achievement System ✅ Duplicate fix - Race condition resolved, achievements granted once Help System ✅ Language cache fix - Categories update correctly after language change 🔧 Improvements Performance ✅ Conversation caching - 90% cache hit rate ✅ Smart memory search - Keyword-based scoring for past conversations ✅ Scalable - Handles 100+ concurrent users [October 2025] 🌍 Major: Internationalization (i18n) ✅ 500+ translation keys - Full English & Greek support ✅ Per-server language - Each server chooses its language ✅ AI language matching - AI responds in server's language ✅ 40+ files updated - Complete codebase localization 🗄️ Major: Database Migration ✅ JSON to SQLite - Better performance and reliability ✅ 100% async - All database operations non-blocking ✅ No more locks - Eliminated "database is locked" errors
Changelog
All notable changes, fixes, and improvements to Security Assistant Bot. [December 2025] 🆕 New Features Website Overhaul ✅ Complete commands page - New dedicated page with 118+ commands across 17 categories ✅ Billing toggle - Monthly/Yearly pricing switch with up to 40% discount display ✅ Yearly subscription plans - Added all yearly pricing tiers to website ✅ Full i18n support - All website content translatable (English & Greek) ✅ Command search - Real-time search functionality on commands page Pricing & Subscription Updates ✅ Yearly plans added - Starter €44.99, Premium €74.99, VIP €132.99, Business €287.99 ✅ Discount badges - 25%, 30%, 35%, 40% OFF labels for yearly plans ✅ Price synchronization - Website now matches PayPal config exactly Single Instance Lock ✅ Duplicate process prevention - Lock file mechanism prevents multiple bot instances ✅ Automatic cleanup - Stale lock files cleaned on startup 🐛 Bug Fixes Subscription System ✅ Fixed tier display inconsistency - Subscription data now loads before command processing ✅ Race condition fix - Added guard in on_message to ignore commands before initialization ✅ Moved subscription loading to on_ready event for proper async handling PayPal Handler ✅ Fixed fallback tier detection - Corrected price ranges for all tiers ✅ Added missing tiers - Starter and Business tiers now properly detected Webhook Server ✅ Health endpoint fix - Added /health to whitelist (was being blocked) Invite Tracker ✅ NoneType comparison fix - Proper handling when invite uses is None Music Player ✅ Removed debug noise - Cleaned up timeout logging messages 🔧 Improvements Website Content ✅ Expanded commands section - 16 categories on main page (was 4) ✅ Feature cards added - Ticket System and Toxicity Filter cards ✅ Tier corrections - Welcome, Tickets, Invite Tracker now correctly shown as FREE ✅ AI Agent added - Now listed in BUSINESS tier features PayPal Config ✅ Feature list fix - Premium tier now shows "Levels System" instead of "Welcome System" Code Quality ✅ Removed debug logging - Cleaned up subscription command debug output ✅ Better error handling - Improved fallback mechanisms [November 2025] 🆕 New Features AI Agent (BUSINESS) ✅ 200+ Discord actions - Execute any server task with natural language ✅ Channel management - Create, delete, clone, lock, archive channels ✅ Role management - Create, edit, assign, bulk operations ✅ User management - Kick, ban, timeout, mute, deafen ✅ Audit log viewing - Check recent server actions ✅ Raid protection mode - Quick enable/disable Community Brain Enhancements ✅ Mood analysis - AI analyzes community sentiment ✅ Predictions - AI-powered activity predictions ✅ Personality profiles - Member personality insights Template Creator ✅ AI-powered templates - Generate complete server structures ✅ Interview wizard - Step-by-step template creation ✅ Apply templates - One-click server setup 🐛 Bug Fixes Database Stability ✅ Batch operations - 10x faster saving with executemany ✅ No more disconnections - Fixed heartbeat blocking every 12 minutes ✅ Timeout increased - 10 second timeout for concurrent operations Achievement System ✅ Duplicate fix - Race condition resolved, achievements granted once Help System ✅ Language cache fix - Categories update correctly after language change 🔧 Improvements Performance ✅ Conversation caching - 90% cache hit rate ✅ Smart memory search - Keyword-based scoring for past conversations ✅ Scalable - Handles 100+ concurrent users [October 2025] 🌍 Major: Internationalization (i18n) ✅ 500+ translation keys - Full English & Greek support ✅ Per-server language - Each server chooses its language ✅ AI language matching - AI responds in server's language ✅ 40+ files updated - Complete codebase localization 🗄️ Major: Database Migration ✅ JSON to SQLite - Better performance and reliability ✅ 100% async - All database operations non-blocking ✅ No more locks - Eliminated "database is locked" errors 📊 Current Statistics Metric Value Total Cogs 38 Commands 150+ Translation Keys 500+ Database Tables 15+ Supported Languages 2 (EN, EL) Last Updated: December 3, 2025
UPDATES
# Changelog All notable changes, fixes, and improvements to this Discord bot. --- ## [Latest Updates] - October 28, 2025 ### 🔧 Development Environment Fix #### **Python Virtual Environment Configuration** - ✅ **Identified correct venv** - `venv_discord` is the active environment - ✅ **Verified dependencies** - 161 packages installed including discord.py 2.6.4 - ✅ **Fixed IDE warning** - Windsurf was looking for venv in wrong location - ✅ **Corrupted venv cleanup** - Identified `venv` folder as corrupted (missing pyvenv.cfg) - ✅ **Recommendation provided** - Use `venv_discord\Scripts\python.exe` as interpreter #### **Bot Startup Verification** - ✅ **Confirmed bot stability** - No errors in production logs - ✅ **All systems operational:** - 35/35 Cogs loaded successfully - Cloudflare Tunnel active - PayPal Webhook server running - AI systems initialized (Gemini 2.0 Flash) - Database connections stable - Voice tracking functional - Welcome system operational --- ## [Previous Updates] - 2025 ### 🌍 Internationalization (i18n) - Complete Overhaul #### **Full i18n Implementation** - ✅ **Complete multilingual support** across 40+ files (30,000+ lines of code) - ✅ **500+ translation keys** in both Greek (EL) and English (EN) - ✅ **Per-server language preferences** with database persistence - ✅ **Interactive language selection** with dropdown UI (`!language` command) - ✅ **Hot reload capability** without bot restart (`!reloadlang` command) #### **AI Prompts Localization** (Critical Fix) - ✅ **All AI prompts now use i18n** - AI responses match server language - ✅ Fixed issue where AI would respond in Greek even when English was selected - ✅ Affected files: - `ai_assistant.py` - 23 translation keys - `advanced_ai.py` - 45 translation keys - `story_ai.py` - 200+ translation keys - `story_ai_generator.py` - 20 translation keys - `community_brain.py` - 15 translation keys - `food_suggestions.py` - 50+ translation keys - `template_creator.py` - 21 AI prompt keys #### **Default Language Change** - ✅ Changed default language from Greek (el) to English (en) - ✅ Existing servers retain their configured language - ✅ New servers default to English --- ### 🗄️ Database Migration - JSON to SQLite #### **Complete Database Conversion** - ✅ **Migrated from JSON to SQLite** for better performance and reliability - ✅ **100% async database operations** using `aiosqlite` - ✅ Eliminated "database is locked" errors - ✅ Migrated systems: - Levels & XP system - Game scores - Welcome system - Reaction roles - Guild settings - Subscription management #### **Performance Improvements** - ✅ **10x faster data saving** using batch operations (`executemany`) - ✅ **No more event loop blocking** - all operations are non-blocking - ✅ **Database timeout increased** to 10 seconds for concurrent operations - ✅ **Eliminated heartbeat warnings** and Discord disconnections --- ### 🚀 Performance & Stability Fixes #### **Discord Heartbeat Blocking (Critical Fix)** - ✅ **Fixed bot disconnections** every ~12 minutes - ✅ Converted all sync `sqlite3` operations to async `aiosqlite` - ✅ Affected files: - `database/db_manager.py` - 15 async methods - `utils/subscription_manager.py` - Full async conversion - `cogs/community_brain.py` - Batch operations - `database/user_facts.py` - 5 async methods - `database/user_memory.py` - 6 async methods #### **Story System Async Conversion** - ✅ **100% async story system** to prevent database locks - ✅ Converted files: - `story_database.py` - 22 async methods - `story_core.py` - 10 async methods - `story_turn_manager.py` - 12 async methods - `story_roles_manager.py` - 8 async methods - `story_manager.py` - 37+ await additions --- ### 🎯 Feature Additions #### **First-Time Setup System** - ✅ **Interactive setup wizard** when bot joins a new server - ✅ **Language selection** (Greek/English) with flag buttons - ✅ **Channel configuration** for welcome, mod logs, and anti-raid - ✅ **Skip option** for automatic channel creation - ✅ **Manual restart** with `!setup` command - ✅ **100% i18n compliant** #### **AI Memory System Enhancements** - ✅ **Increased conversation history** from 5 to 10 messages - ✅ **Conversation caching** with 5-minute cache duration - ✅ **Smart memory search** with keyword-based scoring - ✅ **90% cache hit rate** after warm-up - ✅ **Scalable for 100+ concurrent users** #### **Context-Aware Fact Validation** - ✅ **AI-powered fact validation** using Gemini - ✅ **Context analysis** to prevent incorrect information extraction - ✅ Fixed issue where "μένω στο τηλέφωνο" (on the phone) was interpreted as location - ✅ **Graceful fallback** if AI validation fails #### **Subscription Management** - ✅ **Automatic cleanup** when bot leaves a guild - ✅ **Manual cleanup command** (`!cleanup_subscriptions`) - ✅ **Detailed subscription listing** (`!list_subscriptions`) - ✅ **Developer tier assignment** (`!subscription dev_tier`) - ✅ **Full i18n support** for all subscription features --- ### 🐛 Bug Fixes #### **Duplicate Achievements Fix** - ✅ **Fixed race condition** causing duplicate achievements - ✅ Removed unnecessary `get_user_data()` call after achievement grant - ✅ Achievements now granted exactly once #### **Help System Language Bug** - ✅ **Fixed category names** not updating after language change - ✅ **Language-aware caching** with `{guild_id}_{language}` cache keys - ✅ **Automatic cache invalidation** when language changes - ✅ Categories now display in correct language after bot restart #### **Admin Panel i18n Error** - ✅ **Fixed missing translation keys** in admin panel - ✅ Added `subscription_status_title` and `subscription_status_desc` keys - ✅ Admin panel now fully functional in both languages #### **Server List Owner Display** - ✅ **Fixed owner not showing** in `!servers` command - ✅ **Fallback mechanism** to fetch owner if not cached - ✅ **Graceful error handling** with mention fallback #### **DATEUTIL Bug Fix** - ✅ **Fixed UnboundLocalError** in `user_facts.py` - ✅ Proper handling of `DATEUTIL_AVAILABLE` variable #### **Language Command DM Fix** - ✅ **Fixed permission error** when using `!language` in DMs - ✅ Proper guild-only check with user-friendly error message --- ### 🔧 Code Quality Improvements #### **Async/Await Compliance** - ✅ **All database operations are async** - ✅ **No blocking I/O operations** - ✅ **Proper error handling** with try-except blocks - ✅ **Graceful degradation** when services fail #### **Translation Key Organization** - ✅ **14 categories** of translation keys - ✅ **Consistent naming convention** (snake_case) - ✅ **No duplicate keys** across translation files - ✅ **Comprehensive coverage** of all user-facing strings #### **Database Schema** - ✅ **Proper PRIMARY KEY constraints** - ✅ **Foreign key relationships** where applicable - ✅ **Indexed columns** for better query performance - ✅ **Migration scripts** for schema updates --- ### 📊 Statistics - **Total Files Modified:** 40+ files - **Total Lines of Code:** 30,000+ lines - **Translation Keys:** 500+ keys (EL & EN) - **AI Prompt Files:** 8 files fully localized - **Database Tables:** 15+ tables - **Async Methods Converted:** 100+ methods --- ### 🎨 User Experience Improvements #### **Interactive UI Elements** - ✅ **Dropdown menus** for language selection - ✅ **Button-based navigation** in setup wizard - ✅ **Embed-based responses** with consistent styling - ✅ **Emoji indicators** for better visual feedback #### **Error Messages** - ✅ **User-friendly error messages** in both languages - ✅ **Helpful suggestions** when commands fail - ✅ **Detailed logging** for troubleshooting #### **Command Help** - ✅ **Categorized commands** with emojis - ✅ **Detailed usage examples** - ✅ **Permission requirements** clearly stated - ✅ **Language-aware help text** --- ### 🔒 Known Issues Resolved - ✅ **devimg.py loading issue** - Excluded from auto-load due to Python 3.12 importlib bug - ✅ **Database locking** - Resolved with async operations and increased timeout - ✅ **Heartbeat blocking** - Resolved with batch operations and async conversion - ✅ **AI language mismatch** - Resolved with i18n AI prompts - ✅ **Cache invalidation** - Resolved with language-aware cache keys --- ### 📝 Notes - **Backward Compatibility:** All changes maintain backward compatibility with existing data - **Backups:** JSON backups retained with `.backup` extension - **Testing:** All features tested in production environment - **Documentation:** Comprehensive documentation in `docs/` folder --- ## Future Improvements - [ ] Python 3.13+ upgrade to resolve devimg.py loading issue - [ ] Additional language support (French, Spanish, German) - [ ] Advanced AI features with multi-model support - [ ] Enhanced analytics and reporting - [ ] Mobile-optimized command responses --- **Last Updated:** October 28, 2025 - 23:57 UTC+2
UPDATES
# Changelog All notable changes, fixes, and improvements to this Discord bot. --- ## [Latest Updates] - 2025 ### 🌍 Internationalization (i18n) - Complete Overhaul #### **Full i18n Implementation** - ✅ **Complete multilingual support** across 40+ files (30,000+ lines of code) - ✅ **500+ translation keys** in both Greek (EL) and English (EN) - ✅ **Per-server language preferences** with database persistence - ✅ **Interactive language selection** with dropdown UI (`!language` command) - ✅ **Hot reload capability** without bot restart (`!reloadlang` command) #### **AI Prompts Localization** (Critical Fix) - ✅ **All AI prompts now use i18n** - AI responses match server language - ✅ Fixed issue where AI would respond in Greek even when English was selected - ✅ Affected files: - `ai_assistant.py` - 23 translation keys - `advanced_ai.py` - 45 translation keys - `story_ai.py` - 200+ translation keys - `story_ai_generator.py` - 20 translation keys - `community_brain.py` - 15 translation keys - `food_suggestions.py` - 50+ translation keys - `template_creator.py` - 21 AI prompt keys #### **Default Language Change** - ✅ Changed default language from Greek (el) to English (en) - ✅ Existing servers retain their configured language - ✅ New servers default to English --- ### 🗄️ Database Migration - JSON to SQLite #### **Complete Database Conversion** - ✅ **Migrated from JSON to SQLite** for better performance and reliability - ✅ **100% async database operations** using `aiosqlite` - ✅ Eliminated "database is locked" errors - ✅ Migrated systems: - Levels & XP system - Game scores - Welcome system - Reaction roles - Guild settings - Subscription management #### **Performance Improvements** - ✅ **10x faster data saving** using batch operations (`executemany`) - ✅ **No more event loop blocking** - all operations are non-blocking - ✅ **Database timeout increased** to 10 seconds for concurrent operations - ✅ **Eliminated heartbeat warnings** and Discord disconnections --- ### 🚀 Performance & Stability Fixes #### **Discord Heartbeat Blocking (Critical Fix)** - ✅ **Fixed bot disconnections** every ~12 minutes - ✅ Converted all sync `sqlite3` operations to async `aiosqlite` - ✅ Affected files: - `database/db_manager.py` - 15 async methods - `utils/subscription_manager.py` - Full async conversion - `cogs/community_brain.py` - Batch operations - `database/user_facts.py` - 5 async methods - `database/user_memory.py` - 6 async methods #### **Story System Async Conversion** - ✅ **100% async story system** to prevent database locks - ✅ Converted files: - `story_database.py` - 22 async methods - `story_core.py` - 10 async methods - `story_turn_manager.py` - 12 async methods - `story_roles_manager.py` - 8 async methods - `story_manager.py` - 37+ await additions --- ### 🎯 Feature Additions #### **First-Time Setup System** - ✅ **Interactive setup wizard** when bot joins a new server - ✅ **Language selection** (Greek/English) with flag buttons - ✅ **Channel configuration** for welcome, mod logs, and anti-raid - ✅ **Skip option** for automatic channel creation - ✅ **Manual restart** with `!setup` command - ✅ **100% i18n compliant** #### **AI Memory System Enhancements** - ✅ **Increased conversation history** from 5 to 10 messages - ✅ **Conversation caching** with 5-minute cache duration - ✅ **Smart memory search** with keyword-based scoring - ✅ **90% cache hit rate** after warm-up - ✅ **Scalable for 100+ concurrent users** #### **Context-Aware Fact Validation** - ✅ **AI-powered fact validation** using Gemini - ✅ **Context analysis** to prevent incorrect information extraction - ✅ Fixed issue where "μένω στο τηλέφωνο" (on the phone) was interpreted as location - ✅ **Graceful fallback** if AI validation fails #### **Subscription Management** - ✅ **Automatic cleanup** when bot leaves a guild - ✅ **Manual cleanup command** (`!cleanup_subscriptions`) - ✅ **Detailed subscription listing** (`!list_subscriptions`) - ✅ **Developer tier assignment** (`!subscription dev_tier`) - ✅ **Full i18n support** for all subscription features --- ### 🐛 Bug Fixes #### **Duplicate Achievements Fix** - ✅ **Fixed race condition** causing duplicate achievements - ✅ Removed unnecessary `get_user_data()` call after achievement grant - ✅ Achievements now granted exactly once #### **Help System Language Bug** - ✅ **Fixed category names** not updating after language change - ✅ **Language-aware caching** with `{guild_id}_{language}` cache keys - ✅ **Automatic cache invalidation** when language changes - ✅ Categories now display in correct language after bot restart #### **Admin Panel i18n Error** - ✅ **Fixed missing translation keys** in admin panel - ✅ Added `subscription_status_title` and `subscription_status_desc` keys - ✅ Admin panel now fully functional in both languages #### **Server List Owner Display** - ✅ **Fixed owner not showing** in `!servers` command - ✅ **Fallback mechanism** to fetch owner if not cached - ✅ **Graceful error handling** with mention fallback #### **DATEUTIL Bug Fix** - ✅ **Fixed UnboundLocalError** in `user_facts.py` - ✅ Proper handling of `DATEUTIL_AVAILABLE` variable #### **Language Command DM Fix** - ✅ **Fixed permission error** when using `!language` in DMs - ✅ Proper guild-only check with user-friendly error message --- ### 🔧 Code Quality Improvements #### **Async/Await Compliance** - ✅ **All database operations are async** - ✅ **No blocking I/O operations** - ✅ **Proper error handling** with try-except blocks - ✅ **Graceful degradation** when services fail #### **Translation Key Organization** - ✅ **14 categories** of translation keys - ✅ **Consistent naming convention** (snake_case) - ✅ **No duplicate keys** across translation files - ✅ **Comprehensive coverage** of all user-facing strings #### **Database Schema** - ✅ **Proper PRIMARY KEY constraints** - ✅ **Foreign key relationships** where applicable - ✅ **Indexed columns** for better query performance - ✅ **Migration scripts** for schema updates --- ### 📊 Statistics - **Total Files Modified:** 40+ files - **Total Lines of Code:** 30,000+ lines - **Translation Keys:** 500+ keys (EL & EN) - **AI Prompt Files:** 8 files fully localized - **Database Tables:** 15+ tables - **Async Methods Converted:** 100+ methods --- ### 🎨 User Experience Improvements #### **Interactive UI Elements** - ✅ **Dropdown menus** for language selection - ✅ **Button-based navigation** in setup wizard - ✅ **Embed-based responses** with consistent styling - ✅ **Emoji indicators** for better visual feedback #### **Error Messages** - ✅ **User-friendly error messages** in both languages - ✅ **Helpful suggestions** when commands fail - ✅ **Detailed logging** for troubleshooting #### **Command Help** - ✅ **Categorized commands** with emojis - ✅ **Detailed usage examples** - ✅ **Permission requirements** clearly stated - ✅ **Language-aware help text** --- ### 🔒 Known Issues Resolved - ✅ **devimg.py loading issue** - Excluded from auto-load due to Python 3.12 importlib bug - ✅ **Database locking** - Resolved with async operations and increased timeout - ✅ **Heartbeat blocking** - Resolved with batch operations and async conversion - ✅ **AI language mismatch** - Resolved with i18n AI prompts - ✅ **Cache invalidation** - Resolved with language-aware cache keys --- ### 📝 Notes - **Backward Compatibility:** All changes maintain backward compatibility with existing data - **Backups:** JSON backups retained with `.backup` extension - **Testing:** All features tested in production environment - **Documentation:** Comprehensive documentation in `docs/` folder --- ## Future Improvements - [ ] Python 3.13+ upgrade to resolve devimg.py loading issue - [ ] Additional language support (French, Spanish, German) - [ ] Advanced AI features with multi-model support - [ ] Enhanced analytics and reporting - [ ] Mobile-optimized command responses --- **Last Updated:** October 28, 2025