Help with code: Comments in frontpage

Friday 02 January 2004 11:05:08 am

Im trying to make all the comments to shwo up in the frontpage of my site:

- The idea is to show them sorted by published date.
- The name of the news of wich the comment is made is shown.
- If there is a news with more then 1 comment, it will show only one, the most recent comment.

This is the code:
{let comment_parent_array=array(0) comment_list=fetch(content,list,hash(parent_node_id,2,limit,6,depth,5,sort_by,array(published,false()),class_filter_type,include,class_filter_array,array('comment')))}
{section name=Comment loop=$comment_list}
{section show=not($comment_parent_array|contains($Comment:item.id)) comment_parent_array=$comment_parent_array|insert($Comment:item.id)}
{node_view_gui view=line content_node=$Comment:item}
{/section}
{/section}
{/let}

line_view_comment:
{let ParentNode=fetch(content,node,hash(node_id,$node.parent_node_id))}
<div class="small">{$node.object.published|datetime(custom,"%H:%i")} <a class="small" href={$ParentNode.url_alias|ezurl}>{$ParentNode.object.name|upfirst|shorten(20)}</a></div>

So 1 and 2 is accomplished but the last part I don't know how to do it.
Do you have some ideas?

-Shurbann

Saturday 03 January 2004 4:14:10 am

Hi,

well, i didn't completely understand the code:
{let comment_parent_array=array(0) comment_list=fetch(content,list,hash(parent_node_id,2,limit,6,depth,5,sort_by,array(published,false()),class_filter_type,include,class_filter_array,array('comment')))}
{section name=Comment loop=$comment_list}
{section show=not($comment_parent_array|contains($Comment:item.id)) comment_parent_array=$comment_parent_array|insert($Comment:item.id)}
[..]
What is $comment_parent_array used for? You want to store the IDs of the articles in the array and check, if and ID already exists?
Nice idea :)

But you say, it does not work.
First, I thought "use max=1 in the loop", so you will get only one comment. But you seem to fetch all commments with one single fetch.
Then, maybe you should try something like this (pseudo-code ;) )
Fetch all articles
section loop=article
fetch all comments, where the current article is parent node, sorted by date
section loop=comments, max=1 show=comments
print comment with parent node name
/section
/section

This might work, but the drawback is, that you need LOTS of DB fetches.

Marco
http://www.hyperroad-design.com