New Arod23/Garlon DB now available

arod23 · 06-03-2006, 01:05 PM

Please post questions/comments in original post:

Arod23/Garlon Database Developer Blog

Russ · 06-03-2006, 02:39 PM

Woot! Thanks for all of your hard work guys. I'm looking forward to playing with this.

Tiger Fan · 06-03-2006, 02:42 PM

Quote:

Originally Posted by Russ

Woot! Thanks for all of your hard work guys. I'm looking forward to playing with this.

Same here

JWay · 06-03-2006, 03:12 PM

!!

Jeremy Weimer · 06-03-2006, 03:26 PM

Quote:

Originally Posted by Russ

Woot! Thanks for all of your hard work guys. I'm looking forward to playing with this.

"

arod23 · 06-10-2006, 02:18 AM

Names fixed, pitcher's batting games fixed, etc.

CONN CHRIS · 06-14-2006, 04:16 PM

I absolutely love this database, thank you for the effort!

I do not know if it got into this update or not but Cherokee Fisher is misspelled 'Cheroke' I believe.

Garlon · 06-14-2006, 06:54 PM

1871 Quickstart file available HERE

DunnFan37 · 06-17-2006, 05:11 PM

For Some reason I can not get it to load. Here is what I am trying to do. I am trying to start in 1901 with full minors. When I import the database everything seems to be fine. I edit the awards names, and all the other stuff. But when I click on create league, it starts doing all fictional stuff. Am I doing something wrong please help. I started using Tiger Fans 2902 quickstart, but if I played into the 2000 years, I would like to have all-minors. Thanks for the assistance!!

JWay · 06-17-2006, 05:44 PM

to have full minors you WILL need fictional players.

DunnFan37 · 06-17-2006, 06:01 PM

Do I have to have players on those teams? Or will it be ok for the rosters to be empty?? I just want some sort of a minors system, with my real-players historic league. So when I get further along in my sim and more players in the database, they will have somewhere to play and develope. Thanks...this is what I am trying to do.
What is happening is after I click on import historic league, all the real teams show up. But, when I click start, the game starts importing fictional teams and players. What am I doing wrong..it has to be a database issue??? THanks

JWay · 06-17-2006, 06:28 PM

all teams have to be full with fictional players, and when you run your sim your lowest minor league team will often run out of players. Its recommended that you just set the player creation modifiers for the minor leaguers to .100 so they never see MLB playing time except in extreme situations, works for me.

DunnFan37 · 06-17-2006, 08:00 PM

Thanks, I will try it out!!

<Pion> · 07-05-2006, 02:26 AM

Wrong Thread

arod23 · 07-19-2006, 11:50 PM

*NEW to v.2.0*

- Deleted fielding data (eligibility) for positions where players did not play a significant portion of games

- Deleted UA/PL/FL league players who did not have significant playing time in other leagues
These leagues are considered by experts to be below “major” league levels. If included, these players influence the outcome of league performance in subsequent seasons.

- Created OF eligibility in other OF positions
Based on each player's primary OF position, we adjusted the games played in the other OF positions so OOTP would assign ratings for all OF positions. The reason is that OOTP only gives fielding ratings in OF positions in which a player actually played. So, OOTPs AI will not give a RF player eligibility in LF if they do not have any ratings. This creates situations where a team may have no eligible LF on a team but actually have six OFers. And, the AI may even insert a player that has no OF experience. Realistically, OFers should be able to play in any field, although their effectiveness may not warrant such a move. So, CF now get rated in the corners at roughly half their effectiveness. Corner OFers get rated in the opposite corner at half effectiveness and in CF at 25% effectiveness. Due to the way the two fielding files are setup, this was only done for 1871-1995 OF positions. So, players post-1995 will only have OF eligibility where they have accumulated actual stats. (We are working on ways to address this).

- Fixed zero "errors" in pitching and batting files.
We added 1 BB or 1 SO to a few players who had zeros for BB and SO data, typically players with little playing time. When BB and SO data is zero, OOTP's ratings for Gap, Eye, Ks, Control are out of line with other players (likely due to some ratio equation which doesn't like zero in the numerator or denominator). For example, zero strikeouts in 600 at bats is impressive and should be rewarded with a great K rating, but zero strikeouts in 5 at bats doesn't really warrant the same kind of rating. Also, players with triples and no doubles caused strange gap ratings, so in those cases we gave players one double. Very few players were affected.

- Fixed leap year birthdays.
In some cases, leap year birthdays (February 29th) cause an import error. These birthdays were changed to February 28.

The following files are also included for user preference:

- FieldingOF-actualOF.csv
This is the original OF file based on the actual historical OF data and does not include players having eligibility in other OF positions.

- Master-NoNicknames.csv
Copy of the master file with nicknames removed. Catobase for OOTP6.5 does not do well with nicknames.

Raidergoo · 07-20-2006, 10:31 AM

Arod, if you could do a comparison of player's hometowns vs. cities.txt and come up with a list of cities that are missing, I will do what I can to get them into the game file.

