Buy Now
Sign in

Number of comments in article view ?

Lkark , March 12 2009, 15:20
L
Lkark 6
March 12 2009, 15:20 #26214
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 33
March 13 2009, 07:32 #26268
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
L
Lkark 6
March 13 2009, 13:22 #26299
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 33
March 13 2009, 15:11 #26316
add this line at the top of the code:

$database =& JFactory::getDBO();
L
Lkark 6
March 13 2009, 15:36 #26327
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 33
March 13 2009, 23:34 #26390
i think {pageid} will do this

Max
L
Lkark 6
March 14 2009, 20:21 #26468
Oh, thanks, I must have missed that one :p. Thank you!