OOTP Developments Forums - View Single Post

Garlon · 10-21-2005, 09:14 AM

Arod23 and I just finished putting the finishing touches on 2 new DB's. There is a regular version and a career average version of the DB. They are at the bottom of the page and are called Arod23/Garlon Regular DB and Arod23/Garlon Career Average DB. When you unzip the folder, the DB folder may be inside the unzip folder...if so, just drag the folder with the DB out of this folder and you will be good to go.

Get it here:

OOTP DB Downloads

Here is the readme listing our changes and updates to the DB:

This database was created using AnkitDB5 as a base. Ankit's readme files have been included as well. Special thanks to Ankit for helping us with the programming code to create this new DB.

Like Ankit's DBs, it is suggested that you use the regular version of the DB to import your initial season when starting a league, then use the Career Average DB for importing all rookies in subsequent seasons.

Here is a list of changes we have made to the DB.

1. All Union Association players from 1884 have been deleted except a few who went on to have a legitimate career in the real major leagues. Those players are: Jersey Blakely, Tommy Bond, George Bradley, One Arm Dailey, Buttercup Dickerson, Fred Dunlap, Charlie Ganzel, Jack Glasscock, Jack Gleason, Jim McCormick, Dave Rowe, Orator Shaffer, Charlie Sweeney, and Billy Taylor. These are the 14 players Bill James considers legitimate major leaguers from the Union association in "The New Baseball Historical Abstract" pg 29.

2. Added birthdays for all players missing them. This mostly affects pre-1900 players. These players now debut at age 22.

3. Updated the database to include 2003 and 2004 statistics for all active players and added new players debuting in 2003 and 2004.

4. Added outfielding stats from 1995-2002 which were missing from the original Lahman DB.

5. Modified all player stats during WWII 1942-1945 to an average of the four years before and after the war (1938-1941 and 1946-1949). This was done to account for the fact that in OOTP players do not miss seasons due to military service, nor do we want them to. Any players who missed seasons between 1942-1945 due to military service have had pro-rated seasons put back into their careers based on an average of how they performed between 1938-1949, including any modified years between 1942-1945 in which they did play.

6. Extended the careers of Jackie Robinson, Larry Doby, Monte Irvin, Roy Campanella, Minnie Minoso, and Luke Easter so that they now debut at age 21. Their missing seasons were based on their career average through 1949 when possible, otherwise the player's career average was used to replace his missing seasons. This was done because these players did not have a chance for a full major league career due to segregation in baseball.

7. Warren Spahn debut year has been changed to 1943 since he missed 1943-1945 due to military service. Babe Ruth, the hitter, now debuts in 1916 instead of 1918.

8. The Career Average version of the DB is much like Ankit's, except that in this DB career totals were divided by seasons played, rather than career totals divided by season entries (which can be more than the number of years played for players who were traded during a season). This results in somewhat more accurate totals for players.

9. Added 25 Negro League Players to the DB, plus Satchel Paige who only played a couple seasons in the major leagues. These players are clones of actual major league players who they have been compared to. These players all debut at age 21 and have been given 15-year careers in the DB. Listed are the players, their database id, their debut year, and the player they were cloned from. They are:

Josh Gibson, gibsojo09, 1933, Jimmie Foxx
Buck Leonard, leonabu09, 1929, Johnny Mize
Bingo DeMoss, demosbi09, 1911, Johnny Evers
Ray Dandridge, dandrra09, 1935, George Kell
Pop Lloyd, lloydpo09, 1906, Honus Wagner
Turkey Stearnes, steartu09, 1923, Chuck Klein
Oscar Charleston, charlos09, 1918, Tris Speaker
Martin Dihigo, dihigma09, 1927, Pete Rose
Biz Mackey, mackebi09, 1919, Mickey Cochrane
Buck O'Neil, oneilbu09, 1933, Mark Grace
Judy Johnson, johnsju09, 1921, Pie Traynor
Willie Wells, wellswi09, 1927, Arkie Vaughan
Mule Suttles, suttlmu09, 1922, Ralph Kiner
Cristobal Torriente, torricr09, 1933, Roberto Clemente
Cool Papa Bell, bellco09, 1925, Lou Brock
Newt Allen, allenne09, 1923, Frankie Frisch
Hilton Smith, smithhi09, 1933, Dizzy Dean
Rube Foster, fosteru09, 1901, Lefty Gomez
Bill Foster, fostebi09, 1926, Herb Pennock
Smokey Joe Williams, willism09, 1907, Rube Waddell
Bullet Joe Rogan, roganbu09, 1911, Dazzy Vance
Chet Brewer, brewech09, 1928, Bob Feller
Leon Day, dayle09, 1938, Hal Newhouser
Ray Brown, brownra09, 1929, Ted Lyons
Andy Cooper, coopean09, 1918, George Ruth
Satchel Paige, paigesa09, 1928, custom

