Forum: hoop
Page 11558
Subject: Enhanced Yahoo Boxscores

  Posted by: RecycledSpinalFluid - Dude [204401122] Fri, Oct 14, 2005, 18:01
My Enhanced Boxscores were taking up too much bandwidth to successfully have hosted on a free webhost, so I decided to pull it from the web...and make it a stand-alone HTA program that runs on your machine.

The HTA (HTML Application) source is fully visible and customizable. If you download it and come up with a cool hack, you are obligated to share.

Warning, I am far from a professional coder, so if you think my coding sucks...well...join the crowd.

One thing I have seen with this current version is that it seems to only run with higher level permissions (I only run WinXP-Pro at Administrator levels, so I don't know how it reacts to other OSes and such).

Download and use at your own risk...

Enhanced Boxscore Viewer

Couple of quick notes:
  1. The columns are sartible and reverse sartible, by clicking and reclicking on the headers.
  2. If you can't figure out what the column headers are, hover over the header with your mouse. A tooltip will appear.
  3. I was also going to put a RotoGuru icon in there, but couldn't find a URL to a small enough image...and he probably doesn't need the traffic wasted anyway.
 
1allhair allstars
      Sustainer
      ID: 50902421
      Fri, Oct 14, 2005, 22:29 		Nice work!
 
2Farn
      Sustainer
      ID: 451044109
      Fri, Oct 14, 2005, 22:32 		Great work RSF. much appreciated.
 
3RecycledSpinalFluid
      Dude
      ID: 204401122
      Fri, Oct 14, 2005, 22:39 		Just thought of some more stuff for it, like "Refresh" buttons for the scores only or the boxscores only.

Any and all suggestions gladly welcome...whether it gets acted upon is a whole nother issue... :)
 
4allhair allstars
      ID: 519202713
      Tue, Nov 01, 2005, 11:54 		RSF,
Since you asked... and since it's a favorite pastime of mine to send you lists of annoying suggestions... let me jot a few notes down that fall under the personal preference category that might be worthwhile implementing or not - your call.

= Could you center justify all the numerical columns?
= Could you force the decimal place in the TSN column?
= Auto-refresh? Or, since I like your suggestion of the refresh button, how about a refresh button?
= Can you reformat the player names so that they appear "last name, first init" instead of the opposite?
= Not sure how many players play PSC as opposed to TSN, but if you've got nothing else to do, could you put the TSN column first? Not sure how it appeared last year, and this is an ultra-minor deal...
= Could you show the scores of the games in the left-hand column (where the game links appear)? Especially useful in place of just "final"...
= Could you space or otherwise delimit the night's games? I find it a little difficult to read the pre-game listings given that all the channels are also listed. Am I a whiney little bitch or what?
= Can you add vertical rules at logical places in the stats box? For example, perhaps group the FG, 3P, and FT columns together, the RB and AST columns, so on and so forth? I think this improves the readability of the data and provides improved visual clues for those of us scanning the boxscores...

Ok, I admit I've always loved your boxscore viewer, and with this newest version it looks like we'll have the performance upgrade we've been waiting for. Use or toss these suggestions... no worries, and thanks for putting this great tool together.
 
5RecycledSpinalFluid
      Dude
      ID: 204401122
      Wed, Nov 02, 2005, 22:25 		allhair allstars:
1.) Done
2.) Done
3.) Button Done (to refresh boxscore, just click the game link.)
4.) You're on your own. Too much rework for now...
5.) Done
6.) Initially...it looks like a PITA, so probably not.
7.) Sorta took care of this. Get a bigger monitor... :)
8.) Done, but not to my liking. Cheated and went with : as a seperator.

Get Version 7aa here.
 
6RecycledSpinalFluid
      Dude
      ID: 204401122
      Wed, Nov 02, 2005, 23:31 		Alternate download site: Version 7aa
 
7Memphis Fan
      ID: 5497319
      Wed, Nov 02, 2005, 23:38 		I can't get it to run under Windows XP2 (Admin) anyone have any luck?

Permission Error on line 153.
 
8RecycledSpinalFluid
      Dude
      ID: 204401122
      Wed, Nov 02, 2005, 23:49 		I think is related to IE Zone permissions (Tools-Internet Options-Security(TAB)). Not overly positive on the final settings requirements.
 
9RecycledSpinalFluid
      Dude
      ID: 204401122
      Wed, Nov 02, 2005, 23:53 		Also just uploaded last years online version to: http://rsf.hopto.org/index.asp
 
