|
|
<?php
|
|
|
|
|
|
include('frontend.inc.php');
|
|
|
|
|
|
$TYPES = mysqli_query($link,'SELECT DISTINCT strip_t.id, strip_t.description, strip_t.name, meta.meta FROM strip_t
|
|
|
LEFT JOIN meta ON strip_t.id = meta.type
|
|
|
ORDER BY meta.meta, strip_t.id') or die(mysqli_error($link));
|
|
|
|
|
|
#$MTIME = mysqli_query($link,'SELECT UNIX_TIMESTAMP(MAX(published)) FROM strip') or die(mysqli_error($link));
|
|
|
#conditional_exit(current(mysqli_fetch_row($MTIME)));
|
|
|
|
|
|
pagehead('archive', 'Archives');
|
|
|
?>
|
|
|
|
|
|
<div class="content">
|
|
|
<h2>View By:</h2>
|
|
|
<div><ul class="nl">
|
|
|
<li><a href="archive.php?list_by=date">View by Date</a></li>
|
|
|
<li><a href="archive.php">View by Section</a></li>
|
|
|
<li><a href="archive.php?list_by=date">View in Order</a></li>
|
|
|
</ul></div>
|
|
|
</div>
|
|
|
|
|
|
<?php
|
|
|
|
|
|
if(isset($_REQUEST['list_by']) && $_REQUEST['list_by'] == "date")
|
|
|
{
|
|
|
$comics = mysqli_query($link,"SELECT distinct id, title,
|
|
|
DATE_FORMAT(published, '%M %D, %Y') AS pubdate
|
|
|
FROM strip WHERE published < NOW() ORDER BY id") or die(mysqli_error($link));
|
|
|
|
|
|
echo '<div class="content"><h2>Comics by Date</h2><div><ul>';
|
|
|
|
|
|
while($comic = mysqli_fetch_assoc($comics))
|
|
|
printf('<li><a title="%s" name="%d" href="./strip/%d">%04d - %s</a></li>', $comic['pubdate'], $comic['id'], $comic['id'], $comic['id'], htmlentities($comic['title']));
|
|
|
|
|
|
echo '</ul></div></div>';
|
|
|
}
|
|
|
|
|
|
#elseif(!isset($_REQUEST['list_by']) || $_REQUEST['list_by'] == "type")
|
|
|
else
|
|
|
{
|
|
|
?>
|
|
|
<div class="content" id="typelinks">
|
|
|
<h2>Comics by Section</h2>
|
|
|
<div><ul><?php
|
|
|
while ($type = mysqli_fetch_assoc($TYPES)) {
|
|
|
$comics = mysqli_query($link,"SELECT distinct id, title FROM strip WHERE type = $type[id] AND published < NOW()") or die(mysqli_error($link));
|
|
|
if (mysqli_num_rows($comics) <= 0)
|
|
|
continue;
|
|
|
echo "\t\t<li><a href=\"archive.php#$type[name]\">", htmlentities($type[description]), "</a></li>\n";
|
|
|
}
|
|
|
?></ul></div>
|
|
|
</div>
|
|
|
<?php
|
|
|
mysqli_data_seek($TYPES, 0);
|
|
|
while($type = mysqli_fetch_assoc($TYPES)) {
|
|
|
$comics = mysqli_query($link,"SELECT distinct id, title,
|
|
|
DATE_FORMAT(published, '%M %D, %Y') AS pubdate
|
|
|
FROM strip WHERE type = $type[id] AND published < NOW()") or die(mysqli_error($link));
|
|
|
|
|
|
if(mysqli_num_rows($comics) <= 0)
|
|
|
continue;
|
|
|
|
|
|
echo '<div class="content"><h2><a id="', $type['name'], '">', htmlentities($type['description']), '</a></h2><div><ol>';
|
|
|
|
|
|
while($comic = mysqli_fetch_assoc($comics))
|
|
|
printf('<li><a title="%s" name="%d" href="./strip/%d">%04d - %s</a></li>', $comic['pubdate'], $comic['id'], $comic['id'], $comic['id'], utfentities($comic['title']));
|
|
|
|
|
|
echo '</ol></div></div>';
|
|
|
}
|
|
|
}
|
|
|
?>
|
|
|
|
|
|
<?php pagefoot() ?>
|
|
|
</body>
|
|
|
</html>
|
|
|
|
