[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