Friday, February 10, 2006

Fix pid on one channel

NBC (KNTV) changed their equipment. PID changed and showing weather info instead of NBC.

Need to change serviceid.

mysql> select * from channel where callsign like '%KNTV%';
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+
| chanid | channum | freqid | sourceid | callsign | name | icon | finetune | videofilters | xmltvid | recpriority | contrast | brightness | colour | hue | tvformat | commfree | visible | outputfilters | useonairguide | mplexid | serviceid | atscsrcid |
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+
| 1000 | 111 | NULL | 1 | KNTV-HD | KNTV-HD | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 0 | | 1 | 2 | 4 | 2 |
| 1071 | 111 | NULL | 1 | KNTV-HD | KNTV-HD | none | NULL | | | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 1 | 2 | 3 | 1 |
| 1039 | 11_1 | 12-1 | 1 | KNTVDT | KNTVDT(KNTV-DT) | none | NULL | | 21785 | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 0 | 2 | 4 | 2 |
| 1015 | 11_2 | 12-2 | 1 | KNTVDT2 | KNTVDT2 (KNTV-DT2) | none | NULL | | 36151 | 0 | 32768 | 32768 | 32768 | 32768 | Default | 0 | 1 | | 0 | NULL | NULL | NULL |
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+----------+---------+---------------+---------------+---------+-----------+-----------+
4 rows in set (0.00 sec)

mysql> select * from channel where chanid='1039'\G
*************************** 1. row ***************************
chanid: 1039
channum: 11_1
freqid: 12-1
sourceid: 1
callsign: KNTVDT
name: KNTVDT(KNTV-DT)
icon: none
finetune: NULL
videofilters:
xmltvid: 21785
recpriority: 0
contrast: 32768
brightness: 32768
colour: 32768
hue: 32768
tvformat: Default
commfree: 0
visible: 1
outputfilters:
useonairguide: 0
mplexid: 2
serviceid: 4
atscsrcid: 2
1 row in set (0.00 sec)

Current (bad) serviceid is '4'. Must hack and try 1,2,3,5.

Try 3 first cuz most of my channels are svcid=3 and stupid NBC Weather stream is '4':

mysql> UPDATE channel set serviceid=3 WHERE chanid='1039';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Record something. WORKS! :)
Fixed.

0 Comments:

Post a Comment

<< Home