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

---
 includes/update.php | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 includes/update.php

(limited to 'includes/update.php')

diff --git a/includes/update.php b/includes/update.php
new file mode 100644
index 0000000..6c8d9ff
--- /dev/null
+++ b/includes/update.php
@@ -0,0 +1,28 @@
+<?php
+
+$getlast = "SELECT * FROM config WHERE name = \"lastUpdated\"";
+$getlast2 = mysql_query($getlast);
+$getlast3 = mysql_fetch_array($getlast2);
+
+$last = $getlast3['value'];
+if ($last != date('md'))
+{
+	$getpending = "SELECT * FROM comics WHERE status = \"pending\" ORDER BY id ASC LIMIT 0,1";
+	$getpending2 = mysql_query($getpending);
+	$getpending3 = mysql_fetch_array($getpending2);
+	if (!empty($getpending3))
+	{
+		$id = next_comic_id();
+
+		$setcomic = "UPDATE comics SET status = \"publish\", comic_id = " . $id . " WHERE id = " . $getpending3['id'];
+	        $setcomic2 = mysql_query($setcomic) or die($setcomic);
+
+		$insmeta = "INSERT INTO meta (comic_id,name,value) VALUES (" . $getpending3['id'] . ",\"pubDate\",\"" . date('Y-m-d H:i:s') . "\")";
+		$insmeta2 = mysql_query($insmeta) or die($insmeta);
+
+		$setconfig = "UPDATE config SET value = \"" . date('md') . "\" WHERE name = \"lastUpdated\"";
+		$setconfig2 = mysql_query($setconfig);
+	}
+}
+
+?>
-- 
cgit 1.4.1