From 74a3c3a72caa9fae5ca3cddd005c1e8c160e792c Mon Sep 17 00:00:00 2001 From: "bitweaver.org" Date: Mon, 5 Jun 2006 23:54:05 +0000 Subject: get created date of members so things like blog posts can auto-generate a title --- Pigeonholes.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'Pigeonholes.php') diff --git a/Pigeonholes.php b/Pigeonholes.php index 7f9654c..a16c054 100644 --- a/Pigeonholes.php +++ b/Pigeonholes.php @@ -1,6 +1,6 @@ - * @version $Revision: 1.60 $ + * @version $Revision: 1.61 $ * @package pigeonholes */ @@ -133,7 +133,7 @@ class Pigeonholes extends LibertyContent { $order = "ORDER BY lc.`content_type_guid`, lc.`title` ASC"; $ret = array(); - $query = "SELECT pigm.*, lc.`content_id`, tct.`content_description`, lc.`last_modified`, lc.`user_id`, lc.`title`, lc.`content_type_guid`, uu.`login`, uu.`real_name` + $query = "SELECT pigm.*, lc.`content_id`, tct.`content_description`, lc.`last_modified`, lc.`user_id`, lc.`title`, lc.`content_type_guid`, lc.`created`, uu.`login`, uu.`real_name` FROM `".BIT_DB_PREFIX."pigeonhole_members` pigm INNER JOIN `".BIT_DB_PREFIX."pigeonholes` pig ON ( pig.`content_id` = pigm.`parent_id` ) INNER JOIN `".BIT_DB_PREFIX."liberty_content` lc ON ( lc.`content_id` = pigm.`content_id` ) -- cgit v1.3