News Show Pro GK4 + K2 + Jcomments

Hi

I'm using jcomments to avoid our users to post comments in the news.

My system:
Joomla 2.5.3
K2 2.5.5
News Show Pro GK4 3.1.1
Jcomments 2.3.0

How can I enable the comments counter in News Show Pro GK4 when a user post a comment?

http://canarias24horas.com/

Here you can view some comments:
http://canarias24horas.com/opinion/edit ... omiso.html

Thank you

Hi

I'm sorry but at this moment NSP GK4 for J!2.5 still doesn't support JComments.
Only on J!1.5.

Cheers

http://www.joomlatune.com/n28-87.html

Jcomments has a stable release for joomla 2.5, Jcomments 2.3.0

I need the comments counter working (watch attached file)

Please, give me a ray of light!

thank you

Hi

I'm sorry but at this moment NSP GK4 for J!2.5 still doesn't support JComments.
Only on J!1.5.

Cheers

hi,

when can you fix this ?
this is a big bug ....

In order to use jcomment and not k2_comment you can edit the file gk.source.k2.php

replace this code

Code: Select all

$query_news = '
         SELECT
            content.id AS id,
            COUNT(comments.itemID) AS count         
         FROM
            #__k2_items AS content
            LEFT JOIN
               #__k2_comments AS comments
               ON comments.itemID = content.id       
         WHERE
            comments.published
            AND ( '.$sql_where.' )
         GROUP BY
            comments.itemID
         ;';
         

by this code

Code: Select all

// UTILISATION DE JCOMMENT A LA PLACE de K2_COMMENT
         $query_news = '
         SELECT
            content.id AS id,
            COUNT(comments.object_id) AS count         
         FROM
            #__k2_items AS content
            LEFT JOIN
               #__jcomments AS comments
               ON comments.object_id = content.id       
         WHERE
            comments.published
            AND ( '.$sql_where.' )
         GROUP BY
            comments.object_id
         
         ;';