New ArodGarlon DBs Available

Garlon · 10-21-2005, 05:49 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.

attackemu · 10-21-2005, 07:22 AM

Very nice work! I'll download this one when I get home! Can't wait to play the "non-segregated" history of baseball.

Jestor · 10-21-2005, 07:49 AM

Superb! I'll be taking a look at this myself.

Bluenoser · 10-21-2005, 08:25 AM

Excellent work guys, thanks for your commitment and time in doing this.

timlowery · 10-21-2005, 11:28 AM

Thanks for the great effort. Looking forward to this weekend!

rogmax11 · 10-21-2005, 04:55 PM

Excellent effort, thank you very much! Any chance you could build a similar DB for Puresim?

Garlon · 10-21-2005, 05:07 PM

I have never played Puresim. This DB project alone took months to complete. If we do another one it won't be until the next OOTP is released. You're better off with OOTP anyway :-)

plannine · 10-22-2005, 08:47 PM

I've tested a few seasons and so far it looks great....results for a few seasons' came out well,...the only thing i see missing is adding a few more negro leaguers...like:

Grant Johnson 1895-1916
Hurley McNair (OF/P) 1912-1927
Ted Radcliffe (C/P) 192x-1950:
Louis Santop (C) 1909-1924:
Sol White (3b) 1887-1912:

(or are they there and i just missed them?)

Here's league totals for 1901-1910......Avg & Era are decent (for me anyway)
(The players are the same, the team names have changed...)
This test was with OOTP5 with everything turned off.......

Shaun Sullivan · 10-22-2005, 10:28 PM

Hey guys, cool stuff. It would take me 15 minutes to make this PureSim compatible, but I'd like to get your blessing first. I know a lot of hard must have went into this project!

So, as long as I include your original info and credits do you guys mind if I make a PureSim version of this db?

Shaun

Garlon · 10-23-2005, 05:58 AM

Shaun, it's fine with me, but let me get in touch with Arod, my partner on this project and get back to you.

Also, if anyone else wants to host our DB's on their own site please feel free to do so.

Garlon · 10-23-2005, 03:56 PM

Shaun, you're good to go.

10-21-2005, 05:49 AM	#1
Garlon Hall Of Famer Join Date: Jun 2004 Posts: 4,376	New ArodGarlon DBs 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.

10-21-2005, 07:22 AM	#2
attackemu All Star Reserve Join Date: Apr 2002 Location: Brooklyn Posts: 972	Very nice work! I'll download this one when I get home! Can't wait to play the "non-segregated" history of baseball. __________________ "Disguised in EMU's Blunt and sometimes hostile post is actually very sound advice. I think you would be wise to consider what he said." -ihatenames

10-21-2005, 11:28 AM	#5
timlowery Minors (Triple A) Join Date: Apr 2003 Location: Richmond, VA Posts: 261	Thanks for the great effort. Looking forward to this weekend! __________________ Timothy Lowery Proud Detroit Tigers fan since 1979!!! It's not one thing after another, it's the same thing all the time....

10-22-2005, 08:47 PM	#8
plannine All Star Reserve Join Date: Mar 2003 Location: Michigan Posts: 572	I've tested a few seasons and so far it looks great....results for a few seasons' came out well,...the only thing i see missing is adding a few more negro leaguers...like: Grant Johnson 1895-1916 Hurley McNair (OF/P) 1912-1927 Ted Radcliffe (C/P) 192x-1950: Louis Santop (C) 1909-1924: Sol White (3b) 1887-1912: (or are they there and i just missed them?) Here's league totals for 1901-1910......Avg & Era are decent (for me anyway) (The players are the same, the team names have changed...) This test was with OOTP5 with everything turned off....... Last edited by plannine; 02-15-2006 at 09:25 AM.

10-22-2005, 10:28 PM	#9
Shaun Sullivan Minors (Single A) Join Date: Apr 2002 Posts: 48	Can I create a PureSim version? Hey guys, cool stuff. It would take me 15 minutes to make this PureSim compatible, but I'd like to get your blessing first. I know a lot of hard must have went into this project! So, as long as I include your original info and credits do you guys mind if I make a PureSim version of this db? Shaun

10-21-2005, 08:25 AM	#4
Bluenoser Hall Of Famer Join Date: Mar 2002 Location: In The Moment Posts: 14,491	Excellent work guys, thanks for your commitment and time in doing this.

10-21-2005, 04:55 PM	#6
rogmax11 All Star Starter Join Date: Dec 2002 Posts: 1,320	Excellent effort, thank you very much! Any chance you could build a similar DB for Puresim?

10-21-2005, 05:07 PM	#7
Garlon Hall Of Famer Join Date: Jun 2004 Posts: 4,376	I have never played Puresim. This DB project alone took months to complete. If we do another one it won't be until the next OOTP is released. You're better off with OOTP anyway :-)

10-23-2005, 05:58 AM	#10
Garlon Hall Of Famer Join Date: Jun 2004 Posts: 4,376	Shaun, it's fine with me, but let me get in touch with Arod, my partner on this project and get back to you. Also, if anyone else wants to host our DB's on their own site please feel free to do so.

10-23-2005, 03:56 PM	#11
Garlon Hall Of Famer Join Date: Jun 2004 Posts: 4,376	Shaun, you're good to go.