[drupal-devel] [feature] tracker module should have a block

[hba]

Issue status update for http://drupal.org/node/1570

 Project:      Drupal
 Version:      cvs
 Component:    tracker.module
 Category:     feature requests
 Priority:     minor
 Assigned to:  Anonymous
 Reported by:  hafif
 Updated by:   hba
 Status:       won't fix

hafif: I just made a patch that creates the block you are look for,
check here: http://drupal.org/node/19387.  
I don't know if killes wants to include it any more now than earlier,
though...


hba



Previous comments:
------------------------------------------------------------------------

April 19, 2003 - 08:27 : hafif

but it should be a clever block: 
it should display the comments title *and* the nodes title, and
shouldn't display a node twice.. 
the GROUP BY query to get this list on a DB with thousands of nodes and
comments is very slow. (tracker_page is also very slow) maybe a new
table keeping only nid's, cid's and timestamps, would be nice..


------------------------------------------------------------------------

April 21, 2003 - 20:29 : moshe weitzman

I don't understand the 2nd paragraph. How is this different from the
display current tracker_page?
the idea for a new table is probably a good one. of course, it would be
unnecessary if comments were stored as nodes.


------------------------------------------------------------------------

April 28, 2003 - 00:26 : hafif

basically what i would like, is something like the "active forum topics"
block of the forum.module, also displaying the comments subject.

say, most recently node #456 had 3 new comments, node #956 had 2
comments, and node #123 had 1 comment. then the block would display: 

- subject of comment 3 of #456
  title of #456
- subject of comment 2 of #956
  title of #956
- subject of comment 1 of #123
  title of #123

this way, when you enter the site, you would see say 10 items in that
block, and if you recall any of the subjects you click the one above
it, then the one above that, and so after a few clicks you catch up
completely.

the tracker page also displays older comments in the node that has
recent activity. it's a good way for catching up if your last visit was
a long time ago, but the block i'm suggesting is way faster and more
usable for busy sites with frequent visitors.

i did this on my installation of drupal which is at
http://www.hafif.org/drupalometre using this query instead of the
forum.module's block query it's the block right under the logo: 

SELECT MAX(c.cid) AS ccid, n.nid FROM comments c, node n
WHERE c.nid = n.nid AND n.status = 1 GROUP BY n.nid ORDER
BY timestamp DESC
but it is slow (5 sec), since i have around 45.000 comments, and 15.000
nodes


------------------------------------------------------------------------

October 10, 2004 - 22:45 : killes at www.drop.org

A tracker block would be quite expensive in terms of  database queries.
Blocks can also be generated outside the core, so I won't fix this.