[mythtv-users] [userjob] Movie genre by symlinks
jedi at mishnet.org
Thu Jul 15 13:40:36 UTC 2010
On Thu, Jul 15, 2010 at 05:51:37AM -0700, Tom Sparks wrote:
> Raymond Wagner on Thu Jul 15 05:45:45 UTC 2010 wrote:
> >On 7/14/2010 23:30, Tom Sparks wrote:
> >> --- On Wed, 14/7/10, Raymond Wagner<raymond at wagnerrp.com> wrote:
> >>> On 7/14/2010 08:08, Doug Vaughan
> >>> wrote:
> >>>> Tom,
> >>>> If you have coding skills in
> >>>> python then the MythTV python bindings would provide an
> >>>> excellent interface to the MythTV database which would allow
> >>>> you to create your own userjob.
> >> What tables have the information I need?
> >If you're using the python bindings, you shouldn't touch any of the
> >database tables directly.
> i am using php
> the movies are TV movies
> I am using XBMC (XBMC and mythtv are in different house 900km+ away from each other, with only a 1 hour a day of internet transfer of recorded shows)
> this is the scripted i am think of
> 1 get movie genres from mythtv database for recorded show
> 2 check to see if those genres folder exist if not create them
> 3 create a symbolic link in those folders with the title (and subtitle) of the movie linking it to mythtv's internal filename of the recorded show
> I dont know what parts of the data base have those pieces of information
It's pretty simple really. If you have any business tinkering, then you should be able to quickly
figure out where the relevant bits are just by poking around with the mysql client.
More information about the mythtv-users