Forums / Developer / Movie credits
Vathanan Kumarathurai
Tuesday 02 January 2007 3:27:45 am
I am developing a site where I have to store and display some movie information.
How do I handle the credits information for a movie?
A credit will consist of a role and a person, and the credits will be a list of these pairs, e.g.
<i><Role> <Person></i> Director - Martin Scorsese Casting - Ellen Lewis
My guess is that I need to develop a Credits datatype similar to Authors datatype. The difference will be that the Role and Person in Credits will be fetched from pre-defined lists (from database) and will not be stored as freetext but as a reference to elements in the pre-defined lists.
Is this the way to do it? Or am I on a wrong track? Have you any developed something similar that you are willing to share?
Any feedback will be appreciated.
/vathanan
"Ninety percent of everything is crap" ~Sturgeon's law
kracker
Tuesday 02 January 2007 4:19:07 am
Neat idea! That should prove to be fun to implement.
//kracker
Member since: 2001.07.13 || http://ezpedia.se7enx.com/
André R.
Tuesday 02 January 2007 4:41:56 am
Will this database of persons be inside eZp?And is the roles fixed or different from movie to movie? (Is this going to be a dynamic representation of the whole credit list pr move?)
eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Tuesday 02 January 2007 5:08:53 am
Hi André
All the information will be inside eZ.
The name of the roles are fixed but the number of roles for a movie differ from movie to movie. It is as you write the whole credit list I want to implement, eg. credit list for movies in imdb.com.
Tuesday 02 January 2007 5:29:49 am
HI André
I don't know if this helps to understand the problem better but if I were to develop this scenario in eZ<b>2</b> I will create the following database tables and columns (columns in <>):
eZMovie: <ID> <Name> eZPerson: <ID> <Name> eZRole: <ID> <Name>eZMoviePersonRoleLink: <MovieID> <RoleID> <PersonID>
Tuesday 02 January 2007 5:30:57 am
Ok, then you might be on the right track (to create a custom datatype for it)If it was only director and a couple of other roles I would have suggested one object realtionlist pr role or something.
Tuesday 02 January 2007 5:47:35 am
Do you know of any datatype that I could look into for help to develop this?
I have browsed the Authors, Country, and Category datatypes. The Authors datatype stores the values as 'freetext'. I haven't yet figured out how the other two store the values.
ps. kracker> Fun .. yes ... but also a lot of work I guess. :)
Tuesday 02 January 2007 6:34:02 am
I never said it would be <b>easy</b> ... there are many ways to implement different kinds of functionality. not all of them are quickly implemented. stay fluid, creative and inventive ... I don't see what the problem is ...
//kracker<i>don*t b*tch</i>
Tuesday 02 January 2007 6:45:44 am
I'm not the right person to ask for datatype stuff. You can even implement it without creating a new datatype.Create a folder structure like this
roles(folder) |-director(folder) | |- Joe (person) | |- Martin (person) |-actor | |- Sandy | |- Martin (second node placement)|- art director
And then a object relation from movie to person, and where parent node name is role.But you'll need to add a new node placement to existing persons all the time and I't wouldn't be that easy to maintain.