Mailing List Archive

Where are channel icons kept?
I checked everywhere and cannot identify it.

Running
mythtv-setup
Channel editor
5 10 Canberra
Channel Options - Common
Icon
I enter
10.png
then exit and save.

I have a 10.png file in all places that I consider reasonable
/var/lib/mythtv/icons/
/var/lib/mythtv/logos/
/home/eyal/.mythtv/channels/
/home/mythtv/.mythtv/channels/
/home/eyal/.mythtv/themecache/
/home/mythtv/.mythtv/themecache/
but it is not picked up.

Furthermore, the channel editor keeps showing an icon that was used in the past but was removed now
from all of the above directories.

I should mention that the program guide does not show any icons either. In the database I see

MariaDB [mythconverg]> select * from settings where value like '%icon%';
+--------------------+------+--------------------+
| value | data | hostname |
+--------------------+------+--------------------+
| EPGShowChannelIcon | 1 | e7 |
| EPGShowChannelIcon | 1 | e7.eyal.emu.id.au |
| EPGShowChannelIcon | 1 | localhost |
+--------------------+------+--------------------+

How do I set up the icon for a channel?

TIA

--
Eyal Lebedinsky (eyal@eyal.emu.id.au)
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [ In reply to ]
On 15/07/2021 16:24, Eyal Lebedinsky wrote:
> I have a 10.png file in all places that I consider reasonable
> /var/lib/mythtv/icons/
> /var/lib/mythtv/logos/
> /home/eyal/.mythtv/channels/
> /home/mythtv/.mythtv/channels/
> /home/eyal/.mythtv/themecache/
> /home/mythtv/.mythtv/themecache/
> but it is not picked up.

Mine are in

root@mythtv:~# locate abc1_au.png
/home/mythtv/.mythtv/cache/thumbnails/myth:--ChannelIcons@mythtv-abc1_au.png--102x77.png
/home/mythtv/.mythtv/channels/abc1_au.png
/var/cache/mythweb/image_cache/abc1_au.png

--
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email: stinga+mythtv@wolf-rock.com o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
On 15/07/2021 18.37, stinga wrote:
> On 15/07/2021 16:24, Eyal Lebedinsky wrote:
>> I have a 10.png file in all places that I consider reasonable
>> /var/lib/mythtv/icons/
>> /var/lib/mythtv/logos/
>> /home/eyal/.mythtv/channels/
>> /home/mythtv/.mythtv/channels/
>> /home/eyal/.mythtv/themecache/
>> /home/mythtv/.mythtv/themecache/
>> but it is not picked up.
>
> Mine are in
>
> root@mythtv:~# locate abc1_au.png
> /home/mythtv/.mythtv/cache/thumbnails/myth:--ChannelIcons@mythtv-abc1_au.png--102x77.png
> /home/mythtv/.mythtv/channels/abc1_au.png
> /var/cache/mythweb/image_cache/abc1_au.png

Thanks, this is it. I should have used 'sudo locate' rather than 'locate'.
My icons are in
/root/.mythtv/channels/

cheers

--
Eyal Lebedinsky (eyal@eyal.emu.id.au)
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
On 15/07/2021 11:41, Eyal Lebedinsky wrote:
> My icons are in
>     /root/.mythtv/channels/
>
> cheers

This suggests that your backend is running as root. Is it? Not good for
security...
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
On 15/07/2021 20.18, Jan Ceuleers wrote:
> On 15/07/2021 11:41, Eyal Lebedinsky wrote:
>> My icons are in
>>     /root/.mythtv/channels/
>>
>> cheers
>
> This suggests that your backend is running as root. Is it? Not good for
> security...

I know. I did not set it up this way, must be how it was initially ran when it was installed
over 15 years ago.

