- Add role-based access control: brokers cannot access player.html and players cannot access broker.html
- Update profile.html header to match player/broker dashboard style with dropdown menu
- Update wallet.html header to match player/broker dashboard style with dropdown menu
- Remove hardcoded player.html link from profile.html, use role-based dashboard link
- Fix authentication token key consistency (authToken instead of access_token)

The previous commit added g.user_id = ... but forgot to import 'g' from Flask.
This was causing 500 errors on all authenticated API endpoints.

- Add detailed logging for debugging 500 errors
- Log when API or user_id is not available
- Include traceback in error logs

- Check if api_bp.db_manager is available before accessing it
- Return overlay_data gracefully if database not available

The /api/wallet endpoint was returning 401 because it checks g.user_id
but the auth decorators only set request.current_user. Now both are set.

- Fixed require_auth decorator in auth.py to set g.user_id
- Fixed get_api_auth_decorator in routes.py to set g.user_id

- Add token verification before redirect
- Add detailed logging for API requests
- Increase redirect delay to ensure localStorage sync

- Add Authorization header passthrough in nginx config
- Add cookie passthrough for session authentication
- Improve apiRequest error handling for non-JSON responses
- Only redirect to login on protected pages when auth fails

- Remove /api prefix from profile endpoints since API_BASE_URL already includes it
- Fixes /api/api/profile 404 error

- Add API_BASE_URL prefix to fetch calls in the second apiRequest function
- Fix wallet endpoint URLs to not double-prefix /api
- This fixes the 401 errors and redirect loop

- Add all current files in web directory
- Include wallet.html, profile.html, privacy.html, member.html
- Update JavaScript files list (player.js, broker.js, overlay-controller.js)
- Document symlinks to js/ and templates/ directories

- Update index.html dropdown to match player.html and broker.html
- Add Wallet and Profile Settings links with icons
- Add dropdown divider for visual separation
- Add UI Consistency Requirements section to AI.PROMPT
- Document header and dropdown menu consistency requirements

- Change 'access_token' to 'authToken' throughout
- Change 'refresh_token' to 'refreshToken' throughout
- Fix redirect loop caused by token name mismatch

- Change token check from 'access_token' to 'authToken' in wallet.html
- Add wallet.html to protected pages list in app.js
- Fix token name consistency across the web app

- Add !important to background and color properties
- Ensures styles are not overwritten by other CSS rules

