News Show Pro GK4 + K2 + Jcomments

Free responsive Joomla 2.5 and 3.x module to present your content with easy and intuitive way.
Rate this topic: Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.
cedacosur
Mon Apr 09, 2012 8:12 pm
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
User avatar
Expert Boarder

Seichinha
Mon Apr 09, 2012 11:14 pm
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
User avatar
Moderator

cedacosur
Tue Apr 10, 2012 12:27 am
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
Attachments
Captura de pantalla 2012-04-09 a la(s) 23.44.35.jpg
Captura de pantalla 2012-04-09 a la(s) 23.44.35.jpg (121.12 KiB) Viewed 3302 times
User avatar
Expert Boarder

sheridan
Wed Apr 11, 2012 12:42 pm
Seichinha wrote: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 .... :silly:
User avatar
Expert Boarder

sheridan
Wed Apr 11, 2012 1:27 pm
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
         
         ;';
User avatar
Expert Boarder


cron
Remember me
Don't have an account?
GavickPro website uses cookies. By continuing to use this website, you are giving consent to cookies being used. More details…×