Changeset 551 for trunk/rss.php

Timestamp:

Mar 29, 2009, 2:10:27 PM (16 years ago)

Author:

george

Message:

• Upraveno: Konfigurační soubor je nyní přehledněji config.php namísto db.php. Nutno si jej vytvořit zkopírováním ukázky config.sample.php a doplněním patřičných údajů.
• Přidáno: RSS kanál všech článků.
• Upraveno: Změna verze souboru z HTML 4 na XHTML 1.0. Nutno používat jen povolené tagy a provádět validaci.

File:

• trunk/rss.php (modified) (1 diff)

trunk/rss.php

@@ -1 @@
-<?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
-   } 
+header("Content-Type: text/xml");
+
+include('inc/db.php');
+include('inc/rss_generator.php');
+
+$NewsCount = 10;
+$Items = array();
+
+$DbResult = $db->query('SELECT UNIX_TIMESTAMP(date), articles.* FROM articles ORDER BY date DESC LIMIT '.$NewsCount);
+while($Row = $DbResult->fetch_array())
+{
+  $Items[] = array(
+    'Title' => $Row['title'],
+    'Link' => 'http://'.$_SERVER['SERVER_NAME'].$Config['Web']['BaseURL'],
+    'Description' => $Row['text']." (".$Row['autor'].")",
+    'Time' => $Row['UNIX_TIMESTAMP(date)'],
+  );
+}
+
+echo(GenerateRSS(array(
+  'Title' => $Config['Web']['Title'],
+  'Link' => $Config['Web']['BaseURL'],
+  'Description' => $Config['Web']['Description'],
+  'WebmasterEmail' => $Config['Web']['AdminEmail'],
+  'Items' => $Items), $Config['Web']['Charset']));
   
 ?>
- </channel>
-</rss>