From eee98526c48b9154cd9e9bc8bc3e07769e6a39ea Mon Sep 17 00:00:00 2001
From: Star Rauchenberger <fefferburbia@gmail.com>
Date: Sun, 22 Feb 2009 13:15:37 -0500
Subject: Rewrote Pillowcase

NOTE: There is a new database schema now, so the database from the testing server has to be copied over to the production server, otherwise this code
will fail.
---
 pages/comic.php | 131 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 131 insertions(+)
 create mode 100755 pages/comic.php

(limited to 'pages/comic.php')

diff --git a/pages/comic.php b/pages/comic.php
new file mode 100755
index 0000000..0edd91c
--- /dev/null
+++ b/pages/comic.php
@@ -0,0 +1,131 @@
+<?php
+
+if (isset($_GET['id']))
+{
+	$getcomic = "SELECT * FROM comics WHERE comic_id = " . $_GET['id'] . " AND status = \"publish\"";
+} else {
+	$getcomic = "SELECT * FROM comics WHERE status = \"publish\" ORDER BY comic_id DESC LIMIT 0,1";
+}
+$getcomic2 = mysql_query($getcomic);
+$getcomic3 = mysql_fetch_array($getcomic2);
+
+$date = strtotime(get_meta($getcomic3['id'], 'pubDate'));
+
+?>
+			<DIV CLASS="post">
+				<DIV CLASS="date" TITLE="<?php echo(date('F jS Y g:i a', $date)); ?>">
+					<?php echo(date('M', $date)); ?><BR>
+					<?php echo(date('j', $date)); ?><BR>
+					<?php echo(date('Y', $date)); ?>
+
+				</DIV>
+
+				<DIV CLASS="title">
+					<H2><?php echo($getcomic3['title']); ?></H2>
+<?php
+
+if (has_meta($getcomic3['id'], 'author'))
+{
+?>
+					<CENTER><SMALL>Guest comic by <?php echo(get_meta($getcomic3['id'], 'author')); ?></SMALL></CENTER>
+<?php
+}
+
+?>
+				</DIV>
+			</DIV>
+
+			<DIV CLASS="image">
+<?php
+
+if (has_meta($getcomic3['id'], 'link'))
+{
+?>
+				<A HREF="<?php echo(get_meta($getcomic3['id'], 'link')); ?>">
+	<?php
+}
+?>
+				<IMG SRC="/images/comics/<?php echo($getcomic3['filename']); ?>" ALT="<?php echo(htmlentities($getcomic3['text'])); ?>" TITLE="<?php echo(htmlentities($getcomic3['text'])); ?>">
+<?php
+
+if (has_meta($getcomic3['id'], 'link'))
+{
+?>
+				</A>
+<?php
+}
+?>
+			</DIV>
+
+			<DIV CLASS="cleardiv"></DIV>
+
+			<UL CLASS="navbar">
+<?php
+
+$id = $getcomic3['comic_id'];
+
+$cntcomics = "SELECT COUNT(*) FROM comics WHERE status = \"publish\"";
+$cntcomics2 = mysql_query($cntcomics);
+$cntcomics3 = mysql_fetch_array($cntcomics2);
+$all = $cntcomics3['COUNT(*)'];
+
+if ($id > 2)
+{
+?>				<LI><A HREF="/comic1.htm">First</a></LI>
+<?php
+}
+
+if ($id > 1)
+{
+?>				<LI><A HREF="/comic<?php echo($id-1); ?>.htm">Back</A></LI>
+<?php
+}
+
+if ($id < $all)
+{
+	if ($id != ($all-1))
+	{
+?>				<LI><A HREF="/comic<?php echo($id+1); ?>.htm">Next</A></LI>
+<?php
+?>				<LI><A HREF="/">Today</A></LI>
+<?php
+	} else {
+?>				<LI><A HREF="/">Next</A></LI>
+<?php
+	}
+}
+
+$cntpending = "SELECT COUNT(*) FROM comics WHERE status = \"pending\"";
+$cntpending2 = mysql_query($cntpending);
+$cntpending3 = mysql_fetch_array($cntpending2);
+$numpending = $cntpending3['COUNT(*)'];
+
+?>
+			</UL>
+
+			<DIV CLASS="cleardiv"></DIV>
+
+			<P>
+				pillowcase - the result of an obsession with cute, plush objects that talk nonsense
+			</P>
+
+			<P>
+				because we luv <A HREF="http://xkcd.com">xkcd</A>, make sure you look for the alt text
+			</P>
+
+			<P>
+<?php if ($numpending == 1): ?>
+				there is 1 comic in the pending queue, which means that if Starla wants to be lazy and can't be bothered to update, she can relax for 1 more day before she starts getting angry emails
+<?php elseif ($numpending == 0): ?>
+				oh dear, there aren't any comics in the pending queue, which means that if Starla doesn't hurry up, there may not be a comic tomorrow
+<?php elseif ($numpending > 100): ?>
+				OMG! There are <?php echo($numpending); ?> comics in the pending queue! Starla, you relax as long as you want!
+<?php else: ?>
+				there are <?php echo($numpending); ?> comics in the pending queue, which means that if Starla wants to be lazy and can't be bothered to update, she can relax for <?php echo($numpending); ?> days before she starts getting angry emails
+<?php endif; ?>
+			</P>
+<?php
+
+$title = $getcomic3['title'];
+
+?>
-- 
cgit 1.4.1