Tags list, an add-on to my tags mod

I just whipped this one up per a request from Brian over at The Miniblog (check it out, excellent design, shows what sNews can look like with the right talent). If you have installed my tags mod for sNews, then you can use this to retrieve a list of your tags, comma separated, and clickable (to pass the tag to the search engine).

This mod does not rank your tags by occurrences as a standard tag cloud would, though that's possible to do. So back up your snews.php file and let's get started.

First, we need to add the function, so copy & paste the following function just above the final php closing tag (the ?> at the very bottom) in snews.php;

If you're using my tags mod version 1 and want to continue using that, simply replace the highlighted text with ?search_query= instead of tag/

// this function grabs all the meta_keywords, removes duplicates and builds a comma separated list
function get_taglist($showpages="0") {
    if ($showpages == "1") {
        $pages_query = "category != '-1' ";
    } else {
        $pages_query = "category > 0 ";
    }
    $now = date("Y-m-d H:i:s",time());
    $sql = "SELECT distinct(keywords_meta) FROM "._PRE."articles WHERE ".$pages_query." AND date <= '".$now."' AND published='1' AND visible = 'YES' AND keywords_meta != ''"; 
    $result = mysql_query($sql);
    $count = mysql_num_rows($result);
    $x = "1";
    while ($row = mysql_fetch_array($result)) {
        if ($x < $count) {
            $suffix = ", ";
        } else {
            $suffix = "";
        }
        $tagslist .= $row['keywords_meta'].$suffix; 
    $x++;
    }

    $tagslist = explode(", ",$tagslist); 
    $tagslist = array_unique($tagslist);
    sort($tagslist);
    $keyCount = count($tagslist);
    if ($keyCount > 0) {
        echo '<div class="taglist">';
        for ($i = 0; $i < $keyCount; $i++) {
            if ($i == 0) {
                $pre = "";
            } else {
                $pre = ", ";
            }
            if (!empty($tagslist[$i])) {
                echo $pre.'<a href="'._SITE.'tag/'.urlencode($tagslist[$i]).'/" title="See more articles on '.$tagslist[$i].'">'.$tagslist[$i].'</a>';
            }
        }
        echo "</div>";
    }
}

Now, all you need to do is add the following function call to your index.php file where you want the list displayed, change the "0" to a "1" to show tags from sNews pages, or leave at "0" to display tags from only articles;

<?php get_taglist("0"); ?>

That should be it, if you want to change the styling, all the links are inside a div with the class of "taglist", so add that to your stylesheet and have fun. Below is an example of the results on my site... slightly different format as I'm using SEF links for my tags now, I'll be releasing that mod later on... peace.

Update #1: Jan 23rd, 2009 @ 8:35 pm - corrected div class style instructions, it's class is taglist, not tagslist. Also updated the query to not show the keywords if the article is published in the future.

Update #2: Jan 26th, 2009 @ 5:09 pm - added the sort() function to format the tags list alphabetically.

Update #3: Mar 3rd, 2009 @ 6:16 am - added trailing to tag links.