- Fixed bug in games_thread.py where overdistribution values were incorrectly
  added to the redistribution balance instead of subtracted. Now when we
  overdistribute (negative adjustment), we properly DECREASE the balance.
- Added Migration_068 to reset redistribution balance to 0 after the bug fix.
- Version bumped from 10.0.22 to 10.0.23

- Fix: Changed accumulated_shortfall += adjustment to -= adjustment in games_thread.py
  When overdistributing, we now properly decrease the redistribution balance
- Version: Bumped from 10.0.22 to 10.0.23 (and 10.0r22 to 10.0r23)

- Added recovery mode detection when accumulated_shortfall < 0
- When in recovery mode, select only results with minimum payout to redistribute less
- Updated version to 1.0.20 and 1.0r20

When the CAP threshold is negative and all payouts are 0 (no bets placed),
the system was only selecting one result (e.g., always DRAW) instead of
considering all results with equal payouts.

Changes:
- Fixed fallback selection to include ALL results with minimum payout
- Weighted random selection now properly considers all tied results
- Outcomes with better odds (lower coefficients) have higher probability

This ensures fair random selection among all possible outcomes when
multiple results have the same payout, weighted by their odds.

- Added meta refresh tag for redirect
- Added visible countdown timer
- Added link to homepage in redirect notice

Changed try_files fallback from /index.html to =404 so that
non-existent pages properly return 404 status and show the
custom 404 error page instead of serving index.html with 200.

- Create custom 404.html with combat sports theme
- Features TKO (Technical Knockout) messaging
- Includes animated boxing glove and fun stats
- Configure nginx to use custom 404 error page

- 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