function getRecentArticles return also "welcome" a

function getRecentArticles return also "welcome" a

Postby hierro on Thu Jun 14, 2007 10:03 am

Hi, I think that the function getRecentArticles used in the blog home must return only the articles writed from the user and not the automatic welcome article.

The modification to do is the following:
In the class/summary/dao/summarystats.class.php change the query in this way (row 232):
Code: Select all
         $query = "SELECT a.id AS id, a.blog_id AS blog_id
                 FROM {$prefix}articles a,
                      {$prefix}blogs b
                 WHERE a.date >= ".$this->_startTime." AND a.date <= ".$this->_now."
                       AND a.blog_id = b.id
                       AND b.status = ".BLOG_STATUS_ACTIVE."
                       AND a.slug not like 'welcome'
                       AND a.status = ".POST_STATUS_PUBLISHED."
                     AND b.show_in_summary = '1'
                     AND a.in_summary_page = '1'";
hierro
 
Posts: 54
Joined: Tue Feb 14, 2006 6:49 am

Return to LifeType 2.0 Development

cron