[mythtv] [PATCH] mythvideo - country and genre
maxpower44 at tiscali.fr
Fri Nov 28 07:36:46 EST 2003
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:
>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
What that problem with multiple categorie ?
>Any way, this is how my system works:
>- 'videocategories' table added to database, this hold the different
>- '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.
>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
>// Johan Bellander
>>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
>>(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
>>I don't made any change in the interface at the time (in my
>>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.
>mythtv-dev mailing list
>mythtv-dev at mythtv.org
More information about the mythtv-dev