source: newwww/news/rss.php@ 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');
DB_Query('SET CHARACTER SET latin2');

$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 .= ' OR (category='.($Part*1).')'; 
  }
}

// Get category names
$Categories = array();
DB_Select('news_category', '*');
while($Category = DB_Row())
{
  $Categories[$Category['id']] = $Category['caption'];
}

// Update news from discussion forum
$ForumCategory = 4;   
DB_Change('forum');
DB_Query('SELECT * FROM posts WHERE 1 ORDER BY post_time DESC LIMIT 0,'.$NewsCount);
$Index = 0;
//echo(DB_NumRows().',');
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;    
  
  $Title = $Row4['topic_title'].'-'.$Row['post_subject'];
  $Content = $Row['post_text'];
  $Date = date('Y-m-d H:i:s', $Row2['post_time']);
  $Author = $Row3['username'];
  DB_Change('is');
  //echo('category='.$ForumCategory.' AND title="'.addslashes($Title).'" AND content="'.addslashes($Content).'" AND author="'.addslashes($Author).'" AND date="'.$Date.'"');
  DB_Select('news', '*', 'category='.$ForumCategory.' AND title="'.addslashes($Title).'" AND content="'.addslashes($Content).'" AND author="'.addslashes($Author).'" AND date="'.$Date.'"');
  if(DB_NumRows() == 0) //echo('.'); else echo('x'); 
    DB_Insert('news', array('category' => $ForumCategory, 'title' => $Title, 'content' => $Content, 'author' => $Author, 'date' => $Date));
    //echo($Date);  
  DB_Change('forum');
  DB_Load();
}
DB_Change('is');

// Get news from database by selected categories
$UploadedFilesFolder = 'uploads/';
DB_Query('SELECT enclosure,category,title,content,UNIX_TIMESTAMP(date),author FROM news WHERE 1'.$Where.' ORDER BY date DESC LIMIT 0,'.$NewsCount);
while($Row = DB_Row())
{
  $EnclosuresText = '';
  if($Row['enclosure'] != '')
  { 
    $EnclosuresText .= '<br>Pøílohy: ';
    $Enclosures = explode(';', $Row['enclosure']);
    foreach($Enclosures as $Enclosure)
    {
      if(file_exists($UploadedFilesFolder.$Enclosure)) $EnclosuresText .= ' <a href="http://centrala.zdechov.net/aktuality/'.$UploadedFilesFolder.$Enclosure.'">'.$Enclosure.'</a>';
    }
  }
  $Items[] = array(
    'Title' => $Categories[$Row['category']].' - '.$Row['title'],
    'Link' => 'http://centrala.zdechov.net/aktuality/index.php?category='.$Row['category'],
    'Description' => $Row['content']." (".$Row['author'].")".$EnclosuresText,
    'Time' => $Row['UNIX_TIMESTAMP(date)'],
  );
}

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