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

[Another Sillyname]

On 10 August 2010 09:21, Nick Rout <nick.rout at gmail.com> wrote:
> 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)
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

Thanks Nick

Great pointer.

Anthony