Complete Logo Slice (NZ)

[DJC]

I've manufacured a relatively complete logo slice for the 02113 postcode. Source logos from various locations credits to those artists.

The slice is part of the beta emulator on orac, the port 8000 one.

To access it you'll need to run a GS against that emulator. If you have a previous logo slice added you'll need to do a ClearAndDelete .. then GS.

Te beta emulator is running the standard headends. This probably won't change for a while as I'm busy with other work.

The beta emulator receives the same daily dev slices as orac's main emulator. If you are on the dev emulator [as wanted points out] and have no logos, you can just switch in to get the logo slice.

Once you've GS'ed againt the beta emulator, you can move off it back to the main orac emulator without issue.

Slice number is 151, yes it took that many versions to get a stable slice.

If you have loaded other emulator slices like logos-67 ... stardard-110 ... canda's merged slices to bootstrap tivoweb for manual logo uploading, you'll need to clear and delete before loading this slice. They all use the same LogoGroup ServerId's.

If you have no logos and don't use an emulator, grab the slice from orac's ftp, dbload it and automatically associate logos.

Once you have GS'ed and rebooted then its a matter of going into tivoweb, and doing a one click associate as per the image below, all logos should automatically link up (the current headend doesn't have the linking id's for automatic association).

Experimental ... using myself ... interested in testers ... and better logos.


/DJC

[timmy]

cool can you send me a copy of these logos. were these the ones shown in another thread or have u added to them. I need them for the web interface. I noticed you had put a few into the database. I could'nt view them tho so not sure whether it was you or I at fault.. probably me, hehe.

[Wanted]

Sweet, I'm gonna try it out. I'll edit the post when I am done... or stuck.

EDIT: NICE! Works beautifully. I changed to the dev port and back using my Saturn code with no issue. I didn't need to clear all the data either as I was already on the port 80 orac emulator. You're a leg end.

[deanm]

I have improved the quality of the logo's I originally posted quite a lot on a pixel-by-pixel basis.
Will round 'em up and post them here.

Post what channels are missing and i'll create them when i get a chance.

[DJC]

I have improved the quality of the logo's I originally posted quite a lot on a pixel-by-pixel basis.
Will round 'em up and post them here.

Post what channels are missing and i'll create them when i get a chance.

Cheers Dean, some of them are yours originally I think, others come from other emulators, including AU/Canada ... A few I did from various images and are are frankly shocking. But none are missing.

My goal was to get an operational and working slice... which has alluded me for 151 versions ... but I'm on it now.

It should be a matter of now just updating logos versions by replacing the image and building a slice, the slice versioning should send the new images to the tivos on the beta emulator.

... look forwarding to some updates ...

[DJC]

cool can you send me a copy of these logos. were these the ones shown in another thread or have u added to them. I need them for the web interface. I noticed you had put a few into the database. I could'nt view them tho so not sure whether it was you or I at fault.. probably me, hehe.

... the png's for the images are in the databse, uploaded via phpmyadmin, definitely should work. Originally only did a few but they are all there now.

... the goal is to generate the logo slice (as prer the headends) from the channels table ... linked to a headends config table allowing custome headends for various services and regions ...

... so it would be nice to figure the db driven logos out.

[timmy]

ok cool i'll assume user error and try again tonite

Weird cause I used Navicat (the mysql rich client tool) to try to view them too but could'nt, tho that prog has been causing me some troubles as I mentioned..

[Wanted]

I have improved the quality of the logo's I originally posted quite a lot on a pixel-by-pixel basis.
Will round 'em up and post them here.

Post what channels are missing and i'll create them when i get a chance.

All the ones I care about are there but if you want to be complete there are a few missing (on Saturn anyway).

14 TAB
17 DTA (Discovery Travel & Adventure)
35 Satwx (Saturn Weather)
36 TVSN (Television Shopping Network)
37 TBNSat (TBN I forget what this stands for but it's religious)
63 SCAN (Montage)
64 Choose (Saturn channel guide)
65 SBOGuide (Box Office movie guide)
66 Peek (Box Office now showing trailers)
1095 NoNag (no nag channel)

[DJC]

14 TAB
17 DTA (Discovery Travel & Adventure)
35 Satwx (Saturn Weather)
36 TVSN (Television Shopping Network)
37 TBNSat (TBN I forget what this stands for but it's religious)
63 SCAN (Montage)
64 Choose (Saturn channel guide)
65 SBOGuide (Box Office movie guide)
66 Peek (Box Office now showing trailers)
1095 NoNag (no nag channel)

Tab/TVSN should be there (are on my tivo) ... no saturn logos in the slice ... quite right.

[DJC]

I could'nt view them tho so not sure whether it was you or I at fault.. probably me, hehe.

Take a look at this url ...

http://orac.caffeine.co.nz/logo.php?channel=1001

Channel number change to 1002 ... 1003 ... 1004 etc ... you'll get the logos for each channel.

Here is the php code, pretty basic

<?
// Connect to orac (local host and select user only)
$db = mysql_connect('localhost', ...user..., ...pass...);
mysql_select_db('guideData', $db);
// Query the database
$out = mysql_query("SELECT logoS1 FROM channels WHERE channel_id='$channel'", $db);
if (mysql_num_rows($out) > 0) {
	 // Get the blob
	 $row = mysql_fetch_array($out);
	 $jpg = $row["logoS1"];
	 // Stream the file to the browser
	 header("Content-type: image/jpeg");
	 echo $jpg;
}
mysql_close($db)
?>