| 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. :) |