10. Also included is a custom MLBactuals.txt file made for iatric's Era Calculator when using this DB since it has adjusted totals to account for the addition of the Negro League Players and the extended careers of other players. This is for use with Iatric's Era Calculator program, just replace the original MLBactuals.txt file in the Era calculator folder with this one.
For those who want to start a league before 1900, there is also a file called MLBActualsplus100.txt. This file has 100 years added to the actual year of all seasons, for example 1876 is now listed as 1976 and 2001 is now 2101. This is done as a work-around since the Era Calculator will not allow you to start a league before 1901. OOTP also does not allow you to directly start a league before 1901, but you can start a custom league in 1875,then play thru the season and delete all players, then when you move to 1876 OOTP will prompt you for the DB to import rookies (use the reg DB for importing rookies in 1876 if you plan to do this, and then use the Career AVG version for all subsequent seasons). Note, the Era Calculator does not have any initialization ratings after 1950, so what you will need to do is edit the initratings file in the Era calculator folder and manually input the totals for the year 1976 (which will actually be 1876). So for example, when you are playing OOTP the year might be 1883 in your league, but 1983 in the Era Calculator, but the actual totals the calculator will be working with are the ones from 1883.
A starter 1876 file with instructions will also be made available.

Created by Arod23, Garlon, and Ankit of the OOTP message board forums.

