if (file_exists('./google_sitemap.xsl')) { echo '<?xml-stylesheet type="text/xsl" href="google_sitemap.xsl"?>' . PHP_EOL; } echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">'; } // Get public WB pages // ******************* // Get all pages from db except of the module menu_link $sql = "SELECT p.`link`, p.`modified_when`, p.`parent`, p.`position`, s.`section_id`, s.`module`\r\n\t\tFROM `" . TABLE_PREFIX . "pages` p\r\n\t\tJOIN `" . TABLE_PREFIX . "sections` s\r\n\t\tON p.`page_id` = s.`page_id`\r\n\t\tWHERE (p.`visibility` = 'public')\r\n\t\t\tAND s.`module` != 'menu_link'\r\n\t\t\tAND (s.`publ_start` = '0' OR s.`publ_start` <= {$ts})\r\n\t\t\tAND (s.`publ_end` = '0' OR s.`publ_end` >= {$ts})\r\n\t\tORDER BY p.`parent`, p.`position` ASC"; $result = $database->query($sql); // Loop through the pages if ($result && $result->numRows() > 0) { while ($page = $result->fetchRow()) { $checked = check_link($page['link'], $exclude); if ($checked === true) { $link = htmlspecialchars($wb->page_link($page['link'])); $lastmod = gmdate("Y-m-d", $page['modified_when'] + TIMEZONE); $freq = $page_frequency; $pri = $page_priority; if ($page['parent'] == 0) { if ($page['position'] == 1) { $pri = $page_home_priority; // Should be the homepage $link = WB_URL . '/'; } else { $pri = $page_root_priority; // Root level pages } } output_xml($link, $lastmod, $freq, $pri); $counter++;