I'm happy to write my own but if there's a really nice PHP script out there that i can just run on a cron and exclude directories then i'd love to hear about it!
I'd prefer to use a scraper/crawler type script than write the XML from the database....
wget
for this kind of thing, but you'll need to massage your result from that somewhat. Here a guy seems to use it: ardoino.com/15-google-php-wget-sitemap-generator Can't vouch for the PHP code, but you get the general idea. – Alaniz