<?php
Header("Content-Type: text/xml");

include_once('../global.php');
include_once('rss_generator.php');

// Get news from database by selected categories
$Items = array();
$Database->select_db($Config['Mangos']['DatabaseCharacters']);
$DbResult = $Database->query("SELECT `character_ticket`.`ticket_text` AS `text`, `characters`.`name` AS `name` FROM `character_ticket` JOIN `characters` ON `characters`.`guid` = `character_ticket`.`guid`");
while($Row = $DbResult->fetch_array())
{
  $Items[] = array(
    'Title' => $Row['name'].': '.$Row['text'],
    'Link' => '',
    'Description' => $Row['name'].': '.$Row['text'],
    'Time' => 0,
  );
}

echo(GenerateRSS(array(
  'Title' => 'WoW GM žádanky',
  'Link' => 'http://wow.zdechov.net/administrace/',
  'Description' => 'Požadavky hráčů na GM',
  'WebmasterEmail' => 'wow@zdechov.net',
  'Items' => $Items)));
?>