A small start has already been made, but I think only the surface has been scratched.

arod23 · 07-20-2006, 05:25 PM

Quote:

Originally Posted by Raidergoo

Arod, if you could do a comparison of player's hometowns vs. cities.txt and come up with a list of cities that are missing, I will do what I can to get them into the game file.

A small start has already been made, but I think only the surface has been scratched.

Here is the list of birthplaces, which includes city, state (if US), country. You can match these up with the cities.txt file

Click to download: birthplace.txt

Raidergoo · 07-20-2006, 05:43 PM

Can a script be written comparing the cities.txt file to arod23's birthplaces.txt, and then output of the missing cities posted?

There's 4002 items to evaluate, and I'd appreciate the help.

Garlon · 07-20-2006, 07:28 PM

Radiergoo - Why do you want to add more cities to the cities.txt file? Is it just so that fictional players can also be created in all of the cities that a major leaguer came from too? If you import a historical player from the DB the game grabs his birth city right out of the master.csv file in the DB anyway, so there's no need to have that same city in the cities.txt file.

Raidergoo · 07-20-2006, 09:34 PM

Quote:

Originally Posted by Garlon

Radiergoo - Why do you want to add more cities to the cities.txt file? Is it just so that fictional players can also be created in all of the cities that a major leaguer came from too? If you import a historical player from the DB the game grabs his birth city right out of the master.csv file in the DB anyway, so there's no need to have that same city in the cities.txt file.

#1 Yes, for alternate universe games, I'd like some players ( Harvey Haddix ) to come from Medway, Ohio, which is not in the file.

#2 Not all players import from the master.csv properly, and many come from towns too small to be in the file. If added, with geographical coordinates, the free agent process will be better, even if by a small percentage.

It's small, but repeated efforts that pay attention to detail that will make this a better game.

06-03-2006, 01:05 PM	#1 (permalink)
arod23 Major Leagues Join Date: Apr 2004 Location: Philadelphia, PA Posts: 376	New Arod23/Garlon DB now available Please post questions/comments in original post: Arod23/Garlon Database Developer Blog __________________ Download v.2.1 Arod23/Garlon 2006 DB & Career Average DB, random debut year and normalized DBs here: OOTP DBs

06-03-2006, 02:39 PM	#2 (permalink)
Russ All Star Starter Join Date: Oct 2005 Location: Essex HON! Posts: 1,909 Blog Entries: 1 Thanked 48x in 42 posts Infractions: 0/1 (1)	Woot! Thanks for all of your hard work guys. I'm looking forward to playing with this. __________________ If you don't love Russ, you don't love America. This post brought to you by Carl's Jr.

06-03-2006, 03:12 PM	#4 (permalink)
JWay Hall Of Famer Join Date: Dec 2001 Location: Sioux Falls, South Dakota Posts: 4,289 Blog Entries: 1 Thanked 78x in 51 posts	!! __________________ Passion Bucket...Full Laugh Battle The Classic Baseball Union Check it out!

06-10-2006, 02:18 AM	#6 (permalink)
arod23 Major Leagues Join Date: Apr 2004 Location: Philadelphia, PA Posts: 376	Updated version 1.2 ready for download Names fixed, pitcher's batting games fixed, etc. __________________ Download v.2.1 Arod23/Garlon 2006 DB & Career Average DB, random debut year and normalized DBs here: OOTP DBs

06-14-2006, 04:16 PM	#7 (permalink)
CONN CHRIS Global Moderator Join Date: Oct 2004 Posts: 23,467 Thanked 497x in 347 posts	I absolutely love this database, thank you for the effort! I do not know if it got into this update or not but Cherokee Fisher is misspelled 'Cheroke' I believe. __________________ REC World Prizefighter Rankings Challenge my Brute!

06-14-2006, 06:54 PM	#8 (permalink)
Garlon All Star Starter Join Date: Jun 2004 Posts: 1,551 Thanked 52x in 26 posts	1871 Quickstart file available HERE

06-17-2006, 05:11 PM	#9 (permalink)
DunnFan37 Bat Boy Join Date: Jun 2006 Posts: 19	For Some reason I can not get it to load. Here is what I am trying to do. I am trying to start in 1901 with full minors. When I import the database everything seems to be fine. I edit the awards names, and all the other stuff. But when I click on create league, it starts doing all fictional stuff. Am I doing something wrong please help. I started using Tiger Fans 2902 quickstart, but if I played into the 2000 years, I would like to have all-minors. Thanks for the assistance!!

06-17-2006, 05:44 PM	#10 (permalink)
JWay Hall Of Famer Join Date: Dec 2001 Location: Sioux Falls, South Dakota Posts: 4,289 Blog Entries: 1 Thanked 78x in 51 posts	to have full minors you WILL need fictional players. __________________ Passion Bucket...Full Laugh Battle The Classic Baseball Union Check it out!

