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

---
 .htaccess         |  2 ++
 pages/archive.php | 48 +++++++++++++++++++++++++++++++++++++++++-------
 pages/season.php  | 34 ++++++++++++++++++++++++++++++++++
 style.css         |  5 +++++
 4 files changed, 82 insertions(+), 7 deletions(-)
 mode change 100755 => 100644 pages/archive.php
 create mode 100755 pages/season.php

diff --git a/.htaccess b/.htaccess
index 84bfa5b..317cda7 100755
--- a/.htaccess
+++ b/.htaccess
@@ -10,4 +10,6 @@ RewriteRule images/ / [R]
 RewriteCond %{REQUEST_FILENAME} .png
 RewriteRule images/comics/(.+).png /comic.php?id=$1 [L]
 RewriteCond %{REQUEST_FILENAME} .htm
+RewriteRule season(.+).htm /index.php?area=season&season=$1 [QSA,L]
+RewriteCond %{REQUEST_FILENAME} .htm
 RewriteRule (.+).htm /index.php?area=$1 [QSA,L]
diff --git a/pages/archive.php b/pages/archive.php
old mode 100755
new mode 100644
index c1cd8ab..85a73d5
--- a/pages/archive.php
+++ b/pages/archive.php
@@ -1,14 +1,48 @@
-			<H1>Archive</H1>
+                        <H1>Archives</H1>
+
+			<TABLE ID="seasons">
+				<TR>
+					<TH>Season</TH>
+					<TH>First Comic</TH>
+					<TH>Last Comic</TH>
+					<TH>Comics</TH>
+				</TR>
 
-			<UL ID="archive">
 <?php
 
-$getcomics = "SELECT * FROM comics WHERE status = \"publish\" ORDER BY comic_id ASC";
-$getcomics2 = mysql_query($getcomics);
-while ($getcomics3 = mysql_fetch_array($getcomics2))
+$getseasons = "SELECT * FROM seasons ORDER BY season_id ASC";
+$getseasons2 = mysql_query($getseasons);
+while ($getseasons3 = mysql_fetch_array($getseasons2))
 {
-?>				<LI><A HREF="/comic<?php echo($getcomics3['comic_id']); ?>.htm"><?php echo($getcomics3['title']); ?></A></LI>
+	$getfc = "SELECT * FROM comics WHERE comic_id = " . $getseasons3['first_comic_id'];
+	$getfc2 = mysql_query($getfc);
+	$getfc3 = mysql_fetch_array($getfc2);
+
+	if (!is_null($getseasons3['last_comic_id']))
+	{
+		$getlc = "SELECT * FROM comics WHERE comic_id = " . $getseasons3['last_comic_id'];
+		$getlc2 = mysql_query($getlc);
+		$getlc3 = mysql_fetch_array($getlc2);
+
+		$count = $getseasons3['last_comic_id'] - ($getseasons3['first_comic_id']-1);
+	} else {
+		$getcnt = "SELECT COUNT(*) FROM comics WHERE comic_id >= " . $getseasons3['first_comic_id'];
+		$getcnt2 = mysql_query($getcnt);
+		$getcnt3 = mysql_fetch_array($getcnt2);
+
+		$count = $getcnt3[0];
+	}
+
+?>
+				<TR>
+					<TD><A HREF="/season<?php echo($getseasons3['season_id']); ?>.htm">1</A></TD>
+					<TD><A HREF="/comic<?php echo($getfc3['comic_id']); ?>.htm"><?php echo($getfc3['title']); ?></A><BR />(<?php echo(date('F j Y',strtotime(get_meta($getfc3['id'], 'pubDate')))); ?>)</TD>
+					<TD><?php if (!is_null($getseasons3['last_comic_id'])) { ?><A HREF="/comic<?php echo($getlc3['comic_id']); ?>.htm"><?php echo($getlc3['title']); ?></A><BR />(<?php echo(date('F j Y',strtotime(get_meta($getlc3['id'], 'pubDate')))); ?>)<?php } else { ?><EM>N/A</EM><?php } ?></TD>
+					<TD><?php echo($count); ?></TD>
+				</TR>
 <?php
+
 }
 
-?>			</UL>
+?>
+			</TABLE>
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');
+}
+
+?>
diff --git a/style.css b/style.css
index 0699038..580235b 100755
--- a/style.css
+++ b/style.css
@@ -97,3 +97,8 @@ ul#archive {
 a img {
  border: 0;
 }
+
+table#seasons {
+ text-align: center;
+ width: 100%;
+}
-- 
cgit 1.4.1