[mythtv] MythTV parental rating in DB schema

[Nasa]

----- "Menny Even Danan" <mennyed at gmail.com> wrote:

> I haven't used it before. I'm developing my own script which bulk
> updates all my videos, and fill meta-data from thetvdb and
> themoviedb/imdb.
> Due to request, I wish to add Parental Level support, and for that, I
> need to know the DB schema related.
> 
> 
> The "rating" column holds a string representation of the rating which
> I retrieve from the meta-data sources, and this information is shown
> in the videos browser.
> But MythTV does not take it into account when parent level is enabled.
> 
> 
> So I figured there is another field I need to fill...
> 
> 
> Any ideas?
> 
> 
> On Mon, Nov 9, 2009 at 11:34, Allan Stirling <
> dibblah.allan.stirling at googlemail.com > wrote:
> 
> 
> 
> Menny Even Danan wrote:
> 
> 
> Hi,
> I'm trying to understand the parental level use in MythTV so my
> metadata script ( http://code.google.com/p/fill-mythvideo-metadata/ )
> will also add the required meta data for this too.
> 
> Does anyone know how MythTV stores this information?
> In the 'videometadata' table there are three columns:
> showlevel (int)
> rating (string)
> childid (int)
> 
> Showlevel is the internally (user) defined "level" of the video. It
> does not map onto real ratings. Childid is unrelated.
> 
> Is there some deficiency with JAMU that you are not able to use it?
> 
> Cheers,
> 
> Allan.

JAMU doesn't do anything with showlevel and/or ratings.  The reason?  TMDB doesn't
include movie ratings (as of yet -- look for it to be added in API 2.1).  TVDB doesn't
include TV show ratings either.  The options to set showlevel (1-4) based on ratings
(user defined in a setup screen somewhere) only works when accomplished via a script, as
was recently explained to me.  The specifics of how your script has to take the user defined
ratings and match them to showlevel will have to be explained by someone smarter than I....

Nasa