Movie credits

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

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

/vathanan

"Ninety percent of everything is crap"
~Sturgeon's law

Tuesday 02 January 2007 5:47:35 am

Hi André

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.

/vathanan

ps. kracker> Fun .. yes ... but also a lot of work I guess. :)

"Ninety percent of everything is crap"
~Sturgeon's law

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.

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