User Tools

Site Tools


docs:tips_n_tricks:mythtv

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Last revisionBoth sides next revision
docs:tips_n_tricks:mythtv [30.07.2011 21:11 CEST] – created peterdocs:tips_n_tricks:mythtv [30.07.2011 21:17 CEST] peter
Line 6: Line 6:
   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' ;   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.txt · Last modified: 25.10.2018 11:09 CEST by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki