--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/web/wp-content/plugins/gigs-calendar/rss.php	Wed Dec 23 17:55:33 2009 +0000
@@ -0,0 +1,57 @@
+<?php
+
+header('Content-Type: application/rss+xml; charset=utf-8');
+define('GIGS_PUBLIC', 1);
+define('GIGS_RSS', 1);
+require_once 'ajaxSetup.php';
+require_once 'version.php';
+
+$query = '
+    SELECT p.* 
+    FROM 
+		' . $wpdb->posts . ' p,
+		' . TABLE_GIGS . ' g
+    WHERE 
+		p.ID = g.postID AND
+		g.date >= CURDATE()
+	
+    ORDER BY g.date
+';
+
+$posts = $wpdb->get_results($query);
+echo '<?xml version="1.0"?>'; 
+?>
+<rss version="2.0">
+	<channel>
+		<title><?php bloginfo('name') ?> - <?php _e('Upcoming Gigs feed', $gcd); ?></title>
+		<?php if ( !empty($options['parent']) ) : ?>
+			<link><?php echo get_permalink($options['parent']); ?></link>
+		<?php else : ?>
+			<link><?php get_bloginfo('wpurl') ?></link>
+		<?php endif; ?>
+		
+		<generator>Gigs Calendar v<?php echo DTC_GIGS_PLUGIN_VERSION ?></generator>
+		<description></description>
+ <?php if ($posts): ?>
+	<?php foreach ($posts as $post): ?>
+		<?php setup_postdata($post); ?>
+		<?php $g = new gig(); $g->getByPostID($post->ID); $p = $g->getPerformances(); $p->fetch(); ?>
+		<item>
+			<title><?php echo the_title() ?></title>
+			<link><?php the_permalink(); ?></link>
+			<pubDate><?php echo date('r', strtotime($g->date . ' ' . $p->time)); ?></pubDate>
+
+			<description>
+				<![CDATA[
+					<?php the_content(); ?>
+				]]>
+			</description>
+			<guid><?php the_guid(); ?></guid>
+			
+		</item>
+
+	<?php endforeach; ?>
+<?php endif; ?>
+	
+	</channel>
+</rss>