2018年8月、9月にあったスカパー! (東経110度BS・CSデジタル放送)再編。
TVTestで視聴する分には問題無かったのだが、epgrecで「ディズニージュニア」(ch339)が録画できていない事が判明。
epgrecもsatelite_channel.phpをepgdump.cのチャンネルテーブルに合わせて書換えて、番組表の取得や録画予約まで問題無くできていたのだが、録画ファイルを再生するとND8の「日テレNEWS24」が録画されているという残念な結果だ。
確かに番組表から詳細予約を試みるとダイアログに表示されるチャンネルは"ND8"になるので、epgrecのチャンネル変更が不十分という事になる。そういえばmysqlにも何か持ってたっけ？と思ってRecorder_channelTblをdumpしてみたところ昔のチャンネル情報を持っていた。
個別にSQL文を叩いて修正するのはトラブルの元なので、テーブル一式をクリア
use epg;
TRUNCATE TABLE `Recorder_channelTbl`;
TRUNCATE TABLE `Recorder_programTbl`;
TRUNCATE TABLE `Recorder_reserveTbl`;
してgetepg.phpで番組表を再取得。Recorder_channelTblのチャンネルもアップデートされて万事OK。
…と思いきや、今度は「TBSチャンネル」が録画されてた。どうやらサービスID(SID)でsplitできてないらしい。
Recorder_channelTblにSIDフィールドはあるものの、内容はすべからく"hd"だ…。そういえば昔、番組表のGUIで地道にSIDを設定したような気がするが、今更そんな手作業やりたくない…
というわけで、epgdump.cのチャンネルテーブルからupdate文を作成し、mysqlコマンドで適用。
use epg;
update Recorder_channelTbl set sid = 296 where channel_disc = "3201.ontvjapan.com" and name = "TBSチャンネル";
update Recorder_channelTbl set sid = 298 where channel_disc = "1092.ontvjapan.com" and name = "テレ朝チャンネル1";
update Recorder_channelTbl set sid = 299 where channel_disc = "1067.ontvjapan.com" and name = "テレ朝チャンネル2";
update Recorder_channelTbl set sid = 339 where channel_disc = "339ch.epgdata.ontvjapan" and name = "ディズニージュニア";
update Recorder_channelTbl set sid = 250 where channel_disc = "1040.ontvjapan.com" and name = "スカイ・A Sports+";
update Recorder_channelTbl set sid = 292 where channel_disc = "1133.ontvjapan.com" and name = "時代劇専門CH";
update Recorder_channelTbl set sid = 301 where channel_disc = "301ch.epgdata.ontvjapan" and name = "エンタメ～テレ";
update Recorder_channelTbl set sid = 323 where channel_disc = "1019.ontvjapan.com" and name = "ＭＴＶ";
update Recorder_channelTbl set sid = 294 where channel_disc = "294ch.epgdata.ontvjapan" and name = "ホームドラマCH";
update Recorder_channelTbl set sid = 324 where channel_disc = "1024.ontvjapan.com" and name = "ミュージック・エア";
update Recorder_channelTbl set sid = 329 where channel_disc = "329ch.epgdata.ontvjapan" and name = "歌謡ポップス";
update Recorder_channelTbl set sid = 340 where channel_disc = "1062.ontvjapan.com" and name = "ディスカバリー";
update Recorder_channelTbl set sid = 341 where channel_disc = "1193.ontvjapan.com" and name = "アニマルプラネット";
update Recorder_channelTbl set sid = 354 where channel_disc = "1069.ontvjapan.com" and name = "CNNj";
update Recorder_channelTbl set sid = 363 where channel_disc = "363ch.epgdata.ontvjapan" and name = "囲碁・将棋CH";
update Recorder_channelTbl set sid = 331 where channel_disc = "1046.ontvjapan.com" and name = "カートゥーン";
update Recorder_channelTbl set sid = 55 where channel_disc = "1059.ontvjapan.com" and name = "ショップCH";
update Recorder_channelTbl set sid = 218 where channel_disc = "1010.ontvjapan.com" and name = "東映チャンネル";
update Recorder_channelTbl set sid = 318 where channel_disc = "318ch.epgdata.ontvjapan" and name = "Mnet";
update Recorder_channelTbl set sid = 349 where channel_disc = "2002.ontvjapan.com" and name = "日テレNEWS24";
update Recorder_channelTbl set sid = 101 where channel_disc = "101ch.epgdata.ontvjapan" and name = "スカパー！インフォ";
update Recorder_channelTbl set sid = 219 where channel_disc = "1005.ontvjapan.com" and name = "衛星劇場";
update Recorder_channelTbl set sid = 317 where channel_disc = "317ch.epgdata.ontvjapan" and name = "KBS World";
update Recorder_channelTbl set sid = 800 where channel_disc = "800ch.epgdata.ontvjapan" and name = "スカサカ！";
update Recorder_channelTbl set sid = 801 where channel_disc = "801ch.epgdata.ontvjapan" and name = "スカチャン1";
update Recorder_channelTbl set sid = 254 where channel_disc = "1026.ontvjapan.com" and name = "GAORA";
update Recorder_channelTbl set sid = 325 where channel_disc = "1022.ontvjapan.com" and name = "MUSIC ON! TV";
update Recorder_channelTbl set sid = 330 where channel_disc = "1045.ontvjapan.com" and name = "KIDSステーション";
update Recorder_channelTbl set sid = 343 where channel_disc = "1204.ontvjapan.com" and name = "ナショジオCH";
update Recorder_channelTbl set sid = 227 where channel_disc = "1217.ontvjapan.com" and name = "ザ・シネマ";
update Recorder_channelTbl set sid = 293 where channel_disc = "1015.ontvjapan.com" and name = "ファミリー劇場";
update Recorder_channelTbl set sid = 310 where channel_disc = "1006.ontvjapan.com" and name = "スーパー！ドラマTV";
update Recorder_channelTbl set sid = 342 where channel_disc = "1050.ontvjapan.com" and name = "ヒストリーCH";
update Recorder_channelTbl set sid = 290 where channel_disc = "1207.ontvjapan.com" and name = "SKY STAGE";
update Recorder_channelTbl set sid = 311 where channel_disc = "1014.ontvjapan.com" and name = "AXN";
update Recorder_channelTbl set sid = 316 where channel_disc = "316ch.epgdata.ontvjapan" and name = "AXNミステリー";
update Recorder_channelTbl set sid = 321 where channel_disc = "321ch.epgdata.ontvjapan" and name = "スペシャTV＋";
update Recorder_channelTbl set sid = 333 where channel_disc = "1201.ontvjapan.com" and name = "AT-X";
update Recorder_channelTbl set sid = 353 where channel_disc = "1070.ontvjapan.com" and name = "BBCワールドNews";
update Recorder_channelTbl set sid = 240 where channel_disc = "1007.ontvjapan.com" and name = "ムービープラス";
update Recorder_channelTbl set sid = 262 where channel_disc = "1027.ontvjapan.com" and name = "ゴルフネット";
update Recorder_channelTbl set sid = 305 where channel_disc = "305ch.epgdata.ontvjapan" and name = "チャンネル銀河";
update Recorder_channelTbl set sid = 314 where channel_disc = "1074.ontvjapan.com" and name = "LaLa";
update Recorder_channelTbl set sid = 307 where channel_disc = "1073.ontvjapan.com" and name = "フジテレビONE";
update Recorder_channelTbl set sid = 308 where channel_disc = "1072.ontvjapan.com" and name = "フジテレビTWO";
update Recorder_channelTbl set sid = 309 where channel_disc = "306ch.epgdata.ontvjapan" and name = "フジテレビNEXT";
update Recorder_channelTbl set sid = 322 where channel_disc = "1018.ontvjapan.com" and name = "スペシャTV";
update Recorder_channelTbl set sid = 161 where channel_disc = "1120.ontvjapan.com" and name = "QVC";
update Recorder_channelTbl set sid = 297 where channel_disc = "297ch.epgdata.ontvjapan" and name = "TBSチャンネル2";
update Recorder_channelTbl set sid = 312 where channel_disc = "1016.ontvjapan.com" and name = "FOX";
update Recorder_channelTbl set sid = 351 where channel_disc = "1076.ontvjapan.com" and name = "TBS NEWS";
update Recorder_channelTbl set sid = 223 where channel_disc = "1008.ontvjapan.com" and name = "チャンネルNECO";
update Recorder_channelTbl set sid = 257 where channel_disc = "1068.ontvjapan.com" and name = "日テレG+";
update Recorder_channelTbl set sid = 295 where channel_disc = "295ch.epgdata.ontvjapan" and name = "MONDO TV";
update Recorder_channelTbl set sid = 300 where channel_disc = "300ch.epgdata.ontvjapan" and name = "日テレプラス";
参照
衛星放送のスカパー！ https://www.skyperfectv.co.jp/