10allhair allstars
      Sustainer
      ID: 50902421
      Thu, Nov 03, 2005, 00:18 		I'm touched by the version #... :)

The revisions are great - a little goes a long way! Jury still out on the dividers, but IMHO it's an easier read now than before.

Sure wish my health insurance provider was as responsive as you are... or my kids, for that matter! Thanks (as usual) for ALL your work!
 
11RecycledSpinalFluid
      Dude
      ID: 204401122
      Thu, Nov 03, 2005, 01:07 		allhair allstars, just realized a simple solution for your column breaks. Uploaded as same version number.
 
12VP
      ID: 17105120
      Thu, Nov 03, 2005, 02:01 		Great tool RSF, nice updates too...an auto-update feature might be nice :) I was wondering why mine seemed to break a few hours ago :)

I'll try to look into reversing the names...dunno though...like you said annoying coding for that :)
 
13 nmcrented
      ID: 38382921
      Thu, Nov 03, 2005, 08:03 		To reverse the names, just use this for the "name" code:

retrieveItem = Left(strBuffer,findStrLoc)
strBuffer = Right(strBuffer, Len(strBuffer) - Len(retrieveItem))
tNamePos = InStrRev(retrieveItem, ".")
tName2 = Right (retrieveItem, Len(retrieveItem) - tNamePos)
tName2 = tName2 & ", " & Left(retrieveItem, tNamePos)
arrPlayer(1, UBound(arrPlayer, 2)) = tName2
 
14RecycledSpinalFluid
      Dude
      ID: 204401122
      Thu, Nov 03, 2005, 11:33 		Most excellent!

Download here: Version 8
or here: Version 8
 
15allhair allstars
      Sustainer
      ID: 50902421
      Thu, Nov 03, 2005, 13:11 		I admit I'm partial to Version 7aa, short lived as it was, but hey, Eight is great!
 
16allhair allstars
      Sustainer
      ID: 50902421
      Thu, Nov 03, 2005, 21:45 		RSF,

Gonna add one more quickish item to the list of suggestions (one that I forgot about before...)

Can you force the width of the Player Name column so that both team box score tables (on any given box score page) will line up vertically? This kinda goes along with the new improved column breaks... Again, just a suggestion for some future version...
 
17RecycledSpinalFluid
      Dude
      ID: 204401122
      Thu, Dec 29, 2005, 21:19 		Did a few tweaks today, including players names now link to yahoo pages.

Download here: Version 9
 
18Dave R
      Dude
      ID: 3010361110
      Thu, Dec 29, 2005, 21:34 		Definately cool, RSF!!!!!
 
19allhair allstars
      Sustainer
      ID: 50902421
      Thu, Dec 29, 2005, 22:06 		Nice work. I'm a daily user and your handy tool is on ALL my computers... :)
 
20ole
      Donor
      ID: 01797261
      Thu, Dec 29, 2005, 22:14 		looks great thanks rsf.
 
21RecycledSpinalFluid
      Dude
      ID: 204401122
      Fri, Dec 30, 2005, 22:57 		Another slight tweak to address Post 16.

Download here: Version 10aa
 
22RecycledSpinalFluid
      Dude
      ID: 204401122
      Fri, Nov 17, 2006, 13:27 		BUTT

Only the link in [21] is active, I think...maybe...
 
23RecycledSpinalFluid
      Dude
      ID: 204401122
      Fri, Nov 17, 2006, 13:41 		Well, proving that me and thinking don't always get along, a lot of those old links are still out there, clogging up Al Gore's internet.
 
24RecycledSpinalFluid
      Dude
      ID: 204401122
      Fri, Dec 29, 2006, 23:07 		Going through and revamp the code for another project, I tweaked this some. Could I get some people to test rev.11 and say whether the look sucks or not?

Enhanced Yahoo Boxscores rev 11 (right click and save)
 
25JT
      ID: 4311532922
      Fri, Dec 29, 2006, 23:53 		I tried the new one and I have to say I still prefer 010
 
26RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Dec 30, 2006, 03:05 		Yeah, I'm with you. I just went in a did a bunch more tweaks. Still want to blow the whole thing up.
 
27RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Jan 06, 2007, 00:31 		Enhanced Yahoo Boxscores rev 12

Changed it up.
 
28LBJ
      ID: 0040523
      Sat, Jan 06, 2007, 00:40 		ARGHHHH...I'm going blind from all the yellow!!!

If it ain't broke don't fix it. RSF stop fixing it. :)
 
29RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Jan 06, 2007, 00:42 		LOL...had to do that...my contrast is dieing on my laptop....lol...sorry man.
 
