[pLog-svn] r2507 - plog/branches/plog-1.0.2/class/summary/dao
jondaley at devel.plogworld.net
jondaley at devel.plogworld.net
Wed Sep 21 23:45:55 GMT 2005
Author: jondaley
Date: 2005-09-21 23:45:54 +0000 (Wed, 21 Sep 2005)
New Revision: 2507
Modified:
plog/branches/plog-1.0.2/class/summary/dao/summarystats.class.php
Log:
most read articles needs to check whether the blog is active
Modified: plog/branches/plog-1.0.2/class/summary/dao/summarystats.class.php
===================================================================
--- plog/branches/plog-1.0.2/class/summary/dao/summarystats.class.php 2005-09-21 19:53:30 UTC (rev 2506)
+++ plog/branches/plog-1.0.2/class/summary/dao/summarystats.class.php 2005-09-21 23:45:54 UTC (rev 2507)
@@ -112,8 +112,9 @@
a.status as status,
a.num_reads as num_reads,
a.slug as slug
- FROM {$prefix}articles a
- WHERE status = ".POST_STATUS_PUBLISHED."
+ FROM {$prefix}articles a, {$prefix}blogs b
+ WHERE a.status = ".POST_STATUS_PUBLISHED."
+ AND a.blog_id = b.id AND b.status = ".BLOG_STATUS_ACTIVE."
AND a.date <= ".$this->_now." AND a.date > ".$this->_sevenDaysAgo;
$query .= " ORDER BY a.num_reads DESC ";
More information about the pLog-svn
mailing list