encrypted or something web page

[Lasse Reichstein Nielsen]

Have a look at http://www.foxtel.com.au/TVGuide.aspx
Select a channel in the left hand box, say discovery, hit GO. ....
There appears to be a block of encrypted stuff down the
bottom which is about the right size for the program data.

Anyone got any ideas about how to unencrypt it ?

It seems that the decryption function changes name too. In my current
load of the page, it's called "kt".

To see the "kt" function, simply write this in the address line:
javascript:kt
.... or replace "kt" with the name of the function in your page.

It's rather cryptic. Here is another function that decodes the string
(made without looking at their code, it confuzed more than it helped
anyway):
---
function decode(s) {
var buf = [], n=s.length, h=(n+1)>>1;
for(var i = 0; i<h ; i++) {
buf=s.charAt(i*2+1);
buf[n-i]=s.charAt(i*2);
}

return buf.join("");
}
---
(I don't know whether it works with even length strings, I only had
an odd length string to test with).


You can't hide parts of a web page from the person who controls the
client
/L

 

[Unknown]

Nope, you should get the day's TV guide for that channel.

Looks like its IE specific code since Neil cant see it either.

Works OK here. I got timeout when I had ZA Pro running. Otherwise just OK.
Clicking EDIT gets the page fine.

 

[Rod Speed]

Sorry, I read "import into access" as meaning you were then
going to serve the data up onto another web page. If not then OK,

Yeah, its just for my own use.

they will never know.

And it doesnt matter if they do, completely legal.

Do I recall discussing this with you a couple of years ago?
That is, scraping stuff off a web page into an access database?

Could be, I certainly had a problem initially with the
foxtel pages needing POST method for access.

 

[Rod Speed]

javascript:window.clipboardData.setData('text',document.getElementById("tblCellTVGuideResults").innerText);void%200

In IE will copy it to the clipboard.

Doesnt here, the clipboard just has that string in it, from when I pasted that to the address bar.

 

[Rod Speed]

Whoops, this escaped part edited
More added at the bottom.

Sorry, I read "import into access" as meaning you were then
going to serve the data up onto another web page. If not then OK,

Yeah, its just for my own use.

they will never know.

And it doesnt matter if they do, completely legal.

Do I recall discussing this with you a couple of years ago?
That is, scraping stuff off a web page into an access database?
Yep
http://groups.google.com/[email protected]

In any case, regardless of what the alert gives you it should be a simple
matter to knock up a C# or C++ program to host the MSHTML control and
point it at the page. Then you have programatic access to the entire DOM.

Wanna spell that out a bit more please ?

 

[Rod Speed]

Rod Speed wrote:

Google: XMLTV.

Interesting, thanks for that.

Not sure it helps with the particular problem of that particular web page tho.

The other ones are easy enough to import into access.
The problem is that the detail isnt as good, particularly
they lack the episode title and since I am using that to
keep track of what I have watched already, particularly
with the high level of repeats on the PayTV channels like
Discovery, I need more than just the series title for that.

 

[Rod Speed]

It seems that the decryption function changes name too.
In my current load of the page, it's called "kt".

Figures I spose.

To see the "kt" function, simply write this in the address line:
javascript:kt
... or replace "kt" with the name of the function in your page.

Where are you getting the kt from ? Is it the cn in this load ?

<td id="tblCellTVGuideResults" align="Center"><SCRIPT LANGUAGE="JavaScript" src="jscript.aspx?a=038158.22552643520"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript">cn(" rtseAeanheGs plri,

Looks like it, javascript:cn does produce some visible code.

Thanks for that, I'll have a closer look at that. Looks quite doable.

It's rather cryptic. Here is another function that decodes the string
(made without looking at their code, it confuzed more than it helped
anyway):
---
function decode(s) {
var buf = [], n=s.length, h=(n+1)>>1;
for(var i = 0; i<h ; i++) {
buf=s.charAt(i*2+1);
buf[n-i]=s.charAt(i*2);
}

return buf.join("");
}

 

[rf]

javascript:window.clipboardData.setData('text',document.getElementById("tblC
ellTVGuideResults").innerText);void%200

Doesnt here, the clipboard just has that string in it, from when I pasted

that to the address bar.

You *did* press Enter after you pasted that string to the address bar,
didn't you?

 

[Rod Speed]

that to the address bar.

You *did* press Enter after you pasted that string to the address bar,
didn't you?

Clicked the GO button, actually.

And javascript:cn worked fine there, to show me its code.

 

[Rod Speed]

Clicked the GO button, actually.

And javascript:cn worked fine there, to show me its code.

Worked fine this time tho, maybe it had timed out by the time I tried it the
last time. This time I got the normal display up in the usual way, then put that
javascript:window.clipboardData.setData('text',document.getElementById("tblCellTVGuideResults").innerText);void%200
into the address bar and it worked fine.

Thanks for that, have to consider whether its easier to do it like
that or to just capture the encoded text in the usual way and just
redo the decoding code into VBA and decode it myself.

 

[Rod Speed]

Create a Favorites for it, or the Links toolbar, and then anytime you
need it it's only a click away to get it to the clipboard.

Have two pages open. Yours and the website. Copy it from the website,
paste it into your own Textarea, and then submit the form and have it
posted in a database for you.

I've got it all automated back in Access.

It goes and gets the specified number of days data for
the specified channels, from the specified web sites.
Most channel data comes from at least 2 web sites,
so it carrys on regardless with one web site down etc.

That was working fine with that foxtel site until they
decided to play silly buggers encrypting the data.

So its better to have the access app still get the
data from the websites completely automatically.