From 4cce41c058cc132df28c891585a8380a68f6ab23 Mon Sep 17 00:00:00 2001
From: Star Rauchenberger <fefferburbia@gmail.com>
Date: Wed, 25 Feb 2009 15:39:21 -0500
Subject: Added RSS feed

---
 rss.php | 33 +++++++++++++++++++++++++++++++++
 1 file changed, 33 insertions(+)
 create mode 100644 rss.php

(limited to 'rss.php')

diff --git a/rss.php b/rss.php
new file mode 100644
index 0000000..4b710aa
--- /dev/null
+++ b/rss.php
@@ -0,0 +1,33 @@
+<?php
+
+include('includes/db.php');
+include('includes/update.php');
+
+echo('<?xml version="1.0"?>');
+
+?>
+<rss version="2.0">
+	<channel>
+		<title>Pillowcase</title>
+		<link>http://pillowcase.fourisland.com/</link>
+		<description>pillowcase - the result of an obsession with cute, plush objects that talk nonsense</description>
+		<language>en-us</language>
+<?php
+
+$getitems = "SELECT * FROM comics WHERE status = \"publish\" ORDER BY comic_id DESC LIMIT 0,10";
+$getitems2 = mysql_query($getitems);
+while ($getitems3 = mysql_fetch_array($getitems2))
+{
+?>
+		<item>
+			<title><?php echo($getitems3['title']); ?></title>
+			<link>http://pillowcase.fourisland.com/comic<?php echo($getitems3['comic_id']); ?>.htm</link>
+			<description><![CDATA[<IMG SRC="http://pillowcase.fourisland.com/images/comics/<?php echo($getitems3['filename']); ?> ALT="<?php echo($getitems3['title']); ?>"><p><?php echo($getitems3['text']); ?></p>]]></description>
+			<pubDate><?php echo(date('D, d M Y H:i:s O',strtotime($getitems3['pubDate']))); ?></pubDate>
+		</item>
+<?php
+}
+
+?>
+	</channel>
+</rss>
-- 
cgit 1.4.1