[mythtv-users] Where are channel icons kept? [resolved]

[James]

> On 15 Jul 2021, at 9:15 pm, Eyal Lebedinsky <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>>  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;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210715/ae775d48/attachment.htm>