06-17-2006, 06:01 PM	#11 (permalink)
DunnFan37 Bat Boy Join Date: Jun 2006 Posts: 19	Do I have to have players on those teams? Or will it be ok for the rosters to be empty?? I just want some sort of a minors system, with my real-players historic league. So when I get further along in my sim and more players in the database, they will have somewhere to play and develope. Thanks...this is what I am trying to do. What is happening is after I click on import historic league, all the real teams show up. But, when I click start, the game starts importing fictional teams and players. What am I doing wrong..it has to be a database issue??? THanks

06-17-2006, 06:28 PM	#12 (permalink)
JWay Hall Of Famer Join Date: Dec 2001 Location: Sioux Falls, South Dakota Posts: 4,289 Blog Entries: 1 Thanked 78x in 51 posts	all teams have to be full with fictional players, and when you run your sim your lowest minor league team will often run out of players. Its recommended that you just set the player creation modifiers for the minor leaguers to .100 so they never see MLB playing time except in extreme situations, works for me. __________________ Passion Bucket...Full Laugh Battle The Classic Baseball Union Check it out!

06-17-2006, 08:00 PM	#13 (permalink)
DunnFan37 Bat Boy Join Date: Jun 2006 Posts: 19	Thanks, I will try it out!!

07-05-2006, 02:26 AM	#14 (permalink)
<Pion> All Star Reserve Join Date: Mar 2006 Posts: 612	EZUse program for running historical leagues Wrong Thread

07-19-2006, 11:50 PM	#15 (permalink)
arod23 Major Leagues Join Date: Apr 2004 Location: Philadelphia, PA Posts: 376	Version 2.0 Available NEW to v.2.0 - Deleted fielding data (eligibility) for positions where players did not play a significant portion of games - Deleted UA/PL/FL league players who did not have significant playing time in other leagues These leagues are considered by experts to be below “major” league levels. If included, these players influence the outcome of league performance in subsequent seasons. - Created OF eligibility in other OF positions Based on each player's primary OF position, we adjusted the games played in the other OF positions so OOTP would assign ratings for all OF positions. The reason is that OOTP only gives fielding ratings in OF positions in which a player actually played. So, OOTPs AI will not give a RF player eligibility in LF if they do not have any ratings. This creates situations where a team may have no eligible LF on a team but actually have six OFers. And, the AI may even insert a player that has no OF experience. Realistically, OFers should be able to play in any field, although their effectiveness may not warrant such a move. So, CF now get rated in the corners at roughly half their effectiveness. Corner OFers get rated in the opposite corner at half effectiveness and in CF at 25% effectiveness. Due to the way the two fielding files are setup, this was only done for 1871-1995 OF positions. So, players post-1995 will only have OF eligibility where they have accumulated actual stats. (We are working on ways to address this). - Fixed zero "errors" in pitching and batting files. We added 1 BB or 1 SO to a few players who had zeros for BB and SO data, typically players with little playing time. When BB and SO data is zero, OOTP's ratings for Gap, Eye, Ks, Control are out of line with other players (likely due to some ratio equation which doesn't like zero in the numerator or denominator). For example, zero strikeouts in 600 at bats is impressive and should be rewarded with a great K rating, but zero strikeouts in 5 at bats doesn't really warrant the same kind of rating. Also, players with triples and no doubles caused strange gap ratings, so in those cases we gave players one double. Very few players were affected. - Fixed leap year birthdays. In some cases, leap year birthdays (February 29th) cause an import error. These birthdays were changed to February 28. The following files are also included for user preference: - FieldingOF-actualOF.csv This is the original OF file based on the actual historical OF data and does not include players having eligibility in other OF positions. - Master-NoNicknames.csv Copy of the master file with nicknames removed. Catobase for OOTP6.5 does not do well with nicknames. __________________ Download v.2.1 Arod23/Garlon 2006 DB & Career Average DB, random debut year and normalized DBs here: OOTP DBs

07-20-2006, 10:31 AM	#16 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 8,327 Thanked 53x in 36 posts	Arod, if you could do a comparison of player's hometowns vs. cities.txt and come up with a list of cities that are missing, I will do what I can to get them into the game file. A small start has already been made, but I think only the surface has been scratched.

07-20-2006, 05:43 PM	#18 (permalink)
Raidergoo Hall Of Famer Join Date: Mar 2003 Location: 39.84 N -84.12 W Posts: 8,327 Thanked 53x in 36 posts	Can a script be written comparing the cities.txt file to arod23's birthplaces.txt, and then output of the missing cities posted? There's 4002 items to evaluate, and I'd appreciate the help.

07-20-2006, 07:28 PM	#19 (permalink)
Garlon All Star Starter Join Date: Jun 2004 Posts: 1,551 Thanked 52x in 26 posts	Radiergoo - Why do you want to add more cities to the cities.txt file? Is it just so that fictional players can also be created in all of the cities that a major leaguer came from too? If you import a historical player from the DB the game grabs his birth city right out of the master.csv file in the DB anyway, so there's no need to have that same city in the cities.txt file.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode