Ionize - Free & Open Source creative CMS

[eluser]Kip zonder Kop[/eluser]
In the page controller I added the following code:

Code:

// Next article complete URL
         $article['next_url'] = '';
         $next = $this->article_model->get_adjacent_article($article,'next');
         if (isset($next['name']))
         {        
               $article['next_url'] = base_url() . Settings::get_lang() . '/' . $this->page['name'] . '/' . $next['name'];
         }
            
         // Previous article complete URL            
         $article['previous_url'] = '';
         $previous = $this->article_model->get_adjacent_article($article,'previous');
         if (isset($previous['name']))
         {        
               $article['previous_url'] = base_url() . Settings::get_lang() . '/' . $this->page['name'] . '/' . $previous['name'];
         }

In the article_model I added the following code:

Code:

function get_adjacent_article($current,$adjacent)
   {      
       if ($adjacent == 'previous')
       {
          $this->db->select_max('ordering');
          $this->db->where('ordering <', $current['ordering']);
       }
       else
       {
          $this->db->select_min('ordering');
          $this->db->where('ordering >', $current['ordering']);
       }
      
       $this->db->select('name');
       $this->db->where('online', '1');    
       $this->db->where('id_page', $current['id_page']);
       $this->db->where('((publish_off > ', 'now()', false);
       $this->db->or_where('publish_off = ', '0)' , false);  
       $this->db->where('(publish_on < ', 'now()', false);
       $this->db->or_where('publish_on = ', '0))' , false);
        
       $query = $this->db->get($this->table);
       if ($query->num_rows() > 0)
       {
         return $query->row_array();
       }
       return $false;              
   }

Now in my article templates I can use 2 additional tags:

Code:

<ion:previous_url />
<ion:next_url />

to create url's pointing to the next and previous published article.
I'd like to have something like this to the system to enable easier navigation from one article to the other. Tell me what you think.