|
"Active discussions" list
|
|
By fluffy grue , Section Wishlist []
Posted on Fri Oct 12, 2001 at 12:00:00 PM PST
|
 |
|
How about an "active discussions" user information link which lists, in story-section style (i.e. with the intro text and comments/new information) stories and diaries which have a comment by the specified user? It'd be easier to track discussions than the "comments by" link.
|
| I'd think that it'd be kind of simple to implement. Just do a somewhat more complex query which looks to see if said user has posted to the story, rather than based on what the story's section is. That'd be particularly useful for tracking conversations in interesting diaries and such, and would be a lot more convenient than the hotlist. It'd be sort of a lukewarmlist.
Of course, to make it efficient, each story should get a list of users who have posted a comment to it, rather than having to search through the comments and do complex joins and all that other fun stuff which would immediately bring pretty much any Scoop server to its knees. Once that list is created, though, it'd be pretty simple to search... "SELECT FROM Stories WHERE Posters CONTAINS "fluffy grue"" or something. (Sorry, I only vaguely know SQL and I've never looked at Scoop's table names, so I'm just guessing there. :) |
|
|
Story Views
|
|
22 Scoop users have viewed this story.
|
|
