1. JonusC
  2. Newbies area
  3. Monday, 15 June 2009
  4.  Subscribe via email
Hello again.... :blush:

This one shows how many comments there are in total on the title bar. I think it's especially nice to have if you don't like the extended-info for the "Read More..." button. Here's a screenshot:

[img size=380]http://compojoom.com/components/com_agora/img/members/1866/jocomment_totalmod.png[/img]

Here's the code changes. On line 1860 of comment.class.php...
$html 		= str_replace('{_JOOMLACOMMENT_COMMENTS_TITLE}', _JOOMLACOMMENT_COMMENTS_TITLE, $this->_menu);

...comment that out with // and below that insert this code block...
/* Hack by JonusC - get the total number of comments */
$database =& JFactory::getDBO();
$com = $this->_component;
$query = "SELECT COUNT(*) FROM jos_comment WHERE contentid='$this->_content_id' AND component='$com' AND published='1'";
$database->SetQuery($query);
$number = $database->loadResult();
$html = str_replace('{_JOOMLACOMMENT_COMMENTS_TITLE}', _JOOMLACOMMENT_COMMENTS_TITLE." (".$number." total)", $this->_menu);

...thats it.

I don't know if that code is very good... i'm only new to this PHP language, but it shouldn't slow down the site much I hope...

Daniel, I also wanted to add a feature of showing "Oldest First" or "Newest First" in the Comment title, but for some reason the if ($this->_sort_downward) statement always returned false no matter what :blink: I have no idea why, could it be a bug or....... :unsure: here was the alternate code I was trying to use...
if ($this->_sort_downward) {
$html = str_replace('{_JOOMLACOMMENT_COMMENTS_TITLE}', _JOOMLACOMMENT_COMMENTS_TITLE." (".$number." total, newest first)", $this->_menu);
} else {
$html = str_replace('{_JOOMLACOMMENT_COMMENTS_TITLE}', _JOOMLACOMMENT_COMMENTS_TITLE." (".$number." total, oldest first)", $this->_menu);
}

...but it was always returning the 'oldest first' one, no matter what setting I had in Comments sorting. Is this because I have nested comments turned on?
Responses (2)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Is Ccomment still alive?
Is Ccomment still being supported? It's time for my Pro renewal but I haven't se...
0 Replies
Posted on Thursday, 14 August 2025
  • New
  • Anzeige von mehrtägigen Events auf Buchungsseite
    We have been using Matukio for quite some time now. Unfortunately, we have been ...
    3 Replies
    Posted on Sunday, 03 August 2025
    Assistance Needed – Error When Posting Comments
    Hello, I’m experiencing an issue when trying to submit a comment on my site u...
    0 Replies
    Posted on Sunday, 10 August 2025
  • New
  • Hotspots Pro 6.0.13 compatability with Joomla 5.3.
    Running Hotspots Pro 6.0.13 on Joomla 4.4.13 and want to upgrade to Joomla 5.3.1...
    2 Replies
    Posted on Friday, 04 July 2025
    some questions on Hotspots
    Hi, On Hotspots extension : 1) is it possible to add our own map layer / v...
    0 Replies
    Posted on Thursday, 03 July 2025