BP Stats/Content Engine Data Fields Document

[Clarity]

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>

 

[osugrad21]

Wow that will blow away other sites Clarity...very nice

 

[Brutus1]

You're a 'friggin genius !

 

[bucknut11]

clarity, that's insane! how are you planning on compiling all these stats and info? how far back are you planning on going?

 

[Buckeyeskickbuttocks]

I don't know if it's an internal problem there or here, but I can't see shit Clarity.. Just a blank white box... From the others' posts, I'd suspect it's my end, but thought you should know, in case it's not just my computer.

 

[bucknut11]

bkb, inside the box there's about 20 pages worth of data fields. not sure what's wrong, but i can definitely see it on my end.

 

[Buckeyeskickbuttocks]

Not here, just a white box... no scroll bars.. nothing... :(

 

[bucknut11]

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.

 

[Clarity]

Not here, just a white box... no scroll bars.. nothing... :(

Are you on a Mac?

 

[Buckeyeskickbuttocks]

Nope, Compaq... XP, by the way

 

[Clarity]

clarity, that's insane! how are you planning on compiling all these stats and info? how far back are you planning on going?

1889.

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.

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

 

[jimotis4heisman]

Incredible

 

[OilerBuck]

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!

 

[Clarity]

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.

 

[Buckeyeskickbuttocks]

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..