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

oscar at devel.plogworld.net oscar at devel.plogworld.net
Tue Feb 8 22:41:10 GMT 2005


Author: oscar
Date: 2005-02-08 22:41:09 +0000 (Tue, 08 Feb 2005)
New Revision: 1011

Modified:
   plog/trunk/class/summary/dao/summarystats.class.php
Log:
possibly fixed issue 230 (http://bugs.plogworld.net/view.php?id=230)

Modified: plog/trunk/class/summary/dao/summarystats.class.php
===================================================================
--- plog/trunk/class/summary/dao/summarystats.class.php	2005-02-08 22:21:39 UTC (rev 1010)
+++ plog/trunk/class/summary/dao/summarystats.class.php	2005-02-08 22:41:09 UTC (rev 1011)
@@ -4,6 +4,7 @@
     include_once( PLOG_CLASS_PATH."class/dao/articles.class.php" );
     include_once( PLOG_CLASS_PATH."class/dao/blogs.class.php" );
 	include_once( PLOG_CLASS_PATH."class/dao/users.class.php" );
+	include_once( PLOG_CLASS_PATH."class/dao/articlecommentstatus.class.php" );
 	
 	/**
 	 * maximum number of items that will be shown per page in the summary
@@ -38,7 +39,9 @@
 			$prefix = $this->getPrefix();
 			$query = " SELECT COUNT(*) as total_comments, a.* 
 					   FROM {$prefix}articles_comments AS c, {$prefix}articles AS a, {$prefix}articles_text t
-       				   WHERE c.article_id = a.id AND t.article_id = a.id AND a.status = ".POST_STATUS_PUBLISHED;
+       				   WHERE c.article_id = a.id AND t.article_id = a.id AND 
+					         a.status = ".POST_STATUS_PUBLISHED." AND
+							 c.status = ".COMMENT_STATUS_NONSPAM;
 
 			// ignore certain topics and/or certain texts
 			if( $ignoreTopic != "" )




More information about the pLog-svn mailing list