[pLog-svn] r1002 - plog/trunk/class/dao
ork at devel.plogworld.net
ork at devel.plogworld.net
Tue Feb 8 15:08:59 GMT 2005
Author: ork
Date: 2005-02-08 15:08:59 +0000 (Tue, 08 Feb 2005)
New Revision: 1002
Modified:
plog/trunk/class/dao/articlecategories.class.php
Log:
added description to the query as it is passed as a parameter later on
Modified: plog/trunk/class/dao/articlecategories.class.php
===================================================================
--- plog/trunk/class/dao/articlecategories.class.php 2005-02-08 15:03:24 UTC (rev 1001)
+++ plog/trunk/class/dao/articlecategories.class.php 2005-02-08 15:08:59 UTC (rev 1002)
@@ -201,7 +201,7 @@
$prefix = $this->getPrefix();
$query = "SELECT c.id AS id, c.name AS name, c.url AS url, c.blog_id AS blog_id,
c.last_modification AS last_modification, c.in_main_page AS in_main_page,
- c.parent_id AS parent_id, c.properties AS properties,
+ c.parent_id AS parent_id, c.properties AS properties, c.description AS description,
c.mangled_name AS mangled_name, IF(a.id IS NULL, 0, COUNT(*)) AS num_articles, a.date AS last_update
FROM {$prefix}articles_categories c LEFT JOIN {$prefix}article_categories_link l
ON c.id=l.category_id LEFT JOIN {$prefix}articles a ON a.id = l.article_id
@@ -487,4 +487,4 @@
return( $total );
}
}
-?>
\ No newline at end of file
+?>
More information about the pLog-svn
mailing list