[Comoblog-commit] modules/mod_prevnext/include mod_prevnext.inc.php,NONE,1.1

[iamdecal <iam...@us...>]

Update of /cvsroot/comoblog/modules/mod_prevnext/include
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11777/mod_prevnext/include

Added Files:
	mod_prevnext.inc.php 
Log Message:
initial add

mod_postbytitle, adds next and previous links to the individual post pages.

--- NEW FILE: mod_prevnext.inc.php ---
<?php
    function mod_prevnext_post_next ($post_id) {
        if (CFG_USE_PATH_INFO == 'no'){
            $iisbug = '?';
        }else{
            $iisbug = '';
        }
      
    $query = "
            select      p.post_id as next_post_id
            from        ".CFG_MYSQL_TABPREFIX."posts p
            where       p.post_id > '".$post_id."'
            order by    p.post_id limit 1;
            ";
    $res = mysql_query($query);
   
    if (!$res || !mysql_num_rows($res)){
        return (false);
    }
      
    $post = mysql_fetch_array($res);
    $returnval = CFG_SITE_URL.'post.php'.$iisbug.'/'.$post['next_post_id'];
    #  echo $returnval;
    return ($returnval);
    }


function mod_prevnext_post_prev($post_id) {
    if (CFG_USE_PATH_INFO == 'no'){
      $iisbug = '?';
    }else{
      $iisbug = '';
    }
    
    $query = "
            select      p.post_id as prev_post_id
            from        ".CFG_MYSQL_TABPREFIX."posts p
            where       p.post_id < '".$post_id."'
            order by    p.post_id desc limit 1;
            ";
    $res = mysql_query($query);
   
    if (!$res || !mysql_num_rows($res)){
        return (false);
    }
    
    $post = mysql_fetch_array($res); 
    $returnval = CFG_SITE_URL.'post.php'.$iisbug.'/'.$post['prev_post_id'];
    # echo $returnval;
    return ($returnval);
}




?>