1
rsmike
How to hack "Last comments" block
  • 2005/7/6 7:39

  • rsmike

  • Just popping in

  • Posts: 22

  • Since: 2004/4/22


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_modidcom_itemidMAX(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!

Login

Who's Online

186 user(s) are online (112 user(s) are browsing Support Forums)


Members: 0


Guests: 186


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits