Hi,

I need a perl script which will connect to my database and create
google sitemap.xmls and sitemapindex.xmls according to google rules.
https://www.google.com/webmasters/tools/docs/en/protocol.html

The script will pull the following data from two different tables:

select memberid from members
select pageid from pages

I've attached the sample sitemap.xml and sitemapindex.xml. They are very simple.

The only trick is, we need to make sure sitemap.xmls do not have more than 40,000 records. A record of each sitemap.xml needs to be put into sitemapindex.xml.


Thanks a lot!