[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