' . "\n"; echo '' . "\n"; // Static pages $static = ['', 'jobs.php', 'companies.php', 'categories.php', 'pricing.php', 'contact.php', 'faq.php', 'page.php?slug=about', 'page.php?slug=contact', 'page.php?slug=privacy-policy', 'page.php?slug=terms']; foreach ($static as $s) { echo " " . APP_URL . '/' . $s . "weekly\n"; } // Jobs $pdo = db(); $jobs = $pdo->query("SELECT slug, updated_at FROM jobs WHERE status='active' ORDER BY created_at DESC LIMIT 1000")->fetchAll(); foreach ($jobs as $j) { echo " " . APP_URL . "/job.php?slug=" . htmlspecialchars($j['slug']) . "" . date('Y-m-d', strtotime($j['updated_at'])) . "daily\n"; } // Companies $companies = $pdo->query("SELECT slug, updated_at FROM companies WHERE status='active' ORDER BY created_at DESC LIMIT 1000")->fetchAll(); foreach ($companies as $c) { echo " " . APP_URL . "/company-profile.php?slug=" . htmlspecialchars($c['slug']) . "" . date('Y-m-d', strtotime($c['updated_at'])) . "weekly\n"; } // Categories $cats = $pdo->query("SELECT slug FROM categories WHERE status = 1")->fetchAll(); foreach ($cats as $cat) { echo " " . APP_URL . "/jobs.php?category=" . htmlspecialchars($cat['slug']) . "daily\n"; } echo '';