Home | Webstore
Latest News: FHM 5 Available - OOTP 19 Available! - MLB Manager 2018 Available Now

Perfect Team is LIVE!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 19 > 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-15-2012, 02:47 PM   #21
mikev
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 4,014
Thanks: 0
Thanked 29x in 23 posts
So is the workaround to set the OOTPOU draft to 20 rounds (or whatever in-game is set to) and have it AutoDraft for the last X number of rounds that aren't actually done, then import that into OOTP?
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 05-15-2012, 03:48 PM   #22
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by mikev View Post
So is the workaround to set the OOTPOU draft to 20 rounds (or whatever in-game is set to) and have it AutoDraft for the last X number of rounds that aren't actually done, then import that into OOTP?
That was one solution. However, that means people can't use the in-game draft lists (they can use the OU draft lists, of course). In-game is more flexible, so you lose that functionality. If I went this route, I would have just had a "auto rest of draft" button, so you would still set it up for 3 rounds, but the auto would run the last 17. I don't think you'd want to click "auto" for each owner, etc.

Remember I didn't actually implement this, so OU doesn't generate a csv for importing, even if you did auto all 20 rounds. It requires a special format.

Anyway, I could have done this, but I didn't because I thought Markus was going to fix it right up until release. So it didn't get in.

On a different note, can you guys generate your draft history? Curious how it turns out for some of the other leagues...
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details

Last edited by Getch; 05-15-2012 at 03:51 PM.
Getch is offline   Reply With Quote
Thank you for this post:
Spindel (06-16-2012)
Old 05-15-2012, 04:02 PM   #23
mikev
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 4,014
Thanks: 0
Thanked 29x in 23 posts
Oh don't worry, no blame is being placed on you. Online Leagues are used to being the bastard stepchild of OOTP -- where massive potentially game breaking issues are ignored, but hey we have a new skin, and sounds, and more play by play text!

Right now we're into the 4th round of the GUBA draft. It's set for 7 rounds, but I believe we have 20 in OOTP -- so we can reconfigure to 20 in the OOTPOU and autodraft after Rd7, and then import that and all will be well?

I'll try to generate draft history after the draft is done.
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 05-15-2012, 04:34 PM   #24
knudlen
Minors (Rookie Ball)
 
Join Date: May 2004
Posts: 27
Thanks: 1
Thanked 5x in 2 posts
Helpful timely responses on the ootp boards? I don't have the words.... they should have sent a poet.
knudlen is offline   Reply With Quote
Old 05-15-2012, 04:46 PM   #25
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by mikev View Post
Oh don't worry, no blame is being placed on you. Online Leagues are used to being the bastard stepchild of OOTP -- where massive potentially game breaking issues are ignored, but hey we have a new skin, and sounds, and more play by play text!

Right now we're into the 4th round of the GUBA draft. It's set for 7 rounds, but I believe we have 20 in OOTP -- so we can reconfigure to 20 in the OOTPOU and autodraft after Rd7, and then import that and all will be well?
Unfortunately, it isn't quite so easy... This is what you would need to do:

- After completion of the draft of 7 rounds, manually edit the OOTPOU/draft/<year>/<league>/picks.txt file and add in the 13 rounds... I don't think you want to add them in by hand in the UI. Should be obvious how to do this and pretty simple by looking at the file
- Set all the teams to auto-pick (manually editing the preferences.txt file is fastest here)
- Auto the next pick, and the rest of the draft should auto
- Once this is done, you need to convert the picks.txt file into the format of the draft.csv file. This will be a little bit of a pain.

BTW, this is all assuming that import even works in OOTP... I never really tested it in beta once I saw how it was implemented.

There's a chance I could look into throwing something together for this this weekend. Hold off on doing anything, maybe I can muster up some time to do this in OU.

