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

try {
    $pdo = new PDO("mysql:host=$host;dbname=$db;charset=utf8", $user, $pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    $sqlFile = __DIR__ . '/public_html/skycrestaviationacademy.com/install/database.sql';
    if (!file_exists($sqlFile)) {
        $sqlFile = __DIR__ . '/install/database.sql';
    }
    
    // Drop all tables first
    $pdo->exec('SET FOREIGN_KEY_CHECKS = 0');
    $tables = $pdo->query('SHOW TABLES')->fetchAll(PDO::FETCH_COLUMN);
    foreach ($tables as $table) {
        $pdo->exec("DROP TABLE `$table`");
    }
    $pdo->exec('SET FOREIGN_KEY_CHECKS = 1');

    $sql = file_get_contents($sqlFile);
    $pdo->exec($sql);
    echo "Database imported successfully using PDO!";
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}
unlink(__FILE__);
?>