30Tosh
      Leader
      ID: 057721710
      Sat, Jan 06, 2007, 00:45 		If you could add a 'refresh' button (or tell me how to refresh) ... that would be great.

I don't mind the yellow at all.
 
31RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Jan 06, 2007, 00:47 		Trying to figure that one out Tosh. Even hitting F5 (which is code reload), it still doesn't do a page refresh.
 
32RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Jan 06, 2007, 21:09 		Enhanced Yahoo Boxscores rev 13 (right click and save)

Tosh, one functional refresh button at your service.
 
33Tosh
      Leader
      ID: 057721710
      Sat, Jan 06, 2007, 21:46 		I think we have a problem Houston. It says Mikki Moore has 16 points and LBJ has 9. That can't be right. But seriously ...

I still can't figure out the 'refresh' button. This is what I am getting.

When I open the program (using IE), it says there is 11:41 left in the CLE/NJ game. Confirmed at the Yahoo site.

- After about a 2 minutes of gametime (9:18 left), I press 'refresh' and nothing happens (but the button appears like it's being pushed).
- I click back one day, then up to the current day, and the scoreboard has refreshed to 9:18. The stats are correct.
- I click 'refresh' and the scoreboard/stats revert back to 11:41.
- Going back and forward in the date does not solve the problem at this point. I am unable to get a refresh after the initial one, and cannot get past 9:18

F5 also reverts it back to 11:41

Does any of this description make sense?
 
34Farn
      Leader
      ID: 451044109
      Sat, Jan 06, 2007, 21:53 		refresh button is working. and if you hit the back button and get a refresh at some point even when you click on the new score the old stats still appear.


(saying it with a tone to help work out bugs and not an unappreciative way. much love RSF, especially considering you don't play these games)
 
35Gescom
      Leader
      ID: 520461315
      Sat, Jan 06, 2007, 22:08 		[33] This is also exactly what I'm getting. I havn't found better than to close and re-open game viewer to refresh.
That's said, fantastic tool RSF
 
36Tosh
      Leader
      ID: 057721710
      Sat, Jan 06, 2007, 22:09 		I need to amend the previous post slightly. When I hit 'refresh' the first time, it works perfectly (the scoreboard updates all pretty-like). It's when I hit 'refresh' the second time that the above process starts.

You coming up for an Ms game this year RSF? It's hard to believe it's been over 6 years since we've hoisted a beer together.

And many thanks for such a nifty tool!
 
37RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Jan 06, 2007, 22:31 		OK, so going back/forward works, but the button sucks? Is that an improvement, or was it doing that already?
 
38RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Jan 06, 2007, 22:34 		Re [36]...ah...thats what I was seeing. I'd test and recode. I must have been reloading each time.

Re the Ms game. I was just thinking that same thing. It was 9/11/2000...man thats a long time ago.
 
39RecycledSpinalFluid
      Dude
      ID: 204401122
      Tue, Jan 09, 2007, 23:42 		Enhanced Yahoo Boxscores rev 14 (Right click and Save As)

A functional refresh button...really.

Figured out a way around it only loading a page one time. Just used Yahoo's URL refresh "refresh=" and increment it +1 each view, tricking it into thinking its a new URL.
 
40Tosh
      Leader
      ID: 057721710
      Wed, Jan 10, 2007, 21:31 		Works perfectly. Thanks RSF!
 
41Farn
      Leader
      ID: 451044109
      Wed, Jan 10, 2007, 22:24 		RSF, the refresh button refreshes the score but doesn't refresh stats. And then I reclick on the same game and the stats don't change either.

When I close it out and reopen though I see the up to date stats.
 
42Tosh
      Leader
      ID: 057721710
      Thu, Jan 11, 2007, 00:17 		He's right. Cancel my contract as a beta tester. The individual player stats do not refresh. Only the scores do.

I can't believe I missed that.
 
43RecycledSpinalFluid
      Dude
      ID: 204401122
      Thu, Jan 11, 2007, 00:38 		Gees, ya bunch of whiners.... :)

Enhanced Yahoo Boxscores rev 15 (Right click and Save)
 
44allhair allstars
      Sustainer
      ID: 50902421
      Thu, Jan 11, 2007, 00:52 		Makes me wish I was playing TSN Hoops this year! :)
 
45Tosh
      Leader
      ID: 057721710
      Thu, Jan 11, 2007, 01:02 		RSF - You misspelled that. It's spelled 'winners'.

Rev 15 works great with only one game in progress. I'll report back tomorrow. Thanks for the prompt customer service.
 
