<div class="gmail_quote">On 7 March 2011 21:00, tortise <span dir="ltr"><<a href="mailto:tortise@paradise.net.nz">tortise@paradise.net.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div></div><div class="h5"><br></div></div>
Also looks like Stratos is on DVB-T now, 59, 1406, Ch 21. Anyone know<br>
the SQL to add this?<br>
<br>
</blockquote></div><br><div>This is what I just used...</div><div><br></div><div>insert into channel (chanid,channum,freqid,sourceid,callsign,name,xmltvid,visible,useonairguide,mplexid,serviceid) values (1035,35,53,1,'Stratos','Stratos','<a href="http://stratos.freeviewnz.tv">stratos.freeviewnz.tv</a>',1,1,3,1406);</div>
<div><br></div><div>But you will need to change the freqid from 53 to 59 and the chanid to 1021 and channum to 21. (I guessed the xmltvid as well...) If you use xmltv you might not want the useonairguide on (set to 0 rather than 1).</div>
<div><br></div><div>My changes appear in mythweb (it just reads the database) but I have not yet restarted the server because I am recording, so I am not sure it all works yet...</div><div><br></div><div>If anything does go wrong the change is easily reversed with a simple delete.</div>
<div><br></div><div>BTW, Trackside is also now on dvb-t (the Kordia multiplex with serviceid 1402).</div><div><br></div><div>Brendan</div>