Reply to thread

Message

<blockquote data-quote="bamboocha" data-source="post: 808163" data-attributes="member: 81645">AW: Re: Probleme mit Optionskanälen seit SkyIch weiß nicht, ob es einfacher ist, aber ich habe letzte Woche per SQL die Servie_ID, PMT und den Namen von den Sky Select Sendern in die Sky Bundesliga Sender anhand dieser Liste <a href="http://download.sky.de/web/redaktion/download/Transponder.pdf" target="_blank">http://download.sky.de/web/redaktion/download/Transponder.pdf</a> geändert. Jetzt sind alle Sender vorhanden <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /> Sie können nun per F9 genutzt werden und ich kann dafür auch eine eigene Favoritenliste erzeugen.Wenn ich heute Abend zu Hause bin, kann ich dir ein Skript erstellen.Vielleicht können die Werte auch per Kanallisteneditor geändert werden.[CODE]ORG_Name&nbsp; &nbsp; &nbsp; ORG_ID&nbsp; ORG_PMT NEW_Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NEW_ID&nbsp;&nbsp; NEW_PMTSky Select 2&nbsp; 261&nbsp; &nbsp;&nbsp; 108&nbsp; &nbsp;&nbsp; Sky Bundesliga 1&nbsp; &nbsp; 262&nbsp; &nbsp; &nbsp; 96Sky Select 3&nbsp; 271&nbsp; &nbsp;&nbsp; 103&nbsp; &nbsp;&nbsp; Sky Bundesliga 2&nbsp; &nbsp; 272&nbsp; &nbsp; &nbsp; 96Sky Select 4&nbsp; 281&nbsp; &nbsp;&nbsp; 104&nbsp; &nbsp;&nbsp; Sky Bundesliga 3&nbsp; &nbsp; 282&nbsp; &nbsp; &nbsp; 101Sky Select 5&nbsp; 291&nbsp; &nbsp;&nbsp; 105&nbsp; &nbsp;&nbsp; Sky Bundesliga 4&nbsp; &nbsp; 292&nbsp; &nbsp; &nbsp; 109Sky Select 6&nbsp; 301&nbsp; &nbsp;&nbsp; 98&nbsp; &nbsp; &nbsp; Sky Bundesliga 5&nbsp; &nbsp; 302&nbsp; &nbsp; &nbsp; 111Sky Select 7&nbsp; 311&nbsp; &nbsp;&nbsp; 107&nbsp; &nbsp;&nbsp; Sky Bundesliga 6&nbsp; &nbsp; 312&nbsp; &nbsp; &nbsp; 108Sky Select 8&nbsp; 321&nbsp; &nbsp;&nbsp; 109&nbsp; &nbsp;&nbsp; Sky Bundesliga 7&nbsp; &nbsp; 322&nbsp; &nbsp; &nbsp; 113Sky Select 9&nbsp; 331&nbsp; &nbsp;&nbsp; 115&nbsp; &nbsp;&nbsp; Sky Bundesliga 8&nbsp; &nbsp; 332&nbsp; &nbsp; &nbsp; 114Blue Movie 1&nbsp; 345&nbsp; &nbsp;&nbsp; 121&nbsp; &nbsp;&nbsp; Sky Bundesliga 9&nbsp; &nbsp; 342&nbsp; &nbsp; &nbsp; 120Blue Movie 2&nbsp; 355&nbsp; &nbsp;&nbsp; 123&nbsp; &nbsp;&nbsp; Sky Bundesliga 10&nbsp;&nbsp; 352&nbsp; &nbsp; &nbsp; 122Sky Select 1&nbsp; 251&nbsp; &nbsp;&nbsp; 98&nbsp; &nbsp; &nbsp; Sky Bundesliga 11&nbsp;&nbsp; 252&nbsp; &nbsp; &nbsp; 99[/CODE]Hier die SQLs für's UpdateEin SQL-Client ist bei MySQL bereits installiertEinfach die Eingabeaufforderung starten und in folgende Befehle eingeben. cd &quot;C:\Program Files\MySQL\MySQL Server 5.1\bin&quot;mysql.exe --user=root --password=MediaPortal[CODE]update mptvdb.tuningdetail set name = 'Sky Bundesliga 1', serviceId = '262', pmtPid = '96' where name = 'Sky Select 2' and serviceId = '261' and pmtPid = '108';update mptvdb.tuningdetail set name = 'Sky Bundesliga 2', serviceId = '272', pmtPid = '96' where name = 'Sky Select 3' and serviceId = '271' and pmtPid = '103';update mptvdb.tuningdetail set name = 'Sky Bundesliga 3', serviceId = '282', pmtPid = '101' where name = 'Sky Select 4' and serviceId = '281' and pmtPid = '104';update mptvdb.tuningdetail set name = 'Sky Bundesliga 4', serviceId = '292', pmtPid = '109' where name = 'Sky Select 5' and serviceId = '291' and pmtPid = '105';update mptvdb.tuningdetail set name = 'Sky Bundesliga 5', serviceId = '302', pmtPid = '111' where name = 'Sky Select 6' and serviceId = '301' and pmtPid = '98';update mptvdb.tuningdetail set name = 'Sky Bundesliga 6', serviceId = '312', pmtPid = '108' where name = 'Sky Select 7' and serviceId = '311' and pmtPid = '107';update mptvdb.tuningdetail set name = 'Sky Bundesliga 7', serviceId = '322', pmtPid = '113' where name = 'Sky Select 8' and serviceId = '321' and pmtPid = '109';update mptvdb.tuningdetail set name = 'Sky Bundesliga 8', serviceId = '332', pmtPid = '114' where name = 'Sky Select 9' and serviceId = '331' and pmtPid = '115';update mptvdb.tuningdetail set name = 'Sky Bundesliga 9', serviceId = '342', pmtPid = '120' where name = 'Blue Movie 1' and serviceId = '345' and pmtPid = '121';update mptvdb.tuningdetail set name = 'Sky Bundesliga 10', serviceId = '352', pmtPid = '122' where name = 'Blue Movie 2' and serviceId = '355' and pmtPid = '123';update mptvdb.tuningdetail set name = 'Sky Bundesliga 11', serviceId = '252', pmtPid = '99' where name = 'Sky Select 1' and serviceId = '251' and pmtPid = '98';update mptvdb.channel ch join mptvdb.tuningdetail tn on name like 'Sky Bundesliga %' and ch.idchannel = tn.idchannel set ch.displayName = tn.name ;[/CODE]Gruß bamboocha</blockquote>

