1
Hi everybody.
I have a little question.
I use "Last comments" block from a system module on my site to show last 20. When there is 20 comments on one single topic, block seems strange, isnt it - 20 similar links but no previous comments.
My idea was to change the SQL query, so that last 20 items commented, not 20 comments, would be shown. What do i have to change in "system_blocks.php"?
P.S. Query should be sth like
SELECT MAX(com_id), com_modid, com_itemid, MAX(com_created), COUNT(com_id)
FROM x_xoopscomments
GROUP BY com_modid, com_itemid
ORDER BY 4 DESC
LIMIT 20
In this case, the problem is how to get
com_title of last comment, and how to put this in module of course
10x for answers!