� iTamers Simple SEO » WordPress Archive Lists

January 24, 2006

WordPress Archive Lists

WordPress — Sarah King

One thing I haven't become involved with is writing plugins for WordPress but I have been looking at ways to make my blog more efficient.

I tried out a tag system back in October but found that it generated too many tags and often irrelevant tags so finally scrapped it in favour of the plugins from Ultimate Tag Warrior produced by fellow kiwi Christine Davis (who I don't actually know ;)). Her system allowed me to produce a "Tag Cloud" which is pretty cool.

I haven't totally got my head around the custom tags page with url rewriting but for now I'm happy with urls like /index.php?tag=kiwi and I've learnt a little about templates.

So when I posted some info about the UTW plugin at DigitalPoint one of the members asked about Category Archives and gave a new plugin to use. I took a look and couldn't quite work out how to use it, so took the lessons from UTW and applied them!

SKArchive

I didn't want to replace the default pages when I click on the category name, or change the core template so I'm calling this "SKArchive". First, check out my wordpress archive page.

Create a "skarchive.php" in your template folder (contents below) and upload
In the Admin control panel create a new page and change the template to SKArchive. Save.
Now, view your blog and it should all be there. Tweak as necessary.

The Code

PLAIN TEXT

PHP:

<?php
/*
Template Name: SKArchive
*/
?>
<?php get_header(); ?>
<?php
/**
* @return string
* @param int $catID
* @desc returns a list of posts for a category
*/
function wp_cat_posts( $catID )
{
global $wpdb;
$output = '';
$get_posts_in_cat = "SELECT {$wpdb->posts}.ID, {$wpdb->posts}.post_title,
{$wpdb->post2cat}.post_id, {$wpdb->post2cat}.category_id
FROM `{$wpdb->posts}`, `{$wpdb->post2cat}`
WHERE {$wpdb->posts}.ID = {$wpdb->post2cat}.post_ID
AND {$wpdb->post2cat}.category_id = '$catID'
AND {$wpdb->posts}.post_status = 'publish'
ORDER BY {$wpdb->posts}.post_date desc ";
$get_posts_in_cat_result = mysql_query($get_posts_in_cat);
if (mysql_num_rows($get_posts_in_cat_result)> 0)
{
$output = '<ul>';
while ($posts_in_cat_row = mysql_fetch_assoc($get_posts_in_cat_result))
{
$post_title = $posts_in_cat_row['post_title'];
$postID = $posts_in_cat_row['ID'];
$output .= "<li><a href='" . get_permalink($postID) . "'>{$post_title}</a></li>\n";
}
$output .= '</ul>';
}
return $output;
}//wp_cat_posts
global $wpdb;
$get_cat = "SELECT *
FROM `{$wpdb->categories}`
order by cat_name";
$get_cat_result = mysql_query($get_cat);
while ($cat_row = mysql_fetch_object($get_cat_result))
{
$link = '<a href="'.get_category_link($cat_row->cat_ID).'">';
$link .= apply_filters('list_cats', $cat_row->cat_name, $cat_row).'</a>';
echo "<p><b>{$link}</b></p>" . wp_cat_posts($cat_row->cat_ID);
}
?>
<?php get_footer();
// Credits
//========
//Brian Groce
//http://briangroce.com/
?>

Also on this site

Tags: blog, christine-davis, kiwi, plugins, posts, template, wordpress

2 Comments »

Sarhak, do u plz tell How i add wordpress theme as well as admin panel in my “.com” site. ???

Comment by sagbee — January 26, 2006 @ 10:45 pm
Hi Sagbee

At present you can’t change the templates over at WordPress.com - one of the limitations of taking a hosted package. However many will find this a small price to pay for the convenience.

I see they’ve dropped your blog though! Better luck next time!

Sarah

Comment by sarahk — January 27, 2006 @ 5:25 am

RSS feed for comments on this post. TrackBack URI

Search

Other Resources

1. Portfolio

2. Essentials

3. Code Examples

4. Social Networking

5. Just for fun

iTamer.com