[pLog-CVS] plog/class/dao summarystats.class.php,1.1.2.1,1.1.2.2

[Oscar R. <phu...@us...>]

Update of /cvsroot/plog/plog/class/dao
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28234/class/dao

Modified Files:
      Tag: PLOG_0_3_2_DEVEL
	summarystats.class.php 
Log Message:
a couple of improvements


Index: summarystats.class.php
===================================================================
RCS file: /cvsroot/plog/plog/class/dao/Attic/summarystats.class.php,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -C2 -d -r1.1.2.1 -r1.1.2.2
*** summarystats.class.php	14 Jun 2004 19:51:59 -0000	1.1.2.1
--- summarystats.class.php	19 Jun 2004 14:51:32 -0000	1.1.2.2
***************
*** 26,29 ****
--- 26,31 ----
              $config = Config::getConfig();
              $this->_useCache = $config->getValue( "summary_use_cache" );
+             
+             $this->_db->debug=true;
          }
  
***************
*** 37,44 ****
          {
  			$query = " SELECT COUNT(*) as total_comments, a.* FROM ".$this->getPrefix()."articles_comments AS c "
! 			       . " INNER JOIN ".$this->getPrefix()."articles AS a ON c.article_id=a.id WHERE a.status = 'PUBLISHED' ";
! 				   
              if( $date > 0 )
!             	$query .= " AND c.date > '$date'";
  
              $query .= "GROUP BY c.article_id ORDER BY total_comments DESC ";
--- 39,46 ----
          {
  			$query = " SELECT COUNT(*) as total_comments, a.* FROM ".$this->getPrefix()."articles_comments AS c "
! 			       . " INNER JOIN ".$this->getPrefix()."articles AS a ON c.article_id=a.id WHERE a.status = 'PUBLISHED' ";
! 
              if( $date > 0 )
!                 	$query .= " AND date_format(c.date,'%Y%m%d') > $date ";
  
              $query .= "GROUP BY c.article_id ORDER BY total_comments DESC ";
***************
*** 75,79 ****
  				   
              if( $date > 0 )
!             	$query .= " AND date > '$date'";
  
              $query .= " ORDER BY num_reads DESC ";
--- 77,81 ----
  				   
              if( $date > 0 )
!                 	$query .= " AND date_format(date,'%Y%m%d') > $date";
  
              $query .= " ORDER BY num_reads DESC ";
***************
*** 238,242 ****
  				   
              if( $date > 0 )
!             	$query .= " WHERE a.date > '$date'";		
  				   
  			$query .= " GROUP BY a.blog_id ORDER BY posts DESC ";
--- 240,244 ----
  				   
              if( $date > 0 )
!                 $query .= " AND date_format(a.date,'%Y%m%d') > $date";	
  				   
  			$query .= " GROUP BY a.blog_id ORDER BY posts DESC ";