boardom

qingshuo · Posted: Fri Jan 03, 2003 10:59 pm Post subject: Hack on a Hack (Dodo's Archives)

I have modified Dodo's expanded archiver. I've titled it simply b2archivesExpandex.php and runs as an alternate archiving system (not replacement.

For comparison, this is Dodo's archive page:
http://pure-essence.net/b2archives.php
and here is mine:
http://qingshuo.net/b2/view_b2archivesExpanded.php

Here are the new features:

- Option to display all years (set by default)
- When sorting by title, there are no longer month headings, but alphabetical headings. (fixes the "month jumping" bug)
- month headings now include the year
- Month and year are not displayed before each post in sort by date because the heading already has this info.
- sort by ID is removed. This is impractical, and blogs that have imported from other systems often times do not have IDs that reflect any type of systematic order.
- choosing sort by date will automatically swap the sort menu to descending, choosing sort by title will automatically swap the sort menu to ascending. This is just javascript convenience, the user still has the ability to choose otherwise.
- a bit more style control if you play around a bit

Thanks to Dodo of course for original creation!

Edit:
---------------------------------
Sorry, wrong section, please move to Hacks section, thanks

~Q

Source:
--------------------------------------------------------------------------------------

<?php
// What's the default list order?
$defaultorderby = "post_date";
// Default to ascending to descending?
$defaultorder = "DESC";
// What's your blog file name?
$blogfilename = "index.php";
// What's your site url? (no trailing slash)
$siteurl = "http://yoursite.com/b2";
// What's the name of the table for your posts?
$tablename = "b2posts";
// What's the first year you started your b2?
$first_year = "2000";

$this_year = date("Y");
$pagenow = explode("/", $PHP_SELF);
$pagenow = trim($pagenow[(sizeof($pagenow)-1)]);

if ($pagenow == "b2archivesExpanded.php")
include ("blog.header.php");
if(!$way)
$way = $defaultorderby;
if(!$order)
$order = $defaultorder;
if(!$year)
$year = "all_years";

$archive_mode = "postbypost";
if($year != "all_years") {
$request = " SELECT * FROM $tablename WHERE post_date LIKE '$year%' ORDER BY $way $order";
}
else {
$request = " SELECT * FROM $tablename WHERE post_date ORDER BY $way $order";
}

$result = mysql_query($request);

######################################################
# Feel free to modify the following
######################################################

?>

<script language="javascript" type="text/javascript">

function Chose(whichSort) {
if(!whichSort.selectedIndex) document.getElementById("asc_desc").selectedIndex = 1;
else document.getElementById("asc_desc").selectedIndex = 0;
}

</script>

<div style="align:center">
<form action="<?=$PHP_SELF?>" method="post">
Order by
<select class="form" name="way" style="width:80px;" onchange="Chose(this);">
<?

if($way == "post_date")
echo '<option value="post_date" selected>date</option>\n';
else
echo '<option value="post_date">date</option>\n';
if($way == "post_title")
echo '<option value="post_title" selected>title</option>\n';
else
echo '<option value="post_title">title</option>\n';

?>
</select>

<select class="form" name="order" style="width:120px;" id="asc_desc">
<?
if($order == "ASC")
echo '<option value="ASC" selected>Ascending</option>\n';
else
echo '<option value="ASC">Ascending</option>\n';

if($order == "DESC")
echo '<option value="DESC" selected>Descending</option>\n';
else
echo '<option value="DESC">Descending</option>\n';
?>
</select>

<select class="form" name="year" style="width:100px;">
<?

for($i = $first_year; $i <= $this_year; $i++) {
if($year == $i)
echo "<option value=\"$i\" selected>$i</option>\n";
else
echo "<option value=\"$i\">$i</option>\n";
}
if($year == "all_years")
echo "<option value=\"all_years\" selected>All Years</option>\n";
else
echo "<option value=\"all_years\">All Years</option>\n";

?>
</select>
<input type="submit" name="submit" value="sort" />
</form>
</div>
<?php

while($row=mysql_fetch_object($result)) {

$postdata = get_postdata2($row->ID);
$thismonth = mysql2date("Y\-m", $postdata["Date"]);
$thisyear = mysql2date("Y", $postdata["Date"]);
$linkmonth = mysql2date("Ym", $postdata["Date"]);
$thisletter = substr(ucfirst($postdata["Title"]),0,1);
$i = "/".$thismonth."/";

$setHead = 0;
if($way == "post_date") {
if( $thismonth != $previousmonth && preg_match($i,$postdata["Date"]) ) {
$setHead = 1;
}
}
else {
if($thisletter != $previousletter) {
$setHead = 1;
}
}

// There are some divs adapted to style my webpage, please do change these

if ($setHead) {
if ($previousmonth || $previousletter) echo "</div>"; // this ENDS the style div of the previous header
echo "<div class=\"blogDate\" style=\"margin-top:20px;\">.:: "; // begins a header style div
if ($way == "post_date") echo "<a href=\"$siteurl/".$blogfilename."?m=$linkmonth\">".$thisyear." ".$month[substr($thismonth,5,2)]."</a>";
else echo $thisletter;
echo "</div>\n";
echo "<div class=\"blogTitleLine\" style=\"font-size:75%;\">"; // begin style div of post listings
}

$previousmonth = $thismonth;
$previousletter = $thisletter;
$postdata = get_postdata2($row->ID);
if ($way != "post_title") echo mysql2date("d h:i a", $postdata["Date"]);
else echo mysql2date("m/d/y h:i a", $postdata["Date"]);
echo " - <a href=\"$siteurl/".$blogfilename."?p=".$row->ID."&c=1"."\">";
if ($postdata["Title"]) {
$postdata["Title"] = stripslashes($postdata["Title"]);
echo $postdata["Title"];
} else {
echo $postdata["ID"];
}
echo "</a>";
echo "<br />\n";

}

?>

Mister44 · Posted: Sat Jan 04, 2003 2:21 am Post subject:

this is great! I was thinking about doing pretty much exactly this, and just hadn't gotten around to it.

GamerZ · Joined: 15 May 2002 Posts: 537 Location: Singapore

nicely done

ps: ur site looks cool
_________________

++ GamerZ.Per.Sg - Complex Simplicity

GamerZ · Joined: 15 May 2002 Posts: 537 Location: Singapore

oh ya remmebr to add[php:1:3168868e4a]$way = $_POST['way'];
$year = $_POST['year'];
$order = $_POST['order'];[/php:1:3168868e4a] at the top is register globals is off
_________________

++ GamerZ.Per.Sg - Complex Simplicity

SlackerAPM · Joined: 09 Nov 2002 Posts: 12

Is there a way to configure this hack so it only displays an archive of posts from a specific category? I don't want users to be able to chose which category posts are displayed from, more like I want to actually specify it.

I've made a seperate blog file for displaying articles on my site. This articles page displays all posts from category 2 however when I include an archive below the main content the archive displays posts from both category 1 and 2.

qingshuo · Posted: Mon Feb 03, 2003 2:41 pm Post subject:

I've changed the source alot since then, so I'll upload it here later today. The new source will support Qstrings, which will override POST data. Thus, all you do is remove the drop-down menu for categories and stick ?cat=# in the href=""

SlackerAPM · Joined: 09 Nov 2002 Posts: 12

Awesome, sounds like just what I need. When you do post it could you show exactly how to display from selected categories? This just saves me asking in the future

qingshuo · Posted: Tue Feb 04, 2003 4:25 am Post subject:

Here it is:

SlackerAPM · Joined: 09 Nov 2002 Posts: 12

Hmmm, I've got the removal of the <select name "cat"> bit done and sorted but when I include the page with the &cat=2 it doesn't seem to work. I get this:

Warning: Failed opening 'articles_archive(new).php&cat=2' for inclusion (include_path='') in /home/ebcou/public_html/3ebnews/articles.php on line 61

SlackerAPM · Joined: 09 Nov 2002 Posts: 12

I'm an idiot. Got it sorted Smile

One thing, is it possible to php include a page with the cat=2?

*edit*

Also, I can get the archive page displaying fine if I call it http://www.3eb.co.uk/3ebnews/articles.php?cat=2 but then if I click a link from the archive to display a new post I get a page displaying the selected post along with the archive of every category below it, instead of just category 2. If I then click a link from that archive that isn't in category 2 I don't get any content, just an archive.

I'm not sure I explained that very well but if you click the link you'll get the idea.

SlackerAPM · Joined: 09 Nov 2002 Posts: 12

Anyone?

macshack · Joined: 17 Jul 2002 Posts: 1204 Location: Phoenix, Az

Hi SlackerAPM,

I think we may need to see some code. I tried to follow your description, but I get lost. Not sure what should or should not be rendered and when. So could you post the "articales" code, then may be we might understand.
_________________
Kind Regards,
Michael e

SlackerAPM · Joined: 09 Nov 2002 Posts: 12

OK, here's the code for articles.php, it's basically just my index.php with a few small graphical changes:

qingshuo · Posted: Tue Feb 11, 2003 1:56 am Post subject:

$cat = isset($_GET['cat']) ? $_GET['cat'] : ((isset($_POST['cat'])) ? $_POST['cat'] : "all_cats");

This line grabs $cat from either POST or GET, both of which are missing. Since $cat is already defined at the top, just leave out this line (comment out or delete)

SlackerAPM · Joined: 09 Nov 2002 Posts: 12

Thankyou! Works perfectly now Smile