[mythtv-users] Fwd: Fwd: Re: channel4 hd has no eit - cross-eit

[Steve Evans]

On Mon, 6 Sep 2021 07:01:01 +0100
UB40D via mythtv-users <mythtv-users at mythtv.org> wrote:

> On Sun, 5 Sept 2021 at 11:10, John <jksjdevelop at gmail.com> wrote:
> 
> > I use 65692 which does work but the number may differ for you, test
> > the SD channel you pick as source for the EIT of the HD channel.
> >  
> How can I tell which one it is? I see no clue from the query below as
> to which of them is being used for EIT.
> 
>  select serviceid,chanid,channum,sourceid,callsign,deleted,xmltvid
> from channel where callsign like("%Channel 4%");
> 
> +-----------+--------+---------+----------+--------------+---------------------+-----------------+
> 
> | serviceid | chanid | channum | sourceid | callsign     | deleted
>     | xmltvid         |
> 
> +-----------+--------+---------+----------+--------------+---------------------+-----------------+
> 
> |      9211 |  10211 | 9211    |        1 | Channel 4    | 2021-04-13
> 22:25:17 |                 |
> 
> |      8311 |   9311 | 8311    |        1 | Channel 4+1  | 2021-04-13
> 22:25:17 |                 |
> 
> |      8316 |   9316 | 8316    |        1 | Channel 4+1  | 2021-04-13
> 22:25:17 |                 |
> 
> |      8320 |   9320 | 8320    |        1 | Channel 4    | 2021-04-13
> 22:25:17 |                 |
> 
> |     21200 |  22200 | 21200   |        1 | Channel 4 HD | 2021-04-13
> 22:25:17 | hd.channel4.com |
> 
> |      9211 |  19211 | 9211    |        1 | Channel 4    | NULL
>     |                 |
> 
> |      9212 |  19212 | 9212    |        1 | Channel 4    | NULL
>     |                 |
> 
> |      9213 |  19213 | 9213    |        1 | Channel 4    | NULL
>     |                 |
> 
> |      9214 |  19214 | 9214    |        1 | Channel 4    | NULL
>     |                 |
> 
> |      9216 |  19216 | 9216    |        1 | Channel 4    | NULL
>     |                 |
> 
> |      8311 |  18311 | 8311    |        1 | Channel 4+1  | NULL
>     |                 |
> 
> |      8312 |  18312 | 8312    |        1 | Channel 4+1  | NULL
>     |                 |
> 
> |      8314 |  18314 | 8314    |        1 | Channel 4+1  | NULL
>     |                 |
> 
> |      8316 |  18316 | 8316    |        1 | Channel 4+1  | NULL
>     |                 |
> 
> |      8320 |  18320 | 8320    |        1 | Channel 4    | NULL
>     |                 |
> 
> |     21200 |  31200 | 21200   |        1 | Channel 4 HD | NULL
>     | hd.channel4.com |
> 
> |     22620 |  32620 | 22620   |        1 | Channel 44   | NULL
>     |                 |
> 
> +-----------+--------+---------+----------+--------------+---------------------+-----------------+
> 
> 17 rows in set (0.01 sec)
> 
> 
> I also tried looking at all the existing column headings in "channel"
> (with "select * from channel") but none suggested that a channel was
> being used for EIT. Obviously that info must be in some other table.
> Would you know which?
> 
> 

There is a field called useonairguide in the channel table. When set to
1 the EIT data is used for that channel. See
https://www.mythtv.org/wiki/EIT 

Steve
-- 
____________________________________________________________________
Steve Evans            E-mail: mailto:stevee at gorbag.com
Registered Linux user #217906: http://counter.li.org
Public Encryption Key:         http://www.gorbag.com/public-key.html
____________________________________________________________________

5.10.61-gentoo Intel(R) Core(TM) i7-4790 CPU @ 3.60GHz GNU/Linux

 10:33:57 up 5 days, 23:10,  5 users,  load average: 0.09, 0.26, 0.25

He who hates vices hates mankind.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210906/0d8b6790/attachment.sig>