Navigation: Jump to content areas:


Pro Quality. Fan Perspective.
Login-facebook
Around SBN: Devils Beat Rangers, Head To Stanley Cup Finals

Good News About Retrosheet...

... and I'll give myself a bit of credit here, because it is due to my post and some email I shared with Dave Smith, the guy behind Retrosheet, that it happened.

I posted about the Retrosheet trouble -- and if you missed it, read the original post here -- on Saturday; due to a server change, they had to change URLs on all their boxscores and player pages.

This, of course, caused all their prior links to be broken. I wrote about this on our SB Nation email list, and I got Eric Simon, who writes the SB Nation Mets blog Amazin' Avenue, who knows some UNIX programming, in touch with Dave and they worked out a way to redirect old links to new links. I don't profess to understand how this works, but it does.

Anyway, that means if you have old Retrosheet boxscores bookmarked or linked anywhere, they will redirect to the new ones. Not only that, but it appears to work faster than the old ones.

At this time they haven't been able to do the player pages, but that might happen sometime in the future.

Good news, and thanks to Eric for helping out!

Comment 50 comments  |  0 recs  | 

Do you like this story?

Comments

Display:

I think...
you should hijack this thread.
"I don't talk. I just let what I do talk for myself." -Johan Santana

by sparkles721 on Feb 12, 2007 4:25 PM CST up reply actions  

I'm thinking about it...
...but it makes me cringe when Julie calls me "Jacker".
PTBNL!

by gravedigger on Feb 12, 2007 4:29 PM CST up reply actions  

sigh.
we really need some baseball to talk about.

thread hijacking gets kind of old after a while.

"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 12, 2007 4:31 PM CST up reply actions  

Really?
I think it's fine as long as the subjects change.
"I don't talk. I just let what I do talk for myself." -Johan Santana

by sparkles721 on Feb 12, 2007 4:32 PM CST up reply actions  

well.....
... when every single thread, including the top 100 profiles, gets hijacked, sometimes it gets a little weird, that's all.

baseball starts soon. that'll be a good thing for a lot of reasons.

"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 12, 2007 4:35 PM CST up reply actions  

Yeah...
the top-100 profiles. I'm sure few but Al and the people writing them take them as seriously as I do. Even if it is just a "random 'blog", I see it as a part of history. Sure, the lists have been made before, but for me, it's fun being here as it happens. I just wish I could have been around to edit them all. I'm great (or maybe just love it) at that sort of thing.
worthless...

by tyger1147 on Feb 12, 2007 4:38 PM CST up reply actions  

I take them seriously
I try to balance my goofy comments with serious comments on the top 100s.

And it's Julie's damn fault about the Grace thread.

PTBNL!

by gravedigger on Feb 12, 2007 4:40 PM CST up reply actions  

I believe...
that all the top 100 profiles don't get hijacked with the exception of the Mark Grace one.

I can't wait for baseball.  I know as soon as they start, I will be checking yahoo for pictures everyday and just watch the slideshow and freak out because I'm looking at baseball players.

"I don't talk. I just let what I do talk for myself." -Johan Santana

by sparkles721 on Feb 12, 2007 4:49 PM CST up reply actions  

I agree
You should tell those who to it to stop.

And for the record, that isn't me.

PTBNL!

by gravedigger on Feb 12, 2007 4:37 PM CST up reply actions  

Let's be more accurate.
It isn't ONLY you.

Frankly, I don't mind injecting some humor in some of the threads... but every single one?

The start of training camp should fix this problem.

"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 12, 2007 4:45 PM CST up reply actions  

Capt. Killjoy
No, seriously, I agree.  I keep my comments relevant during the season.  Except on the OBD threads or ridiculous diaries.
PTBNL!

by gravedigger on Feb 12, 2007 5:23 PM CST up reply actions  

Do you prefer...
Jack?
"I don't talk. I just let what I do talk for myself." -Johan Santana

by sparkles721 on Feb 12, 2007 4:31 PM CST up reply actions  

Funny gal
No I don't.  Well if it is between that and Jacker, I guess I do.

How about either Mark or gravedigger (or some variance on that)

PTBNL!

by gravedigger on Feb 12, 2007 4:36 PM CST up reply actions  

OK.
I can do that.

What's your middle name? I don't have a middle name, and sometimes I kind of wish I did.

"I don't talk. I just let what I do talk for myself." -Johan Santana

by sparkles721 on Feb 12, 2007 4:50 PM CST up reply actions  

Hey!
Maybe we could make this a new BCB contest: Pick a middle name for Sparkles!
"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 12, 2007 4:53 PM CST up reply actions  

LOL!!
"I don't talk. I just let what I do talk for myself." -Johan Santana

by sparkles721 on Feb 12, 2007 4:55 PM CST up reply actions  

so you like this idea?
n/t
"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 12, 2007 4:59 PM CST up reply actions  

I'd be fine with it.
I'm not sure how it would work as a contest, but if you want to do it you can.
"I don't talk. I just let what I do talk for myself." -Johan Santana

