RotoGuru Hockey Forum

View the Forum Registry


0 Subject: Any Alternate Sources for SW Price Info?

Posted by: Richard
- [58435323] Thu, Dec 28, 17:39

I've found myself with a bit of spare time to dedicate to my hockey teams, but I'm feeling information starved with the "sortibles" down. In order to work thru my frustrations, I'm trying to find other alternative sources of information on the SW game.

There must be a fairly easy way to download the current prices for SW players since this info is an integral part of the package that make up the "sortibles". Anyone know the URL for current price information or anyone know how that info is accessed thru the SW site?

I'm looking for one file to download as I don't really want to pull that information down one player at a time.

Richard
1Teddy
      ID: 3611361211
      Thu, Dec 28, 21:15
Hi Richard, how about pulling it from team's rosters page at the SW site? it sort with the possition too.

Teddy
2hoops boy
      ID: 51440922
      Thu, Dec 28, 22:34
I looking into switching servers since I am loseing any hope that the current provider will get things worked out; in the mean time I can send you a copy of my price info file if you want, just shoot me an email.
3RANGERSN2K
      ID: 4510341614
      Thu, Dec 28, 22:39
wats the sortibles link?
4Richard
      ID: 58435323
      Thu, Dec 28, 23:47
hoops boy - I was wondering how you generate the price info file. Is there a file that you (I) can download from the SW servers or do you run a script that processes information (potentially from the team roster pages) and creates that price info file.

As Teddy suggests, I can loop thru (fairly quickly) the 30 team roster pages and grab the current price for each of the players. In fact while waiting for responses to this post, I created an Excel macro that does just that.

However, if SW has done the work for me and I can grab a single file why should I go thru with the effort to download and parse thru 30 team pages worth of info.

Richard
5Perm Dude
      ID: 471126619
      Thu, Dec 28, 23:49
Rangers, The second pull-down menu ("Other Hockey Pages") at the top & bottom of the page, offers links to other sites, including a number of statistical tools for helping analyse SW statistics. There is/was a page which sorts players based upon a number of factors (postition, SWP/Game, price, etc) that seems to be acting up. Much faster and more versitile than the SW tools.

pd
6J
      ID: 101131321
      Fri, Dec 29, 01:07
hoops boy, any chance you could team up with Guru to use his server??????? I really like the way his sartibles work, I was never a huge fan of the way Paul did them, but I'm still greatful he did, and you are.

Either way, thanks!
7hoops boy
      ID: 51440922
      Fri, Dec 29, 07:35
J, unfortunatly all of puals code was written in asp,and (afaik) all of dave's code is written in perl. I am sure dave's server doesn't support asp, as that was talked about once before. I may end up rewriteing the whole thing in perl, but Im going to try to avoid that if I can.
8deepsnapper
      ID: 404592723
      Fri, Dec 29, 08:23
Got a new error (for me) this AM while trying to access Sortables. Error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x5b8 Thread 0x794 DBC 0x247f024 Jet'.

/fhs/dbcommon.asp, line 33


Just an FYI, It's probably not new, just to me. ;-)
9Code Cracker
      ID: 8446221
      Fri, Dec 29, 08:26
Standby, I think hoops boy is close to having a new site up for sortibles and schedule viewer.
10hoops boy
      ID: 51440922
      Fri, Dec 29, 11:39
feel free to test out the new server
11J
      ID: 50726110
      Fri, Dec 29, 11:49
HTTP 500 - Internal server error
;(
12J
      ID: 50726110
      Fri, Dec 29, 13:15
hoops boy, your link is "http://ww2.realftp.com/fhs/"

did that 2 accidentally slip in there?

;)
13Harkonnon
      ID: 4453220
      Fri, Dec 29, 14:47
the 2 is for double speed !!!!!

woohhhhhhoooooooooooo that site rocks !!!!

I should check, you did not store data on my hd.

14J
      ID: 50726110
      Fri, Dec 29, 14:55
yeah. duh. I know that, i was just kidding...or something.
15Harkonnon
      ID: 4453220
      Fri, Dec 29, 14:59
so the question remains

what did code cracker know about it ?
I guess he hacked the NASA or CIA or the Vatikan.

16Richard
      ID: 58435323
      Fri, Dec 29, 16:27
hoops boy - the new site is working for me, but where's Mario?

Richard
17Code Cracker
      ID: 8446221
      Fri, Dec 29, 17:25
He may need to be added to the database. I'll send hoops boy an email.
18¤ Mario LeMoose ¤
      ID: 811342917
      Fri, Dec 29, 17:34
The fine print: "RealFTP.com free service should be used for personal use only. Storing the files at RealFTP.com files and giving link from other sites to your file may cause termination of account."
19hoops boy
      ID: 51440922
      Fri, Dec 29, 21:08
Richard Unfortunately the server issues have delayed my studying of adding ipo's into the system. I did add mario into the database, but apparently in not enough places (if you go to the player pages, there is one for #66, but he doesn't have any stats associated with him) I'll look into it a little more and see what I have to do complete his entry.

