Extension Request

Bentot · August 2006

Can someone create an extension so that we can see which discussion or thread an online member is currently reading?

WallPhone · August 2006

I could easily show which one they last read, I think.

The hard part is knowing if they still are in that page or if they moved to another page, or closed their browser.

Bentot · August 2006

Some forums like vbulletin show you that and the list of who's (members) viewing a thread. This would be cool.

WallPhone · August 2006

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.

Extension Request

Comments