[pLog-svn] r4654 - plog/branches/lifetype-1.1.5/class/summary/dao

[oscar at devel.lifetype.net]

Author: oscar
Date: 2007-02-01 15:26:14 -0500 (Thu, 01 Feb 2007)
New Revision: 4654

Modified:
   plog/branches/lifetype-1.1.5/class/summary/dao/summarystats.class.php
Log:
Applied Jordi's suggestion for the most recent blogs, which works good enough according to Elena's feedback. Thanks guys! :)

Modified: plog/branches/lifetype-1.1.5/class/summary/dao/summarystats.class.php
===================================================================
--- plog/branches/lifetype-1.1.5/class/summary/dao/summarystats.class.php	2007-02-01 15:01:32 UTC (rev 4653)
+++ plog/branches/lifetype-1.1.5/class/summary/dao/summarystats.class.php	2007-02-01 20:26:14 UTC (rev 4654)
@@ -179,15 +179,18 @@
 			include_once( PLOG_CLASS_PATH."class/dao/blogs.class.php" );
 		 
 			$prefix = $this->getPrefix();
-            $query = "SELECT COUNT(a.id) as t, SUM((num_reads / (TO_DAYS(NOW()) - TO_DAYS(a.date) + 1)) ) as rank, b.id AS blog_id
-                      FROM {$prefix}articles AS a
-                      INNER JOIN {$prefix}blogs AS b 
-                      ON b.id = a.blog_id AND b.status = ".BLOG_STATUS_ACTIVE."
-                      WHERE a.date >= ".$this->_startTime." AND a.date <= ".$this->_now." 
-					  AND in_summary_page = '1' 
-					  AND b.show_in_summary = '1'
-					  GROUP BY a.id
-                      ORDER BY rank DESC";
+			
+			$query = "SELECT SUM(((a.num_reads + a.num_comments/5) / (TO_DAYS(NOW()) - TO_DAYS(a.date) + 1)) )/COUNT(a.id) as rank,
+			           b.id AS blog_id
+			           FROM {$prefix}articles AS a
+			           INNER JOIN {$prefix}blogs AS b
+			           ON b.id = a.blog_id AND b.status =  ".BLOG_STATUS_ACTIVE."
+                       WHERE a.date >= ".$this->_startTime." 
+                       AND a.date <= ".$this->_now."
+					   AND a.in_summary_page = '1'
+			           AND b.show_in_summary = '1'
+			           GROUP BY b.id
+			           ORDER BY rank DESC";			
 
             if( $maxBlogs > 0 )
             	$query .= " LIMIT 0,".$maxBlogs;