Question:
How can I make a sitemap for my wiki?
Answer:
{assign_variable:wiki_path="http://www.example.com/index.php/wiki/"}
{exp:query sql="SELECT r.*,
p.page_namespace, p.page_name AS topic,
n.namespace_label AS namespace
FROM exp_wiki_revisions r, exp_wiki_page p, exp_wiki_namespaces n
WHERE p.last_updated = r.revision_date
AND n.namespace_name = p.page_namespace
AND r.page_id = p.page_id
AND r.revision_status = 'open'
AND r.wiki_id = 1
ORDER BY p.page_name"}
<url><loc>{wiki_path}{namespace}:{topic}</loc>
<lastmod>{current_time format="{DATE_W3C}"}</lastmod>
<changefreq>weekly</changefreq>
<priority>0.6</priority>
</url>
{/exp:query}
{exp:query sql="SELECT r.*,
p.page_namespace, p.page_name AS topic
FROM exp_wiki_revisions r, exp_wiki_page p
WHERE p.last_updated = r.revision_date
AND p.page_namespace = ''
AND r.page_id = p.page_id
AND r.revision_status = 'open'
AND r.wiki_id = 1
ORDER BY p.page_name"}
<url><loc>{wiki_path}{topic}</loc>
<lastmod>{current_time format="{DATE_W3C}"}</lastmod>
<changefreq>weekly</changefreq>
<priority>0.6</priority>
</url>
{/exp:query}
{exp:query sql="SELECT r.*,
p.page_namespace, p.page_name AS topic
FROM exp_wiki_revisions r, exp_wiki_page p
WHERE p.last_updated = r.revision_date
AND p.page_namespace = 'category'
AND r.page_id = p.page_id
AND r.revision_status = 'open'
AND r.wiki_id = 1
ORDER BY p.page_name"}
<url><loc>{wiki_path}Category:{topic}</loc>
<lastmod>{current_time format="{DATE_W3C}"}</lastmod>
<changefreq>weekly</changefreq>
<priority>0.6</priority>
</url>
{/exp:query}
Category:SEO Category:Templates