Quote:
I'll try to generate draft history after the draft is done.
History gets generated for all years prior to the current one. No need to wait. This year's draft will be loaded into the history when you run Generate History the following year.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Thank you for this post:
firstbigweekend (05-15-2012)
Old 05-15-2012, 06:10 PM   #26
mikev
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 4,014
Thanks: 0
Thanked 29x in 23 posts
Sounds good.

You are a true asset to online leagues.
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 05-16-2012, 10:57 AM   #27
mad0die
All Star Reserve
 
mad0die's Avatar
 
Join Date: Feb 2002
Location: TX
Posts: 909
Thanks: 13
Thanked 18x in 14 posts
Thank you very much, Getch. We love your utility and appreciate your efforts!
__________________
Commish GUBA
mad0die is offline   Reply With Quote
Old 05-25-2012, 12:18 AM   #28
Isryion
Major Leagues
 
Join Date: Oct 2011
Posts: 318
Thanks: 16
Thanked 52x in 37 posts
Hi all,

I'm a new user to this and am trying to set it up for a league I'll be starting. I think I've got things mostly taken care of, but I need some help with the .csv files (how to create them, which ones I need to move, etc...). If anyone can point me in the right direction that would be great as they're not in the readme as of yet.

EDIT: For informational purposes, I did create .csv files for the league and I moved them into the csv folder in my bin. However, in the setup, I still get the message that the directory exists but does not contain leagues .csv.

Thanks in advance for any help.

Last edited by Isryion; 05-25-2012 at 12:22 AM.
Isryion is offline   Reply With Quote
Old 05-25-2012, 11:16 AM   #29
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by Isryion View Post
Hi all,

I'm a new user to this and am trying to set it up for a league I'll be starting. I think I've got things mostly taken care of, but I need some help with the .csv files (how to create them, which ones I need to move, etc...). If anyone can point me in the right direction that would be great as they're not in the readme as of yet.

EDIT: For informational purposes, I did create .csv files for the league and I moved them into the csv folder in my bin. However, in the setup, I still get the message that the directory exists but does not contain leagues .csv.

Thanks in advance for any help.
PM me your site, and I can take a look.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Thank you for this post:
Isryion (05-25-2012)
Old 05-25-2012, 07:49 PM   #30
Isryion
Major Leagues
 
Join Date: Oct 2011
Posts: 318
Thanks: 16
Thanked 52x in 37 posts
Much thanks to Getch for getting me squared away. My next question, after reading the comments on the draft tool is are these tools easily usable in an inaugural draft with a budget? Is there anything I should be aware of going in, or should I use a different format like a forum?

I ask because I've done drafts in this toolset before but never an inaugural draft. Thanks for any input.
Isryion is offline   Reply With Quote
Old 05-30-2012, 12:17 PM   #31
mikev
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 4,014
Thanks: 0
Thanked 29x in 23 posts
Hey Getch, seeing this error when trying to enable All Star voting:

Quote:
Error Occurred!
Could not open asField1.html at OOTPOU/ASAdmin.pm line 568.
Any suggestions?
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 05-30-2012, 07:14 PM   #32
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by mikev View Post
Hey Getch, seeing this error when trying to enable All Star voting:
Manually make the OOTPOU/allstar directory. Looks like I forgot to make that directory in the code. Before I had shipped that directory as part of OOTPOU, must have gotten lost in the upgrade to 13.

Quote:
...after reading the comments on the draft tool is are these tools easily usable in an inaugural draft with a budget? Is there anything I should be aware of going in, or should I use a different format like a forum?
An inaugural draft not currently supported, although it probably wouldn't take much to extend it to one (it supported it way back in OOTP 9 days or so). Maybe in a later patch?

