[mythtv-users] Great source for channel icons (was --> "http://www.lyngsat-logo.com")

Greg Estabrooks greg at phaze.org
Thu Dec 22 09:35:35 EST 2005


>  Not asking for a feature, like you say I was just pointing out how useful 
> your script is going to be for me to generate this data to be inserted into the
> tables.

 I just tested it and it does work just like I expected.  I 
added some values to my database for a local channel that didn't have a logo
and mythfilldb grabbed it and updated the tables for me.... so if we can
populate a users table with either an SQL squirt or with some script 
the next time they run mfdb it will grab the images for any channels they have
that don't have logos. I plan on starting to gather big lists of this data
for most every country, users can import the data and let mythfilldatabase
handle the rest for them "automatically".


mysql> insert into callsignnetworkmap values(1610,'ELTV','lyngsat_ELTV');
Query OK, 1 row affected (0.04 sec)

mysql> insert into networkiconmap values (1610,'lyngsat_ELTV','[lyngsat]/aa/atv_halifax.jpg');
Query OK, 1 row affected (0.04 sec)

mysql> INSERT INTO settings VALUES ('mythfilldatabase.urlmap.lyngsat','http://www.lyngsat-logo.com/logo/tv',NULL);Query OK, 1 row affected (0.00 sec)

mythtv at woop:~$ mythfilldatabase --update-icon-map
2005-12-22 10:28:40.725 Using runtime prefix = /usr/local
2005-12-22 10:28:40.737 New DB connection, total: 1
2005-12-22 10:28:40.740 Enabling Settings Cache.
2005-12-22 10:28:40.741 Clearing Settings Cache.
2005-12-22 10:28:40.744 Updating icons for sourceid: 1
2005-12-22 10:28:40.745 New DB connection, total: 2
2005-12-22 10:28:40.749 New DB connection, total: 3
2005-12-22 10:28:40.764 Attempting to fetch icon with: wget --timestamping --directory-prefix=/home/mythtv/.mythtv/channels http://www.lyngsat-logo.com/logo/tv/aa/atv_halifax.jpg
--10:28:40--  http://www.lyngsat-logo.com/logo/tv/aa/atv_halifax.jpg
           => `/home/mythtv/.mythtv/channels/atv_halifax.jpg'
Resolving www.lyngsat-logo.com... 195.35.83.150
Connecting to www.lyngsat-logo.com[195.35.83.150]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 3,163 [image/jpeg]

100%[======================================================================>] 3,163         --.--K/s

10:28:41 (20.99 KB/s) - `/home/mythtv/.mythtv/channels/atv_halifax.jpg' saved [3163/3163]

Updating channel icon for chanid: 1010




More information about the mythtv-users mailing list