- Updated Migration_067 to use correct SQL for double-encoded JSON
- Fixed _set_match_status_and_result to properly handle UNDER/OVER results
- When result is UNDER/OVER, store it in under_over_result field
- Extract actual fight winner from winning_outcomes JSON

The winning_outcomes column is stored as a double-encoded JSON string:
- Outer layer: JSON string (e.g., '"[\"KO2\", \"WIN1\"]"')
- Inner layer: JSON array of outcome names

The fix uses JSON_UNQUOTE(JSON_EXTRACT(JSON_UNQUOTE(winning_outcomes), '$[0]'))
to extract the first outcome from the inner array.

- When result is UNDER/OVER, store it in under_over_result field
- Extract actual fight winner from winning_outcomes or match outcomes
- Prevents match.result from being incorrectly set to UNDER/OVER
- This fixes the recurring bug where result field showed UNDER/OVER instead of actual fight winner

- Added migration that fixes matches where result field contains UNDER or OVER
- Parses winning_outcomes JSON to find actual fight winner
- Sets under_over_result to the previous incorrect result value
- Runs automatically at application launch

- Fixed bug where match.result showed 'under'/'over' instead of actual fight winner
- Added print functionality to admin fixture details page with option to print last N matches
- Enhanced cashier dashboard to show all matches of today's fixture with proper status
- Added Result, Winning Outcomes, and Under/Over columns to cashier match list
- Made 'Bet' status badge clickable linking to /bets/new
- Added date filter to select past fixtures with proper venue timezone handling
- Removed 'Update Display Overlay' and 'Send Custom Message' buttons from cashier dashboard
- Bumped version to 1.0.17

- Changed from server local date (date.today()) to venue timezone date
- Use get_today_venue_date() for proper timezone-aware date calculation
- Convert venue date range to UTC for database queries using venue_to_utc_datetime()
- This fixes the issue where selecting yesterday's date showed today's fixture
- The database stores start_time in UTC, so we need to convert the selected date to UTC range

- Added Result column showing match result (WIN1, DRAW, WIN2, etc.)
- Added Winning Outcomes column showing all winning outcomes from extraction
- Added Under/Over column showing UNDER or OVER result
- Updated summary boxes to show wins, draws, under, and over counts
- Improved print layout with better column sizing

- Changed from 'pending matches' to 'all matches in today's fixture'
- Added summary row showing counts by status (total, pending, bet, ingame, done, other)
- Added Result and Under/Over columns to the match table
- Made 'Bet' status badge clickable - links to new bet page for that match
- Added date filter to select past fixtures by date
- Updated API endpoint to support date parameter for filtering
- Color-coded rows based on match status (done=green, failed=red, ingame=blue, bet=yellow)

- Added Print Matches button in header
- Added print modal with options to print all or last N matches
- Added professional print layout with fixture info, summary, and match table
- Print includes cashier username and timestamp

- API now returns is_today, is_past, and fixture_venue_date flags
- JavaScript filterFixtures() uses server-provided is_past flag instead of browser timezone
- renderFixturesTable() uses server-provided is_today/is_past for date badges
- Fixes fixtures not showing when browser timezone differs from venue timezone

- get_fixtures() now uses get_today_venue_date() instead of date.today()
- calculate_fixture_status() converts UTC start_time to venue timezone before date comparison
- Fixes fixtures not showing when start_time is today in local time but yesterday in UTC

- Remove active_status=True filter when finding pending matches with results
- Re-activate matches that had active_status=False (partially processed)
- This fixes match 426 being skipped because it had active_status=0

Fix cross-day fixture handling: don't add matches to yesterday's fixture, finalize pending matches with results, bump version to 1.0.16

- Fixed bug in _update_bet_results where match.result was incorrectly set to UNDER/OVER when selected_result was UNDER/OVER
- Now properly looks for actual fight winner (WIN1, DRAW, WIN2, etc.) from winning outcomes or match outcomes
- Added print functionality to fixture details page with options to:
  - Print all matches or last N matches
  - Include/exclude completed or pending matches
- Added print-specific CSS for clean printouts

- Added _refresh_endpoints_from_config() method that checks for URL/token changes
- Called before each scheduled request to ensure config changes are immediately applied
- URL changes trigger endpoint URL updates for fastapi_main, reports_sync, reports_last_sync
- Token changes update authentication configuration and enable/disable endpoints accordingly
- Interval changes are also detected and applied dynamically
- Combined with existing immediate trigger on config save, this ensures seamless config updates

- Add visible 'Back to Dashboard' button in profile.html header
- Add visible 'Back to Dashboard' button in wallet.html header
- Add logout function to wallet.html
- Both buttons use role-based navigation (player -> player.html, broker -> broker.html)

- 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