[QUOTE="bamboocha, post: 808163, member: 81645"] [b]AW: Re: Probleme mit Optionskanälen seit Sky[/b] Ich weiß nicht, ob es einfacher ist, aber ich habe letzte Woche per SQL die Servie_ID, PMT und den Namen von den Sky Select Sendern in die Sky Bundesliga Sender anhand dieser Liste [url]http://download.sky.de/web/redaktion/download/Transponder.pdf[/url] geändert. Jetzt sind alle Sender vorhanden :-) Sie können nun per F9 genutzt werden und ich kann dafür auch eine eigene Favoritenliste erzeugen. Wenn ich heute Abend zu Hause bin, kann ich dir ein Skript erstellen. Vielleicht können die Werte auch per Kanallisteneditor geändert werden. [CODE] ORG_Name ORG_ID ORG_PMT NEW_Name NEW_ID NEW_PMT Sky Select 2 261 108 Sky Bundesliga 1 262 96 Sky Select 3 271 103 Sky Bundesliga 2 272 96 Sky Select 4 281 104 Sky Bundesliga 3 282 101 Sky Select 5 291 105 Sky Bundesliga 4 292 109 Sky Select 6 301 98 Sky Bundesliga 5 302 111 Sky Select 7 311 107 Sky Bundesliga 6 312 108 Sky Select 8 321 109 Sky Bundesliga 7 322 113 Sky Select 9 331 115 Sky Bundesliga 8 332 114 Blue Movie 1 345 121 Sky Bundesliga 9 342 120 Blue Movie 2 355 123 Sky Bundesliga 10 352 122 Sky Select 1 251 98 Sky Bundesliga 11 252 99[/CODE] Hier die SQLs für's Update Ein SQL-Client ist bei MySQL bereits installiert Einfach die Eingabeaufforderung starten und in folgende Befehle eingeben. cd "C:\Program Files\MySQL\MySQL Server 5.1\bin" mysql.exe --user=root --password=MediaPortal [CODE] update mptvdb.tuningdetail set name = 'Sky Bundesliga 1', serviceId = '262', pmtPid = '96' where name = 'Sky Select 2' and serviceId = '261' and pmtPid = '108'; update mptvdb.tuningdetail set name = 'Sky Bundesliga 2', serviceId = '272', pmtPid = '96' where name = 'Sky Select 3' and serviceId = '271' and pmtPid = '103'; update mptvdb.tuningdetail set name = 'Sky Bundesliga 3', serviceId = '282', pmtPid = '101' where name = 'Sky Select 4' and serviceId = '281' and pmtPid = '104'; update mptvdb.tuningdetail set name = 'Sky Bundesliga 4', serviceId = '292', pmtPid = '109' where name = 'Sky Select 5' and serviceId = '291' and pmtPid = '105'; update mptvdb.tuningdetail set name = 'Sky Bundesliga 5', serviceId = '302', pmtPid = '111' where name = 'Sky Select 6' and serviceId = '301' and pmtPid = '98'; update mptvdb.tuningdetail set name = 'Sky Bundesliga 6', serviceId = '312', pmtPid = '108' where name = 'Sky Select 7' and serviceId = '311' and pmtPid = '107'; update mptvdb.tuningdetail set name = 'Sky Bundesliga 7', serviceId = '322', pmtPid = '113' where name = 'Sky Select 8' and serviceId = '321' and pmtPid = '109'; update mptvdb.tuningdetail set name = 'Sky Bundesliga 8', serviceId = '332', pmtPid = '114' where name = 'Sky Select 9' and serviceId = '331' and pmtPid = '115'; update mptvdb.tuningdetail set name = 'Sky Bundesliga 9', serviceId = '342', pmtPid = '120' where name = 'Blue Movie 1' and serviceId = '345' and pmtPid = '121'; update mptvdb.tuningdetail set name = 'Sky Bundesliga 10', serviceId = '352', pmtPid = '122' where name = 'Blue Movie 2' and serviceId = '355' and pmtPid = '123'; update mptvdb.tuningdetail set name = 'Sky Bundesliga 11', serviceId = '252', pmtPid = '99' where name = 'Sky Select 1' and serviceId = '251' and pmtPid = '98'; update mptvdb.channel ch join mptvdb.tuningdetail tn on name like 'Sky Bundesliga %' and ch.idchannel = tn.idchannel set ch.displayName = tn.name ;[/CODE] Gruß bamboocha [/QUOTE]

Verification