by sparkles721 on Feb 12, 2007 5:28 PM CST up reply actions  

I should leave this up to Julie...
... as I put her in charge of contests.
"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 12, 2007 10:03 PM CST up reply actions  

lol
hey, she agreed to do it!
"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 12, 2007 10:33 PM CST up reply actions  

yes.
n/t
"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 12, 2007 10:57 PM CST up reply actions  

Why do you say that?
n/t
"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 12, 2007 11:01 PM CST up reply actions  

so...
... this was a stealth thread hijack, eh?
"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 12, 2007 11:04 PM CST up reply actions  

You still didn't share your middle name...
but that's OK.  Maybe Al can tell us his.
"I don't talk. I just let what I do talk for myself." -Johan Santana

by sparkles721 on Feb 12, 2007 11:15 PM CST up reply actions  

The problem is...
I couldn't recommend a good middle name unless I knew the first and last. And well... I guess that's up to you guys to want to divulge that information.
worthless...

by tyger1147 on Feb 12, 2007 5:30 PM CST up reply actions  

Wait...
You mean Sparkles isn't her real name?
PAGAN!

by Jesse Guam on Feb 12, 2007 8:56 PM CST up reply actions  

Don't believe that!
That's a lie. Sparkles IS my real name.  
"I don't talk. I just let what I do talk for myself." -Johan Santana

by sparkles721 on Feb 12, 2007 9:47 PM CST up reply actions  

Yep
Good deal
WARD!

by cubbieboy on Feb 12, 2007 3:14 PM CST reply actions  

Player links
are all still busted though.
The early bird gets the worm, but the second mouse gets the cheese.

by scareduck on Feb 13, 2007 7:27 AM CST reply actions  

That's correct.
The email I got indicated that it was fairly easy to do the boxscore redirects, not so easy to do the player pages.

They're working on it.

"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 13, 2007 7:40 AM CST up reply actions  

that's true
The boxscore redirects should only take one rule in etc/httpd/httpd.conf if you have mod_rewrite installed.

The player redirects will take, as near as I can figure it, 27 rules. If they need help doing this, Al, you can point them here or have them contact me. It would require one rule to move Pkoufs101.htm to k/Pkoufs101.htm. This rule should be easily applicable to any player or manager. It would then require 26 rules to convert k/Pkoufs101.htm to K/Pkoufs101.htm (one for each letter of the alphabet), as I know of no good ways to use backreferences in mod_rewrite to convert lowercase to uppercase or vice-versa. There are some other alternatives available to them if they have shell access and/or direct control over the directory structure - use the first rule I suggest, and then have directories aliased from the lowercase to the existing uppercase directories, etc.

by false cognate on Feb 13, 2007 12:22 PM CST up reply actions  

actually, two rules
Al, I don't know who to pass this on to, but the following two rules inserted into httpd.conf should work if they have mod_rewrite enabled.

RewriteMap uppercase int:toupper
RewriteRule ^boxesetc/(P{1}(a-z{1}).*) boxesetc/${uppercase:$2}/$1 [R=301, L]

by false cognate on Feb 13, 2007 1:17 PM CST up reply actions  

I'll quit replying to myself
after this post.

I'm not a regexp or mod_rewrite ninja, so the above rules may need to be tweaked a little bit in order to make them work, but I'm sure that I'm pretty close to the correct regexp if it doesn't work. The major things I'm not sure about: do I need to close the string with a $ delimiter, and do I need to escape the slashes with backslashes.

by false cognate on Feb 13, 2007 1:26 PM CST up reply actions  

My head just exploded
That's why I always get others to write my .htaccess files for me.
PTBNL!

by gravedigger on Feb 13, 2007 2:29 PM CST up reply actions  

Man,
regexps are one of the most arcane bits of knowledge in the computer world. Depending on what language you're programming in, sometimes the little things are different. I've been messing around with regexps for going on a decade and I still don't have a complete grasp. Granted, it's not my everyday job, but I always try to master things that I'm going to use semi-regularly.

I can explain the string if you're interested, but you'd probably be the only one here.

by false cognate on Feb 13, 2007 2:44 PM CST up reply actions  

If that is something...
...you truly want to do, I'll listen (or, rather, read).  But you are right, I'm probably the only one.
PTBNL!

by gravedigger on Feb 13, 2007 2:45 PM CST up reply actions  

for the education
and edification of the (very) few people here who care:

mod_rewrite is a very powerful plug in for the Apache webserver. It is consequently also very confusing and complicated.

The first line reads:
RewriteMap uppercase int:toupper

This defines a mapping function called 'uppercase' which uses Apache's internal uppercasing function. I didn't know this existed until I looked it up today. You could call the function whatever you wanted - "foobar" or "doodoohead" or whatever, but obviously it's easier if you name it something descriptive.

The second line reads:
RewriteRule ^boxesetc/(P{1}(a-z{1}).*) boxesetc/${uppercase:$2}/$1 [R=301, L]

