I have been playing around with the sitemap plugin from: http://www.dagondesign.com/articles/sitemap-generator-plugin-for-wordpress/
but I had some problems with it as it treated my pages just like posts. So one of my friends modified tho code. I have included below my comment on the authors site:
hello alleister,
like I told you in previous comments here I was trying to get your plugin to work with wpmu. As it did not work, due to some differences in the table structure I asked a friend to change it for me.
Here are the differences as I have found out (no guarantee though):
wp: if post_status = static => it is a page
wpmu: if post_status = published THEN check if post_type = page or post to find out if its a page or a post.
The relevant data that had to be changed was this:
$items = $wpdb->get_results("
SELECT post_title, ID, post_parent, post_name
FROM {$table_prefix}posts, {$table_prefix}post2cat, {$table_prefix}categories
WHERE post_parent = '$id'
AND post_status = 'publish'
AND post_type ='page'
AND ID = {$table_prefix}post2cat.post_id
AND {$table_prefix}post2cat.category_id = {$table_prefix}categories.cat_ID
AND post_date < NOW()
AND post_status != 'draft' AND post_status != 'attachment'
$extra_checks
ORDER BY {$ddsg_page_sort_order}, cat_name
");
I hope my code doesn't lose its formatiing.
P.S. the changes were done by adrian.ceapa@zice.ro and I hope it works out for all of you using wpmu
