• Follow us on Twitter @buckeyeplanet and @bp_recruiting, like us on Facebook! Enjoy a post or article, recommend it to others! BP is only as strong as its community, and we only promote by word of mouth, so share away!
  • Consider registering! Fewer and higher quality ads, no emails you don't want, access to all the forums, download game torrents, private messages, polls, Sportsbook, etc. Even if you just want to lurk, there are a lot of good reasons to register!

BP Stats/Content Engine Data Fields Document

Clarity

Will Bryant
Staff member
For your comments, suggestions, corrections, questions, etc. This is revised from a version I posted yesterday. The notes in the document are meant for the programmer, who is English and not familiar with US Football.

<center><iframe src="http://www.buckeyeplanet.com/imgops/BP_datafields_041807.htm" width="90%" height="500"></iframe></center>
 
bummer man. i'll sum it up for you: if i'm understanding it correctly, this database will have every conceivable tidbit of information you'll ever want to know about any player (past, current, or future) and any game.
 
Upvote 0
bucknut11 said:
clarity, that's insane! how are you planning on compiling all these stats and info? how far back are you planning on going?

1889. :wink:

Obviously I won't be able to reach max depth for all years. But we'll go as deep as we can for every year we've played.

Obviously all years going forward will have max depth.

Basically, there's absolutely nothing about OSU football that members of this site won't be able to know with a few mouseclicks.

"Show me all 3rd quarters of away games in the snow, where we played on grass against non-conference teams, where we rushed for less than 40 yards on the quarter, but passed for more than 40, and scored at least 1 touchdown -- but limit the results to where we had a player that was recruited out of a Florida highschool."

Lol. We're just about there. I think. Some serious hurdles to cross, but we're close enough that I can just about taste it.

thebkb said:
Nope, Compaq...

Do me a favor, hit the red navbar up top, and click on 2004 Preseason Polls. When that loads, do you see the Polls table with all the content?

In the meantime, if you want to see this doc, the URL is below. I've put it up so people can better understand the base goal of this site, and also in case I've missed something crucial.

http://www.buckeyeplanet.com/imgops/BP_datafields_041807.htm
 
Upvote 0
Clarity,

As a CSCI/ISA grad with extensive work with database design and applications, I appreciate all the work that's goes into the designing, gathering of data, testing and maintenance that goes along with this project. You're a freakin' magician man...Thanks so much for all the work you do...it's all spectacular!
 
Upvote 0
OilerBuck said:
Clarity,

As a CSCI/ISA grad with extensive work with database design and applications, I appreciate all the work that's goes into the designing, gathering of data, testing and maintenance that goes along with this project. You're a freakin' magician man...Thanks so much for all the work you do...it's all spectacular!

Thanks. If you can make any better sense of some of the areas particularly lacking in there (most are highlighted yellow), that would be a big help. I don't have the first clue about dbase structure, so the more clear I can be as we wrap things up, the better.

I was microbio/biochem, so this stuff doesn't come naturally. Lol.
 
Upvote 0
Clarity - I did the preseason poll thing as you requested and it came up without a hitch. Also, tried the link, it opened a window, but hung. I'll try this thread again tomorrow at work and see if it is maybe just this computer... Perhaps I don't have some browser something-a-whatsit turned on here... I seem to be the only one who's having the problem..
 
Upvote 0
Back
Top