[mythtv-users] Which table?

[Robert]

Michael Sullivan wrote:
> I'd like to write a PHP script that will access the mythconverg database
> and query for a list of programs being recorded the current day and
> email that list to myself and another user.  I can write the script to
> query the db and send the email, but I can't figure out which table
> holds that information.  My best bet was the record table, but it seems
> to only return data for shows that I've marked not to record:
> 
> For example:
> 
> mysql> select title, starttime from record where startdate="2008-09-22";
> +------------------------+-----------+
> | title                  | starttime |
> +------------------------+-----------+
> | The Last Samurai       | 19:00:00  | 
> | The Poseidon Adventure | 03:30:00  | 
> | Paranormal State       | 22:30:00  | 
> | Paranormal State       | 22:00:00  | 
> | Paranormal State       | 21:30:00  | 
> | Paranormal State       | 21:00:00  | 
> | The Poseidon Adventure | 03:30:00  | 
> +------------------------+-----------+
> 7 rows in set (0.16 sec)
> 
> 
> In the MythTV interface, the only program listed to record on 9-22 is
> "Terminator:  The Sarah Connor Chronicles".  However, if I search for
> that in the record table:
> 
> mysql> select title, starttime, startdate from record where
> title="Terminator: The Sarah Connor Chronicles";
> +-----------------------------------------+-----------+------------+
> | title                                   | starttime | startdate  |
> +-----------------------------------------+-----------+------------+
> | Terminator: The Sarah Connor Chronicles | 19:00:00  | 2008-01-13 | 
> +-----------------------------------------+-----------+------------+
> 1 row in set (0.00 sec)
> 
> The only record is from a long time ago.  Those shows up above are
> listed above in the db are listed in the GUI, but they are manual "Don't
> record"s I have a lot of space issues, so I go through the listing in
> the GUI each time I run mythfilldatabase and mark things not to record
> that I know will be on again soon.  Can anyone help me?
> 

I don't know about the database schema, but as an alternative, why not 
just grab http://yourmythtvbox:6544/xml and parse the the <Scheduled> 
tag?  Even easier, you could just email yourself a copy of 
http://yourmythtvbox:6544

Robert.