FM / public

/home/u764571690/domains/cubecodex.com/public_html/

/home/u764571690/domains/cubecodex.com/public_html

Name	Size	Mode	Actions
admin/	-	0755	rm
api/	-	0755	rm
assets/	-	0755	rm
cache/	-	0755	rm
config/	-	0755	rm
handlers/	-	0755	rm
includes/	-	0755	rm
pages/	-	0755	rm
partials/	-	0755	rm
vendor/	-	0755	rm
.gitignore	137	0644	edit dl rm
.htaccess	7636	0644	edit dl rm
404.php	9461	0644	edit dl rm
index.php	5517	0644	edit dl rm
robots.txt	228	0644	edit dl rm
sitemap.php	3030	0644	edit dl rm

Edit: /home/u764571690/domains/cubecodex.com/public_html/sitemap.php (3030B)

<?php
/**
 * Dynamic XML Sitemap Generator
 */
header("Content-Type: application/xml; charset=utf-8");
require_once __DIR__ . '/config/db.php';
require_once __DIR__ . '/config/url_helper.php';

// Define the base URL - ensure it ends with /
$protocol = (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') ? "https" : "http";
$host = $_SERVER['HTTP_HOST'];
$baseUrl = $protocol . "://" . $host . "/";

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

// 1. Static Pages
$staticPages = [
    '', // Home
    'shop',
    'courses',
    'services',
    'internship',
    'about',
    'contact',
    'blogs',
    'privacy',
    'terms',
    'shipping-policy',
    'refund-policy'
];

foreach ($staticPages as $page) {
    echo '<url>';
    echo '<loc>' . $baseUrl . $page . '</loc>';
    echo '<lastmod>' . date('Y-m-d') . '</lastmod>';
    echo '<changefreq>weekly</changefreq>';
    echo '<priority>' . ($page === '' ? '1.0' : '0.8') . '</priority>';
    echo '</url>';
}

// 2. Blog Posts
try {
    $stmt = $pdo->query("SELECT slug, updated_at, created_at FROM blogs WHERE status = 'published' ORDER BY created_at DESC");
    while ($row = $stmt->fetch()) {
        $lastMod = !empty($row['updated_at']) ? date('Y-m-d', strtotime($row['updated_at'])) : date('Y-m-d', strtotime($row['created_at']));
        echo '<url>';
        echo '<loc>' . $baseUrl . 'blog-detail/' . htmlspecialchars($row['slug']) . '</loc>';
        echo '<lastmod>' . $lastMod . '</lastmod>';
        echo '<changefreq>monthly</changefreq>';
        echo '<priority>0.7</priority>';
        echo '</url>';
    }
} catch (Exception $e) { }

// 3. Products
try {
    $stmt = $pdo_cc->query("SELECT id, slug, created_at FROM products WHERE is_active = 1 AND approval_status = 'approved' ORDER BY created_at DESC");
    while ($row = $stmt->fetch()) {
        $slug = !empty($row['slug']) ? $row['slug'] : obfuscate_id($row['id']);
        $lastMod = date('Y-m-d', strtotime($row['created_at']));
        echo '<url>';
        echo '<loc>' . $baseUrl . 'product-detail/' . htmlspecialchars($slug) . '</loc>';
        echo '<lastmod>' . $lastMod . '</lastmod>';
        echo '<changefreq>monthly</changefreq>';
        echo '<priority>0.7</priority>';
        echo '</url>';
    }
} catch (Exception $e) { }

// 4. Courses
try {
    $stmt = $pdo_cc->query("SELECT id, slug, created_at FROM courses WHERE is_active = 1 AND approval_status = 'approved' ORDER BY created_at DESC");
    while ($row = $stmt->fetch()) {
        $slug = !empty($row['slug']) ? $row['slug'] : obfuscate_id($row['id']);
        $lastMod = date('Y-m-d', strtotime($row['created_at']));
        echo '<url>';
        echo '<loc>' . $baseUrl . 'course-player/' . htmlspecialchars($slug) . '</loc>';
        echo '<lastmod>' . $lastMod . '</lastmod>';
        echo '<changefreq>monthly</changefreq>';
        echo '<priority>0.6</priority>';
        echo '</url>';
    }
} catch (Exception $e) { }

echo '</urlset>';

'; echo ''; // 1. Static Pages $staticPages = [ '', // Home 'shop', 'courses', 'services', 'internship', 'about', 'contact', 'blogs', 'privacy', 'terms', 'shipping-policy', 'refund-policy' ]; foreach ($staticPages as $page) { echo ''; echo '' . $baseUrl . $page . ''; echo '' . date('Y-m-d') . ''; echo 'weekly'; echo '' . ($page === '' ? '1.0' : '0.8') . ''; echo ''; } // 2. Blog Posts try { $stmt = $pdo->query("SELECT slug, updated_at, created_at FROM blogs WHERE status = 'published' ORDER BY created_at DESC"); while ($row = $stmt->fetch()) { $lastMod = !empty($row['updated_at']) ? date('Y-m-d', strtotime($row['updated_at'])) : date('Y-m-d', strtotime($row['created_at'])); echo ''; echo '' . $baseUrl . 'blog-detail/' . htmlspecialchars($row['slug']) . ''; echo '' . $lastMod . ''; echo 'monthly'; echo '0.7'; echo ''; } } catch (Exception $e) { } // 3. Products try { $stmt = $pdo_cc->query("SELECT id, slug, created_at FROM products WHERE is_active = 1 AND approval_status = 'approved' ORDER BY created_at DESC"); while ($row = $stmt->fetch()) { $slug = !empty($row['slug']) ? $row['slug'] : obfuscate_id($row['id']); $lastMod = date('Y-m-d', strtotime($row['created_at'])); echo ''; echo '' . $baseUrl . 'product-detail/' . htmlspecialchars($slug) . ''; echo '' . $lastMod . ''; echo 'monthly'; echo '0.7'; echo ''; } } catch (Exception $e) { } // 4. Courses try { $stmt = $pdo_cc->query("SELECT id, slug, created_at FROM courses WHERE is_active = 1 AND approval_status = 'approved' ORDER BY created_at DESC"); while ($row = $stmt->fetch()) { $slug = !empty($row['slug']) ? $row['slug'] : obfuscate_id($row['id']); $lastMod = date('Y-m-d', strtotime($row['created_at'])); echo ''; echo '' . $baseUrl . 'course-player/' . htmlspecialchars($slug) . ''; echo '' . $lastMod . ''; echo 'monthly'; echo '0.6'; echo ''; } } catch (Exception $e) { } echo '';