Перемещение по разделу статей (следующая и предыдущая)

    public function getArticleWithButton($article_id, $cat_id, $orderby = 'id', $order = 0) {
 
		$sql = "SELECT *
				FROM cms_content
				WHERE category_id = '$cat_id' AND id <> $article_id ";
        switch ($orderby) {
            case  'pubdate':
            $sql .= " AND ($orderby BETWEEN '1900-01-01 00:00:00' AND '$order')
                      ORDER BY $orderby DESC LIMIT 1";
            break;
            case 'ordering': 
            $sql .= " AND id > $article_id
                      ORDER BY $orderby DESC, id ASC  LIMIT 1";
            break;
            default: 
            $sql .= " AND id > $article_id
                      ORDER BY id ASC LIMIT 1";
            break;
        }
        $result = $this->inDB->query($sql);
        if ($this->inDB->num_rows($result)) 
            $article['prev'] = $this->inDB->fetch_assoc($result);
 
 
		$sql = "SELECT *
				FROM cms_content
				WHERE category_id = '$cat_id' AND id <> $article_id ";
        switch ($orderby) {
            case  'pubdate':
            $sql .= " AND ($orderby BETWEEN '$order' AND '2100-01-01 00:00:00')
                      ORDER BY $orderby ASC LIMIT 1";
            break;
            case 'ordering': 
            $sql .= " AND id < $article_id
                      ORDER BY $orderby DESC, id DESC LIMIT 1";
            break;
            default: 
            $sql .= " AND id < $article_id
                      ORDER BY id DESC LIMIT 1";
            break;
 
        }
 
        $result = $this->inDB->query($sql);
        if ($this->inDB->num_rows($result)) 
            $article['next'] = $this->inDB->fetch_assoc($result);            
 
        return $article;
    }

 
if ($do=='read'){
 
	$inCore->includeConfig();
 
    $seolink = $inCore->request('seolink', 'str', '');
 
    $seolink = preg_replace ('/[^a-z0-9_\/\-]/i', '', $seolink);
 
    if ($seolink) { 
        $article = $model->getArticleByLink($seolink);
    } elseif($id) {
        $article = $model->getArticle($id);
    }
 

$cat = $model->getCategory($article['category_id']); 

    if($cfg['rating'] && $article['canrate']){
        $inCore->loadLib('karma');
        $karma = cmsKarma('content', $article['id']);
 
        $smarty->assign('karma_points', cmsKarmaFormatSmall($karma['points']));
        $smarty->assign('karma_votes', $karma['votes']);
 
        $btns = cmsKarmaButtonsText('content', $article['id'], $karma['points'], $is_author);
        if ($btns) { $smarty->assign('karma_buttons', $btns); }
    }

    $article_button = $model->getArticleWithButton($article['id'], $article['cat_id'], $cat['orderby'], $article[$cat['orderby']]);
    if ($article_button['prev']) $article_button['prev']['image'] = (file_exists(PATH.'/images/photos/medium/article'.$article_button['prev']['id'].'.jpg') ? 'article'.$article_button['prev']['id'].'.jpg' : '');
    if ($article_button['next']) $article_button['next']['image'] = (file_exists(PATH.'/images/photos/medium/article'.$article_button['next']['id'].'.jpg') ? 'article'.$article_button['next']['id'].'.jpg' : '');
    if ($cat['orderto']=="ASC") { list($article_button['next'],$article_button['prev']) = array($article_button['prev'],$article_button['next']); }
    $smarty->assign('article_button', $article_button);
 

{if $article_button.prev || $article_button.next}
<table width="100%"  class="article_button">
    <tr>
        <th>{if $article_button.prev}Предыдущая статья в разделе <a href="/{$pcat.seolink}">{$article.cat_title}</a>{else} {/if}</th>
        <th>{if $article_button.next}Следующая статья в разделе <a href="/{$pcat.seolink}">{$article.cat_title}</a>{else} {/if}</th>
    </tr>
    <tr>
        <td width="50%" class="prev">{if $article_button.prev}
            <div class="title"><a href="/{$article_button.prev.seolink}.html">{$article_button.prev.title}</a></div>
            {if $article_button.prev.image}<div class="text"><a href="/{$article_button.prev.seolink}.html"><img src="/images/photos/small/{$article_button.prev.image}" alt="{$article_button.prev.title}" title="{$article_button.prev.title}" /></a></div>{/if}
        {else} {/if}</td>
        <td width="50%" class="next">{if $article_button.next}
            <div class="title"><a href="/{$article_button.next.seolink}.html">{$article_button.next.title}</a></div>
            {if $article_button.next.image}<div class="text"><a href="/{$article_button.next.seolink}.html"><img src="/images/photos/small/{$article_button.next.image}" alt="{$article_button.next.title}" title="{$article_button.next.title}" /></a></div>{/if}
        {else} {/if}</td>
    </tr>
</table>
{/if}

 
<table width="100%"  class="article_button">
    <tr>
        <td width="50%" class="prev">{if $article_button.prev}&#8592; <a href="/{$article_button.prev.seolink}.html">{$article_button.prev.title}</a>
        {else} {/if}</td>
        <td width="50%" class="next">{if $article_button.next}<a href="/{$article_button.next.seolink}.html">{$article_button.next.title} &#8594;</a>
        {else} {/if}</td>
    </tr>
</table>