Request
dark
Theme
Auto Light Dark
Version History

Changelog

v2.2.1 Telegram Bot Improvements & Network Diagnostics August 1, 2025

Telegram Bot Enhancements

  • ✓ Settings-based startup: Bot only starts when Telegram notifications are enabled in admin settings
  • ✓ Network diagnostics: Detailed error messages for connection issues, firewall blocks, and ISP restrictions
  • ✓ Robust error handling: Graceful handling of network timeouts, invalid tokens, and API errors
  • ✓ Exponential backoff: Smart retry mechanism with increasing delays for network failures
  • ✓ Connection testing: Automatic bot authentication check on startup with clear status messages

System Reliability

  • ✓ Conditional startup: Bot respects admin settings and only runs when explicitly enabled
  • ✓ Graceful degradation: System continues to function even if Telegram API is unreachable
  • ✓ Detailed logging: Comprehensive logging for debugging connection issues and network problems

v2.2.0 Automatic Spotify Integration & Track Completion July 25, 2025

Automatic Spotify Integration

  • ✓ Automatic Spotify login during event creation: Seamless redirect to Spotify auth if not logged in
  • ✓ Intelligent session management: Event data is temporarily stored and automatically processed after login
  • ✓ Automatic playlist creation: Spotify playlist is created directly after successful login
  • ✓ Seamless workflow: From event creation through login to finished playlist without interruption

Auto-Playlist System

  • ✓ Auto-playlist selection: Choose a Spotify playlist to automatically play after all requests
  • ✓ Playlist persistence: Selected auto-playlist is saved per event and restored on page reload
  • ✓ Automatic playback: Auto-playlist starts automatically when the last track finishes
  • ✓ Queue integration: New song requests are still properly queued during auto-playlist playback

Automatic Track Completion System

  • ✓ Automatic track completion detection: Tracks are marked as played at 95% progress or track change
  • ✓ Live playlist synchronization: Played tracks are automatically removed from Spotify playlist
  • ✓ Real-time UI updates: Tracklist is automatically updated without page reload
  • ✓ Background processing: Everything runs in the background without user interaction

Admin Layout Improvements

  • ✓ Responsive 3-column layout: Compact Spotify player left, event details right, tracklist below
  • ✓ New Spotify header: Integrated play, sync and open buttons in event details
  • ✓ Conditional layout: Optimized display depending on Spotify playlist status
  • ✓ Mobile optimization: Button texts are hidden on small screens

Complete Localization

  • ✓ German texts translated: All remaining German texts in all files translated to English
  • ✓ Consistent language usage: Uniform localization throughout the entire application
  • ✓ Multilingual support: Complete support for DE, EN and NL

Technical Improvements

  • ✓ Session type extensions: New pendingEventData structure for temporary event storage
  • ✓ New API routes: /admin/events/create-after-auth and /admin/events/:id/track-completed
  • ✓ Improved error handling: Detailed logging and graceful error handling
  • ✓ Real-time synchronization: Bidirectional sync between web interface and Spotify playlist

v2.1.1 Admin Dashboard & Translations July 24, 2025

Admin Dashboard Fixes

  • ✓ Fixed Spotify account display: Linked Spotify account email now correctly shows in admin event layout
  • ✓ Fixed total requests display: Added missing total requests counter to admin event statistics
  • ✓ iPad view improvements: Spotify account info now also visible in iPad-optimized event view

Translation Updates

  • ✓ Added missing translation key 'admin.event.stats.total_requests' for total requests counter
  • ✓ Updated all locale files (EN, DE, NL) with new translation keys

v2.1.0 Spotify Player UX & Auto-Play Features July 23, 2025

Spotify Player Improvements

  • ✓ Automatic playback of new song requests: Direct playback when nothing is playing, otherwise add to queue
  • ✓ Intelligent queue system: New tracks are automatically added to the Spotify queue
  • ✓ Fixed playlist sync button: Complete bidirectional synchronization between event requests and Spotify playlist
  • ✓ Improved login UX: Centered, clean login box in blacklist style without distracting player controls

Authentication & Navigation

  • ✓ Smart redirect after Spotify login: Automatic return to the original page (Event or Settings)
  • ✓ Return URL system: Stores the origin page in session for seamless navigation
  • ✓ Improved error handling: Even login errors redirect to the correct page

Localization

  • ✓ Complete Spotify player localization: All German texts replaced with localized variables
  • ✓ Localized status messages: Connection status, device status and error messages in all languages
  • ✓ Localized error alerts: Token expiration, no active device and other Spotify errors

Technical Improvements

  • ✓ New syncEventPlaylist method: Complete bidirectional synchronization with detailed logging
  • ✓ New admin API route: /admin/events/:id/sync-playlist for manual playlist synchronization
  • ✓ Graceful error recovery: Auto-play or sync errors don't affect request creation

v2.0.1 Ban Modal and Blacklist Improvements July 23, 2025

