Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
i suggest that the query which produces the tracker page of a specific user be changed like this:
SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name,
MAX(GREATEST(n.changed, c.timestamp)) AS last_activity
FROM node n LEFT JOIN comments c ON n.nid = c.nid LEFT
JOIN users u ON n.uid = u.uid WHERE <b>n.uid = '".
check_query($id) ."'</b> AND n.status = 1 GROUP BY n.nid,
n.title, n.type, n.changed, n.uid, u.name ORDER BY
last_activity DESC
should be
SELECT n.nid, n.title, n.type, n.changed, n.uid, u.name,
MAX(GREATEST(n.changed, c.timestamp)) AS last_activity
FROM node n LEFT JOIN comments c ON n.nid = c.nid LEFT
JOIN users u ON n.uid = u.uid WHERE <b>(c.uid = '".
check_query($id) ."' OR n.uid = '". check_query($id)
."')</b> AND n.status = 1 GROUP BY n.nid, n.title, n.type,
n.changed, n.uid, u.name ORDER BY last_activity DESC
this way, we can track everything the user has produced. including the comments he wrote under other peoples nodes...
Comments
Comment #1
moshe weitzman CreditAttribution: moshe weitzman commentednice suggestion ... i am working on a patch for tracker.module which will have this enhancement along with a link for "mark all as read"
Comment #2
moshe weitzman CreditAttribution: moshe weitzman commentedComment #3
killes@www.drop.org CreditAttribution: killes@www.drop.org commentedfixed in cvs
Comment #4
(not verified) CreditAttribution: commented