' . "\n"; echo '' . "\n"; // 1. Homepage - Highest priority echo " \n"; echo " {$base_url}index.php\n"; echo " daily\n"; echo " 1.0\n"; echo " \n"; // 2. Static pages $static_pages = [ 'libinfo' => ['priority' => '0.8', 'changefreq' => 'monthly'], 'services' => ['priority' => '0.8', 'changefreq' => 'monthly'], 'memberarea' => ['priority' => '0.7', 'changefreq' => 'weekly'], 'contact' => ['priority' => '0.7', 'changefreq' => 'monthly'], ]; foreach ($static_pages as $page => $config) { echo " \n"; echo " {$base_url}index.php?p={$page}\n"; echo " {$config['changefreq']}\n"; echo " {$config['priority']}\n"; echo " \n"; } // 3. Bibliographic records (books/collections) // Only include published and not deleted items $biblio_query = "SELECT biblio_id, last_update FROM biblio WHERE opac_hide = 0 ORDER BY last_update DESC LIMIT 5000"; $result = $dbs->query($biblio_query); if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $biblio_id = $row['biblio_id']; $last_update = $row['last_update']; // Format date to W3C format (YYYY-MM-DD) $lastmod = date('Y-m-d', strtotime($last_update)); echo " \n"; echo " {$base_url}index.php?p=show_detail&id={$biblio_id}\n"; echo " {$lastmod}\n"; echo " monthly\n"; echo " 0.6\n"; echo " \n"; } } // 4. Popular subjects/topics $subject_query = "SELECT DISTINCT topic FROM mst_topic ORDER BY topic LIMIT 100"; $result = $dbs->query($subject_query); if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $topic = urlencode($row['topic']); echo " \n"; echo " {$base_url}index.php?search=Search&keywords={$topic}\n"; echo " weekly\n"; echo " 0.5\n"; echo " \n"; } } // 5. Authors (if you want to include author pages) $author_query = "SELECT DISTINCT author_name FROM mst_author ORDER BY author_name LIMIT 200"; $result = $dbs->query($author_query); if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $author = urlencode($row['author_name']); echo " \n"; echo " {$base_url}index.php?search=Search&keywords={$author}\n"; echo " monthly\n"; echo " 0.4\n"; echo " \n"; } } // Close XML echo ''; // Optional: Save to file for static serving // Uncomment below to save sitemap to file /* $xml_content = ob_get_contents(); file_put_contents(__DIR__ . '/sitemap.xml', $xml_content); */