Просмотр Смотреть все комментарии участника
Ссылка на страницу, где {segment_3} будет id участника
Еще один способ взят отсюда: http://expressionengine.com/wiki/Display_Comments_by_Member/
Раздел:Комментарии
Раздел:Советы
{exp:query sql="SELECT name FROM exp_comments
WHERE exp_comments.author_id = '{segment_3}' LIMIT 1"} Комментарии {name}{/exp:query
{exp:query limit="10" sql="SELECT exp_comments.weblog_id AS www, url_title, name, comment_id,
comment_date, comment AS ccc, title AS ttt
FROM exp_comments, exp_weblog_titles
WHERE exp_comments.entry_id = exp_weblog_titles.entry_id
AND exp_comments.author_id = '{segment_3}'
ORDER BY comment_id DESC"}
<table width="100%" border="0" cellspacing="10" cellpadding="0">
<tr>
<td width="50%" valign="top"><div class="comment"><a href="/site/comments/{url_title}/#comment-{comment_id}">{ttt}</a><br>
{ccc}</div>
<div align="right" class="short">Автор: {name} / {comment_date format='%d.%m.%Y, %H:%i'} </div>
<br></td>
</tr>
</table>
{paginate}
<table width="100%" border="0" cellspacing="10" cellpadding="0">
<tr>
<td width="50%" valign="top"><div class="comment"> <span class="pagecount"> {pagination_links}</span> <br>
</div></td>
</tr>
</table>
{/paginate}
{/exp:query}
Еще один способ взят отсюда: http://expressionengine.com/wiki/Display_Comments_by_Member/
<ul>
{exp:query sql="SELECT
member_id, screen_name AS s_name,
avatar_filename, author_id,
comment, comment_date,
title, t.entry_id,
url_title
FROM exp_members m
LEFT JOIN exp_comments c
ON m.member_id = c.author_id
AND c.comment_date =
( SELECT MAX(comment_date)
FROM exp_comments
WHERE author_id = m.member_id )
LEFT JOIN exp_weblog_titles t
ON c.entry_id = t.entry_id
GROUP BY member_id
ORDER BY join_date, comment_date DESC LIMIT 50"}
<li><h2>{s_name}</h2>
{if avatar_filename ==""}
<a href="path_to_profile"><img src="path_to_placeholder" alt="" /></a><br />
{if:else}
<a href="path_to_profile"><img src="path_to_avatar" /></a><br />
{/if}
{if comment}
<b>Title: <a href="/index.php/template_group/template/{url_title}">{title}</a></b><br />
Last commented: {comment_date format="%D, %F %d, %Y - %g:%i%a"}<br />
{comment}
</li>{if:else}
This users has not contributed any comments</li>{/if}
{/exp:query}
</ul>
Раздел:Комментарии
Раздел:Советы