--
Eyal Lebedinsky (eyal@eyal.emu.id.au)
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
On 15/07/2021 20.29, Eyal Lebedinsky wrote:
>
>
> On 15/07/2021 20.18, Jan Ceuleers wrote:
>> On 15/07/2021 11:41, Eyal Lebedinsky wrote:
>>> My icons are in
>>>      /root/.mythtv/channels/
>>>
>>> cheers
>>
>> This suggests that your backend is running as root. Is it? Not good for
>> security...
>
> I know. I did not set it up this way, must be how it was initially ran when it was installed
> over 15 years ago.

I should clarify. The daemons run as user mythtv.
mythtv-setup does not start unless it is launched as root.

--
Eyal Lebedinsky (eyal@eyal.emu.id.au)
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
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.

--
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email: stinga+mythtv@wolf-rock.com o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
On 15/07/2021 21.36, stinga 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.

I beg to differ:

$ locate 10.png| grep /10.png|wc -l
19
sudo locate 10.png| grep /10.png|wc -l
21

'locate' will not show files that the user does not have permission to see.

--
Eyal Lebedinsky (eyal@eyal.emu.id.au)
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
> On 15 Jul 2021, at 7:36 pm, stinga <stinga+mythtv@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

James

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
On 15/07/2021 19:41, Eyal Lebedinsky wrote:
> I beg to differ:
>
> $ locate 10.png| grep /10.png|wc -l
> 19
> sudo locate 10.png| grep /10.png|wc -l
> 21
>
> 'locate' will not show files that the user does not have permission to
> see.
I do as well...

root@mythtv:~# ll zxzx
---------- 1 root root 0 Jul 15 19:55 zxzx

root@mythtv:~# locate zxzx
/root/zxzx


mythtv@mythtv:~$ locate zxzx
/root/zxzx

¯\_(?)_/¯

Must some difference somewhere, I prefer my version!

--
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email: stinga+mythtv@wolf-rock.com o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
On 15/07/2021 19:45, James wrote:
>> On 15 Jul 2021, at 7:36 pm, stinga<stinga+mythtv@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!

--
'ooroo

Stinga...(:)-)
---------------------------------------------------
Email: stinga+mythtv@wolf-rock.com o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
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@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?

--
Eyal Lebedinsky (eyal@eyal.emu.id.au)
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
> On 15 Jul 2021, at 8:50 pm, Eyal Lebedinsky <eyal@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@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
James
Re: Where are channel icons kept? [resolved] [ In reply to ]
On 15/07/2021 22.55, James wrote:
>
>
>> On 15 Jul 2021, at 8:50 pm, Eyal Lebedinsky <eyal@eyal.emu.id.au <mailto:eyal@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@wolf-rock.com <mailto:stinga+mythtv@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.

cheers

> James


--
Eyal Lebedinsky (eyal@eyal.emu.id.au)
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
Re: Where are channel icons kept? [resolved] [ In reply to ]
> On 15 Jul 2021, at 9:15 pm, Eyal Lebedinsky <eyal@eyal.emu.id.au> wrote:
>
>
>
> On 15/07/2021 22.55, James wrote:
>>> On 15 Jul 2021, at 8:50 pm, Eyal Lebedinsky <eyal@eyal.emu.id.au <mailto:eyal@eyal.emu.id.au><mailto:eyal@eyal.emu.id.au <mailto:eyal@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@wolf-rock.com <mailto:stinga+mythtv@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;
Re: Where are channel icons kept? [resolved] [ In reply to ]
On 15/07/2021 23.38, James wrote:
>
>
>> On 15 Jul 2021, at 9:15 pm, Eyal Lebedinsky <eyal@eyal.emu.id.au <mailto:eyal@eyal.emu.id.au>> wrote:
>>
>>
>>
>> On 15/07/2021 22.55, James wrote:
>>>> On 15 Jul 2021, at 8:50 pm, Eyal Lebedinsky <eyal@eyal.emu.id.au <mailto:eyal@eyal.emu.id.au><mailto:eyal@eyal.emu.id.au <mailto:eyal@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@wolf-rock.com <mailto:stinga+mythtv@wolf-rock.com> <mailto:stinga+mythtv@wolf-rock.com <mailto:stinga+mythtv@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@eyal.emu.id.au)
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org