User Tools

Site Tools


docs:tips_n_tricks:mythtv

This is an old revision of the document!


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.

docs/tips_n_tricks/mythtv.1312053475.txt.gz · Last modified: 30.07.2011 21:17 CEST by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki