[pLog-CVS] plog/class/dao articles.class.php,1.24,1.24.2.1

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

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

Modified Files:
      Tag: PLOG_0_3_2_DEVEL
	articles.class.php 
Log Message:
fixed an incompatibility with mysql 4.1, due to a change that the development team
introduced in mysql 4.1 (timestamp type is not returned as a number anymore...)


Index: articles.class.php
===================================================================
RCS file: /cvsroot/plog/plog/class/dao/articles.class.php,v
retrieving revision 1.24
retrieving revision 1.24.2.1
diff -C2 -d -r1.24 -r1.24.2.1
*** articles.class.php	15 Apr 2004 18:18:53 -0000	1.24
--- articles.class.php	24 Apr 2004 21:18:36 -0000	1.24.2.1
***************
*** 191,195 ****
                        WHERE a.blog_id = $blogid";
              if( $date != -1 )
!             	$query .= " AND a.date LIKE '$date%'";
  
              // the common part "c.id = a.category_id" is needed so that
--- 191,195 ----
                        WHERE a.blog_id = $blogid";
              if( $date != -1 )
!             	$query .= " AND a.date+0 LIKE '$date%'";
  
              // the common part "c.id = a.category_id" is needed so that
***************
*** 469,473 ****
          function getPostsPerDay( $blogId, $daystamp )
  		{
! 			$query = "SELECT * FROM ".$this->getPrefix()."articles WHERE blog_id = ".$blogId." AND date LIKE '".$daystamp."%' ORDER BY date DESC;";
  
  			$result = $this->_db->Execute( $query );
--- 469,473 ----
          function getPostsPerDay( $blogId, $daystamp )
  		{
! 			$query = "SELECT * FROM ".$this->getPrefix()."articles WHERE blog_id = ".$blogId." AND date+0 LIKE '".$daystamp."%' ORDER BY date DESC;";
  
  			$result = $this->_db->Execute( $query );