<?php
// DB Import Script - DELETE THIS FILE AFTER USE
$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());
}

$sqlFile = __DIR__ . '/install/database.sql';
if (!file_exists($sqlFile)) {
    die("SQL file not found at: $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) . ' | Query: ' . substr($query, 0, 80);
    }
}

echo "<h2>Database Import Result</h2>";
echo "<p style='color:green'>Success: $success queries executed.</p>";
if (!empty($errors)) {
    echo "<p style='color:orange'>Errors (" . count($errors) . "):</p><ul>";
    foreach ($errors as $e) {
        echo "<li>" . htmlspecialchars($e) . "</li>";
    }
    echo "</ul>";
} else {
    echo "<p style='color:green'><b>All queries executed without error!</b></p>";
}
mysqli_close($conn);
echo "<p style='color:red'><b>IMPORTANT: Delete this file immediately after use!</b></p>";
?>
