Menu
▾
▴
[QuotersChoice-svn] SF.net SVN: quoterschoice:[97] trunk
|
From: <au...@us...> - 2008-12-18 19:49:32
|
Revision: 97
http://quoterschoice.svn.sourceforge.net/quoterschoice/?rev=97&view=rev
Author: auron_x
Date: 2008-12-18 19:49:28 +0000 (Thu, 18 Dec 2008)
Log Message:
-----------
- added feed for latest quotes
* please test with some different aggregators before releasing
(currently only tested on Opera 9.62)
Modified Paths:
--------------
trunk/allquotes.php
trunk/index.php
Added Paths:
-----------
trunk/quotefeed.php
Modified: trunk/allquotes.php
===================================================================
--- trunk/allquotes.php 2008-12-18 12:42:28 UTC (rev 96)
+++ trunk/allquotes.php 2008-12-18 19:49:28 UTC (rev 97)
@@ -8,6 +8,7 @@
<head>
<title>Zitate lesen</title>
<link rel="stylesheet" type="text/css" href="themes/modern.css" media="screen" />
+ <link rel="alternate" type="application/rss+xml" title="RSS" href="./quotefeed.php" />
<meta http-equiv="Content-Type" content="application/xhtml+xml;charset=utf-8" />
<script src="vote.js" type="text/javascript"></script>
</head>
Modified: trunk/index.php
===================================================================
--- trunk/index.php 2008-12-18 12:42:28 UTC (rev 96)
+++ trunk/index.php 2008-12-18 19:49:28 UTC (rev 97)
@@ -9,6 +9,7 @@
<title>HPI Zitate</title>
<meta http-equiv="Content-Type" content="application/xhtml+xml;charset=utf-8" />
<link rel="stylesheet" type="text/css" href="themes/modern.css" media="screen" />
+ <link rel="alternate" type="application/rss+xml" title="RSS" href="./quotefeed.php" />
</head>
<body>
<?php
Added: trunk/quotefeed.php
===================================================================
--- trunk/quotefeed.php (rev 0)
+++ trunk/quotefeed.php 2008-12-18 19:49:28 UTC (rev 97)
@@ -0,0 +1,30 @@
+<?php
+ include("./dbfunctions.inc.php");
+ $rooturl = $_SERVER['SERVER_NAME'].substr($_SERVER['PHP_SELF'],0,strrpos($_SERVER['PHP_SELF'],'/')+1);
+?>
+<?xml version="1.0" encoding="UTF-8"?>
+<rss version="2.0">
+ <channel>
+ <title>QuotersChoice - RSS Feed</title>
+ <link><?php echo $rooturl; ?></link>
+ <description>Latest Quotes from QuotersChoice.</description>
+ <language>de-de</language>
+ <docs>http://www.rssboard.org/rss-specification</docs>
+ <generator>QuotersChoice - RSS-Script</generator>
+<?php
+ startsql();
+ $sql = "SELECT id,date,quote FROM quotes ORDER BY id DESC LIMIT 50";
+ $result = mysql_query($sql);
+ while($row = mysql_fetch_assoc($result)) {
+
+ ?>
+ <item>
+ <title>neues Quote - QuotersChoice</title>
+ <link><?php echo $rooturl."showquotes.php?q=".$row['id']; ?></link>
+ <description><![CDATA[<?php echo utf8_encode(nl2br(strip_tags($row['quote']))); ?>]]></description>
+ <guid><?php echo $rooturl."showquotes.php?q=".$row['id']; ?></guid>
+ <pubDate><?php echo strftime("%a, %d %b %Y %H:%M:%S UTC", $row['date']); ?></pubDate>
+ </item>
+ <?php } ?>
+ </channel>
+</rss>
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|