- Remove duplicate .balance-display definition
- Use dark blue background (#1a5a7a) with white text for better contrast
- Add border and shadow for better visibility

- Use solid #00d4ff background instead of gradient
- Add border for better definition
- Increase font weight to 700
- Add box shadow for better visibility

- Add --card-bg CSS variable for consistent background colors
- Make dropdown menu background solid (#2a2a2a) instead of transparent
- Add border and stronger shadow to dropdown for better visibility
- Change balance button to gradient background with dark text
- Add shadow to balance button for better readability

- Match Qt player behavior: wait 5 seconds after result video ends
- Switch to black screen during the 5-second delay
- Send PLAY_VIDEO_RESULT_DONE after delay to allow results overlay to display
- Clear result data after the done message is sent

- Query ExtractionAssociationModel for winning outcomes based on match result
- Include under_over_result in winning outcomes list
- Match Qt player's getWinningOutcomes() logic in API endpoint
- Results overlay now correctly shows fighter names, result, winning outcomes, and under/over result

Fix results overlay template to display fighter names, main result, under/over result, and winning outcomes

- Added separate HTML sections for main result and under/over result display
- Added updateMainResultDisplay() and updateUnderOverResultDisplay() functions
- Updated prepareResultsAnimation() to call both new display functions
- Under/over result now shows with distinct styling (green for UNDER, orange for OVER)
- web/templates is a symlink to mbetterclient/qt_player/templates

- Added user dropdown menu with avatar, wallet and profile links
- Integrated Gravatar support with MD5 hash for email-based avatars
- Added dropdown toggle functionality with click-outside-to-close
- Fixed balance display colors for better readability
- Added dropdown divider styling

- Add MD5 hash function for Gravatar URL generation
- Display avatar from custom URL or Gravatar (with email hash)
- Show real_name or username as display name
- Show email from database
- Format member since date nicely
- Add fallback for avatar load errors
- Update back button based on user role

- Create wallet.html with full wallet management UI
- Fix player.js to show actual username (real_name or username) instead of 'Player'
- Add Wallet links to player.html and broker.html headers
- Wallet page includes balance overview, deposit/withdraw modals, transaction history

- Add WalletModel and WalletTransactionModel for balance tracking
- Add wallet API endpoints: balance, deposit, withdraw, transactions
- Add profile API endpoints: password change, email change with verification, avatar upload
- Create profile.html page with wallet and profile management UI
- Update player.html and broker.html with profile links
- Add wallet and profile JavaScript functions to app.js
- Add comprehensive CSS styling for profile and wallet components

- Fix overlay controller to properly handle video phase state machine
- Stop template rotation during match/result phases
- Fetch match data with fighter names from database for match phase
- Send match data to match_video template via matchUpdate message
- Handle result_data properly in result phase
- Update match_video template to process match data from web player
- Update overlay-web-adapter to emit match data directly

This fixes the issue where the web player overlay was cycling between
fixtures and match templates instead of showing the match_video template
during match video playback, and not showing results either.

- Updated main.py version to 1.0.15
- Updated build.py app_version to 1.0.15
- Updated MbetterClient.spec version to 1.0.15
- Updated mbetterclient/__init__.py __version__ to 1.0.15
- Updated mbetterclient/config/settings.py version to 1.0.15
- Updated mbetterclient/config/settings.py user_agent to MbetterClient/1.0r15
- Updated mbetterclient/web_dashboard/app.py app_version to 1.0.15

- Added guard in loadTemplate() to skip if template already loaded
- Fixed executePhaseTransition() to properly pass match data to results template
- Removed duplicate match_video loading logic in fetchOverlayData()
- Template names are now normalized to prevent case-sensitivity issues

- Fixed overlay controller to check video phase before loading templates
- Prevented template rotation during match and result phases
- Fixed resultUpdate message handling in overlay-web-adapter.js
- Template rotation now only runs during idle/intro phases
- match_video template now correctly displays during match video
- results template now correctly displays during result video

- Set video_phase='match' in rtsp_streamer._switch_to_video() when playing UNDER/OVER videos
- Stop template rotation immediately when match/result phase detected in overlay-controller.js
- This prevents the overlay from cycling between fixtures/match templates during match video
- Results template now properly displays after match video ends

- Added _cached_today_fixture_id and _today_fixture_cache_time to cache today's fixture
- Cache is valid for 60 seconds to prevent race conditions
- This prevents multiple fixtures being created when _get_or_create_today_fixture is called multiple times in quick succession
- Also provides MySQL queries for user to clean up duplicate fixtures

- Add _process_today_pending_matches() to process pending matches in today's fixture
- Add _resolve_match_bets() to resolve bets for matches being finalized
- Add _get_outcome_coefficient_for_bet() to get coefficients for bet resolution
- For pending matches with no results: change status to 'bet' to play first
- For pending matches with results: finalize as 'done' and resolve associated bets
- Add Step 5 in initialize() to process today's pending matches

- Add _get_outcome_template() method to fetch template assignments from database
- Update _handle_play_video_match() to use configured template for UNDER/OVER videos
- Update _play_result_video() to use configured template for result videos
- Update _switch_to_result_overlay() to use new template lookup method
- Templates are now correctly loaded based on dashboard configuration
- Falls back to match_video.html for UNDER/OVER and results.html for other outcomes

- Fix _get_or_create_today_fixture() to use created_at as fallback when start_time is NULL
- Replace _initialize_new_fixture() calls with _get_or_create_today_fixture() in _handle_start_game()
- Fix reset_fixtures() to use raw SQL DELETE statements for proper MySQL foreign key handling
- Delete tables in correct order: extraction_stats, bets_details, bets, match_outcomes, matches, match_outcomes_templates, matches_templates

- Updated _cleanup_old_incomplete_matches() to also check matches with NULL start_time using created_at as fallback
- Updated _get_yesterday_incomplete_matches() to also check matches with NULL start_time using created_at as fallback
- Added detailed debug logging to help diagnose date/time issues
- This fixes the issue where matches from old fixtures were not being detected because their start_time was NULL or recently synced

- Add _cleanup_old_incomplete_matches() to mark 2+ day old matches as failed
- Add _get_yesterday_incomplete_matches() to detect yesterday's incomplete matches
- Add _get_or_create_today_fixture() to ensure new matches go to today's fixture
- Modify initialize() to process past incomplete matches before starting
- Modify _handle_start_game() to use pre-computed yesterday_fixture_id
- Add yesterday_fixture_id attribute to track yesterday's fixture for completion

This ensures:
- Matches from 2+ days ago are marked as failed with bet cancellation
- Yesterday's incomplete matches are played to completion first
- New matches are created in today's fixture, not yesterday's

- Add _cleanup_old_incomplete_matches() to close matches 2+ days old as 'failed'
- Add _get_yesterday_incomplete_matches() to find yesterday's incomplete matches
- Add _get_or_create_today_fixture() to ensure new matches go to today's fixture
- Add yesterday_fixture_id attribute to track yesterday's fixture for completion
- Modify initialize() to process past incomplete matches before starting
- Pre-create today's fixture when yesterday's incomplete matches are found
- Ensure new matches are created in today's fixture, not yesterday's

- Add video phase tracking in RTSPStreamer (idle, intro, match, result)
- Implement HLS delay compensation for overlay template synchronization
- Fix results template not showing after match video ends
- Add phase transition handling with configurable delay compensation
- Update overlay API endpoint to include video phase state
- Add phaseTransitionTimer for delayed template changes

This ensures overlay templates are synchronized with HLS video playback
by compensating for FFmpeg encoding and web player buffering delays.

Fix match result display: use display_result field to show actual fight winner instead of UNDER/OVER