Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 26 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 05-01-2015, 02:52 PM   #661
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
So is the file updated after AJ mentioned several errors?
__________________
Go today don't wait for tomorrow
It isn't promised, all the time you get borrowed
Don't live your life for other people
Don't bottle your emotions till they crack and fill a couple just sorrows
Take your mind and refocus go get a paper write your goals out
Throw your middle fingers to all your haters


"Stay Strong"


The Game is offline   Reply With Quote
Old 05-01-2015, 02:56 PM   #662
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by The Game View Post
So is the file updated after AJ mentioned several errors?
Yes and there were over a thousand data errors. I used BBref to fix them rather than Lahman.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-01-2015, 04:07 PM   #663
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
In my experience with the earlier version of the HS DB, if I ran a fictional league starting before 1871 with the correct team ID's, the 1871 players would go to their first stint team. Now most are just designated IND in those early years. That wouldn't be a problem, except now it seems that action causes RD to kick in.

Would changing the year of debut in your MASTER.CSV solve the issue of missing pre 1871 careers?
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 05-01-2015, 05:42 PM   #664
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
RD kicks in? I thought that was what you wanted? Confused.

I always start in 1871 with all real Players and all real Teams. I have never tried switching from Fictional to Historical mid-stream. There is no in game Team File pre 1871 which is why you get all the IND's. Nowhere for the Players to go that the game knows about.

YearID CountOfRealPlayers
1856 1
1857 1
1858 4
1859 4
1860 10
1861 12
1862 14
1863 23
1864 28
1865 45
1866 64
1867 87
1868 110
1869 131
1870 146
1871 266
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 05-01-2015 at 05:46 PM.
Spritze is offline   Reply With Quote
Old 05-01-2015, 06:44 PM   #665
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Sir Spritze, started a historical game in 2014 with your database. The good news is that I'm not seeing any duplicate players anymore like I did before (Three Norichika Aokis, two from Japan, one from MLB - triple vision oye! - but no more - yay!) the latest fix.

The bad news is some 83 out of the 4158 players have imported with zero ability to catch the ball, or hit the ball, and they have all imported as RF or LF whether or not they actually play there or not. A lot of them are Korean or Japanese players, but unfortunately Yordano Ventura is one of them. Yep, that Yordano Ventura - the Royals hotheaded ace SP. He imported as a LF with zero ability to catch the ball or hit the ball. Let's just blame this all on Sean Lahman taking up yoga or tai-chi, or whatever it is that's distracted him lately (kidding Mr. Lahman, just kidding!) from his life's work. I don't know which file the problem is in. Maybe Ventura didn't get pitch ratings in the master file. It doesn't look like he got stats in the pitching.csv file or the pitching2.csv file. The list of fenceposts is as follows (where possible, I included the position they imported as, and what they are in real life):

Andrew Albers (imports as LF, IRL SP 2013) (alberan01)
Keiyo Aomatsu (imports as RF, IRL ??) (aomatke80)
Mike Belfiore (imports as LF, IRL RP 2013) (belfimi01)
Vince Belnome (imports as LF, IRL DH 2014) (belnovi01)
Ryan Brasier (imports as LF, IRL RP 2013) (brasiry01)
Billy Burns (imports as LF, IRL PR/CF 2014) (burnsbi02)
Jeong-Guk Cha (imports as RF, IRL ??) (chajegu55)
Masashi Chikazawa (imports as RF, IRL ??) (chikama95)
Jeong-Min Chin (imports as RF, IRL ??) (chijemi55)
Byeong-Chan Cho (imports as RF, IRL ??) (chobych56)
Jae-Yeong Cho (imports as RF, IRL ??) (chojaye55)
Gyeong-Sik Choo (imports as RF, IRL ??) (chogysi55)
Dong-Rak Chou (imports as RF, IRL ??) (chodora55)
Dong-Yeon Chou (imports as RF, IRL ??) (chodoye56)
Min-Jun Chou (imports as RF, IRL ??) (chomiju55)
Zach Clark (imports as LF, IRL RP 2013) (clarkza01)
Jose De La Torre (imports as LF, IRL RP 2013) (delatjo01)
Chris Dwyer (imports as LF, IRL RP 2013) (dwyerch01)
Junichi Fukuhara (imports as RF, IRL ??) (fukuhju80)
Yun-Seop Han (imports as RF, IRL ??) (hanyuse55)
Yeon-Cheol Ho (imports as RF, IRL ??) (hoyech55)
Ma-Tae Hong (imports as RF, IRL??) (honmata55)
Myeong-Chan Hong (imports as RF, IRL ??) (honmych55)
Hidekazu Hoshi (imports as RF, IRL ??) (hoshihi80)
Naoki Hosomi (imports as RF, IRL ??) (hosomna95)
I-Gap Hwang (imports as RF, IRL ??) (hwaiga55)
Suguru Ichikawa (imports as RF, IRL ??) (ichiksu80)

