connect_error) { die("Connection failed: " . $mysqli->connect_error); } else { $db = $mysqli; } } elseif ($database === 'sqlite') { $db_path = 'db/ddd_db.sqlite'; if (file_exists($db_path)) { try { $db = new SQLite3($db_path); } catch (Exception $e) { die("Failed to open the SQLite database: " . $e->getMessage()); } } else { die("Database file does not exist: " . $db_path); } } else { die("Unsupported database type specified in config.cfg"); } } else { die("Database configuration not found in config.cfg"); } // Get mode from request $mode = $_REQUEST['mode'] ?? 'DX'; // Construct query based on mode if ($mode == "DX") { echo "Top 100 DX Mode"; $query = "SELECT * FROM scores WHERE Mode = 'DX' ORDER BY Score DESC LIMIT 100"; } elseif ($mode == "EX") { echo "Top 100 EX Mode"; $query = "SELECT * FROM scores WHERE Mode = 'EX' ORDER BY Score DESC LIMIT 100"; } else { die("Invalid mode specified"); } // Execute query and fetch results $result = null; if ($db instanceof SQLite3) { $result = $db->query($query); } elseif ($db instanceof mysqli) { $result = $db->query($query); } if ($result) { $counter = 1; echo "
    "; while ($row = ($db instanceof SQLite3) ? $result->fetchArray(SQLITE3_ASSOC) : $result->fetch_assoc()) { $output = "" . $counter . " " . $row["Name"] . "" . "   " . "" . number_format($row["Score"]) . ""; // Retrieve the boss names and split them into an array $bosses = explode(",", $row["Bosses"]); echo "
  1. "; echo "
    "; echo $output; echo "
    "; if (!empty($bosses)) { echo "
    "; // Display an image for each boss name foreach ($bosses as $boss) { $bossImage = trim(strtolower($boss)) . ".png"; if ($bossImage != ".png") { echo "
    "; echo "" . $boss . ""; echo "
    " . $boss . "
    "; echo "
    "; } } echo "
    "; } echo "
    2. "; $counter++; } echo "
"; } else { echo "
0 results"; } // Close database connection if ($db instanceof SQLite3) { $db->close(); } elseif ($db instanceof mysqli) { $db->close(); } ?>
Back