|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
|
Thread Tools |
04-28-2018, 06:39 PM | #1 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Spritze DB for OOTP19
Done except for the export to the Internet.
Players still start at 18 (or earlier if they did IRL) I was thinking of removing the players who are in the OOTP databases already but they don't start at 18 so I did not. Ethnicities and arm slots have been added as have the other new OOTP items added by OOTP Developments to the OOTP file structures. There are some values that just have placeholders for now as it will take all summer to procure the data. Real stats and neutralized stats are the same MLE's as before. So really real stats do not exist. A couple of versions ago I removed them because users of the database could not remember to only use the newts. So either one you pick produces the same results. I'll wait a week or so to upload this in case anyone has any requests or concerns. It will be an ODB file as CSV's do not work with OOTP anymore. I have been waiting on the new historical lead to be named before I released this to make sure he would be OK with it as I would not want to do any toes stepping on but that may not happen for a while so I just decided to go for it.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
04-28-2018, 08:17 PM | #2 |
Hall Of Famer
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
|
any chance of an amended .csv, with just the players names, race, arm slot, debut year/ final year and player IDs - you know, without anything proprietary? i find that the .csv files are extremely helpful, if for nothing else to get the player IDs to make large .txt files to import. the rest of the stuff i can edit, when/as needed.
thanks for all the great DBs in the past. i've used them more than the ones that come in the game it seems. be well.
__________________
"This is my opening farewell " - Jackson Browne “They make a desolation and call it peace.” ― Agha Shahid Ali "Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt "I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen "Hello darkness, my old Friend ...." - Paul Simon Before Mays, before DiMaggio, there was Oscar Charleston. "All the lies about Babe Ruth are true." - Waite Hoyt Avatar is the late great Townes Van Zandt. rip. Last edited by mitchkenn; 04-28-2018 at 09:04 PM. Reason: minutia |
04-29-2018, 01:58 AM | #3 |
All Star Starter
Join Date: Aug 2011
Posts: 1,921
|
Hi spritze.
I was just testing your 18 db with the new version, and the odd feature of not getting drafts occurred. The new players in 1872 show up, but as free agents, not draft. Draft is selected all is as it should be in the setup screens. You may want to double check the draft is working fine with the new one. Ps I also tested neutralized, and 19 called up the stats odd. 1 column seemed moved over. So runs became at bats, at bats were games played. Every player imported as a .567 like hitter. Just a heads up, you might want to check that too. Love your db and work. If I can test anything for you, shoot me over a pm Cheers |
04-29-2018, 10:55 AM | #4 | |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Quote:
I'll check the newts later today.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
|
04-29-2018, 11:14 AM | #5 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Newts look fine as well.
You did not specify how you were viewing the newts. This screenshot is from the newt inaugural draft.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
04-29-2018, 02:04 PM | #6 |
All Star Starter
Join Date: Aug 2011
Posts: 1,921
|
Sorry Spritze. Here is a screenshot. This is 1871, spritze db 18, neutralized stats. out of the box setup. Here are how the historical stats import for everyone, just 2 examples
|
04-29-2018, 02:08 PM | #7 |
Hall Of Famer
Join Date: Aug 2010
Location: Indiana
Posts: 9,798
|
New historical lead?
|
04-29-2018, 02:35 PM | #8 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Reproducible is not what these examples are.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 04-29-2018 at 02:50 PM. |
04-29-2018, 02:47 PM | #9 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Aye. I have retired.
I will be around to help answer questions if the new person has any questions which they may not but I have humped my last tulip. Golden years are burgeoning and beckoning.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
04-29-2018, 03:17 PM | #10 |
Hall Of Famer
Join Date: Aug 2010
Location: Indiana
Posts: 9,798
|
Best wishes for those golden years. Hopefully you won't stop playing and you will be around to talk about that.
|
04-29-2018, 04:03 PM | #11 |
All Star Starter
Join Date: Aug 2011
Posts: 1,921
|
|
04-29-2018, 04:11 PM | #12 |
Hall Of Famer
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
|
may your retirement be filled with peace and contentment. All you've done, and all the help extended, remains a standard and is appreciated. if you're ever this way, a dr. pepper awaits.
__________________
"This is my opening farewell " - Jackson Browne “They make a desolation and call it peace.” ― Agha Shahid Ali "Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt "I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen "Hello darkness, my old Friend ...." - Paul Simon Before Mays, before DiMaggio, there was Oscar Charleston. "All the lies about Babe Ruth are true." - Waite Hoyt Avatar is the late great Townes Van Zandt. rip. |
05-02-2018, 12:08 PM | #13 |
All Star Starter
Join Date: Sep 2015
Location: Kelowna, British Columbia
Posts: 1,266
|
What mitchkenn said enjoy your retirement, hopefully you will have second thoughts regarding OOTP.
|
05-02-2018, 02:45 PM | #14 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
I retired from working 5 years ago except for a very few consults with old clients.
I will be available for consults with OOTP if anything comes up. Hopefully the new guy will be overflowing with new ideas and can push historicals to new heights.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
05-02-2018, 04:52 PM | #15 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
ok
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
05-02-2018, 05:06 PM | #16 |
Hall Of Famer
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
|
__________________
"This is my opening farewell " - Jackson Browne “They make a desolation and call it peace.” ― Agha Shahid Ali "Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt "I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen "Hello darkness, my old Friend ...." - Paul Simon Before Mays, before DiMaggio, there was Oscar Charleston. "All the lies about Babe Ruth are true." - Waite Hoyt Avatar is the late great Townes Van Zandt. rip. Last edited by mitchkenn; 05-02-2018 at 09:26 PM. |
05-03-2018, 02:02 AM | #17 | |
Minors (Double A)
Join Date: Jun 2008
Posts: 146
|
I personally look forward to this update more than I do the actual release of the game, so I'm sad to hear you'll be taking a step back.
One thing you said has left me confused though... Quote:
Is my interpretation correct? If not, what did you really mean? I love starting everyone at that early age in some fictional minor leagues, so that's why I'm curious. Thanks man |
|
05-03-2018, 11:29 AM | #18 | |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Quote:
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
|
05-03-2018, 07:19 PM | #19 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
|
Update:
Slight pause before I release this. While I was creating the player list for those that import I decided it was too confusing to have some different player ID's in OOTP and the Spritze database so I will change mine to match OOTP. If OOTP does not have one, like for most Japanese and Korean players I will be making my own.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
05-03-2018, 07:22 PM | #20 |
Hall Of Famer
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,853
|
darn - but thanks for the update ....
__________________
"This is my opening farewell " - Jackson Browne “They make a desolation and call it peace.” ― Agha Shahid Ali "Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt "I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen "Hello darkness, my old Friend ...." - Paul Simon Before Mays, before DiMaggio, there was Oscar Charleston. "All the lies about Babe Ruth are true." - Waite Hoyt Avatar is the late great Townes Van Zandt. rip. Last edited by mitchkenn; 05-03-2018 at 08:49 PM. |
Bookmarks |
|
|