[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