Also, in general, real life got a bit overwhelming of late, so that's why I never got to the draft import and a few other things. It'll should settle down soon.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 05-30-2012, 08:08 PM   #33
mikev
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 4,014
Thanks: 0
Thanked 29x in 23 posts
Quote:
Originally Posted by Getch View Post
Manually make the OOTPOU/allstar directory. Looks like I forgot to make that directory in the code. Before I had shipped that directory as part of OOTPOU, must have gotten lost in the upgrade to 13.
Fixed! Thanks again
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 06-09-2012, 12:17 PM   #34
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
I wanted to make a feature request. Can we get sortable columns in the awards voting area?
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 06-10-2012, 04:22 AM   #35
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
FYI there seems to be some type of bug in the metrics that determine rookie eligibility. I have a guy that clearly shows as rookie eligible in game that was not placed on the ROY ballot even though he had a 40.9 VORP played in 148 games with 600 plate appearances and probably should be the ROY winner.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 06-11-2012, 04:13 PM   #36
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
I wanted to make a feature request. Can we get sortable columns in the awards voting area?
I'll put it on the list, but I got bigger fish to fry first. Unfortunately, it's not as simple as it sounds.

Quote:
Originally Posted by dangarion View Post
FYI there seems to be some type of bug in the metrics that determine rookie eligibility. I have a guy that clearly shows as rookie eligible in game that was not placed on the ROY ballot even though he had a 40.9 VORP played in 148 games with 600 plate appearances and probably should be the ROY winner.
Can you link him? OOTP in fact determines rookie eligibility incorrectly. I believe it only uses service time, and the player must have under 45 days of service time to be considered a rookie. Note that the 45 days includes time as a September callup (which it shouldn't). In general, OOTP usually causes people to lose the rookie eligibility too quickly, not the other way around.

There could be a bug in my code somewhere too, I use stats (less than 130 AB's and 50 IP's I think.... I forget the #'s exactly), and ignore service time, due to the fact that OOTP does not track non-September service time. I rather be too inclusive than too restrictive when it comes to rookie eligibility.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 06-11-2012, 04:25 PM   #37
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Thanks! I know that stat sorting isn't simple usually it's done with java or ajax in other applications I've used, but personally have never implemented it in things I've made because of the lack of ease to doing it.

As for the player not on the list it's actually Mike Trout.

Player Report for #27 Mike Trout

In game he's showing on the rookie stats (even in real life right now he is rookie eligible).

Quote:
Originally Posted by Getch View Post
I'll put it on the list, but I got bigger fish to fry first. Unfortunately, it's not as simple as it sounds.



Can you link him? OOTP in fact determines rookie eligibility incorrectly. I believe it only uses service time, and the player must have under 45 days of service time to be considered a rookie. Note that the 45 days includes time as a September callup (which it shouldn't). In general, OOTP usually causes people to lose the rookie eligibility too quickly, not the other way around.

There could be a bug in my code somewhere too, I use stats (less than 130 AB's and 50 IP's I think.... I forget the #'s exactly), and ignore service time, due to the fact that OOTP does not track non-September service time. I rather be too inclusive than too restrictive when it comes to rookie eligibility.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 06-12-2012, 04:38 PM   #38
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by dangarion View Post
In game he's showing on the rookie stats (even in real life right now he is rookie eligible).
Looks like there is a bug. I have the max AB's at 100, but it should be 130. That caused him to fall of the ballot.

Change the line in AWAdmin:

if ($self->{stats}->{$id}->{TAB} < 100) {

to

if ($self->{stats}->{$id}->{TAB} < 130) {

To fix. I'll have it fixed in the next update. Thanks for finding this.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Thank you for this post:
dangarion (06-12-2012)
Old 06-12-2012, 05:38 PM   #39
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Quote:
Originally Posted by Getch View Post
Looks like there is a bug. I have the max AB's at 100, but it should be 130. That caused him to fall of the ballot.

Change the line in AWAdmin:

if ($self->{stats}->{$id}->{TAB} < 100) {

to

if ($self->{stats}->{$id}->{TAB} < 130) {

To fix. I'll have it fixed in the next update. Thanks for finding this.
Perfect. Thanks!
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 06-12-2012, 06:01 PM   #40
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Is there a way to specifically reset one persons' votes in Award voting?
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

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 09:53 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

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 © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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