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 27
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
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 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 27
March 13 2009, 15:11 #26316
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 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 27
March 13 2009, 23:34 #26390
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 6
March 14 2009, 20:21 #26468
Oh, thanks, I must have missed that one :p. Thank you!