[mythtv-users] Which table?

Michael Sullivan michael at espersunited.com
Sun Sep 21 14:02:47 UTC 2008

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?

More information about the mythtv-users mailing list