46Addicted
      Dude
      ID: 4611592518
      Thu, Jan 11, 2007, 22:12 		RSF,
Not to complain...
Ahhh why not!! I didn't post on Jedman's I'm bitter thread.
Using the forward arrows isn't bringing up the next day's schedule. It works for the back arrows.

--Addicted--
 
47Logan47474
      Sustainer
      ID: 421021139
      Thu, Jan 11, 2007, 22:33 		Not to complain, but when are we going to get live-action scoring? I mean, sheesh.
 
48RecycledSpinalFluid
      Dude
      ID: 204401122
      Thu, Jan 11, 2007, 22:49 		RE [46], yeah, I noticed that the other day. My latest "fixes" fixed to that (ie...it used to work...DOH!)

Anything in this thread isn't taken as complaining. Just attempts to make it more useful.

RE [47], not really that far off. Thinking on adding an "auto-refresh" that you can set the duration between refreshes to. So, if 1 second between refreshes make you happy, then have at it. Can deal with this now that the manual refreshes actually work.
 
49tothreeball
      Dude
      ID: 09118139
      Thu, Jan 11, 2007, 23:01 		Any idea how to resolve a permission denied message when I go to run the viewer.
 
50RecycledSpinalFluid
      Dude
      ID: 204401122
      Thu, Jan 11, 2007, 23:58 		Did you mess with the setting in post 8?
 
51RecycledSpinalFluid
      Dude
      ID: 204401122
      Fri, Jan 12, 2007, 20:31 		Enhanced Yahoo Boxscores rev 16 (Right click and Save)

Early version of the "auto refresh". Currently hardcoded for 15 second intervals.

It will refresh the available boxscores (left pane) and the current viewed boxscore (right pane).

Beta test and complain here... ;)
 
52tothreeball
      Dude
      ID: 09118139
      Fri, Jan 12, 2007, 22:59 		RSF, yes I looked at that. I changed a few things but I have no idea if I was changing the right settings. Actually I do have an idea, I wasn't changing the right setting as I could get it to load properly. I guess I can try again, just not sure what I'm looking for.
 
53RecycledSpinalFluid
      Dude
      ID: 204401122
      Fri, Jan 12, 2007, 23:03 		OK. I thought I had which settings it was (atleast I could replicate getting the error then undo it). I'll dink around again and try to figure it out again.
 
54tothreeball
      Dude
      ID: 09118139
      Fri, Jan 12, 2007, 23:26 		Appreciate the help. Thank you.
 
55RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Jan 13, 2007, 00:00 		Here is a screen capture of my settings in post 8.

I'd go through. Change one at a time, test, if no change, set back, change the next one, test. Lather, rinse and repeat.

If its not just one...then I guess do them all.
 
56RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Jan 13, 2007, 00:01 		Of course...yahoo boxes are down right now...a coincidence...I hope so. :)
 
57tothreeball
      Dude
      ID: 09118139
      Sat, Jan 13, 2007, 00:49 		Eureka, thanks for your assistance RSF. Very impressive.
 
58RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Jan 13, 2007, 01:14 		So...were you able to isolate which setting it was?
 
59tothreeball
      Dude
      ID: 09118139
      Sat, Jan 13, 2007, 01:23 		Probably not. I went through your settings. I must have a different IE version as the settings were similar but not exact to the ones on my Internet Options. I made changes to match your screen capture settings as best I could, I think about 8 changes and it worked. I didn't go through them one at a time, my apologies. May have been helpful to anyone else having a similar problem. I am getting constant messages telling me my computer is now at risk from a security standpoint. (Perhaps I should play around as you suggested one setting at a time to see if this will go away) Oh well, I think I'll just lock the doors and pack it in for the night. Thanks again for your assistance. Looking forward to having this available on an ongoing basis.
 
60RecycledSpinalFluid
      Dude
      ID: 204401122
      Mon, Jan 15, 2007, 21:32 		Enhanced Yahoo Boxscores rev 17 (Right click and Save)

Adjustable AutoRefresh settings on the right.
 
62rolf1001
      Sustainer
      ID: 038118220
      Wed, Jan 31, 2007, 16:58 		Wonderful tool, RSF :)

On german Windows systems, there's a small "bug" because we have "," as decimal separator instead of "."
So the calulated TSNP are too big, eg. 350,00 instead of 35,00.
Adding
SetLocale("en-us")
at the beginning of the script did the job for me.
My VBA skills are very limited, so i don't know if this has any secondary effects on other systems.
But now your tool works on my local machine.
 
