Forums

Hi there😉,

I just wonder how I get the number of comments in the article view (in the comment-form.html.php, to be precise).

Hi Lkark,

the code is available in plugins/content/chronocomments.php

you can just copy and paste, but here its:

$query = "SELECT * FROM #__chrono_comments WHERE component = '".JRequest::getVar('option')."' AND pageid= '".$pageid."' AND published='1' AND verify='1' ORDER BY datetime ASC";
				$database->setQuery( $query );
				$blogcomments = $database->loadObjectList();
echo count($blogcomments);

Cheers
Max

That ends up with and fatal error:


Fatal error: Call to a member function setQuery() on a non-object in public_html/components/com_chronocomments/templates/comment-form.html.php on line 7

And line # 7 in my case is:
$database->setQuery( $query );

Do you think you can solve that?🙂

add this line at the top of the code:

$database =& JFactory::getDBO();

Thank you so much!🙂

Btw, can I ask you if it's possible to load the latest comment's aritcle's id in the mod_chronocomments?

i think {pageid} will do this😉

Max

Oh, thanks, I must have missed that one :p. Thank you!🙂