If you notice, so far the MLB players are importing as LF, while the foreign players are importing as RF. Interesting, we'll see if this continues.
actionjackson is offline   Reply With Quote
Old 05-01-2015, 07:22 PM   #666
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
RD kicks in? I thought that was what you wanted? Confused.

I always start in 1871 with all real Players and all real Teams. I have never tried switching from Fictional to Historical mid-stream. There is no in game Team File pre 1871 which is why you get all the IND's. Nowhere for the Players to go that the game knows about.

YearID CountOfRealPlayers
1856 1
1857 1
1858 4
1859 4
1860 10
1861 12
1862 14
1863 23
1864 28
1865 45
1866 64
1867 87
1868 110
1869 131
1870 146
1871 266
Actually, no, and I apologize if I was vague. I wanted to import the players according to your revised timeline (above) and have them play in a fictional league through 1900 and until the rookies imported. Then import 1901 as a HISTORIC LEAGUE without players, transfer the rosters and continue with the DB. (This is a bit shortened to avoid too much detail). As best I can tell, players import historically when TEAM ID's match up. Those who were not designated would be FA and hopefully sign with a ML club or go to a lesser or minor league. Crazy maybe, but that was what I was trying to do.

Does this make what I was asking any clearer? Can you help me? I have a bad case of OOTP!

But thank you for your great work and patience.

JP
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 05-01-2015, 07:31 PM   #667
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Continued from above...

Takahiro Imanami (imports as RF, IRL ??) (imanata80)
Hak-Soo Jeong (imports as RF, IRL ??) (jeohaso56)
In-Ho Jeong (imports as RF, IRL ??) (jeoinho55)
Jeong-O Jeong (imports as RF, IRL ??) (jeojeo55)
Donnie Joseph (imports as LF, IRL RP 2013-2014) (josepdo01)
Akihiko Kato (imports as RF, IRL ??) (katoak95)
Dong-Myeong Kim (imports as LF, IRL ??) (kimdomy55)
Gi-Seong Kim (imports as RF, IRL ??) (kimgise55)
Hak-Jae Kim (imports as RF, IRL ??) (kimhaja55)
Jeong-Han Kim (imports as RF, IRL ??) (kimjeha56)
Jong-Seong Kim (imports as RF, IRL ??) (kimjose58)
Mu-Seong Kim (imports as RF, IRL ??) (kimmuse56)
Mu-Seong M Kim (imports as RF, IRL ??) (kimmuse55)
Se-Jung Kim (imports as RF, IRL ??) (kimseju58)
Seong-Gyun Kim (imports as RF, IRL ??) (kimsegy56)
Seong-Ho Kim (imports as RF, IRL ??) (kimseho58)
Won Kim (imports as RF, IRL ??) (kimwo55)
Yong-Seop Kim (imports as RF, IRL ??) (kimyose56)
Min-Ho Ku (imports as RF, IRL ??) (kumiho55)
Shigenori Kuremoto (imports as RF, IRL ??) (kuremsh80)
Toshiki Kurobane (imports as RF, IRL ??) (kurobto80)
Yong-Seop Kwak (imports as RF, IRL ??) (kwayose55)
Yeong-Geun Kwon (imports as RF, IRL ??) (kwoyege55)
Du-Hwan Lee (imports as LF, IRL ??) (leeduhw55)
Ho-Gyun Lee (imports as RF, IRL ??) (leehogy55)
Ho-Seong Lee (imports as RF, IRL ??) (leehose56)
Sang-Ho Lee (imports as RF, IRL ??) (leesaho55)
Seung-Yeop S Lee (imports as RF, IRL ??) (leeseye56)

Last of the fenceposts coming up...A few foreign players came in as LF, but they're mostly RF. I have no clue why. Maybe RF and LF were short on players...Who knows?
actionjackson is offline   Reply With Quote
Old 05-01-2015, 08:28 PM   #668
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Continued from above...

