source: newwww/news/rss_1@ 3

<?

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

include_once('../global.php');
include_once('rss_generator.php');
include_once('../is/db.php');
DB_Init('localhost','root','','is');

$NewsCount = 15;

$Items = array();
$Category = '';
$CategoryOption = '';
$CategoryOptionURL = '';
$CategoryName = '';

// Prepare WHERE condition 
$Where = '';
if(array_key_exists('select', $_GET)) 
{
  $Parts = explode('-', addslashes($_GET['select']));
  foreach($Parts as $Part)
  {
    $Where .= ' AND (category='.($Part*1).')'; 
  }
  $CategoryOption = 'WHERE category='.$Category.' ';
  $CategoryOptionURL = '?category='.$Category;
  $CategoryName = $NewsCategoryNames[$Category];
}

// Get category names
$CategoryName = '';
DB_Select('news_category', '*', '1'.$Where);
while($Category = DB_Row())
{
  $CategoryName .= ','.$Category['caption']; 
}
$CategoryName = substr($CategoryName, 1);

// Update news from discussion forum
$ForumCategory = 4;   
DB_Init('localhost', 'root', '', 'forum');
DB_Query('SELECT * FROM posts WHERE 1 ORDER BY post_time DESC LIMIT 0,'.$NewsCount);
$Index = 0;
while($Row2  = DB_Row())
{
  DB_Save();
  DB_Query('SELECT * FROM posts_text WHERE post_id='.$Row2['post_id']);
  $Row = DB_Row();
  $Row['post_text'] = StrTr($Row['post_text'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
  $Row['post_text'] = str_replace("\n","<br>", $Row['post_text']); 
  $Row['post_subject'] = StrTr($Row['post_subject'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
  DB_Query('SELECT * FROM users WHERE user_id='.$Row2['poster_id']);
  $Row3 = DB_Row();
  DB_Query('SELECT * FROM topics WHERE topic_id='.$Row2['topic_id']);
  $Row4 = DB_Row();
  $Row4['topic_title'] = StrTr($Row4['topic_title'], "\x8A\x8D\x8E\x9A\x9D\x9E", "\xA9\xAB\xAE\xB9\xBB\xBE"); 
  $Index = $Index + 1;    
  DB_Load();
  
  $Title = $Row4['topic_title'].'-'.$Row['post_subject'];
  $Content = Row['post_text'];
  $Date = $Row2['post_time'];
  DB_Select('news', '*', 'WHERE category='.$ForumCategory.' AND title="'.$Title.'" AND content="'.$Content.'" AND author="'.$Author.'" AND date="'.$Date.'"');
  if(DB_NumRows() == 0) DB_Insert('news', array('category' => $ForumCategory, 'title' => $Title, 'content' => $Content, 'date' => );  
}
DB_Init('localhost', 'root', '', 'is');

// Get news from database by selected categories
DB_Query('SELECT title,content,UNIX_TIMESTAMP(date),author FROM news WHERE 1'.$Where.' ORDER BY id DESC LIMIT 0,'.$NewsCount);
while($Row = DB_Row())
{
  $Items[] = array(
    'Title' => $Row['title'],
    'Link' => 'http://centrala.zdechov.net/aktuality/index.php',
    'Description' => $Row['content']." (".$Row['author'].")",
    'Time' => $Row['UNIX_TIMESTAMP(date)'],
  );
}

echo(GenerateRSS(array(
  'Title' => 'Aktuality ZdìchovNET: '.$CategoryName,
  'Link' => 'http://centrala.zdechov.net/',
  'Description' => 'Aktuality komunitní poèítaèové sítì ZdìchovNET',
  'WebmasterEmail' => 'robie@centrum.cz',
  'Items' => $Items)));
?>