Wrox Programmer Forums
|
Forum and Wrox.com Feedback Post your suggestions for improving the Forums or Wrox.com or questions for the staff here. "Where can I find the code for my book?"
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Forum and Wrox.com Feedback section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old April 8th, 2004, 06:01 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 1,285
Thanks: 0
Thanked 2 Times in 2 Posts
Default Request: Sounds for Active Topics

Here's my idea: on the Active Topics page, if the user has it to reset every x seconds, whenever there's an active topic that wasn't there before, the browser plays a sound.

Could we implement this feature? We would certainly have to be able to disable the sound in the member profile or something.

Thanks.

Snib

P2P Member
<><
__________________
-Snib - http://www.snibworks.com
Where will you be in 100 years?
  #2 (permalink)  
Old April 9th, 2004, 04:07 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 836
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The problem with this approach is that it requires the forum software to maintain state, whereas it currently has no notion of state or history. The page is generated via a query, where some post timestamp is >= the specified timestamp of the "active topics" dropdown (this defaults to "last login").

It's not a trivial problem, but could potentially be tricky to add. See, you're requiring the forum software to remember the result set from the previous 'active topics' query, and compare the entire result set with the current result set to spot additions.

This result set could be stored as some serialized array in a server-side session cache.

The other (and imho better) solution to this problem is to only save the timestamp of the last active postings display, and write a query that performs the set differences for you.

Problem is, this depends on your database's ability to perform such queries.


When all is said and done, it seems to me that it's all a wasted effort since you can just view the topics that have been active in the last 15 minutes. It should be pretty easy to tell if any postings are new, since you're not really going to have THAT much activity happening in a 15-minute window.


Take care,

Nik
http://www.bigaction.org/
  #3 (permalink)  
Old April 9th, 2004, 04:11 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 1,285
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Nik:

I understand this would be difficult, and I suppose few people would use it. I would, but now that I think about it again, I agree: it would be wasting time.

Snib

P2P Member
<><





Similar Threads
Thread Thread Starter Forum Replies Last Post
request forwarging & request redirection hafizmuhammadmushtaq Servlets 2 April 24th, 2008 12:42 AM
Sights and Sounds in Access Forms SerranoG Access 1 October 11th, 2005 09:56 AM
referencing a subform, more complex than it sounds nimarii Access 1 February 11th, 2004 06:35 PM
Sounds in Excel VBA selbybrock Wrox Book Feedback 0 December 13th, 2003 02:14 PM
Sounds in excel vba selbybrock Excel VBA 0 October 24th, 2003 09:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.