[mythtv-users] Where are channel icons kept? [resolved]
Eyal Lebedinsky
eyal at eyal.emu.id.au
Thu Jul 15 14:36:57 UTC 2021
On 15/07/2021 23.38, James wrote:
>
>
>> On 15 Jul 2021, at 9:15 pm, Eyal Lebedinsky <eyal at eyal.emu.id.au <mailto:eyal at eyal.emu.id.au>> wrote:
>>
>>
>>
>> On 15/07/2021 22.55, James wrote:
>>>> On 15 Jul 2021, at 8:50 pm, Eyal Lebedinsky <eyal at eyal.emu.id.au <mailto:eyal at eyal.emu.id.au><mailto:eyal at eyal.emu.id.au <mailto:eyal at eyal.emu.id.au>>> wrote:
>>>>
>>>>
>>>>
>>>> On 15/07/2021 22.08, stinga wrote:
>>>>> On 15/07/2021 19:45, James wrote:
>>>>>>> On 15 Jul 2021, at 7:36 pm, stinga<stinga+mythtv at wolf-rock.com <mailto:stinga+mythtv at wolf-rock.com> <mailto:stinga+mythtv at wolf-rock.com <mailto:stinga+mythtv at wolf-rock.com>>> wrote:
>>>>>>>
>>>>>>> On 15/07/2021 17:41, Eyal Lebedinsky wrote:
>>>>>>>> Thanks, this is it. I should have used 'sudo locate' rather than 'locate'.
>>>>>>>> My icons are in
>>>>>>>> /root/.mythtv/channels/
>>>>>>>>
>>>>>>>> cheers
>>>>>>> sudo shouldn't make any difference.
>>>>>> Not true.
>>>>>>
>>>>>> [sandypit] /home/jam [1005]% ls -ld /root
>>>>>> drwx------ 12 root root 4096 Jul 14 14:18 /root
>>>>>>
>>>>>> That means others cannot look there
>>>>> Yeah, correct, but locate is not ls, updatedb does not care about that or at least it does not on my debian box.
>>>>> I am guessing there are different ways to create the DB .
>>>>> Off topic for mythv, we managed to solve OPs issue!
>>>>
>>>> Yes you did, and thanks.
>>>>
>>>> One side point (from the original post) was left open though:
>>>> The program guide does not show any icons
>>>> I thought it should?
>>> To resolve that, and I'm sure there is a *correct* way, I wrote a short script to update the db directly.
>>> Mail me and I'll sent you a copy
>>
>> Others may be interested in the script, but if you prefer then my email should be in the From header
>> and in my sig below.
>
> You'll need to match chan numbers and icons
> I did not say to Eyal
>
> $ mysql -u mythtv -p mythtv mythconverg < seticons
> James
>
> [sandypit] /home/jam/mythconverg [1002]% cat seticons
> update channel set icon='seven.png' where chanid=10007;
> update channel set icon='7HD.png' where chanid=10070;
> update channel set icon='seven.png' where chanid=10071;
> update channel set icon='7two.png' where chanid=10072;
> update channel set icon='7mate.png' where chanid=10073;
> update channel set icon='7food.png' where chanid=10074;
> update channel set icon='7flix.png' where chanid=10076;
> update channel set icon='racing.png' where chanid=10078;
>
> update channel set icon='sbs.png' where chanid=10003;
> update channel set icon='sbshd.png' where chanid=10030;
> update channel set icon='sbsvicelandhd.png' where chanid=10031;
> update channel set icon='sbsviceland.png' where chanid=10032;
> update channel set icon='sbsfood.png' where chanid=10033;
> update channel set icon='sbsnitv.png' where chanid=10034;
>
> update channel set icon='9.png' where chanid=10009;
> update channel set icon='9HD.png' where chanid=10090;
> update channel set icon='9.png' where chanid=10091;
> update channel set icon='9gem.png' where chanid=10092;
> update channel set icon='9go.png' where chanid=10093;
> update channel set icon='9life.png' where chanid=10094;
> update channel set icon='yourmoney.png' where chanid=10095;
> update channel set icon='9go.png' where chanid=10099;
>
> update channel set icon='10bold.png' where chanid=10001;
> update channel set icon='10.png' where chanid=10010;
>
> update channel set icon='10peach.png' where chanid=10011;
> update channel set icon='10bold.png' where chanid=10012;
> update channel set icon='10HD.png' where chanid=10013;
> update channel set icon='TVSN.png' where chanid=10014;
> update channel set icon='spree.png' where chanid=10015;
>
> update channel set icon='abc.png' where chanid=10002;
> update channel set icon='ab3hd.png' where chanid=10020;
> update channel set icon='abc.png' where chanid=10021;
> update channel set icon='ABC2.png' where chanid=10022;
> update channel set icon='abcme.png' where chanid=10023;
> update channel set icon='abcnews.png' where chanid=10024;
>
> update channel set icon='wtv.png' where chanid=10044;
I see.
Since chanid is different for every installation, a 'where channum=' would suit most people
as this is stable. Even 'callsign=' should work.
I also have different file names... but if the channels change again (as win and nine
recently did) then a script like this should be handy.
So I just saved the current setup:
mysql -u root -p -s mythconverg <<<'select channum,icon,callsign from channel;' >icons.lst
for use later with:
while read channum icon callsign ; do
echo "update channel set icon='$icon' where channum='$channum';"
done <icons.lst >seticons
Or use callsign maybe.
--
Eyal Lebedinsky (eyal at eyal.emu.id.au)
More information about the mythtv-users
mailing list