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.0 out of 6 based on 0 vote(s)
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
cedacosur
Expert Boarder
Expert Boarder

Mon Apr 09, 2012 8:12 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
Seichinha
Moderator
Moderator

Mon Apr 09, 2012 11:14 pm


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 1635 times
User avatar
cedacosur
Expert Boarder
Expert Boarder

Tue Apr 10, 2012 12:27 am


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
sheridan
Expert Boarder
Expert Boarder

Wed Apr 11, 2012 12:42 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
sheridan
Expert Boarder
Expert Boarder

Wed Apr 11, 2012 1:27 pm



Return to News Show Pro GK4
cron