[support] Determine if comments have replies
Cameron B. Prince
cplists at teslauniverse.com
Fri Feb 17 05:44:44 UTC 2012
After much trial and error (and temptation to edit comments.module), I was
able to figure out how to determine if comments have replies without
additional queries. Since the theme_preprocess_comment function runs per
comment and does not have access to the entire array of comments, the code
must be placed in theme_preprocess_node as follows:
function theme_preprocess_node(&$vars) {
$keys = array_keys($vars['elements']['comments']['comments']);
foreach ($keys as $k) {
if (!is_numeric($k)) {
continue;
}
$pid = $vars['elements']['comments']['comments'][$k]['#comment']->pid;
$vars['elements']['comments']['comments'][$pid]['#comment']->has_children =
!empty($pid);
$last = $k;
}
$vars['elements']['comments']['comments'][$last]['#comment']->last = TRUE;
}
The last line before closing the function adds an additional flag ³last² to
the comments array on the final comment in the array.
Cameron
On 2/16/12 12:10 AM, "Cameron B. Prince" <cplists at teslauniverse.com> wrote:
> I have a need to determine if comments have replies. This is what I've come
> up with to make this determination, but I would rather find a way that
> doesn't require an additional database query per comment.
>
> function theme_preprocess_comment(&$variables) {
> $comment = $variables['elements']['#comment'];
> $count = db_query('SELECT COUNT(*) FROM {comment} WHERE pid = :cid',
> array(':cid' => $comment->cid))->fetchField();
> $comment->has_children = !empty($count);
> }
>
> I can see that theme_preprocess_node has access to the entire array of
> comments in its $variables argument when displaying it with print_r. The
> issue is I can't seem to figure out how to loop over the comments so that I
> could check for a value in the pid field and add a has_children => TRUE to
> the parent comment's array.
>
> Can someone point me in the right direction?
>
> Thanks,
> cameronbprince
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120216/7ce1ffa3/attachment.html
More information about the support
mailing list