0UT1S's

// Start the XML document
echo '<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" 
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
        xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">';

// Include the configuration file
require_once("includes/config.php");

// Query to fetch all games sorted by ID in descending order
$game_query = "SELECT * FROM zon_games ORDER BY id DESC";
$run = mysqli_query($con, $game_query);

// Generate URLs for each game
while ($row = mysqli_fetch_assoc($run)) {
    $text = $row['game_name'];
    $slug = strtolower($text); // Convert to lowercase
    $slug = str_replace('&', '-', $slug); // Replace '&' with '-'
    $slug = str_replace(' ', '-', $slug); // Replace spaces with '-'
    $slug = htmlspecialchars($slug, ENT_QUOTES, 'UTF-8'); // Sanitize for XML
    
    // Output the URL for the game
    echo '<url>
          <loc>' . $site_url . 'single/' . $row['id'] . '/' . $slug . '</loc>
          </url>';
}

// Close the XML document
echo '</urlset>';
?>