Index: openacs.org-dev/www/templates/homepage-index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/www/templates/homepage-index.tcl,v diff -u -r1.12 -r1.13 --- openacs.org-dev/www/templates/homepage-index.tcl 2 Aug 2002 16:16:32 -0000 1.12 +++ openacs.org-dev/www/templates/homepage-index.tcl 2 Aug 2002 16:59:43 -0000 1.13 @@ -88,19 +88,19 @@ select fm.message_id, fm.subject as title, - fm.user_id, +-- fm.user_id, fm.forum_id, - person__name(fm.user_id) as user_name, - fm.posting_date, - forums_forum__name(fm.forum_id) as forum_name, - to_char(posting_date,'MM/DD/YY') as sent_date_no_time, - to_char(posting_date,'HH24:MM') as sent_time, +-- person__name(fm.user_id) as user_name, +-- fm.posting_date, + forums_forum__name(fm.forum_id) as forum_name +-- to_char(posting_date,'MM/DD/YY') as sent_date_no_time, +-- to_char(posting_date,'HH24:MM') as sent_time, -- to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified - (select count(*) - from forums_messages_approved fm1 - where fm1.forum_id = fm.forum_id - and fm1.tree_sortkey between tree_left(fm.tree_sortkey) and tree_right(fm.tree_sortkey)) as n_messages +-- (select count(*) +-- from forums_messages_approved fm1 +-- where fm1.forum_id = fm.forum_id +-- and fm1.tree_sortkey between tree_left(fm.tree_sortkey) and tree_right(fm.tree_sortkey)) as n_messages from forums_messages_approved fm , forums_forums ff