Tags Mod for sNews version 2

Here is the second edition of my tags mod for sNews 1.7, this mod will format your tags in an SEO link, as shown on my own page here, i.e. http://yousite.com/tag/widget/. This version also separates the tags search from the standard search.

Please note, if you have installed my tags mod and want to upgrade to this version, I will write up a separate tutorial on that as well, if you can't figure out the differences from this one. As before, you will need to add your keywords with a single comma and space separating them, i.e.
keyword1, keyword2, keyword3, etc.

So let's get started. BACK-UP your snews.php file and work on a copy.

1. Find the hard coded link items;

$l['cat_listSEF'] = 'archive,contact,sitemap,login,administration,admin_category,admin_article,article_new,extra_new,page_new,snews_categories,snews_articles,extra_contents,snews_pages,snews_settings,snews_files,logout,groupings,admin_groupings';

now we need to add the "tag" page, as in the highlighted code;

$l['cat_listSEF'] = 'archive,contact,sitemap,tag,login,administration,admin_category,admin_article,article_new,extra_new,page_new,snews_categories,snews_articles,extra_contents,snews_pages,snews_settings,snews_files,logout,groupings,admin_groupings';

2. now in the function center(), find the globals and add the code like below, IF YOU HAVE ALREADY ADDED THE url code from the SEO aearch mod, you do not need to add that again.

global $categorySEF, $subcatSEF, $articleSEF;
    // begin new code
    $url = explode('/',clean(cleanXSS($_GET['category']))); // already done if you have the SEO search mode installed
    if ($url[0] == "tag") {
        $tags_query = $url[1];
    }
    // end new code

3. Now around line 545, still within the function center(), find the following code;

case isset($_POST['search_query']): // this may have been changed to $search_query if you have installed the SEO search mod
    search(); return; break;

Now ADD the following code below;

case isset($tags_query):
    tagsearch($tags_query); return; break;

4. Find the function articles. Look for