UI Improvements

  • ✓ Modernized ban modal: No more alert popups, replaced with visual feedback directly in the modal
  • ✓ Redesigned delete modal in blacklist view: Now displays song information (cover, title, artist)
  • ✓ Integrated visual feedback for success and error messages directly in modals

Technical Improvements

  • ✓ Fixed parameter passing to blacklist endpoint (spotify_id, title, artist)
  • ✓ Improved ban logic: Requests are automatically deleted after blacklist entry
  • ✓ Enhanced error handling with detailed visual feedback

v2.0.0 Major Update: Spotify Integration & Player July 23, 2025

Spotify Playlist Integration

  • ✓ Automatic playlist creation when creating events
  • ✓ Automatic synchronization of song requests with the playlist
  • ✓ New option in the admin panel for playlist linking
  • ✓ Automatic unfollowing of playlist when deleting an event
  • ✓ Secure token management with encrypted storage

Spotify Player Integration

  • ✓ Full playback control (Play, Pause, Previous, Next, Volume)
  • ✓ Intelligent device management and switching
  • ✓ Real-time display of current track and status
  • ✓ Automatic detection of active Spotify clients
  • ✓ Step-by-step guide for client activation

Technical Improvements

  • ✓ Extended OAuth scopes for playback permissions
  • ✓ Complete Spotify Web API integration
  • ✓ Improved error handling and user guidance
  • ✓ Robust OAuth2 Authorization Code Flow with refresh token
  • ✓ Encrypted storage of all Spotify tokens
  • ✓ Automatic token refresh on expiration

Localization

  • ✓ Fully localized player user interface
  • ✓ Multilingual help texts and instructions
Breaking Changes: Spotify logout and re-login required for extended playback permissions.

v1.6 Major iPad Dashboard & Localization Update July 20, 2025

Localization

  • ✓ All texts in the fullscreen QR code overlay are now fully localized
  • ✓ Fixed issue where English settings would still show German texts
  • ✓ Complete Dutch language support for all new features
  • ✓ All texts in the iPad tracklist view are now fully localized
  • ✓ Error messages in JavaScript part have been localized and translated into all languages

iPad Dashboard Improvements

  • ✓ Display of open requests count in the fullscreen overlay
  • ✓ Enhanced toggle button with smooth animations and better design
  • ✓ Optimized QR code size and layout for iPad Air devices
  • ✓ Dark address bar on iPad for a consistent fullscreen experience

iPad Dashboard

  • ✓ New iPad-optimized view for events with dashboard design
  • ✓ Fullscreen mode without navigation bar for maximum overview
  • ✓ Prominent QR code display for easy scanning
  • ✓ Automatic scroll effect for the tracklist with constant speed

Technical Improvements

  • ✓ Smart tracklist refresh only after reaching the scroll end
  • ✓ Constant scroll speed for better readability
  • ✓ Fixed sorting order: Newest songs are now displayed at the top

v1.5.1 Notification Enhancements July 19, 2025

Notification Enhancements

  • ✓ Support for multiple Telegram chat IDs (comma-separated list)
  • ✓ Browser notifications can now be enabled in parallel with Telegram notifications

Technical Improvements

  • ✓ Fixed TypeScript errors related to missing module typings
  • ✓ Improved internationalization for notification settings
  • ✓ All notification texts are now fully internationalized and available in all supported languages

v1.5.0 Docker Restructuring & Multi-Instance Support July 18, 2025

Docker Improvements

  • ✓ Restructured project: All application files moved to "app" subdirectory
  • ✓ Docker files (Dockerfile, docker-compose.yml) kept in the main directory
  • ✓ Simplified build process with a central image for all instances
  • ✓ Automated build script (build.sh) for easy image creation

Multi-Instance Support

  • ✓ Multiple instances can be operated in the same main directory
  • ✓ Individual databases per instance as local volume
  • ✓ Individual logos per instance as local volume
  • ✓ Independent configuration of environment variables per instance

Technical Improvements

  • ✓ Improved Dockerfile with automatic creation of the image folder
  • ✓ Removal of the LOGO_URL environment variable in favor of volume mounting
  • ✓ Optimized restart process for individual instances

UI Improvements

  • ✓ Replaced logo with a music icon in the header for a unified design
  • ✓ Simplified QR code display in the event view
  • ✓ Simplified deployment without logo middleware and volume mounts

v1.4.3 Persistent Song Statistics System July 1, 2025

Backend Improvements

  • ✓ Implemented persistent song statistics that survive event deletions
  • ✓ "Most Requested Songs" now shows data from the last 30 days, even if original events are deleted
  • ✓ Created dedicated song_stats table with automatic migration from existing request data
  • ✓ Song requests are now automatically aggregated and tracked independently of events
  • ✓ Added automatic cleanup script for statistics older than 30 days
  • ✓ Optimized database queries with proper indexing for statistics retrieval
  • ✓ Successfully migrated existing song request data to new persistent statistics system

