JComments counter in category-view

mcmurdok
Topic Author
Offline
Senior Member

13 years 1 month ago #23184 by mcmurdok

JComments counter in category-view was created by mcmurdok

Is there any possibility to show the number of JComments of an item in the category-view like it is standard in combination com_content and JComment? Or have I to wait for a special field-plugin
System: Joomla 2.5.x, FLEXIContent - 2.0 - preRC3 r1110

Regards

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

13 years 1 month ago #23188 by micker

Replied by micker on topic JComments counter in category-view

a solution is in forum do usse search ?

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

domich
Offline
New Member

13 years 1 week ago #24359 by domich

Replied by domich on topic JComments counter in category-view

Hi there,

I´ve the same problem, but can´t find a solution in the forum. Can you post here the link?

regards

Please Log in or Create an account to join the conversation.

denniskobus
Offline
Junior Member

12 years 5 months ago #30944 by denniskobus

Replied by denniskobus on topic JComments counter in category-view

I also searched the forum but no luck.
a little hint would be apreciated

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 5 months ago #30950 by ggppdk

Replied by ggppdk on topic JComments counter in category-view

something like this can be used:

Code:

$id = $items[$i]->id;
$db =& JFactory::getDBO();
$query 	= 'SELECT COUNT(com.object_id)'
		. ' FROM #__jcomments AS com'
		. ' WHERE com.object_id = ' . (int)$id
		. ' AND com.object_group = ' . $db->Quote('com_flexicontent')
		. ' AND com.published = 1'
		;
$db->setQuery($query);
$num_comments = $db->loadResult();

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

denniskobus
Offline
Junior Member

12 years 5 months ago #31030 by denniskobus

Replied by denniskobus on topic JComments counter in category-view

Thanks!
I have it working by adding it to my flexi template.

That's is probably not how it should have been done, but for now fine by me. Unless you say that that is very bad for performance?

Thanks again, dennis

Please Log in or Create an account to join the conversation.