[mythtv-users] How does mythconverg.program.videoprop get populated in the UK?

[Nick Rout]

On Tue, Aug 10, 2010 at 7:19 PM, Another Sillyname
<anothersname at googlemail.com> wrote:
> Hi Guys
>
> I'm trying to write a script that handles HD transcoding better and
> also retains AC3 audio intact.
>
> While doing this I've identified that within the script I want to use
> the mythconverg.program.videoprop field which usually should contain
> the HDTV value to represent whether a program is transmitted in HD or
> not.
>
> In the UK on Freesat we currently have 4 'real' channels:-
>
> BBC HD - Channel 10940
> ITV HD - Channel 8000
> STV HD - Channel 7855
> Granada HD - Channel 7851
>
> While BBC HD and Granada HD are populating the videoprop correctly
> with the HDTV value, ITV HD and STV HD are only populating the field
> with WIDESCREEN.  This is causing my script to not execute the way I
> would wish.
>
> Could someone please let me know is the videoprop field populated from
> EIT data (as I suspect) or does it come from another source?  In other
> countries does the videoprop field get populated correctly or is it
> inconsistent?  (If it's inconsistent I'll have to write more into the
> script to try to detect all instances of a HD transmission).
>
> Thanks in advance.

if you are relying on a eit or xmltv you are relying on a third party
to tell you, which is probably inherently unreliable.

Take a look at the recordedmarkup table:

mysql> describe recordedmarkup;
+-----------+-----------------------+------+-----+---------------------+-------+
| Field     | Type                  | Null | Key | Default             | Extra |
+-----------+-----------------------+------+-----+---------------------+-------+
| chanid    | int(10) unsigned      | NO   | PRI | 0                   |       |
| starttime | datetime              | NO   | PRI | 0000-00-00 00:00:00 |       |
| mark      | mediumint(8) unsigned | NO   | PRI | 0                   |       |
| type      | tinyint(4)            | NO   | PRI | 0                   |       |
| data      | int(11) unsigned      | YES  |     | NULL                |       |
+-----------+-----------------------+------+-----+---------------------+-------+
5 rows in set (0.00 sec)

where type= 30 it shows the vertical pixels and type=31 shows horizontal pixels:

|   2937 | 2010-08-04 21:28:00 |      1 |   30 |  720 |
|   2937 | 2010-08-04 21:28:00 |      1 |   31 |  576 |
|   2920 | 2010-08-10 18:59:00 |      1 |   31 |  576 |
|   2920 | 2010-08-10 18:59:00 |      1 |   30 |  720 |
+--------+---------------------+--------+------+------+

If your script looks at those values it should be able to determine
whether the show is HD or SD by the pixels shown (of course that won't
detect SD upscaled to HD resolution)