Sitemap in PHP generat dinamic

Am tot cautat o solutie facuta, insa se pare ca nu e multa lume interesata de subiect. Lucrez acum la un site care are peste 200.000 pagini si care va avea in jur de 40 de sitemaps. Cum fac generararea? Iata codul mai jos:

<?php
//include baza de date
$db=mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbdatabase);

$mainPages = array(
“http://www.domeniu.ro/”,
“http://www.domeniu.ro/topuseri/”,
“http://www.domeniu.ro/toparticole/”);

//declara header si insceput sitemap
header (‘Content-type: text/xml’);
echo ‘<?xml version=”1.0″ encoding=”ISO-8859-1″ ?>’;
echo ‘<urlset xmlns=”http://www.google.com/schemas/sitemap/0.84″ xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xsi:schemaLocation=”http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd”>’;

for($i=0; $i<count($mainPages); $i++){
echo ‘<url>
<loc>’. $mainPages[$i] .’</loc>
<changefreq>daily</changefreq>
<priority>1.0</priority>
</url>’;
}

//genereaza categoriile
$map_result = mysql_query(“SELECT id FROM categorii”);
while ($map_row = mysql_fetch_array($map_result)) {
$category = “http://www.domeniu.ro/categorie/” . $map_row['id'] . “/”;

echo ”
<url>
<loc>”. $category  .”</loc>
<changefreq>weekly</changefreq>
<priority>1.0</priority>
</url>”;
}

//genereaza elementele
$map_result = mysql_query(“SELECT id FROM articole WHERE aprobat = 1″);
while ($map_row = mysql_fetch_array($map_result)) {
echo ‘
<url>
<loc>http://www.domeniu.ro/articol/’. $map_row['id'] .’/</loc>
<changefreq>weekly</changefreq>
<priority>1.0</priority>
</url>’;
}

//inchide sitemapul
echo ‘
</urlset>’;

?>