במ12[cvbnvbnvbnvbnnmnnmnmnnmnmnmnmnmnmmnnmnmnmqewv;'

]]jkjjgdjffksdkdxmnnnnnnnnnnnmnmmnmnmnmnmbnwqeqwewqskfgj במ12[cvbnvbnvbnvbnnmnnmnmnnmnmnmnmnmnmmnnmnmnmqewv;'

<?php
include_once 'Config.php'; // Ensure Config.php contains your $mysqli connection

// Query to fetch cities and their locations from the database
$sql = "SELECT city.city_slug, location.location_slug 
        FROM location 
        LEFT JOIN city ON location.city_id = city.city_id 
        ORDER BY location.location_id DESC";
$result = $mysqli->query($sql);

if (!$result) {
    die('Error: ' . $mysqli->error);
}

// Prepare an array to hold cities and their respective locations
$cities = [];

// Fetch cities and their locations and store them in an associative array
while ($row = $result->fetch_assoc()) {
    $citySlug = $row['city_slug'];
    $locationSlug = $row['location_slug'];
    
    if (!isset($cities[$citySlug])) {
        $cities[$citySlug] = [];
    }
    
    $cities[$citySlug][] = $locationSlug;
}

// Close MySQL connection
$mysqli->close();

// Start outputting the XML content
header('Content-type: application/xml');

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

// Last modification date (assuming all URLs have the same last modification date)
$lastMod = (new DateTime())->setTimezone(new DateTimeZone('Asia/Kolkata'))->format('Y-m-d\TH:i:sP');
  
   $home_url='https://www.cgnight.net/';
   $login_url='https://www.cgnight.net/login';
   $register_url='https://www.cgnight.net/register';

echo '<url>';
    echo '<loc>' . $home_url . '</loc>';
    echo '<lastmod>' . $lastMod . '</lastmod>';
    echo '<changefreq>daily</changefreq>';
    echo '<priority>1.0</priority>';
    echo '</url>';

echo '<url>';
    echo '<loc>' . $login_url . '</loc>';
    echo '<lastmod>' . $lastMod . '</lastmod>';
    echo '<changefreq>daily</changefreq>';
    echo '<priority>0.5</priority>';
    echo '</url>';

echo '<url>';
    echo '<loc>' . $register_url . '</loc>';
    echo '<lastmod>' . $lastMod . '</lastmod>';
    echo '<changefreq>daily</changefreq>';
    echo '<priority>0.5</priority>';
    echo '</url>';

// Loop through each city and its locations to generate sitemap URLs
foreach ($cities as $citySlug => $locations) {
    $cityUrl = 'https://www.cgnight.net/call-girls/' . htmlspecialchars($citySlug);

// Output <url> for city
    echo '<url>';
    echo '<loc>' . $cityUrl . '</loc>';
    echo '<lastmod>' . $lastMod . '</lastmod>';
    echo '<changefreq>daily</changefreq>';
    echo '<priority>0.9</priority>';
    echo '</url>';

// Loop through locations within the city
    foreach ($locations as $locationSlug) {
        $locationUrl = 'https://www.cgnight.net/call-girls/' . htmlspecialchars($citySlug) . '/' . htmlspecialchars($locationSlug);

// Output <url> for location
        echo '<url>';
        echo '<loc>' . $locationUrl . '</loc>';
        echo '<lastmod>' . $lastMod . '</lastmod>';
        echo '<changefreq>daily</changefreq>';
        echo '<priority>0.7</priority>';
        echo '</url>';
    }
}

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