[pLog-svn] r1761 - plog/branches/plog-1.0.1/class/summary/dao

[oscar at devel.plogworld.net]

Author: oscar
Date: 2005-04-05 22:03:34 +0000 (Tue, 05 Apr 2005)
New Revision: 1761

Modified:
   plog/branches/plog-1.0.1/class/summary/dao/summarystats.class.php
Log:
fixed issue 402 (http://bugs.plogworld.net/view.php?id=402)

Modified: plog/branches/plog-1.0.1/class/summary/dao/summarystats.class.php
===================================================================
--- plog/branches/plog-1.0.1/class/summary/dao/summarystats.class.php	2005-04-05 21:57:26 UTC (rev 1760)
+++ plog/branches/plog-1.0.1/class/summary/dao/summarystats.class.php	2005-04-05 22:03:34 UTC (rev 1761)
@@ -47,7 +47,8 @@
        				         AND a.status = ".POST_STATUS_PUBLISHED." 
        				         AND c.status = ".COMMENT_STATUS_NONSPAM."
        				         AND b.id = a.blog_id
-       				         AND b.status = ".BLOG_STATUS_ACTIVE;
+       				         AND b.status = ".BLOG_STATUS_ACTIVE."
+       				         AND a.date <= NOW()";
 
 			// ignore certain topics and/or certain texts
 			/*if( $ignoreTopic != "" )
@@ -268,7 +269,8 @@
 					        AND c.in_main_page = 1 
 					        AND a.blog_id = b.id
 					        AND b.status = ".BLOG_STATUS_ACTIVE."
-					        AND a.status = ".POST_STATUS_PUBLISHED;
+					        AND a.status = ".POST_STATUS_PUBLISHED."
+					        AND a.date < NOW()";
 
 
 			// in case we'd like to ignore certain posts based on a topic (like the registration message!)