63RecycledSpinalFluid
      Dude
      ID: 204401122
      Wed, Jan 31, 2007, 19:28 		Good to know. I'll add that in the next release, as there are another thing or two I'd like to fix (or re-fix). Overall, I'm liking how it sits right now.
 
64Addicted
      Dude
      ID: 4611592518
      Sat, Mar 03, 2007, 14:41 		RSF,
Something's happened to the Yahoo Boxscores.
I've been getting the this message the last 2 days.
I'm getting a script error on line 206, character 2. Type mismatch: '[ string: "03/02">Mar 2 | "]'

Can you take a look at it?

--Addicted--
 
65deejay
      Donor
      ID: 501182710
      Sat, Mar 03, 2007, 14:45 		Same here, Addicted.

I get a runtime error.
Line: 775

it says. no clue what that means.
 
66RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Mar 03, 2007, 17:28 		I'll check it out later.
 
67RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Mar 03, 2007, 18:14 		Enhanced Yahoo Boxscores rev 18 (Right click and Save)
 
68deejay
      Donor
      ID: 501182710
      Sat, Mar 03, 2007, 22:47 		Same story, rsf...
 
69RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Mar 03, 2007, 22:48 		Don't know what to say. It works for me. Anyone else having issues with Rev 18?
 
70Dave R
      SuperDude
      ID: 3010361110
      Sat, Mar 03, 2007, 22:54 		Works here
 
71deejay
      Donor
      ID: 501182710
      Sat, Mar 03, 2007, 23:08 		Weird, but I downloaded the latest version, still get an error(code: 176), they ask me to debug, but that doesn't work... Forgive my ignorance btw :)
 
72RecycledSpinalFluid
      Dude
      ID: 204401122
      Sat, Mar 03, 2007, 23:16 		Not ignorance. Just something weird going on.

Does it load at all? Is it one particular boxscore?
 
73deejay
      Donor
      ID: 501182710
      Sun, Mar 04, 2007, 06:46 		It loads on Feb. 21, that has been since a week, then if you want to go to the next date(or specific date, then you get a runtime error), I have to say I was still using an old version(#8), but downloaded the latest one last night and it is the same.

This is the message:
A runtime error has occured
Do you wish to debug?

Line:775
Error: invalid procedure, call or argument: "Mid"
Yes No


 
74RecycledSpinalFluid
      Dude
      ID: 204401122
      Sun, Mar 04, 2007, 12:41 		Sounds like some kind of caching issue. Just curiously, can you atleast use http://rsf.hopto.org which is the old online version.
 
75deejay
      Donor
      ID: 501182710
      Sun, Mar 04, 2007, 12:50 		Thanks rsf, this one work.

I do have other online ones, but they didn't work either , this one for example.
http://68.64.51.115:8765/

again thanks.
 
76RMBees
      Leader
      ID: 1310551119
      Sun, Mar 04, 2007, 13:11 		I'm getting the following:

Line: 177
Char: 1
Error: Permission Denied
Code: 0
url file: ///C:Documents%20and%20settings/HP_Administrator/Desktop/game_viewer_0/8.hta
 
77RecycledSpinalFluid
      Dude
      ID: 204401122
      Sun, Mar 04, 2007, 14:46 		[Re: 75] The server that I have that page served on is a dynamic address, and it has changed. So that 68.64.51.115 address is gone (thats where the rsf.hopto.org used to point to).
 
78RecycledSpinalFluid
      Dude
      ID: 204401122
      Sun, Mar 04, 2007, 16:34 		RMBees sounds like the IE settings stuff. Check post 55.
 
79slug
      ID: 247172714
      Sun, Mar 04, 2007, 17:33 		I couldn't get either 17 or 18 to work last night. Similar error messages as the others. Today 18 is working, but not 17. Weird.
 
80Dave R
      SuperDude
      ID: 3010361110
      Wed, Apr 18, 2007, 21:01 		Is this working for anyone?
 
81Addicted
      Dude
      ID: 4611592518
      Wed, Apr 18, 2007, 21:26 		Broke again!!

Oh Well,
Maybe next year.

--Addicted--
 
82RecycledSpinalFluid
      Dude
      ID: 204401122
      Thu, Apr 19, 2007, 02:50 		Was it some glitch earlier? It worked for me earlier and still works for me now.
 
83deejay
      ID: 73221817
      Thu, Apr 19, 2007, 05:42 		82

It was weird, was looking at the scores, and all of a sudden only Cha-Nyk was left on the page. Refreshed the page couple of times, but no luck...
And No, I hadn't taken any drugs.