source: branches/beta/rss.php@ 477

<?php
  header('Content-Type: text/xml; charset=utf-8');
  header('Expires: ' . date('D, d M Y H:i:s') . '  GMT');
  header('Last-Modified: ' .date('D, d M Y H:i:s') . '  GMT');
  
 
 include_once("./inc/db.php");

?>
<<?php ?>?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
  <channel>
    <title>HoF Ticket RSS</title>
    <link>http://wow.zdechov.net/</link>
    <description>HoF Ticket RSS</description>
    <language>cs</language>
    <lastBuildDate><?php echo date("j/m/Y H:i:s").""; ?></lastBuildDate>
    <atom:link href="http://www.samuraj-cz.com/rss/" rel="self" type="application/rss+xml" />
 
<?php

  mysql_connect("$db_server", "$db_user", "$db_pass");
  mysql_select_db($db_characters);
  mysql_query("SET NAMES 'utf8'");
   $result = mysql_query("SELECT * FROM character_ticket ORDER BY ticket_lastchange DESC, ticket_id DESC LIMIT 20 ");
    while($rec = mysql_fetch_array($result)) {
        $guid = $rec["guid"];
        $time = $rec["ticket_lastchange"];
    $human_date = date("d.m.Y  H:i", strtotime($time)); 
        $result2 = mysql_query("SELECT name FROM characters where guid='$guid' ");
        while($rec2 = mysql_fetch_array($result2)) {
        $name = $rec2["name"];
        }
        ?>
    <item>
        
     <title><?php echo "<br><b>$name</b></br>"; ?> sss</title>
         <pubDate><?php echo"$human_date";?></pubDate>
         <link>http://wow.zdechov.net/beta</link>
         <description><?php echo "<br>".htmlspecialchars(strip_tags($rec[ticket_text]))." </br>"; ?></description>
     
         
    </item>
<?php
   } 
  
?>
 </channel>
</rss>