Changelog

• Remove layout preference toggle from package-list.php and search.php
• Delete backend/api/layout-preference.php endpoint
• Remove API routes for layout preference
• Remove setting option from settings.php
• Delete user_preferences table schema and migration files
• Clean up outdated documentation files
• Grid view is now the default and only view

• Register migrate-reputation-schema route in API router
• Add Steam ID validation to leaderboard query (PostgreSQL regex)
• Create cleanup tool for invalid users (template literals, malformed IDs)
• Display 'Private User' instead of Steam ID for private profiles
• Add cleanup button to reputation management page

• Modal system with focus trap, scroll lock, ESC/overlay close
• Keyboard shortcuts (?, /, ESC, g+h, g+f, arrows)
• Form validation with real-time feedback
• Button system with hover/focus-visible states
• Toast notification limit (max 3)
• Loading states for async operations
• Scroll lock utility
• 44px minimum touch targets
• Comprehensive reduced-motion support
• All implementations vanilla JS, no frameworks

• Redesigned offline.html with s&box Explorer branding
• Improved visual polish with animations and hover effects
• Updated service worker to v2 with better caching strategy
• Added network-first approach with cache fallback
• Enhanced push notification handling with smart tab focusing

• Implement WebhookNotificationManager with duplicate prevention and rate limiting
• Add ChangeDetector for tracking new and updated packages
• Create DiscordWebhook API wrapper with retry logic
• Build comprehensive admin interface with stats, filters, and health monitoring
• Add database schema for webhook settings, notifications, and package snapshots
• Support package type filtering (games, addons, maps, etc.)
• Implement update cooldown to prevent spam (24h default)
• Add notification history log with success/failure tracking
• Include test functionality for manual package notifications
• Set up cron-compatible detection script

Redis Integration:

• Created 10 production-ready Redis classes in backend/includes/redis/
• RedisBase, RedisCache, RedisCounters, RedisLeaderboard, RedisLock
• RedisRateLimiter, RedisSessionHandler, RedisActivityStream, RedisPubSub
• RedisQueryCache, RedisBloomFilter, RedisHelper
• Integrated Redis into PageViewTracker, NotificationDispatcher, API routing
• Updated RecentlyViewedManager, PostgreSQLManager, WatchlistManager
• Added Redis API endpoints for counters, leaderboards, activity streams

Performance Optimization:

• Added .user.ini with OPcache configuration for 10-50x faster execution
• Added check-opcache.php diagnostic tool
• Optimized cache_manager.php with Redis support

Configuration:

• Updated .htaccess for production optimization
• Redis integration ready but optional (CACHE_DRIVER=sqlite by default)
• All Redis code tested and production-ready

• Add RedisCache implementation with fallback to SQLite

• Enhance NotificationManager, ReputationSystem, and WatchlistManager

• Add Redis warmup and system info admin tools

• Remove deprecated precache scripts

• Add cache testing and migration utilities

• Add MigrationManager for database schema versioning
• Add PageViewTracker for analytics event logging
• Add AnalyticsEvents for event type definitions
• Add aggregate-analytics tool for data processing
• Update AdminLogViewer with analytics support
• Update admin-tools-api with analytics endpoints
• Update log-viewer with analytics UI

Some stuffs

Introduces DatabaseManager for unified SQLite access and adds MigrationManager for data migration. Refactors multiple backend modules and APIs to use the consolidated database when enabled, improving maintainability and scalability. Updates .gitignore to exclude .zip files.

Introduces API documentation generation via new backend endpoints and helpers, including docs.php and api-doc-generator.php. Refactors Router to support route metadata for documentation, updates API response formatting, and removes obsolete scripts and tools. Also updates frontend scripts to use new API endpoints and improves code consistency.

• Implement i18n.php with translation loading and caching
• Add language switcher in footer with flag icons
• Create locale files for 23 languages
• Update all frontend pages to use translation functions
• Add locale notification system for missing translations
• Remove deprecated language-switcher component
• Update translation tools

• Added i18n system with language detection and routing
• Created translation infrastructure with 9 locale namespaces
• Added language switcher in header with search and grouping
• Integrated language settings tab in user settings
• Added 29 language support: European, Asian, Middle Eastern languages
• Created translation tools (translate-simple.py, check-translation-keys.py)
• Added localized URL routing for major languages
• Implemented persistent translation cache for performance
• Added Kiro hook for automatic translation key checking
• Updated all pages to use translation system