Me again ....
i have some problem with Jcomment and News Show Pro GK4,
i try this code but it doesn't works
sheridan wrote: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
;';
Thank you very much for your help
