RSS

<?php
   $select = dbquery("SELECT n.*, us.user_name, us.user_email
                       FROM ".$prefix."news as n 
                       LEFT JOIN ".$prefix."users as us
                         ON n.author=us.user_id 
                       WHERE zobrazovat_od <= '".time()."' 
                         AND (zobrazovat_do >= '".time()."' OR zobrazovat_do = '0') 
                         AND visible<='".$userdata['user_level']."' 
                       ORDER BY permanent DESC, zobrazovat_od DESC, datestamp DESC
                       LIMIT 0,1");

header("Content-Type: text/xml");

echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
?>
<rss version="2.0">
  <channel>
    <?php
      echo "<title>".unescape($site_settings['nazov'])." - ".$RSS_PLUGIN_INFO['nazov']."</title>";
      echo "<link>".INDEX."news/</link>";
      echo "<description>".$RSS_PLUGIN_INFO['popis']."</description>";
      echo "<language>cs</language>";
      echo "<copyright>".unescape($site_settings['nazov'])."</copyright>";

      while($array = dbarray($select)) {
          echo "<item>";
              echo "<title>".unescape($array['title'])."</title>";
              echo "<link>".INDEX."news/".$array['news_id']."-".plain(unescape($array['title']), "-")."/</link>";
              echo "<description>".strip_tags(unescape($array['snippet']))."</description>";
              echo "<author>".$array['user_email']." (".$array['user_name'].")</author>";
              // kategorie
              if ($array['cats'] != 0) {
              	  $cats_where = preg_replace("/,/", "' OR cat_id='", $array['cats']);
              	  $sel_cats = dbquery("SELECT * FROM ".$prefix."news_cats WHERE cat_id='$cats_where'");
              	  while($cats_arr = dbarray($sel_cats)) {
                      echo "<category>".unescape($cats_arr['cat_name'])."</category>";
                  }
              }
              //
              echo "<pubDate>".date("r", $array['datestamp'])."</pubDate>";
          echo "</item>";
      }
    ?>
  </channel>
</rss>