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

oscar at devel.lifetype.net oscar at devel.lifetype.net
Thu Jan 12 23:07:02 GMT 2006


Author: oscar
Date: 2006-01-12 23:07:02 +0000 (Thu, 12 Jan 2006)
New Revision: 2783

Modified:
   plog/trunk/class/dao/articles.class.php
Log:
small issue with some fields being missing


Modified: plog/trunk/class/dao/articles.class.php
===================================================================
--- plog/trunk/class/dao/articles.class.php	2006-01-12 23:01:00 UTC (rev 2782)
+++ plog/trunk/class/dao/articles.class.php	2006-01-12 23:07:02 UTC (rev 2783)
@@ -472,7 +472,12 @@
 		    $where = $this->buildWhere( $blogId, $date, $amount, $categoryId, $status, $userId, $maxDate, $searchTerms );
             $query = "SELECT a.id as id, a.id, a.date,
                              a.user_id,a.blog_id,a.status,a.properties,
-                             a.num_reads, a.slug, 1 AS relevance FROM {$prefix}articles a, {$prefix}articles_categories c, 
+                             a.num_reads, a.slug, 1 AS relevance, a.num_comments AS num_comments,
+							 a.num_nonspam_comments AS num_nonspam_comments, a.num_trackbacks AS num_trackbacks,
+							 a.num_nonspam_trackbacks AS num_nonspam_trackbacks, 
+							 a.global_category_id AS global_category_id,
+							 a.in_summary_page AS in_summary_page
+							 FROM {$prefix}articles a, {$prefix}articles_categories c, 
                              {$prefix}article_categories_link l";
 			if( $searchTerms != "" )
 				$query .= ", {$prefix}articles_text t ";
@@ -1172,6 +1177,7 @@
 			$article->setUserInfo( $this->users->getUserInfoFromId( $query_result['user_id'] ));*/
 			
 			// counters
+			print_r($query_result);
 			$article->setTotalComments( $query_result['num_comments'] );
 			$article->setNumComments( $query_result['num_nonspam_comments'] );
 			$article->setNumTrackbacks( $query_result['num_nonspam_trackbacks'] );



More information about the pLog-svn mailing list