This is where the magic happens. It defines a rule to be invoked if part of the URL matches the pattern ^.....*) which will then be substituted with boxesetc/$....$1

Pattern:
^ denotes start of a string.
boxesetc/ is included at the start of the string just for sanity's sake.
Then we group the remainder using parentheses. This will be recalled as a backreference in the substitution as $1.
P{1} means match a single capital P. All personal pages in old (and new) retrosheet URLs start with P, as far as I can tell.
Then we group the next character using parentheses to create backreference $2. We match a-z{1} meaning a single lowercase letter.
Then .* should match all remaining characters in the string.

Substitution:
boxesetc/ is again included since we included it before.
${uppercase:$2} returns the string created by feeding backreference $2 into the function 'uppercase'. In the case of the Sandy Koufax page (Pkoufs101.htm) this would feed the lowercase letter k into the 'uppercase' function and return capital K.
/ is the directory delimiter.
$1 returns backreference $1, or Pkoufs101.htm

Pretty complicated, huh?

by false cognate on Feb 13, 2007 3:09 PM CST up reply actions  

Check your email.
n/t
"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 13, 2007 3:48 PM CST up reply actions  

bleargh
Like I said, I'm not a regexp ninja. The correct second line should be:

RewriteRule ^boxesetc/(P([a-z]).*) boxesetc/${uppercase:$2}/$1 [R=301, L]

For anyone who cares, I'm in contact with Dave over at retrosheet.org, we're going to try to make this work. I have a backup plan in case he can't get his webhost to modify a certain file. Hopefully we'll have this working soon.

by false cognate on Feb 13, 2007 9:50 PM CST up reply actions  

Excellent.
For everyone else's info, after I read this part of the thread (which was a foreign tongue to me) I put false cognate in touch with Dave Smith.

Hope they can get this worked out! Keep me informed so I can post another update.

"[BCB] is much better than... well, everything." -- gravedigger, January 21, 2007

by Al Yellon on Feb 14, 2007 4:06 AM CST up reply actions  

The thing is...
...programming looks like greek at first glance, but it is usually very logical and easy to understand once you know the rules.  Simpler than learning a real language, IMO.
PTBNL!

by gravedigger on Feb 14, 2007 9:06 AM CST up reply actions  

Comments For This Post Are Closed


User Tools

Welcome to Bleed Cubbie Blue, the Chicago Cubs blog for the SB Nation, created on February 9, 2005 by Al Yellon

FanPosts

Community blog posts and discussion.

Recommended FanPosts

Small
Maybe it's time to take a deep breath

Recent FanPosts

Zambrano_background_2_small
What is the most likely move in June regarding current players?
Small
Draft Prep: Pierce Johnson
Small
Trying to be positive (need some help)
Small
Soriano back to Second?
Small
Javier Baez Peoria Bound?
Small
Draft Prep: Conference Tournament Version
Despite-an-inflated-babip-lahair-is-no-one-month-wonder
Suddenly, I feel your pain
Small
Start of the LaHair Regression?
Dsc06783_small
Rookie Season Ticket Open House

+ New FanPost All FanPosts >

FanShots

Quick hits of video, photos, quotes, chats, links and lists that you find around the web.

Recommended FanShots

Doug Glanville On His Teammate, Kerry Wood
Thanks.
Samardzija takes a dig at Hawk Harrelson
Chicago vs. Chicago, Round 2.
Wrigley Field Photo Gallery

Recent FanShots

Wrigley Field Supporters Propose Tearing Down Rest Of Chicago
2012 Stars and Stripes Hat
Sveum moves Castro back to #2 spot
OT: Tyler Colvin bats 2nd
The Pittsburgh Pirates Offensive Catastrophe
Roy Halladay Bobblehead Fail
Full sized image
All The Topps Baseball Card Cubs, 1951 - 2012
Rob Neyer answers the question: When should the Cubs call up Anthony Rizzo?
Don't Have MLB Network? You Might Get Shut Out Of A Playoff Telecast

+ New FanShot All FanShots >

Featured Poll

Poll
Should the National League adopt the designated hitter rule?

  963 votes | Results

Cubs By The Numbers

Cubs By The Numbers is a history of the ballclub by uniform number, but the biographies help trace the history of our beloved team in a new way. For everyone who's a Cubs fan, anyone who ever wore the uniform is like family. Cubs By The Numbers reintroduces readers to some of their long-lost ancestors, even ones they think they already know.

Click here to order your copy, available now!

Recent Stories in Chicago Cubs Game Threads

Yahoo_full_count

Recent Stories in Ticket Exchanges


Managing Editor

Alyellontoppscard_small Al Yellon

Front Page Contributors

Profile_small Josh Timmers

B_w_avatar_small Brett Taylor

Marvin_the_martian_small Shawn Domagal-Goldman

Other Contributors

Toonmike_small Mike Bojanowski

Dsc_0139_small David Sameshima