Here is some SQL that prints a beautiful list of who last read what and when:SELECT MAX(LastViewed), LUM_Discussion.DiscussionID, LUM_User.UserID, LUM_User.Name, LUM_Discussion.Name
FROM LUM_UserDiscussionWatch
LEFT JOIN LUM_User ON (LUM_User.UserID = LUM_UserDiscussionWatch.UserID)
LEFT JOIN LUM_Discussion ON (LUM_Discussion.DiscussionID = LUM_UserDiscussionWatch.DiscussionID)
GROUP BY UserID Extension still to come.
Comments
The hard part is knowing if they still are in that page or if they moved to another page, or closed their browser.
SELECT MAX(LastViewed), LUM_Discussion.DiscussionID, LUM_User.UserID, LUM_User.Name, LUM_Discussion.Name FROM LUM_UserDiscussionWatch LEFT JOIN LUM_User ON (LUM_User.UserID = LUM_UserDiscussionWatch.UserID) LEFT JOIN LUM_Discussion ON (LUM_Discussion.DiscussionID = LUM_UserDiscussionWatch.DiscussionID) GROUP BY UserID
Extension still to come.