New Features

  • ✓ "Most Requested Songs" section now persists data for 30 days regardless of event lifecycle
  • ✓ Song popularity tracking is now independent of event management
  • ✓ Maintains historical song request data for better long-term insights

v1.4.2 Setup Page Polish & Search Refinements July 1, 2025

User Interface Improvements

  • ✓ Modernized search form with Tabler input-icon design and rounded styling
  • ✓ Increased search bar size for better visibility and mobile usability
  • ✓ Restored search form to full width layout for better usability
  • ✓ Simplified search experience by removing progress bar for cleaner interface
  • ✓ Fixed home page alignment to match consistent layout with other admin pages
  • ✓ Reverted home page to clean, native design with standard page header and card layout
  • ✓ Made Instagram profile URL configurable via INSTAGRAM_URL environment variable
  • ✓ Added comprehensive icons to setup page form labels and instructions for better visual hierarchy
  • ✓ Fixed setup page header alignment to match other admin pages with consistent icon placement
  • ✓ Fixed Spotify icon visibility in test button - now remains visible on hover/focus states
  • ✓ Enhanced Spotify icon in test button to turn white on hover/focus for better visual feedback
  • ✓ Enhanced all form hints with informational icons for improved user guidance
  • ✓ Added contextual icons to Spotify setup instructions (arrows, copy, link icons)
  • ✓ Improved callback URL display in setup instructions - moved to separate line to prevent text cutoff
  • ✓ Enhanced callback URL with bordered box design, monospace font, and click-to-select functionality for easy copying
  • ✓ Created dedicated Spotify test endpoint for setup process that works without admin authentication
  • ✓ Achieved complete visual consistency across all setup page elements with Tabler icon system

v1.4.1 UI Polish & Button Consistency July 1, 2025

User Interface Improvements

  • ✓ Standardized event list action buttons to match admin tracklist styling (32px size, 1.2em icons)
  • ✓ All admin action buttons now have consistent sizing and icon styling across all pages
  • ✓ Fixed vertical alignment issues in events table - all content now properly centered in table cells
  • ✓ Fixed notification button flashing on page load by implementing smooth opacity transition
  • ✓ Added missing logout icon to navbar dropdown menu for visual consistency
  • ✓ Updated song request buttons to match admin tracklist styling (32px size, Tabler icons, btn-list layout)
  • ✓ Final polish pass on button alignment and icon consistency throughout admin interface

v1.4.0 Major Security & UI Update July 1, 2025

Security & Credential Management

  • ✓ Spotify credentials are now stored encrypted in database instead of environment variables
  • ✓ New encryption service using modern crypto API with AES-256-GCM
  • ✓ Removed SPOTIFY_CLIENT_ID and SPOTIFY_CLIENT_SECRET from .env and docker-compose.yml
  • ✓ Added secure settings table with encrypted column support

User Interface & Experience

  • ✓ Complete theme system with Auto/Light/Dark modes
  • ✓ Theme switcher in navbar next to user menu
  • ✓ Fixed dark mode flash on F5 refresh (FOUC prevention)
  • ✓ Redesigned admin settings page with icons and better grouping
  • ✓ Added icons to all settings sections and improved visual hierarchy
  • ✓ Replaced all SVG icons with consistent CSS/Tabler icons
  • ✓ Added Spotify configuration status indicator in settings
  • ✓ Standardized page layout spacing across admin pages
  • ✓ Improved badge color contrast for better readability

Telegram Integration

  • ✓ Telegram bot now sends chat ID automatically on /start command
  • ✓ Simplified Telegram setup - just start the bot and copy the chat ID
  • ✓ Enhanced notification messages with event names and better formatting
  • ✓ Fixed 'requested at' time in Telegram notifications to match admin panel

Spotify Integration

  • ✓ Added 'Test Spotify Credentials' buttons in both setup and settings
  • ✓ Dynamic redirect URI generation based on current domain
  • ✓ New API endpoints for credential validation before saving

Localization

  • ✓ Complete localization coverage for all new features (DE, EN, NL)
  • ✓ All theme-related UI strings are properly localized
  • ✓ Dynamic domain display in setup instructions now localized
  • ✓ Admin language preference setting - override browser language in admin panel
  • ✓ Fixed language detection and persistence in admin panel

Technical Improvements

  • ✓ New theme middleware for server-side theme management
  • ✓ RESTful API endpoints for theme switching and credential testing
  • ✓ Improved error handling and user feedback throughout the application
  • ✓ Database migrations system for smooth updates

Migration Notes

For Existing Installations

If you're upgrading from a previous version, you'll need to re-enter your Spotify credentials through the admin panel.
Migration Steps:
  1. Your existing Spotify credentials in .env will no longer be used
  2. Go to Admin → Settings → Spotify API Configuration
  3. Enter your Spotify Client ID and Client Secret
  4. Use the 'Test Spotify Credentials' button to verify they work