Buy Now
Sign in

Number of comments in article view ?

Lkark , March 12 2009
L
Lkark
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).
admin
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
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
L
Lkark
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?
admin
add this line at the top of the code:

$database =& JFactory::getDBO();
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
L
Lkark
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?
admin
i think {pageid} will do this

Max
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
L
Lkark
Oh, thanks, I must have missed that one :p. Thank you!