Installing Schema & Seed Data...
';
// Read and execute SQL
$sql_file = __DIR__ . '/database.sql';
if (!file_exists($sql_file)) { $sql_file = __DIR__ . '/cricket-exchange/database.sql'; }
if (!file_exists($sql_file)) { $sql_file = __DIR__ . '/../cricket-exchange/database.sql'; }
$sql = file_exists($sql_file) ? file_get_contents($sql_file) : '';
// Strip comments
$clean_sql = preg_replace('/--[^\n]*\n/', "\n", $sql);
$clean_sql = preg_replace('/\/\*.*?\*\//s', '', $clean_sql);
$statements = array_filter(array_map('trim', explode(';', $clean_sql)));
$success_count = 0; $error_count = 0;
foreach ($statements as $stmt) {
if (empty($stmt)) continue;
if ($conn->query($stmt)) {
$success_count++;
} else {
if ($conn->errno !== 1062 && $conn->errno !== 1060) {
echo '
⚠️ ' . htmlspecialchars($conn->error) . '
';
$error_count++;
}
}
}
echo "
✅ Database setup completed successfully! ($success_count operations executed)
";
echo '
View All Accounts & Credentials';
echo '