Db'den veri çekerek sitemap nasıl hazırlanır?

<?php

function make_url_friendly($url)
{
    $url = trim($url);
    $url = strtolower($url);

    $find = array('<b>', '</b>');
    $url = str_replace ($find, '', $url);

    $url = preg_replace('/<(\/{0,1})img(.*?)(\/{0,1})\>/', 'image', $url);

    $find = array(' ', '"', '&', '&', '\r\n', '\n', '/', '\\', '+', '<', '>');
    $url = str_replace ($find, '-', $url);

    $find = array('é', 'è', 'ë', 'ê', 'É', 'È', 'Ë', 'Ê');
    $url = str_replace ($find, 'e', $url);

    $find = array('í', 'ı', 'ì', 'î', 'ï', 'I', 'İ', 'Í', 'Ì', 'Î', 'Ï');
    $url = str_replace ($find, 'i', $url);

    $find = array('ó', 'ö', 'Ö', 'ò', 'ô', 'Ó', 'Ò', 'Ô');
    $url = str_replace ($find, 'o', $url);

    $find = array('á', 'ä', 'â', 'à', 'â', 'Ä', 'Â', 'Á', 'À', 'Â');
    $url = str_replace ($find, 'a', $url);

    $find = array('ú', 'ü', 'Ü', 'ù', 'û', 'Ú', 'Ù', 'Û');
    $url = str_replace ($find, 'u', $url);

    $find = array('ç', 'Ç');
    $url = str_replace ($find, 'c', $url);

    $find = array('ş', 'Ş');
    $url = str_replace ($find, 's', $url);

    $find = array('ğ', 'Ğ');
    $url = str_replace ($find, 'g', $url);

    $find = array('/[^a-z0-9\-<>]/', '/[\-]+/', '/<[^>]*>/');

    $repl = array('', '-', '');

    $url = preg_replace ($find, $repl, $url);
    $url = str_replace ('--', '-', $url);

    return $url;
}

?>

<?
include "ayar.inc.php";
include "seo.inc.php";
?>
<?
$xml_ciktisi="<?xml version=\"1.0\" encoding=\"windows-1254\"?><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\">\n";
$isimx=mysql_query("SELECT * FROM icerik where onay='e' ORDER BY id DESC");;
while($link = mysql_fetch_array($isimx))
{
$url = "http://www.site.com/".ucwords(strtolower(make_url_friendly($link['baslik'])))."";
$tarih = date("Y-m-d");
$xml_ciktisi .= "<url>
                          <loc>$url</loc>
                          <lastmod>$tarih</lastmod>
							  <changefreq>daily</changefreq>
							  <priority>0.5</priority>
							  </url>\n";
};

$xml_ciktisi .= "</urlset>\n";
echo $xml_ciktisi;		
?>

<?
include "ayar.inc.php";
include "seo.inc.php";
?>
<?
$xml_ciktisi="<?xml version=\"1.0\" encoding=\"windows-1254\"?><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\">\n";
$isimx=mysql_query("SELECT * FROM icerik where onay='e' ORDER BY id DESC");;
while($link = mysql_fetch_array($isimx))
{
$url = "http://www.site.com/".ucwords(strtolower(make_url_friendly($link['baslik'])))."";
$tarih = date("Y-m-d");
$xml_ciktisi .= "<url>
                          <loc>$url</loc>
                          <lastmod>$tarih</lastmod>
							  <changefreq>daily</changefreq>
							  <priority>0.5</priority>
							  </url>\n";
};

$xml_ciktisi .= "</urlset>\n";
	
?>

<?

$raw = $xml_ciktisi;
$handle = fopen("sitemap.xml", "w");
fwrite($handle, $raw);

?>

<?php
include ("ayar.php");

function cevir($sihirliperi) {
$tr = array('ş','Ş','ı','İ','ğ','Ğ','ü','Ü','ö','Ö','Ç','ç');
$eng = array('s','S','i','I','g','G','u','U','o','O','C','c');
$sihirliperi = str_replace($tr,$eng,$sihirliperi);
$sihirliperi = eregi_replace('[^0-9A-Za-z]',"_",$sihirliperi);
$sihirliperi = str_replace('__','_',$sihirliperi);
return $sihirliperi;
}

echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>\n";
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\">";

$sorgu = mysql_query("SELECT id,konu FROM makale WHERE yayin='YAYINDA' AND onay='onaylandi'");
while ($cek = mysql_fetch_array($sorgu)) {
$id = $cek[id];
$konu = $cek[konu];
$seomakale = cevir($konu);
echo "\n<url>\n<loc>http://www.sihirliperi.net/$cek[id]-$seomakale.htm</loc>\n<changefreq>daily</changefreq>\n<priority>0.5</priority>\n</url>";
}

echo "\n</urlset>";
?>

                              <changefreq>daily</changefreq>
                              <priority>0.5</priority>