[pLog-svn] r526 - plog/trunk/class/summary/dao

subaochen at devel.plogworld.net subaochen at devel.plogworld.net
Fri Dec 17 16:21:07 GMT 2004


Author: subaochen
Date: 2004-12-17 16:21:06 +0000 (Fri, 17 Dec 2004)
New Revision: 526

Modified:
   plog/trunk/class/summary/dao/summarystats.class.php
Log:
fix getMostActiveBlogs: check blog status to only show the active blogs


Modified: plog/trunk/class/summary/dao/summarystats.class.php
===================================================================
--- plog/trunk/class/summary/dao/summarystats.class.php	2004-12-17 15:35:29 UTC (rev 525)
+++ plog/trunk/class/summary/dao/summarystats.class.php	2004-12-17 16:21:06 UTC (rev 526)
@@ -254,8 +254,9 @@
 			$prefix = $this->getPrefix();
             $query = "SELECT COUNT(*) as t, SUM((num_reads / (TO_DAYS(NOW()) - TO_DAYS(a.date) + 1)) ) as rank, b.*
                        FROM {$prefix}articles AS a
-                       INNER JOIN {$prefix}blogs AS b ON b.id=a.blog_id
-                       GROUP BY a.blog_id ORDER BY rank DESC ";
+                       INNER JOIN {$prefix}blogs AS b 
+                           ON b.id=a.blog_id AND b.status=".BLOG_STATUS_ACTIVE.
+                       " GROUP BY a.blog_id ORDER BY rank DESC ";
 
             if( $maxBlogs > 0 )
                 $query .= " LIMIT 0,".$maxBlogs;




More information about the pLog-svn mailing list