10-21-2005, 09:14 AM	#1
Garlon Hall Of Famer Join Date: Jun 2004 Posts: 4,371	New ArodGarlon DB's Available Arod23 and I just finished putting the finishing touches on 2 new DB's. There is a regular version and a career average version of the DB. They are at the bottom of the page and are called Arod23/Garlon Regular DB and Arod23/Garlon Career Average DB. When you unzip the folder, the DB folder may be inside the unzip folder...if so, just drag the folder with the DB out of this folder and you will be good to go. Get it here: OOTP DB Downloads Here is the readme listing our changes and updates to the DB: This database was created using AnkitDB5 as a base. Ankit's readme files have been included as well. Special thanks to Ankit for helping us with the programming code to create this new DB. Like Ankit's DBs, it is suggested that you use the regular version of the DB to import your initial season when starting a league, then use the Career Average DB for importing all rookies in subsequent seasons. Here is a list of changes we have made to the DB. 1. All Union Association players from 1884 have been deleted except a few who went on to have a legitimate career in the real major leagues. Those players are: Jersey Blakely, Tommy Bond, George Bradley, One Arm Dailey, Buttercup Dickerson, Fred Dunlap, Charlie Ganzel, Jack Glasscock, Jack Gleason, Jim McCormick, Dave Rowe, Orator Shaffer, Charlie Sweeney, and Billy Taylor. These are the 14 players Bill James considers legitimate major leaguers from the Union association in "The New Baseball Historical Abstract" pg 29. 2. Added birthdays for all players missing them. This mostly affects pre-1900 players. These players now debut at age 22. 3. Updated the database to include 2003 and 2004 statistics for all active players and added new players debuting in 2003 and 2004. 4. Added outfielding stats from 1995-2002 which were missing from the original Lahman DB. 5. Modified all player stats during WWII 1942-1945 to an average of the four years before and after the war (1938-1941 and 1946-1949). This was done to account for the fact that in OOTP players do not miss seasons due to military service, nor do we want them to. Any players who missed seasons between 1942-1945 due to military service have had pro-rated seasons put back into their careers based on an average of how they performed between 1938-1949, including any modified years between 1942-1945 in which they did play. 6. Extended the careers of Jackie Robinson, Larry Doby, Monte Irvin, Roy Campanella, Minnie Minoso, and Luke Easter so that they now debut at age 21. Their missing seasons were based on their career average through 1949 when possible, otherwise the player's career average was used to replace his missing seasons. This was done because these players did not have a chance for a full major league career due to segregation in baseball. 7. Warren Spahn debut year has been changed to 1943 since he missed 1943-1945 due to military service. Babe Ruth, the hitter, now debuts in 1916 instead of 1918. 8. The Career Average version of the DB is much like Ankit's, except that in this DB career totals were divided by seasons played, rather than career totals divided by season entries (which can be more than the number of years played for players who were traded during a season). This results in somewhat more accurate totals for players. 9. Added 25 Negro League Players to the DB, plus Satchel Paige who only played a couple seasons in the major leagues. These players are clones of actual major league players who they have been compared to. These players all debut at age 21 and have been given 15-year careers in the DB. Listed are the players, their database id, their debut year, and the player they were cloned from. They are: Josh Gibson, gibsojo09, 1933, Jimmie Foxx Buck Leonard, leonabu09, 1929, Johnny Mize Bingo DeMoss, demosbi09, 1911, Johnny Evers Ray Dandridge, dandrra09, 1935, George Kell Pop Lloyd, lloydpo09, 1906, Honus Wagner Turkey Stearnes, steartu09, 1923, Chuck Klein Oscar Charleston, charlos09, 1918, Tris Speaker Martin Dihigo, dihigma09, 1927, Pete Rose Biz Mackey, mackebi09, 1919, Mickey Cochrane Buck O'Neil, oneilbu09, 1933, Mark Grace Judy Johnson, johnsju09, 1921, Pie Traynor Willie Wells, wellswi09, 1927, Arkie Vaughan Mule Suttles, suttlmu09, 1922, Ralph Kiner Cristobal Torriente, torricr09, 1933, Roberto Clemente Cool Papa Bell, bellco09, 1925, Lou Brock Newt Allen, allenne09, 1923, Frankie Frisch Hilton Smith, smithhi09, 1933, Dizzy Dean Rube Foster, fosteru09, 1901, Lefty Gomez Bill Foster, fostebi09, 1926, Herb Pennock Smokey Joe Williams, willism09, 1907, Rube Waddell Bullet Joe Rogan, roganbu09, 1911, Dazzy Vance Chet Brewer, brewech09, 1928, Bob Feller Leon Day, dayle09, 1938, Hal Newhouser Ray Brown, brownra09, 1929, Ted Lyons Andy Cooper, coopean09, 1918, George Ruth Satchel Paige, paigesa09, 1928, custom 10. Also included is a custom MLBactuals.txt file made for iatric's Era Calculator when using this DB since it has adjusted totals to account for the addition of the Negro League Players and the extended careers of other players. This is for use with Iatric's Era Calculator program, just replace the original MLBactuals.txt file in the Era calculator folder with this one. For those who want to start a league before 1900, there is also a file called MLBActualsplus100.txt. This file has 100 years added to the actual year of all seasons, for example 1876 is now listed as 1976 and 2001 is now 2101. This is done as a work-around since the Era Calculator will not allow you to start a league before 1901. OOTP also does not allow you to directly start a league before 1901, but you can start a custom league in 1875,then play thru the season and delete all players, then when you move to 1876 OOTP will prompt you for the DB to import rookies (use the reg DB for importing rookies in 1876 if you plan to do this, and then use the Career AVG version for all subsequent seasons). Note, the Era Calculator does not have any initialization ratings after 1950, so what you will need to do is edit the initratings file in the Era calculator folder and manually input the totals for the year 1976 (which will actually be 1876). So for example, when you are playing OOTP the year might be 1883 in your league, but 1983 in the Era Calculator, but the actual totals the calculator will be working with are the ones from 1883. A starter 1876 file with instructions will also be made available. Created by Arod23, Garlon, and Ankit of the OOTP message board forums.