if ($_ID || (!$_catID && $frontpage != 0)) {

and update the $query_articles variable by adding the highlighted code

if ($_ID || (!$_catID && $frontpage != 0)) {
        if (!$_ID) $_ID = $frontpage;
            // article or page, id as indentifier
            $query_articles = 'SELECT
                    a.id AS aid,title,a.seftitle AS asef,a.category AS acat,a.keywords_meta AS keywords,text,a.date,
                    a.displaytitle,a.displayinfo,a.commentable,a.visible
                FROM  '._PRE.'articles'.' AS a
                WHERE id ='.$_ID.$visible;
        } else {

5. Now look for

// get the rows for category
if ($_catID) {

and update the $query_articles variable by adding the highlighted code

// get the rows for category
if ($_catID) {
    $query_articles = 'SELECT
            a.id AS aid,title,a.seftitle AS asef,a.keywords_meta AS keywords,text,a.date,
            a.displaytitle,a.displayinfo,a.commentable,a.visible
    FROM '._PRE.'articles'.' AS a
    WHERE position = 1
        AND a.published =1
        AND category = '.$_catID.$visible.'
    ORDER BY artorder ASC,date DESC
    LIMIT '.($currentPage - 1) * $article_limit.','.$article_limit;
} else {
    $query_articles = 'SELECT
            a.id AS aid,title,a.seftitle AS asef,a.keywords_meta AS keywords,text,a.date,
                displaytitle,displayinfo,commentable,a.visible,
            c.name AS name,c.seftitle AS csef,
            x.name AS xname,x.seftitle AS xsef
        FROM '._PRE.'articles'.' AS a
        LEFT OUTER JOIN '._PRE.'categories'.' as c
            ON category = c.id
        LEFT OUTER JOIN '._PRE.'categories'.' as x
            ON c.subcat =  x.id AND x.published =\'YES\'
        WHERE show_on_home = \'YES\'
            AND position = 1
            AND a.published =1
            AND c.published =\'YES\''.$visible.'
        ORDER BY date DESC
        LIMIT '.($currentPage - 1) * $article_limit.','.$article_limit;
}

6. That will slurp the keywords into the $r['keywords'] variable. We will now prepare to break the keywords apart and insert them into the article, underneath the "infoline" and admin edit links. Still within the articles function, find the 2 instances of the admin links;

} else if (_ADMIN) {
    echo '<p>'.$edit_link.'</p>';
}

then insert the following code below both of the admin edit links, like this;

// insert new code here
if (trim($r['keywords']) != "") { // not empty 
    $article_tags = explode(', ', $r['keywords']);
    $keyCount = count($article_tags);
    if ($keyCount > 0) {
        echo '<div class="tags">';
        for ($i = 0; $i < $keyCount; $i++) {
            if ($i == 0) {
                $pre = "";
            } else {
                $pre = ", ";
            }
             echo $pre.'<a href="'._SITE.'tag/'. urlencode($article_tags[$i]).'/" title="See more articles on '.$article_tags[$i].'">'.$article_tags[$i].'</a>';
        }
        echo "</div>";
    }
}

7. Now add the tags engine, THERE ARE TWO OPTIONS, PICK ONE. The first tagsearch function is for people who want to use MySQL's full-text speed and don't need to use tags under the full-text limit of 4 characters. If that's you, then simply copy and paste the entire function below to just above the closing php tag, if not, skip to step 9 now.

//TAGS ENGINE
function tagsearch($tags_query,$limit = 100) {
    $tags_query = clean(cleanXSS($tags_query));
    echo '<h2>'.l(tag_results).'</h2>';
    if (strlen($tags_query) < 4) {
        echo '<div><p>'.l('charerror').'</p>';
    } else {
        $tags_query = trim($tags_query);
       
        $now = date("Y-m-d H:i:s",time());
        $query = 'SELECT a.id,a.title,a.seftitle AS asef,a.date AS date,
                   c.name AS name,c.seftitle AS csef,
                   x.name AS xname,x.seftitle AS xsef, MATCH(a.keywords_meta) AGAINST (\'"+'.$tags_query.'"\' IN BOOLEAN MODE) AS score
            FROM '._PRE.'articles'.' AS a
            LEFT OUTER JOIN '._PRE.'categories'.' as c
                ON category = c.id AND c.published =\'YES\'
            LEFT OUTER JOIN '._PRE.'categories'.' as x
                ON c.subcat =  x.id AND x.published =\'YES\'
            WHERE MATCH(a.keywords_meta) AGAINST (\'"+'.$tags_query.'"\' IN BOOLEAN MODE) AND position != 2
                AND a.published = 1
                AND date <= \''.$now.'\'';
        if(!_ADMIN){
            $query = $query.'AND a.visible = \'YES\'';
        }
        $query = $query.' GROUP BY a.id HAVING score > \'0\' ORDER BY score DESC LIMIT '.$limit;
        $result = mysql_query($query);
        $numrows = mysql_num_rows($result);
        if (!$numrows) {
            echo '<div><p>'.l('noresults').'
                <strong>'.stripslashes(entity($tags_query)).'</strong>.</p>';
        } else {
            echo '<div id="tag_results"><p><strong>'.$numrows.'</strong> '.l('tagresultsfound').' <strong>'.
            stripslashes(entity($tags_query)).'</strong>.</p>';
            while ($r = mysql_fetch_array($result)) {
                $date = date(s('date_format'), strtotime($r['date']));
                if ($r['name']) { $name = ' in '.$r['name']; } else { $name = "";}
                if (isset($r['xsef']))  $link = $r['xsef'].'/'.$r['csef'].'/';
                else $link = isset($r['csef']) ? $r['csef'].'/' : '';
                echo '<p><a href="'._SITE.$link.$r['asef'].'/">'.$r['title'].'</a><br /><span class="tag_sub">added on '.$date.$name.'</span></p>';
            }
        }
    }
    echo '</div>';
}

8. Now set up a MySQL full-text index on your keywords field in your database

ALTER TABLE articles ADD FULLTEXT(keywords_meta); 

9. OK, add this tagsearch function only if you don't want to use MySQL's full-text search;

//TAGS ENGINE
function tagsearch($tags_query,$limit = 100,$min_chars = 2) {
    $tags_query = clean(cleanXSS($tags_query));
    echo '<h2>'.l(tag_results).'</h2>';
    if (strlen($tags_query) < $min_chars) {
        echo '<div><p>Tags must be at least '.$min_chars.' characters!</p>';
    } else {
        $tags_query = trim($tags_query);
       
        $now = date("Y-m-d H:i:s",time());
        $query = 'SELECT a.id,a.title,a.seftitle AS asef,a.date AS date,
                   c.name AS name,c.seftitle AS csef,
                   x.name AS xname,x.seftitle AS xsef
            FROM '._PRE.'articles'.' AS a
            LEFT OUTER JOIN '._PRE.'categories'.' as c
                ON category = c.id AND c.published =\'YES\'
            LEFT OUTER JOIN '._PRE.'categories'.' as x
                ON c.subcat =  x.id AND x.published =\'YES\'
            WHERE (a.keywords_meta LIKE \'%'.$tags_query.'%\' AND a.keywords_meta REGEXP \':<:'.$tags_query.':>:\') AND position != 2
                AND a.published = 1
                AND date <= \''.$now.'\'';
        if(!_ADMIN){
            $query = $query.'AND a.visible = \'YES\'';
        }
        
        $query = $query.' ORDER BY date DESC LIMIT '.$limit;
        $result = mysql_query($query);
        $numrows = mysql_num_rows($result);
        if (!$numrows) {
            echo '<div><p>'.l('noresults').'
                <strong>'.stripslashes(entity($tags_query)).'</strong>.</p>';
        } else {
            echo '<div id="tag_results"><p><strong>'.$numrows.'</strong> '.l('tagresultsfound').' <strong>'.
            stripslashes(entity($tags_query)).'</strong>.</p>';
            while ($r = mysql_fetch_array($result)) {
                $date = date(s('date_format'), strtotime($r['date']));
                if ($r['name']) { $name = ' in '.$r['name']; } else { $name = "";}
                if (isset($r['xsef']))  $link = $r['xsef'].'/'.$r['csef'].'/';
                else $link = isset($r['csef']) ? $r['csef'].'/' : '';
                echo '<p><a href="'._SITE.$link.$r['asef'].'/">'.$r['title'].'</a><br /><span class="tag_sub">added on '.$date.$name.'</span></p>';
            }
        }
    }
    echo '</div>';
}

10. Now open your language file (EN.php in the lang folder if you're using the default) and add the following lines;

# Tag search
$l['tag'] = 'Tags';
$l['tagresultsfound'] = 'item(s) tagged with;';
$l['tag_results'] = 'Tag Search';

10. Now you need an icon, like this one , save that and drop it into your images folder and then add the following to your style sheet. These are my colors, feel free to create your own.

#tag_results p {
    line-height:1.2em;
    margin: 0 0 10px 0;
}

#tag_results a {
    color: #386E80;
}

.tag_sub {
    font-size: 0.9em;
    color: #777777;
}

.tags {
    background: #fff url('../images/tags.png') left center no-repeat;
    font-size: 0.9em;
    margin-bottom: 14px;
    padding: 0 0 2px 14px;
}

.tags a {
    color: #f66363;
    text-decoration: none;
}

.tags a:hover {
    color: #000;
    text-decoration: none;
}

You can change things around to display them only on certain articles like I have done, for example I only show the tags on true "articles", not on "pages". To show only on articles with "infoline" shown and not "pages" like mine, I wrapped the second instance of the tag code in the following;

if ($infoline == true && $_catID != 0) {
//tag code goes here
}