MythTV

Show the Video Source in the Channel Name

update channel set name = CONCAT(name,' (DVB-C)') where not name like '%DVB-%' and sourceid in (select sourceid from videosource where name = 'DVB-C')  ;
update channel set name = CONCAT(name,' (DVB-T)') where not name like '%DVB-%' and sourceid in (select sourceid from videosource where name = 'DVB-T')  ;
update channel set name = CONCAT(name,' (Kab.)') where not name like '%Kab.%' and not name like '%Analog%' and sourceid in (select sourceid from videosource where name = 'Kabel Analog')  ;

Set those channels visible that have EPG

update channel set visible = 0 where not chanid in ( select distinct(chanid) from program) ;
update channel set visible = 1 where  chanid in ( select distinct(chanid) from program) ;

This works of course only after you alread did get EPG data.

Back to top
docs/tips_n_tricks/mythtv.txt · Last modified: 2011/07/30 21:17 by peter