[mythtv-users] Manually inserting "recorded programs" into theDB and commercial flagging

Iohan Reyes ijr at routex.net
Thu Nov 2 18:23:34 UTC 2006


Thanks for the response.  This, along with using the
myth.rebuilddatabase.pl script to actually put the file in the
'recorded' table pretty much covers what I am looking for.

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of jack snodgrass
Sent: Thursday, November 02, 2006 12:40 PM
To: jmeans at physics.tamu.edu; Discussion about mythtv
Subject: Re: [mythtv-users] Manually inserting "recorded programs" into
theDB and commercial flagging

On 11/2/06, Joel Means <jmeans at physics.tamu.edu> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Iohan Reyes wrote:
> > I have a little bit of a background on mysql so I decided to poke
around
> > in the mythconverg database.  I'm starting to understand how the
tables
> > relate to one another, but am still learning.  My specific question
and
> > the subject of this email is what table and which fields are
absolutely
> > necessary to fill-in with information so that I can commercial flag
an
> > mpeg file that was recorded from outside of mythtv?
> >
> > Here's the scenario, I have recorded a few programs on my Tivo and
> > extracted them as mpeg files onto my MythTV box.  I have figured out
how
> > to make them show up in the "Watch Recordings" list by inserting
rows in
> > the 'recorded' table.  The reason I want them in "Watch Recordings"
> > instead of in "Watch Videos" are purely for convenience and less
> > confusion for other family members.  Now, the last step I would like
to
> > accomplish is to commflag the mpeg files, but I'm not sure which
other
> > tables need to be populated with what info to make this possible.
> >

The jobqueue table controls the jobs that need to be run. It's fairly
strait forward...
ofcourse... I've only re-queued jobs or added jobs to shows that myth
had
put in to the recorded table... I don't know if there are any other
tables
invlolved.... to re-queue a job ( or add a new one you do )
insert into jobqueue (chanid, starttime, type, status) values
(1014,'2006-10-27 19:00:00',256,1); ( where 256 corresponds to user
job #1 in my case )
If you have a record already there and want to re-queue it, you can do:
update jobqueue set status=1, hostname='', comment='' where id = xxx;
xxx is the id of the job in the table. For you... you just want to add
commerical
scan jobs, so you'd do inserts. On my box... type 2 is for the
commerical
flagging jobs.

jack
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


More information about the mythtv-users mailing list