<?php
$host = '162.55.65.66';
$db   = 'flightbo_game';
$user = 'flightbo_game';
$pass = 'flightbo_game';

$conn = mysqli_connect($host, $user, $pass, $db);
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

// SQL file is in public_html/skycrestaviationacademy.com/install/database.sql
$sqlFile = __DIR__ . '/public_html/skycrestaviationacademy.com/install/database.sql';
if (!file_exists($sqlFile)) {
    // Try alternate path
    $sqlFile = '/home2/flightbo/public_html/skycrestaviationacademy.com/install/database.sql';
}
if (!file_exists($sqlFile)) {
    die("SQL file not found. Tried: $sqlFile");
}

$sql = file_get_contents($sqlFile);
$queries = explode(';', $sql);
$success = 0;
$errors = [];

foreach ($queries as $query) {
    $query = trim($query);
    if (empty($query)) continue;
    if (mysqli_query($conn, $query)) {
        $success++;
    } else {
        $errors[] = mysqli_error($conn) . ' | ' . substr($query, 0, 60);
    }
}

echo "<h2>DB Import Result</h2>";
echo "<p style='color:green'>Done: $success queries OK.</p>";
if (!empty($errors)) {
    echo "<ul style='color:orange'>";
    foreach (array_slice($errors, 0, 10) as $e) {
        echo "<li>" . htmlspecialchars($e) . "</li>";
    }
    echo "</ul>";
} else {
    echo "<p style='color:green'><b>All good! Delete this file now.</b></p>";
}
mysqli_close($conn);
?>
