[mythtv] [PATCH] mythvideo - country and genre

[Johan Bellander]

Well, I dont know if my way of doing it is the best, maybe everyone else
want to get their categories from IMDB..

> Hi,
> Sorry i don't know you also work on a genre /category systeme for 
> mythvideo. I would be better if my patch is not apply now.
> 
> Johan Bellander wrote:
> 
> >Hi,
> >
> >I also have written a genre (or category) system for 
> MythVideo (See a post a
> >few day(or weeks) back). My system does not grab the genre 
> from IMDB because
> >IMDB does not have a single category for a movie, it has 
> several and i only
> >wished to have a movie in one single genre.
> >  
> >
> Can you tell me which kind of categorie do you whish create in your 
> mythbox ?
> What that problem with multiple categorie ?
> 
> >Any way, this is how my system works:
> >- 'videocategories' table added to database, this hold the different
> >categories.
> >- 'category' column added to 'videometadata' referencing to
> >'videocategories' by an index.
> >  
> >
> In my system :
> - 'videometadatagenre' table added to database with two column :
> -- idvideo which is the primary key of the videomatadata
> -- genre which is varchar 128 (for example 'Drama')
> for the country, it's the same thing (videometadatacountry)
> 
> >- When you click 'browse videos' you are prompted by a 
> 'select category'
> >screen (Where you also can choose to browse 'all videos' if 
> you like.)
> >  
> >
> In my mind, i would like to make something like you :
> a dialogue box with
> select genre <all> <Drama> ...
> select country <all> <US> <France> ....
> select duration <all> <between 0 and 30 mn><between 30 and 60 mn> ...
> select rated <all><between 0 and 1><between 1 and 2> ....
> and with you system add
> select categorie <all><Movie><TVShow>...
> when a video is a movie, information can be grab from IMDB
> 
> >- When browsing movies in a certain category you can change 
> category by
> >pressing 8 and 9 (temp keys).
> >- You can switch category in the 'details'(or whatever it's 
> called) dialog.
> >  
> >
> Ok
> 
> >Left to do:
> >- Fix up the 'select category'-GUI a bit. (I have got a 
> better grasp of how
> >the GUI works, now.. =) )
> >- A way to add categories in the setup section. (right now 
> you have to add
> >the categories in the db)
> >
> >I don't know which way the system should go...
> >
> >A bit off topic.. I'm have also written a 'Poster browser' 
> and i'm working
> >on an 'Alfabetic browser' which hopefully will be finish 
> this weekend if i
> >dont have to work overtime a my jobb. =) Will try to post 
> some screenshots
> >of the system next week.
> >
> >  
> >
> very good idea for Poster browser
> about the alfabetic browser, we probably can make a general browser 
> which allow us to browse in all direction (alfabetic, 
> duration, genre, 
> rated, country or / and categorie)
> 
> >Oh, and by the way, I would be nice to see the code for your 
> 'genre system'.
> >  
> >
> You can try the patch i send yesterday or take the complete 
> mythvideo I 
> send i to your personnal mail.
> You will find a videodb/patch.sql file, apply this patch create 
> videometadatagenre and videometadatacountry in mysql and modify the 
> field plot in videometadata
> I would like to see your code too. I would like to know how it's 
> possible to mix your code with mine.
> Send me too some screenshot even if it's not finished just to have an 
> idea about you system.
> Can you explain exactly what kind of categorie you whish use 
> ? Is it my 
> genre ?
> 
> >// Johan Bellander
> >
> >  
> >
> 
> Xavier
> 
> >  
> >
> >>-----Original Message-----
> >>From: MaxPower [mailto:maxpower44 at tiscali.fr]
> >>Sent: den 27 november 2003 23:47
> >>To: Development of mythtv
> >>Subject: [mythtv] [PATCH] mythvideo - country and genre
> >>
> >>
> >>Thx to apply my french translation
> >>
> >>I post an other path yesterday in a mail called "[mythtv] [Patch] 
> >>mythvideo - french movie database".
> >>Please don't apply this patch yet because something is wrong in the 
> >>french movie database part.
> >>
> >>I make a other patch that change 2 things :
> >>The fisrt thing allow french user (user who choose french 
> language in 
> >>setting) to grab movie information from a french site.
> >>This change affect only the videomanager.cpp file.
> >>Cover files are now save as [number IMNB + extension file] 
> to be sure 
> >>that the cover file name is unique.
> >>I transform type of plot (in videometadata) to varchar(128) to text
> >>
> >>The second add two informations about a movie, the 
> countries and the 
> >>genres. For this moment the changes aren't visible for the user.
> >>I have created two tables : videometadatagenre and 
> >>videometadatacountry 
> >>(see in patch.sql for details).
> >>For example, if "The Pianist" is the intid 1 in videometadata, 
> >>videomatadatagenre look like this
> >>idvideo | genre
> >>1 |  Drama
> >>1 | War
> >>and the videometadata look like this:
> >>idvideo | country
> >>1 | UK
> >>1 | France
> >>1 | Poland
> >>...
> >>I don't create a table genre and a table country because I 
> >>don't know if 
> >>i should ....
> >>These informations are automatically grab  from IMDB (or 
> french movie 
> >>database site for french user).
> >>These changes are made in videomanager.cpp, metadata.h and 
> >>metadata.cpp
> >>I don't made any change in the interface at the time (in my 
> >>todo list).
> >>
> >>For the sql change, I don't know if the patch.sql is 
> correct or if I 
> >>must made a "diff metadata.old.sql metadata.new.sql" ... ?
> >>
> >>Thx to read me and please reply if not all are clear for you.
> >>
> >>
> >>xavier
> >>
> >>    
> >>
> >_______________________________________________
> >mythtv-dev mailing list
> >mythtv-dev at mythtv.org
> >http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
> >
> >  
> >
> 
> 
>