Hak-Soo Lim (imports as RF, IRL ??) (limhaso55)
Chia-Jen Lo (imports as LF, IRL RP 2013) (loch02)
Usami Makitani (imports as RF, IRL ??) (makitus95)
Brett Marshall (imports as LF, IRL RP 2013) (marshbr01)
Ryuhei Matsuyama (imports as RF, IRL ??) (matsury80)
Hiroki Nakagawa (imports as RF, IRL ??) (nakaghi80)
Tsubasa Nakatani (imports as RF, IRL ??) (nakatts80)
Takuto Nobuhara (imports as RF, IRL ??) (nobuhta95)
Jeong-Hun Paek (imports as RF, IRL ??) (paejehu56)
Seung-Hun Paek (imports as RF, IRL ??) (paesehu55)
Bong-Soo Pak (imports as RF, IRL ??) (pakboso55)
Du-Il Pak (imports as RF, IRL ??) (pakduil55)
U-Ho Pak (imports as RF, IRL ??) (pakuho55)
Seung-Jae Pang (imports as RF, IRL ??) (panseja55)
Enny Romero (imports as LF, IRL SP 2013) (romeren01)
Takashi Sasagawa (imports as RF, IRL ??) (sasagta95)
Jeong Seo (imports as RF, IRL ??) (seoje55)
Ju-Il Shin (imports as RF, IRL ??) (shijuil55)
Soo-Geun Song (imports as RF, IRL ??) (sonsoge55)
Daijiro Tanaka (imports as LF, IRL ??) (tanakda81)
Henry Urrutia (imports as RF, IRL DH/LF) (urruthe01)
Yordano Ventura (imports as LF, IRL SP 2013-present) (ventuyo01)
Duke Welker (imports as LF, IRL RP 2013) (welkedu01)
Seung-Hak Yang (imports as RF, IRL ??) (yanseha55)
Yeong-Dong Yang (imports as RF, IRL ??) (yanyedo55)
Kota Yoshida (imports as RF, IRL ??) (yoshiko95)
Sang-Mu Yun (imports as RF, IRL ??) (yunsamu55)
Tae-Soo Yun (imports as RF, IRL ??) (yuntaso55)

I have no idea what caused this, but it's gotta be in there somewhere. If you want to see it for yourself in-game, start a 2014 historical game via the game creation wizard thingy, use the player search and shortlist to get a list and sort it according to worst range, and voila 83 fenceposts. We'll call it the Yordano Ventura bug for now, because he's the one that motivated me to report it. Good luck whenever you get a chance. Cheers.

Last edited by actionjackson; 05-01-2015 at 08:38 PM.
actionjackson is offline   Reply With Quote
Old 05-01-2015, 11:11 PM   #669
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Japanese and Korean stats have not been updated since 2008 those are the ID's that end in the 50's, 80's and 90's. More than likely these players did not play in the field through 2008.

The few that end in 01 or 02 are from Lahman. I'll check those out.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 05-01-2015 at 11:17 PM.
Spritze is offline   Reply With Quote
Old 05-01-2015, 11:16 PM   #670
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
Does this make what I was asking any clearer? Yes Can you help me?
You are playing the game outside its design parameters. I have no idea how to accomplish your necessities. Sorry.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-01-2015, 11:47 PM   #671
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
You are playing the game outside its design parameters. I have no idea how to accomplish your necessities. Sorry.
When the DB did not support RD it seemed to allow this. Can the RD capability of the DB be turn off?

My earlier question about the master.csv, can the debut year be changed there?

Thank you.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 05-02-2015, 12:37 AM   #672
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
When the DB did not support RD it seemed to allow this. Can the RD capability of the DB be turn off? No

My earlier question about the master.csv, can the debut year be changed there? If you choose to

Thank you.
Random Debut is controlled by OOTP16. That is where you turn it off and on. The DB simply had a few missing fields in the Master that stopped RD in its tracks. It did not turn it on or off.

You may edit the master to your likes as far as debuts.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 05-02-2015 at 12:52 AM.
Spritze is offline   Reply With Quote
Old 05-02-2015, 12:42 AM   #673
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
Japanese and Korean stats have not been updated since 2008 those are the ID's that end in the 50's, 80's and 90's. More than likely these players did not play in the field through 2008.

The few that end in 01 or 02 are from Lahman. I'll check those out.
Thanks Spritze. I'm sure Mr. Ventura would thank you too, though I'm not sure you'd want the kind of thanks he seems to dole out with regularity these days. 100 mph inside fastballs are not my idea of "Thank You!".
actionjackson is offline   Reply With Quote
Old 05-02-2015, 01:16 AM   #674
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
Random Debut is controlled by OOTP16. That is where you turn it off and on. The DB simply had a few missing fields in the Master that stopped RD in its tracks. It did not turn it on or off.

You may edit the master to your likes as far as debuts.
So would changing one of those fields prevent unwanted RD?

I downloaded your latest dropbox file today. I am going to try again with it and not removing the OBD files. I'll see what results I get and/or try tweaking the MASTER.CSV.

Thank you for all your help and hard work.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 05-02-2015, 10:22 AM   #675
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
So would changing one of those fields prevent unwanted RD?
RD only happens when you activate it in game so....No. If you don't want RD do not turn it on.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-02-2015, 12:12 PM   #676
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
The Lahman errors have been fixed. Almost all were KC Royals.

