from pathlib import Path code = r''' LeaguePilot System Check
🧪 LeaguePilot Build Audit

System Check

This page checks the real current LeaguePilot setup before we keep building. It now uses information_schema so HostGator/MariaDB table checks do not falsely fail.

100% core setup detected for this season.

Next Best Action: Core data exists. Review, publish, or export.

🚀 Review / Publish Open Master Hub

DB: hamikest_hbccreators Season #1 Demo Baseball Season draft

DB Connection
OK
Connected
DB Name
hamikest_hbccreators
SELECT DATABASE()
Players
25
league_players
Teams
3
generated teams
Games
8
league_games

Core Readiness

Players imported
25 record(s)
✅ Ready Open
Coaches entered
4 record(s)
✅ Ready Open
Fields entered
3 record(s)
✅ Ready Open
AI settings saved
1 record(s)
✅ Ready Open
Teams generated
3 record(s)
✅ Ready Open
Rosters generated
25 record(s)
✅ Ready Open
Schedule generated
8 record(s)
✅ Ready Open

Important Notes

No major workflow block detected. Use this page after each build change to verify the system still lines up.

Official schedule table expected by current build: league_games
Also present in DB: league_schedule_games
Official team output expected by current build: league_generated_teams + league_generated_rosters
Official DB include expected: ../../database_config1/db_config_hbc.php

League Tables Found

Live list from information_schema using the connected DB name.

league_ai_recommendations
league_ai_simulation_runs
league_blackouts
league_coaches
league_communication_logs
league_fields
league_field_availability
league_games
league_game_official_assignments
league_generated_rosters
league_generated_teams
league_media_campaigns
league_officials
league_organizations
league_players
league_player_requests
league_recruiter_interactions
league_registration_payments
league_schedule_games
league_seasons
league_sponsors
league_system_events
league_team_build_settings
league_team_sponsors
league_volunteers
league_weather_cache

Required Database Tables / Columns

league_organizations
Required columns found
✅ Schema OK
league_seasons
Required columns found
✅ Schema OK
league_players
Required columns found
✅ Schema OK
league_coaches
Required columns found
✅ Schema OK
league_fields
Required columns found
✅ Schema OK
league_blackouts
Required columns found
✅ Schema OK
league_team_build_settings
Required columns found
✅ Schema OK
league_generated_teams
Required columns found
✅ Schema OK
league_generated_rosters
Required columns found
✅ Schema OK
league_games
Required columns found
✅ Schema OK

Official Core Pages

leaguepilot_master_hub.php
Official start page / live command center
✅ File Exists Open
leaguepilot_system_check.php
System checker / build audit
✅ File Exists Open
leaguepilot_player_import.php
Official player intake/import
✅ File Exists Open
leaguepilot_coach_manager.php
Official coach manager
✅ File Exists Open
leaguepilot_field_manager.php
Official field manager
✅ File Exists Open
leaguepilot_blackout_manager.php
Official blackout manager
✅ File Exists Open
leaguepilot_ai_levers.php
Official AI levers/settings
✅ File Exists Open
leaguepilot_ai_team_builder_engine.php
Official AI team generator
✅ File Exists Open
leaguepilot_manual_roster_editor.php
Official roster editor
✅ File Exists Open
leaguepilot_ai_schedule_builder_engine.php
Official schedule generator engine
✅ File Exists Open
leaguepilot_schedule_builder.php
Visual schedule builder/calendar layer
✅ File Exists Open
leaguepilot_publish_center.php
Publish center
✅ File Exists Open
leaguepilot_parent_portal.php
Parent-facing portal
✅ File Exists Open
leaguepilot_exports.php
Export center
✅ File Exists Open

Overlap / Legacy / Experimental Files

These may be useful, but should not be treated as the main workflow unless we confirm they are current.

leaguepilot_dashboard.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_command_center.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_launch_center.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_ai_super_hub.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_controls.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_upload_players.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_upload_coaches.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_upload_fields.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_generate_teams.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_blackout_manager_v1.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_schedule_builder_v1.php
Present in folder. Confirm whether this is old, duplicate, or active.
Review Open
leaguepilot_ai_team_builder.php
Not found in this folder.
Not Present

All LeaguePilot PHP Files Found

This is a live scan of files named leaguepilot_*.php in the current folder.

leaguepilot_ai_analytics.php
leaguepilot_ai_copilot.php
leaguepilot_ai_levers.php
leaguepilot_ai_scenario_simulator.php
leaguepilot_ai_schedule_builder_engine.php
leaguepilot_ai_super_hub.php
leaguepilot_ai_super_hub_v2.php
leaguepilot_ai_super_hub_v2_2.php
leaguepilot_ai_team_builder_engine.php
leaguepilot_blackout_manager.php
leaguepilot_blackout_manager_v1.php
leaguepilot_coach_manager.php
leaguepilot_command_center.php
leaguepilot_communication_center.php
leaguepilot_controls.php
leaguepilot_dashboard.php
leaguepilot_digital_twin.php
leaguepilot_exports.php
leaguepilot_facility_traffic_command.php
leaguepilot_field_manager.php
leaguepilot_financial_center.php
leaguepilot_gameday_ops.php
leaguepilot_generate_teams.php
leaguepilot_geo_heatmap.php
leaguepilot_geocode.php
leaguepilot_launch_center.php
leaguepilot_manual_roster_editor.php
leaguepilot_map_review.php
leaguepilot_master_hub.php
leaguepilot_master_hub_v3.php
leaguepilot_master_hub_v4.php
leaguepilot_media_command_center.php
leaguepilot_mobile_commissioner.php
leaguepilot_mvpeeps_schedule_sync.php
leaguepilot_mvpeeps_team_creator.php
leaguepilot_officials_center.php
leaguepilot_parent_command_center.php
leaguepilot_parent_portal.php
leaguepilot_player_import.php
leaguepilot_publish_center.php
leaguepilot_recruiting_war_room.php
leaguepilot_reset_demo.php
leaguepilot_schedule_builder.php
leaguepilot_schedule_builder_v1.php
leaguepilot_season_health_engine_v1.php
leaguepilot_sponsorship_center.php
leaguepilot_system_check.php
leaguepilot_system_check_v2.php
leaguepilot_tournament_engine.php
leaguepilot_upload_coaches.php
leaguepilot_upload_fields.php
leaguepilot_upload_players.php
leaguepilot_weather_center.php
''' Path('/mnt/data/leaguepilot_system_check_v2.php').write_text(code, encoding='utf-8') print('/mnt/data/leaguepilot_system_check_v2.php')