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

moshe weitzman’s picture

Assigned: Unassigned » moshe weitzman

nice suggestion ... i am working on a patch for tracker.module which will have this enhancement along with a link for "mark all as read"

moshe weitzman’s picture

Title: tracker module with a uid » tracker module with a uid - omits posts
Category: feature » bug
Priority: Minor » Normal
killes@www.drop.org’s picture

fixed in cvs

Anonymous’s picture