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

[oscar at devel.lifetype.net]

Author: oscar
Date: 2006-05-13 15:53:53 +0000 (Sat, 13 May 2006)
New Revision: 3403

Modified:
   plog/trunk/class/summary/dao/summarystats.class.php
Log:
we can restrict the list of newest blogs to only the last 7 days. It should look more dynamic, and it will require less load in the database


Modified: plog/trunk/class/summary/dao/summarystats.class.php
===================================================================
--- plog/trunk/class/summary/dao/summarystats.class.php	2006-05-13 15:38:44 UTC (rev 3402)
+++ plog/trunk/class/summary/dao/summarystats.class.php	2006-05-13 15:53:53 UTC (rev 3403)
@@ -164,7 +164,8 @@
 			          FROM ".$this->getPrefix()."blogs 
 					  WHERE status = ".BLOG_STATUS_ACTIVE." 
 					  AND show_in_summary = '1'
-					  ORDER BY id DESC";
+					  AND create_date > ".$this->_sevenDaysAgo."
+					  ORDER BY create_date DESC";
 
             if( $maxBlogs > 0 )
             	$query .= " LIMIT 0,".$maxBlogs;