query database

Jan 9, 2003, 11:17 PM ET3 posts by 2 posters
3 posts
neuro

Hi all,

something I've been meaning to do for an age was create a query database, where you could tap in a few key phrases, quotes or words from an episode and get a list back of all matching eps. This would be great for those who can remember an itty bit of an episode, but can't remember which one it was.

I've managed to get something basic up and running at long last. It's a bit beta at the moment, but seems to be working reasonably well for the most part. It uses scripts from thecfsi.com - I got them before they closed :( - as the source data. Please be aware you *can't* download the scripts. Any matching episodes you get from a query search returns links to the entries in the episode guide on friends-tv.org in lieu of my own content.

What I hope to add is contextual results, where you see the brief snippit of the show that matches your query, and possibly in the future, my own (or others if you would like to contribute) episode summaries - the only problem is that the ones on friends-tv.org are pretty good to start with!! :) Something else I *might* add is a spoiler filter, to disable specific seasons, although with only two left I might not bother!

Anyway, have a gander at http://neuro.me.uk/projects/friends-db/ and let me know what you think.

My next target may be reactivating my age old uk.media.tv.friends FAQ :)

_ __/| ___ ___ __ _________ "Hell hath no fury like a woman scorned \`O_o' / _ \/ -_) // / __/ _ \ for Sega." -- Brodie, 'Mallrats' =(_ _)=/_//_/\__/\_,_/_/ \___/ @ well.com :: William Anderson U - Ack! Phttpt! Thhbbt! http://neuro.me.uk/
neuroneuro

neuro wrote in message news:[email]:

just an update - the database now includes all episodes from 1x01 to 9x11.

Did nobody like it? :(

_ __/| ___ ___ __ _________ "Hell hath no fury like a woman scorned \`O_o' / _ \/ -_) // / __/ _ \ for Sega." -- Brodie, 'Mallrats' =(_ _)=/_//_/\__/\_,_/_/ \___/ @ well.com :: William Anderson U - Ack! Phttpt! Thhbbt! http://neuro.me.uk/
Roni Raabneuro

I liked it. I was actually in the middle of writing an application like this, but for scripts, which is a stand-alone application (like the one Brent did once). Way to go!

Roni Roni's Ross and Rachel Page Website: http://www.rossandrachel.com Message board: http://www.rossandrachel.com/forum