I'll need to update the Japanese and Korean players by adding, 2009, 2010, 2011, 2012, 2013, 2014 season stats. That'll take awhile.

Box Droppings Share:
https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

On the Wiki also.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 05-02-2015 at 02:52 PM.
Spritze is offline   Reply With Quote
Old 05-02-2015, 03:00 PM   #677
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Question/Query: I've compiled a list of guys who I think the defensive ratings are short changing. I think it's that the range/error/arm ratings are too low, but you would know better than me. Defense is the toughest nut to crack of course. The stats for hitting and pitching are much easier to apply to ratings. If you could possibly take a look, I'd appreciate it. If you feel they're fine, that's cool too. This is from starting a historical 2014 game with the Spritze database:

Manny Machado 3B (machama01)
Andrelton Simmons SS (simmoan01)
Nolan Arenado 3B (arenano01)
Salvador Perez C (Catcher Ability fine, Catcher Arm looks too low) (perezsa02)
Josh Donaldson 3B (donaljo02)
Ben Zobrist UT (mostly 2B/RF, but also LF/CF/SS) (zobribe01)
Leonys Martin CF (Range and Error look fine, but Arm could use a big boost) (martile01)
Jason Heyward RF (Arm and Error look fine, perhaps Range could use a boost) (heywaja01)
Josh Reddick RF (Error looks fine, Range and Arm could use a boost) (reddijo01)
Billy R Hamilton CF (Error looks fine, Range and Arm could use a boost) (hamilbi02)
Yan Gomes C (Both Catcher Ability, and Catcher Arm could use a big boost) (gomesya01)
Chase Utley 2B (Range could use a boost, all else looks OK) (utleych01)
Anthony Rendon 3B/2B (Range and Double Play could use a boost, Error and Arm look OK) (rendoan01)
Trevor Plouffe 3B (could use a boost in Double Play, everything else looks OK) (plouftr01)

Most of these guys are guys who have emerged defensively (with the exception of Utley and Zobrist who have more experience, and Plouffe who, while not tremendous defensively, deserves better in the DP rating) in the last three full seasons, while Lahman was out chasing butterflies (kidding, just kidding!), so they may have gotten missed/not be getting their due because of that. Maybe it's all controlled by the stats, so not much can be done, I don't know. That's why I'll leave it in your capable hands. Thanks.

Last edited by actionjackson; 05-02-2015 at 03:01 PM.
actionjackson is offline   Reply With Quote
Old 05-02-2015, 03:13 PM   #678
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
It's all controlled by the stats, so nothing can be done.

As their stats change so will their ratings. The ratings chips just fall where they fall based on overall Stats 1871-2014 and a players personal contribution to those. It takes about 200-400 games played at a specific position to get real good ratings.

If these players have incorrect stats they should be fixed though,

Otherwise the ratings "are what we thought they were".

For instance Yan Gomes was a very pedestrian to poor catcher statswise his first 94 games at the position. His last 126 were better which improved his ratings. If he keeps it up his ratings will increase further. If he does not, well then there it is. Historical requires a player to prove it over time.

If you use 1-year recalc you'll get ratings weighted more to 2014, the default 3-year will include ratings based on 2012, 2013 and 2014.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 05-02-2015 at 03:33 PM.
Spritze is offline   Reply With Quote
Old 05-02-2015, 04:07 PM   #679
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
It's all controlled by the stats, so nothing can be done.

As their stats change so will their ratings. The ratings chips just fall where they fall based on overall Stats 1871-2014 and a players personal contribution to those. It takes about 200-400 games played at a specific position to get real good ratings.

If these players have incorrect stats they should be fixed though,

Otherwise the ratings "are what we thought they were".

For instance Yan Gomes was a very pedestrian to poor catcher statswise his first 94 games at the position. His last 126 were better which improved his ratings. If he keeps it up his ratings will increase further. If he does not, well then there it is. Historical requires a player to prove it over time.

If you use 1-year recalc you'll get ratings weighted more to 2014, the default 3-year will include ratings based on 2012, 2013 and 2014.
I usually use 3 years double weighted recalc. I should go through the whole tedious advanced setup process with it set up the way I usually set it up and see how it looks before jumping to conclusions. Should also probably look at 2012 and 2013 with my settings. No time to do it now though. I'll get to it later and see what I find. Thanks.

EDIT: Aren't the players also given "beginner" type ratings for range, arm, error, DP, experience etc. in the master.csv file? Maybe if those were adjusted upwards it would help. I don't know...Just spitballin'.

Last edited by actionjackson; 05-02-2015 at 04:15 PM.
actionjackson is offline   Reply With Quote
Old 05-02-2015, 04:18 PM   #680
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
The fielding ratings in the Master are only used for Random Debut.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Reply

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:36 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments