BETA version of OOTP2007 DB available...

[Gambo]

Hey guys. I put together a DB for use with the upcoming game. While all of the previous DBs will still work on the new game the idea was to create one which implements the new "import ratings each season" feature and still be able to have players import in their first pro season. The setup is a bit different as it required to DBs in one (one for initial import and one for regular yearly use)...

I am sending it to OOTP modsquad if any beta testers want to try it... hopefully they'll post it soon.


Here is the readme...

Basic Information (Feb 2007)

This database will work on 2007 using the “adjust ratings every season option”. This is a Beta Version for Testing on OOTP2007

For those new to the game the concept of this database is to include every player and still correct the flaws of importing in OOTP. In addition to this, because the purpose of OOTP is to manage a team as players develop during their entire career, it will import players according to when they actually made their pro-debut as opposed to their major league debut, and at ratings according to their age.

For best results in OOTP 2007 this package includes 2 full databases and another directory with the original Lahman Batting Pitching and Fielding Files.

The 1st directory “2007Import” should be used when you first create your league. Make the appropriate edits described below then create your historical league. Your league should now include any players who played that year on their teams, minor leaguers in their organization on their rosters and players who missed the season as Free Agents.

Note:
In this DB each of the Batting, Pitching and Fielding csv files is sorted by year. I also include the original LahmanDB files sorted in this way. The way to import the historical stats is to open each of my files in Notepad and delete the seasons previous to the one you start with (e.g. if you start in 1977, delete 1871-1976’s stats) then copy those seasons from the supplied Lahman (in their subdirectory) files above the remaining years in my file. Now, when you import players they will retain their original previous statistics upon import.

The 2nd directory “2007Yearly” should be used from every year on. This DB includes players actual yearly statistics and an import year stat line for player the year they made their professional debut. Using this database will import players as rookies when they made their pro debut and allow the game to adjust players as the game is designed.

Note:
To come up with the “debut” numbers I used OOTP basic ability scale for AAA-Rookie League player adjustment modifiers. A players BA will be 85% if they spent 1 year in the minors, 80% for two years and so on to 60% for 5 or more years. Their other stats are adjusted accordingly.

Final Note for Testers…
I would like feedback on how this database handles pitcher/hitters such as Babe Ruth but more specifically players like Canseco, Oquendo and Halter who made brief pitching appearances.


Gambo 2007 OOTP DB

This is the newest version of my database. Using this database OOTP will import players whether they were in the majors or minor leagues and assign them properly to their correct organizations.

Here is a rundown of the changes made to create this database…

Changes from previous Gambo DBs

Negro Leaguers have been removed.
No Longer a career average DB.
No Longer division between players who pitched and played other positions regularly (e.g. Babe Ruth)


Future Updates

I’d like to create an alternate database which implements Negro Leaguers and such, also some minor leaguers who never reached the majors. For now however let me try and make sure this version is up and running.

[jtb]

As a fan of your previous work, I can't wait to try this when OOTP2007 is released.
Thanks.

[Gambo]

Here's the link if anyone wants to DL it.


http://rapidshare.com/files/16287889...007DB.zip.html

[jcd66442]

WOW!!! I like it. It has alot of minors league players. I use OOTP 6.51 and I load database 1989 season. Boy it takes long time to load a 1989 season. Almost 1900 players.

Options

Adjust hitters with less than? 50? 100? 150? 300? (there alot of players less than 100 AB)

Adjust pitchers with less than? ##
bad hitters? ##
bad pitchers? ##
I use remaining career
L/R - No I don't use it (that my option)
Base fielding? Entire career? season? (entire career would be best?)

[Gambo]

Great!!! If your using the DB pre 2007 just use the import directory. (The yearly directory makes no difference without the 2007 feature). Just don't forget to make the changes upon initial import to get the proper historical statistics.

If you like the new DB so much I still recommend using my DB ver 4.0 (which i just checked isn't available anywhere that I can see off hand --- ver 3.9 is at Jazzrack's site) at:
http://65.78.148.37/ootp/rosters/GamboAnkit390.zip

I'll throw a link for 4.0 up in a bit...

Since this isn't a career average DB i'd just go a little lower than the defaults...Fielding for entire career.

[Gambo]

Version 4.0 for 2006 and before....


http://rapidshare.com/files/16428137...ver40.zip.html

[Raidergoo]

Having fun with this. . .

Chuck Klein was probably the best overall player. Imagine what he would have done if he was not fragile like Mickey Mantle or Eric Davis. He missed 890 games or so.

Career Batting Stats

G 	AB 	H 	2B 	3B 	HR 	RBI 	R 	BB 	HP 	SF 	K 	SB 	CS 	AVG 	OBP 	SLG 	OPS 	VORP
 
2279 	8992 	3173 	578 	108 	545 	1793 	1783 	1170 	33 	67 	554 	71 	33 	.353 	.426 	.623 	1.049 	1465.4

[Raidergoo]

My Hall of Fame scan missed the real star of the sim, Ted Williams, as he is still active in November, 1954.

G 	AB 	H 	2B 	3B 	HR 	RBI 	R 	BB 	HP 	SF 	K 	SB 	CS 	AVG 	OBP 	SLG 	OPS 	VORP
 
2180 	7527 	2797 	401 	80 	584 	1641 	1976 	2384 	40 	61 	607 	87 	53 	.372 	.521 	.679 	1.200 	1833.7

[Gambo]

Awesome!

Chuck Klein had a career .320 BA with 300 HR, his 162G average was .320-28-111, Williams's was .344-37-130...according to the sim .344-39-127 for Klein, Williams .372-43-122... comparable!

Hey Raidergoo are you using the DB according to the readme?
Import DB for import and the remainder with the yearly DB? Also, can you check Stachell Paige for me?

[Raidergoo]

Originally Posted by Gambo

Awesome!

Chuck Klein had a career .320 BA with 300 HR, his 162G average was .320-28-111, Williams's was .344-37-130...according to the sim .344-39-127 for Klein, Williams .372-43-122... comparable!

Hey Raidergoo are you using the DB according to the readme?
Import DB for import and the remainder with the yearly DB? Also, can you check Stachell Paige for me?

Using per the readme; also not using recalc yearly for accuracy feature this time. I cut the run short sometime in the 1960's to handle my OOTP 2006 online league. More data late tonight.

[Raidergoo]

I'll have some more career stats from Gambo's database soon. It's been a rough go here; several issues came up (it's snowing, AGAIN) that needed to be handled.

It's 1954 in the sim right now, I may let it run until 1960 before showing 3-4 players and their stats.

[Raidergoo]

Player Report for #9 Rogers 'Rajah' Hornsby

G 	AB 	H 	2B 	3B 	HR 	RBI 	R 	BB 	HP 	SF 	K 	SB 	CS 	AVG 	OBP 	SLG 	OPS 	VORP
 
3180 	12258 	4314 	659 	257 	537 	2429 	2506 	1982 	66 	94 	1348 	225 	161 	.352 	.442 	.579 	1.021 	1948.6

27 seasons, dominant player until 1933, played very successfully 1934-1940, but was in and out of the lineup often.

Clearly awesome up at age 41.

[Raidergoo]

Player Report for #15 Lou 'The Iron Horse' Gehrig

G 	AB 	H 	2B 	3B 	HR 	RBI 	R 	BB 	HP 	SF 	K 	SB 	CS 	AVG 	OBP 	SLG 	OPS 	VORP
 
3328 	12618 	4144 	497 	92 	713 	2437 	2296 	1723 	45 	105 	1848 	205 	123 	.328 	.408 	.552 	.960 	1351.3

He never got sick in this universe. Won 11 HR titles in a row 1924-1935. Played until 1947, played at high level until 1945.

[Raidergoo]

Player Report for #16 John 'Little Napoleon' McGraw

G 	AB 	H 	2B 	3B 	HR 	RBI 	R 	BB 	HP 	SF 	K 	SB 	CS 	AVG 	OBP 	SLG 	OPS 	VORP
 
2502 	8586 	2477 	333 	154 	16 	957 	1806 	1935 	378 	51 	693 	1062 	284 	.288 	.437 	.369 	.806 	402.7

OOTP and SB's in the Deadball era don't get along well; it's an element that is getting looked at quite a bit. McGraw is the SB leader at this point.

[Raidergoo]

You asked for Satchel Page. He suffered through two major back injuries that cost him 21 months of playing time, and it wrecked his career. 19-22, 3.81 ERA.

[Gambo]

Bump!