LeMoose I read that differently the first time, thinking that you are not suppose to link to files on this site from other sites, such as people uploading tons of mp3's they link at from other websites. Either way I think this is probably a temporary server at best. I am currently looking into paying for web hosting but need to make sure everything will work with whatever host I go with, and admittedly am trying to keep my out of pocket $$ to a minimum. Hopefully that way we could at least finish off this season on one host.
20Scott
      ID: 33449420
      Sat, Dec 30, 08:56
The new server is not working for me, any ideas how to get to the new site??
21Team AA
      ID: 53947612
      Sat, Dec 30, 09:34
i cann't seem to bring up the site either "server too busy" i wanted/ needed to do some management. it has been nice to think that i haven't made any trades yet this week though
22KrazyKoalaBears
      ID: 1910491418
      Sat, Dec 30, 10:13
hoops boy, is there any way we could try to convert it to PHP? If so, I could host it at Gleem at no cost.
23hoops boy
      ID: 51440922
      Sat, Dec 30, 17:40
Server is up, I did a little reconfigureing that should help things stay more stable, however I am looking to move into a permanent home soon. Also I think Mario is in, but his points/$$ arnt showing up yet. I will wait for the new stats tommorrow AM before hacking into the db again.

KKB, I'd love nothing more than to have this thing running on php, but short of a rewrite it doesnt seem likely. I ran the schedual matrix code through asp2php and it didnt like it, not to mention haveing to convert from access to mysql, and that app is infintely simpler than the rest of the code. If you want to take a crack at it, lmk and I'll hook you up with the source, but otherwise were on asp for now.
24KrazyKoalaBears
      ID: 1910491418
      Sat, Dec 30, 17:41
I've got a friend at work that knows a heck of a lot more ASP than me, so I'll check with him on TUE and get back with you.
25BZ
      ID: 5111183117
      Sun, Dec 31, 17:20
I actually like KKB's idea about Gleem.com. It is usually fast, very user-friendly, and it has a URL which is easy to remember. I dont want to be a burden or cause any extra work for anybody, though, so if this is too much, forget about it.
26¤ Mario LeMoose ¤
      ID: 4911533119
      Sun, Dec 31, 19:53
hoops boy: The domaindlx site actually responded tonight! Is that the server you're referring to in #23, or the new (realftp) one? Player info is, of course, a week behind ... but my favorite tool (the simple little schedule viewer) works just fine.
27hoops boy
      ID: 51440922
      Mon, Jan 01, 09:52
mario I noticed that the old server started responding again, I think this is probably due in paert because most of the traffic is now going to the new server.
28¤ Mario LeMoose ¤
      ID: 4509110
      Mon, Jan 01, 10:09
Ah, I see ... so the official new home for stats and schedules is http://ww2.realftp.com/fhs. Thanks, hoops boy. Just an FYI: the "real time" clock at that site seems to be behind by 20 minutes or so.
29hoops boy
      ID: 51440922
      Mon, Jan 01, 19:40
Mario Yeah... whats up with that? I thought my clock at home was off at first, but I have this atomic clock program I ran to double check. Along those lines I actually have to go back to work tommorrow, which means I'll have less time to devote to the whole thing, but the good news is updates should happen more on schedual (since I cant sleep in till 10:00 o'clock!)
30walk
      ID: 141149317
      Mon, Jan 01, 20:05
hoops boyeeeeeeeeee!

:-)
walk
31¤ Mario LeMoose ¤
      ID: 50020120
      Mon, Jan 01, 20:20
hoops boy: Saw your note about the time difference at the top of the stats site home page ... cute! ;-) I have a little suggestion as you continue to make improvements (keep in mind that my ideas often involve effort on someone else's part): Might it be possible for you to incorporate KKB's philliephan banner between the horizontal rules on that page, update the blurb about Paul, and somehow work in a link to the trust fund thread? (Also, the ***Latest Info*** link at the top of the page leads to one of philliephan's old threads ... don't know how you want to deal with that.)

I'll bet you already have these items on your "to do" list.

Thanks.
32esposo
      ID: 52453011
      Tue, Jan 02, 08:06
I am getting server too busy notices...
33deepsnapper
      ID: 404592723
      Tue, Jan 02, 08:13
The domaindlx site appears to be current this AM.
34esposo
      ID: 52453011
      Tue, Jan 02, 08:37
yes I am in on the "www2.domaindlx.com/fhs/stats1.asp site," too, thanks for the feedback
RotoGuru Hockey Forum

View the Forum Registry




Post a reply to this message: (But first, how about checking out this sponsor?)

Name:
Email:
Message:
Ignore line feeds? no (typical)   yes (for HTML table input)


Viewing statistics for this thread
Period# Views# Users
Last hour11
Last 24 hours11
Last 7 days22
Last 30 days43
Since Mar 1, 2007721410