[pLog-svn] r1573 - plog/trunk/class/dao

[oscar at devel.plogworld.net]

Author: oscar
Date: 2005-03-22 16:01:59 +0000 (Tue, 22 Mar 2005)
New Revision: 1573

Modified:
   plog/trunk/class/dao/articles.class.php
Log:
fixed issue http://bugs.plogworld.net/view.php?id=367. In fact, the way I built
the Articles::getNumArticles() method is plain embarrassing... In fact this
fix is just a hack on top of an already hackish method but we've got no time
to find a better solution. Perhaps in next release :)


Modified: plog/trunk/class/dao/articles.class.php
===================================================================
--- plog/trunk/class/dao/articles.class.php	2005-03-22 10:10:56 UTC (rev 1572)
+++ plog/trunk/class/dao/articles.class.php	2005-03-22 16:01:59 UTC (rev 1573)
@@ -309,6 +309,9 @@
 				$query .= "WHERE t.article_id = a.id AND $where";
 			else
 				$query .= " WHERE $where";			
+				
+			if( $categoryId != -1 )
+				$query .= " GROUP BY a.id";
                                                                       
             $result = $this->_db->Execute( $query );