[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