Movie credits

Author Message

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 (the)

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

Vathanan Kumarathurai

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.

/vathanan

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

Vathanan Kumarathurai

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

André R.

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.

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

Vathanan Kumarathurai

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

kracker (the)

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>

Member since: 2001.07.13 || http://ezpedia.se7enx.com/

André R.

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.