From d87d85235d2fa2a3e2bc97344377fcc37f88fa9c Mon Sep 17 00:00:00 2001
From: Star Rauchenberger <fefferburbia@gmail.com>
Date: Wed, 17 Jun 2009 15:04:14 -0400
Subject: Added season information to archives

---
 pages/season.php | 34 ++++++++++++++++++++++++++++++++++
 1 file changed, 34 insertions(+)
 create mode 100755 pages/season.php

(limited to 'pages/season.php')

diff --git a/pages/season.php b/pages/season.php
new file mode 100755
index 0000000..6b45a27
--- /dev/null
+++ b/pages/season.php
@@ -0,0 +1,34 @@
+<?php
+
+if (is_numeric($_GET['season']))
+{
+	$getseason = "SELECT * FROM seasons WHERE season_id = " . $_GET['season'];
+	$getseason2 = mysql_query($getseason);
+	$getseason3 = mysql_fetch_array($getseason2);
+}
+
+if (isset($getseason3) && ($getseason3['season_id'] == $_GET['season']))
+{
+
+?>
+			<H1>Archive for Season <?php echo($_GET['season']); ?></H1>
+
+			<UL ID="archive">
+<?php
+
+$getcomics = "SELECT * FROM comics WHERE status = \"publish\" AND comic_id >= " . $getseason3['first_comic_id'] . " AND comic_id <= " . $getseason3['last_comic_id'] . " ORDER BY comic_id ASC";
+$getcomics2 = mysql_query($getcomics);
+while ($getcomics3 = mysql_fetch_array($getcomics2))
+{
+?>				<LI><A HREF="/comic<?php echo($getcomics3['comic_id']); ?>.htm"><?php echo($getcomics3['title']); ?></A></LI>
+<?php
+}
+
+?>			</UL>
+<?php
+
+} else {
+	include('pages/comic.php');
+}
+
+?>
-- 
cgit 1.4.1