Sitenize RSS & Sitemap Ekleyin

<? echo '<?xml version="1.0" encoding="utf-8"?>'; ?>
<? echo '<?xml-stylesheet href="rss.xsl" type="text/xsl"?>'."\n"; ?>
<rss version="2.0">
    <channel>
        <title>Yeni Programlar - Siteadı</title>
        <description>Siteadı yeni programlar rss servisi.</description>
        <link>http://www.siteadi.com/</link>
        <language>tr-TR</language>
        <ttl>3</ttl>
<?
    // iyinet.com - fan
    include("inc/config.inc.php");
    @sqlconnect();
    $sql = mysql_query("select id,adi,aciklama from program limit 10");
    while($veri    = @mysql_fetch_array($sql)) {
?>        
        <item>
            <title><?=$veri['adi']?></title>
            <link>http://www.siteadi.com/<?=seo($veri['adi'])?>-<?=$veri['id']?>.html</link>
            <description><?=substr($veri['aciklama'],0,255)?>...</description>
        </item>
<?
    }
    @sqlclose();
?>        
    </channel>
</rss>

<?
    // iyinet.com - fan
    include("inc/config.inc.php");
    @sqlconnect();
        echo '<?xml version="1.0" encoding="UTF-8"?>'."\n";
        echo '<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">'."\n";
            $sql = mysql_query("select id,adi from program");
            while($veri    = @mysql_fetch_array($sql)) {
                echo "\t".'<url>'."\n\t\t";
                    echo '<loc>http://www.xxxxx.com/'.seo($veri['adi']).'-'.$veri['id'].'.html</loc>'."\n\t\t";
                    echo '<changefreq>monthly</changefreq>'."\n\t\t";
                    echo '<priority>0.2</priority>'."\n\t";
                echo "".'</url>'."\n";
            }
        echo '</urlset>';
    @sqlclose();
?>

    function sqlconnect() {
        $sqlserver = "localhost";
        $sqladmin = "root";
        $sqlpassword = "";
        $sqldatabase = "down";
        @mysql_connect($sqlserver,$sqladmin,$sqlpassword) or die("Not Available");
        @mysql_select_db($sqldatabase);
    }
    
    function sqlclose() {
        @mysql_close();
    }  

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

        for($i=0;$i <= 5;$i++) {
            $z = str_replace("--","-",$z);
        }
        return strtolower($z);
    }