[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Movie database - THE ANSWER ( LONG POST )
- Subject: Re: Movie database - THE ANSWER ( LONG POST )
- From: jthielen@VNET.IBM.COM (James A. Thielen - Schaumburg, Il.)
- Date: Mon, 11 Apr 94 11:13:59 EDT
- Disclaimer: This posting represents the poster's views, not those of Advantis.
- News-software: UReply 3.1
- Newsgroups: comp.sys.apple2
- Organization: Advantis - A Networking Services Company
- References: <al190290.765822982@academ01> <2o4aur$kbo@rbse.Mountain.Net>
- Reply-to: jthielen@VNET.IBM.COM
In <2o4aur$kbo@rbse.Mountain.Net> Quinn Avery writes:
$Alberto Roffe Illades (al190290@academ01.mty.itesm.mx) wrote:
$: Is there somewhere a Public Domain MOVIE database for Appleworks? (better if it works with AW 2.0)
$: I remember seeing one once on some FTP site, but I can't find it anymore.
$: Thank you for any help!
$
$: -Alberto Roffe
$
$: (al190290@academ01.mty.itesm.mx, or Roffe@Delphi.com)
$
$I'm very interested in this as well.
$
$-Q
$
From: SMTP2 --IINUS1 Date and time 02/21/94 16:08:19
=========================================================================
Received: from ibmpcug.co.uk by vnet.IBM.COM (IBM VM SMTP V2R2) with TCP;
Mon, 21 Feb 94 16:05:01 EST
From: movie@ibmpcug.co.uk
Subject: HELP - [Movie Database] (P)
Date: Mon Feb 21 20:40:54 GMT 1994
Reply-To: movie@ibmpcug.co.uk
Sender: movie@ibmpcug.co.uk
Message-ID: <9402212040.aa20799@kate.ibmpcug.co.uk>
Apparently-To: <jthielen@vnet.ibm.com>
help
This help file relates to HELP requests sent to:
movie@ibmpcug.co.uk
The following is a brief listing of possible Commands
and what the Movie Database Request Server will return.
The Movie Database Server runs every couple of hours
so please be patient. During busy periods requests can take
several hours.
Commands should be in the Body of the message.
The Subject line may be blank.
Commands in the body MUST start in the left hand column.
MULTIPLE commands are possible in a single mail message each
command needs to be on a separate line.
Other HELP options include:
HELP ADD HELP on the ADD command to suggest additions to the
Movie Database.
HELP EXTRA HELP on the Advanced commands and extended
descriptions of awards and other short codes used
within the Movie Database.
-------------------
Examples:
MOVIE Aliens
TITLE Doc Hollywood
ACTOR Davis, Geena
HELP
HELP ADD
HELP EXTRA
will mail back full information on the movie Aliens (Dir James Cameron)
etc. A line or a subject of HELP will return this message.
Multiple lines in a single mail message with a blank
subject will return information about all selected requests. Remeber
that for movies with the definta article in the title (The, A) that this
needs to be included in any search ie "Package, The".
For further examples see appendix B. Advanced options can be found in
Appendix D.
Also note that the database can be installed locally on a number of
machines and operating systems see Appendix C.
-------------------
Standard Options
================
TITLE:<title to find full details about (Director, Cast, Writer etc)>
DIRCT:<director to find details of filmography>
ACTOR:<actor/actress to find details of filmography>
COMPO:<composer to find details of filmography>
WRITE:<writer to find details of filmography>
CINEM:<cinematographer to find details of filmography>
COSTU <costume designer to find details of filmography>
EDITO <editor to find details of filmography>
DESIG <production designer to find details of filmography>
PERSN <Full filmography for individual from all lists including acting
and other credits in cinema (eg including direction, writing etc>
MOVIE <title to find full details about (Director, Cast, Writer etc)>
[full list for movie (as title) plus lists of all other
movies relating to cast and crew see TRACE MOVIE]
TRACE ACTOR <displays ALL information about ALL movies an individual
Actor has worked on>
TRACE DIRCT <displays ALL information about ALL movies an individual
Director has worked on>
TRACE COMPO <displays ALL information about ALL movies an individual
Composer has worked on>
TRACE CINEM <displays ALL information about ALL movies an individual
Cinematographer has worked on>
TRACE WRITE <displays ALL information about ALL movies an individual
Writer has worked on>
TRACE MOVIE <full list for movie (as title) plus lists of all other
movies relating to cast and crew >
(as previous movie command)
Please note that the option must be 5 characters followed by a space
then details of the Actor etc to find. Also note that the server
processes requests every couple of hours so please be patient.
EXAMPLES
========
Examples to find films by a director:
DIRCT Hitchcock, Alfred
Examples of Actors/Actress search:
ACTOR Biehn, Michael
ACTOR Davis, Geena
ACTOR Grant, Cary
Example of Composer:
COMPO Herrmann, Bernard
etc Please note that the Movie Database is case sensitive (ACTOR, DIRCT
and MOVIE commands others are less stringent).
Examples of more advanced queries:
TRACE ACTOR Fox, Michael J.
This will list all movies with details of each of them in which
Michael J. Fox has worked on.
Therefore an incorrect spelling may not result in the correct response.
You may search the database with partial requests which will need to
be followed up with full requests when the correct details are known
(see appendix B)
If you need assistance, please contact
alanj@ibmpcug.co.uk
Please enclose copies of unusal responses.
Finally remember that the server is only run every couple of hours
so please be patient.
Movie Database Request Daemon Notes Follow...
Appendix A -- Where does the database come from?
====================================================
The database has been generated from the various lists posted regularly to
the USENET group rec.arts.movies. The lists are available via anonymous FTP
from cathouse.org FTP in pub/cathouse/movies/database/moviedb-2.8.tar.Z
The following table shows the maintainer of each list
(to whom all additions should be sent):
List | Maintained by
-----------------|--------------------------------------
Actors | Col Needham <cn@ibmpcug.co.uk>
Actresses | Col Needham <cn@ibmpcug.co.uk>
Alt. Titles | Michel Hafner <hafner@ifi.unizh.ch>
Cinematographers | Michel Hafner <hafner@ifi.unizh.ch>
Composers | Michel Hafner <hafner@ifi.unizh.ch>
Directors | Col Needham <cn@ibmpcug.co.uk>
Movies | Michel Hafner <hafner@ifi.unizh.ch>
Plot Summaries | Colin Tinto <colint@spider.co.uk>
Trivia | Murray Chapman <muzzle@cs.uq.oz.au>
Writers | Jon Reeves <reeves@zk3.dec.com>
Character Names | Steve Hammond <shammond@indirect.com>
Biographies | Mark Harding <ccsmh@ss1.bath.ac.uk>
Crazy Credits | Mark Harding <ccsmh@ss1.bath.ac.uk>
Editors | Col Needham <cn@ibmpcug.co.uk>
Production Design| Michel Hafner <hafner@ifi.unizh.ch>
Costune Designers| Michel Hafner <hafner@ifi.unizh.ch>
-------------------------------------------------------
--------------------------------------------------------------------
Database Output Key
KEY
===
All titles are assumed to be movies unless otherwise indicated:
"xxxxx" = a television series
"xxxxx" (mini) = a television mini-series
(TV) = TV movie, or made for cable movie
(V) = made for video movie
The following tags indicate awards won by people/movies:
(AA) = academy award winner
(AAN) = academy award nominee
(GG) = golden globe winner
(GGN) = golden globe nominee
===================================================================
APPENDIX B - Example mail message
=================================
\/---Do Not Type past this point in example
|
| NOTES
mail movie@ibmpcug.co.uk |
Subject: | Subject may be blank
|
|
TITLE Aliens | Gives full info on movie.
TRACE MOVIE Alien (1979) | Full info plus search of
participants.
ACTOR Fox, Michael J. | Actor/Actress Filmography.
ACTOR Davis, Geena | Actor/Actress Filmography.
DIRCT Hitchcock, Alfred | Director Filmography.
MUSIC Her | Search on music database for
| this partial name.
CINEM Vitt | Search on Cinematographer database
| this partial name.
TRACE DIRCT Hitchcock, Alfred | List all movies that have been
| worked on by Alfred Hitchcock
MOVIE Searchers, The (1956) | Don't forget The, A etc in titles
|
<Ctrl D> |
Note the mail may have blank lines and other information is ignored.
-----------------------------------------------------------------------
Appendix C
==========
Searching the lists
-------------------
The lists can now be searched via a mail-server interface. For details
send a message with a subject HELP to <movie@ibmpcug.co.uk>.
Alternatively, the movie database package uses the information contained on
the lists to create and search a massive movie database. The latest version
includes a new program which takes all the trouble out of installing and
maintaining the database. It also supports the new biographies and crazy
credits lists.
The package is on the cathouse.org FTP site in the file:
pub/cathouse/movies/database/moviedb-2.8.tar.Z
see the README file in the same directory for information on how to
get started.
Finally, if you have access to a HTTP browser such as 'xmosaic', the database
is available via the document:
http://www.cm.cf.ac.uk:80/Movies/moviequery.html
This interface can also be accessed by an experimental text based browser:
telnet into info.cern.ch, and the movie database is under Subject/Movies
-----------------------------------------------------------------------
Appendix D
==========
Advanced Commands
-----------------
INDEX - Creates and index for films in a particular year
-----
INDEX ALL <year> Index of ALL films
INDEX MRR <year> Index of movies rated
INDEX SMR <year> Index of movies rated sorted by rating
INDEX VMR <year> Index of movies rated sorted by number of votes
Note: Year in form 1993
eg
INDEX MRR 1993
Rated movies for 1993 in alphabetical order.
SEARC - performs substring search in the various databases
-----
SEARC ACTOR <actor name seach string>
SEARC DIRCT <director name seach string>
SEARC WRITE <writer name seach string>
SEARC COMPO <composor name seach string>
SEARC CINEM <cinematographer name seach string>
SEARC COSTU <costume designers name search string>
SEARC EDITO <editor name search string>
SEARC DESIG <production designers name search string>
SEARC TITLE <movie title search string>
Note: search strings must be at least THREE (3) characters long.
eg
SEARC ACTOR Fox, Mic
SEARC TITLE Aliens
Produces a list of individuals that meet the search string "Fox, Mic".
Produces a list of movies that contain the string "Aliens"
LISTA - Allows you to perform linked searches between two unique
----- individuals in the actor/actress lists.
LISTA <name> AND <name>
Will list the films in which the two named individuals (on the
actors/actreess list) who have worked together.
eg
LISTA Hepburn, Katharine AND Tracy, Spencer
Note the AND must be in CAPITAL letters to work! Also note that this
works with the Actor/Actress lists only.
Subject: ADD
------------
There is now a central clearing house for updates to the Movie
Database. You can now send updates to the Movie Database via the
Movie Database Mail Server. Updates will be passed to the list
co-ordinators weekly for adding to the next update of the database.
For full details send a message to movie@ibmpcug.co.uk Subject:
HELP ADD
-----------------------------------------------------------------------
General Note. If you have problems using this server with the mail
path try using a Reply-To: header to direct the return mail address.
===================================================================
Any queries regarding the contents should be directed at the
list maintainers whose addresses are above.
Any queries or comments relating to this Mail Server
Please address them to:
alanj@ibmpcug.co.uk
I hope you find this server useful.
Please let me have your suggestions for improvements and enhancements
and I will see what I can do.
Regards
ALan Jay
alanj@ibmpcug.co.uk
--
v3.1
---------------------------------------------------------------------------
Thanks for using the Movie DataBase Server at The PC User Group UK.
Mail address: movie@ibmpcug.co.uk General information: info@ibmpcug.co.uk
The PC User Group, PO Box 360, HARROW HA1 4LQ, ENGLAND. +44(0)81 863 1191
===========================================================================
--
******************************************************************************
| Jim | "To boldly go where ___ |
| | no one has gone ___..---'---`---..___ |
| | before." .-=========================- |
| "Keeping the Riff-Raff | _______________/ :.::.:.---..___..---~~~ |
| and Interlopers out | ((___________(_||_)_____/ |
| of the systems!" | /____/___:..::.:::.::/ USS Enterprise |
| | \__________/ NCC-1701D |
| | |
******************************************************************************