Форум программистов [Powered by Invision Power Board]

Код

<?php
include("includes/db.php");
header ("Content-type: text/xml");
echo ('<?xml version="1.0" encoding="windows-1251"?>');
?>

<!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN"
                    "http://my.netscape.com/publish/formats/rss-0.91.dtd">

<rss version="0.91">
<channel>
       <title>IT Light</title>
       <description>IT Новини</description>
       <link>http://www.it-light.net/rss.php</link>
       <language>bg</language>
       <copyright>Copyright 2006, Максим Крижановски</copyright>
       <managingEditor>[email protected]</managingEditor>
       <webMaster>[email protected]</webMaster>


<?php
OpenDBConnection();
$sql = "select * from itl_news where visible=1 order by id desc limit 0,20";
$result = DBQuery($sql);

while ($row = @mysql_fetch_array ($result)) {
   if (strlen($row['text']) > 200) {
       $data = substr($row['text'], 0, 200);
       $data .= "...";
} else {
    $data = $row['text'];
}
$data = stripslashes($data);
$bad_symbols = array("<",">","&");
$good_symbols = array("&lt;","&gt;","&amp;");
$ugly_symbols = array("[url=","[img]","[/img]","<center>","</center>","[b]","[/b]","[","]");
$data = str_replace ($ugly_symbols, "", $data);
$categories = Array("", "IT новини: ", "Софтуер: ", "Хардуер: ", "Игри: ", "Хумор: ");
$title = $categories[$row['category_id']].$row['caption'];
$title = str_replace($bad_symbols, $good_symbols, $title);
$desc = str_replace($bad_symbols, $good_symbols, $data);

   echo ("<item>\n\t<title>");
   echo $title;
   echo ("</title>\n");
   echo ("\t<description>\n");
   echo $desc;
   echo (")\n");
   echo ("</description>\n");
   echo ("\t<link>http://www.it-light.net/index.php?category=");
   echo $row[category_id];
   echo ("&amp;id=");
   echo $row[id];
   echo ("</link>\n</item>\n\n");
}
closeDBConnection();
?>
<skipHours>
<hour>1</hour>
</skipHours>
</channel>
</rss>