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.

1 files changed, 131 insertions, 0 deletions

@@ -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'];
+
+?>