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 10-20-2011, 07:12 PM   #41
mjdoom
Minors (Rookie Ball)
 
mjdoom's Avatar
 
Join Date: May 2007
Posts: 37
Quote:
Originally Posted by Getch View Post
Don't change the scale in the Admin, or else you'll severely mess up your development.

There's nothing currently you can really do about it. One of the enhancements I might do for that graph is allow you to specify what attributes you want to see, which would solve this. Maybe I can throw in a scaling factor too... that shouldn't be too hard.

But for now, you'll have to deal with it.
Ok, thanks.
mjdoom is offline   Reply With Quote
Old 10-24-2011, 12:43 AM   #42
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,917
Question about the draft, since you can apparently only have 30 picks per round, what do you do about compensation picks? My league has 34 picks in the first round and then 10 picks in the supplemental round and so on. Is the best way to have the original draft order loaded in the order.txt file and then do trades to make sure each team is drafting in the right place?
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote
Old 10-24-2011, 11:45 AM   #43
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by molarmite View Post
Question about the draft, since you can apparently only have 30 picks per round, what do you do about compensation picks? My league has 34 picks in the first round and then 10 picks in the supplemental round and so on. Is the best way to have the original draft order loaded in the order.txt file and then do trades to make sure each team is drafting in the right place?
Yeah, this is one of the things I gotta do in the draft to make it better in the next release.

The way we handle it now in one of my leagues is you generate the normal draft order as if there were no additional picks/supplemental picks. After OU generates all of the rounds, then manually edit the OOTPOU/draft/<league>/<year>/picks.txt file and insert the picks where they should go (the format is BOS-BOS, which is team the pick originally belonged to and the current team that owns it, if I recall). You'll get the pick order right, but the draft round headers will be off (which is purely cosmetic).

Yes, this is pooptastic (it was written for OOTP before it supported supplimental picks), and one of the many things that will be improved shortly.
__________________
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; 10-24-2011 at 11:46 AM.
Getch is offline   Reply With Quote
Old 10-24-2011, 11:48 AM   #44
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by mjdoom View Post
I just updated our reports and the new graph for development is having a bit of an issue with how our league does things and I'm not sure if there is a good way to deal with it. We have our actual ratings scale from 1-100 and our potential scale from 1-10. This causes the potential to get squished at the bottom of the chart.

Is there any good way to deal with this or do I just need to set them both to the same scale in the admin screen so that they both show up on the same scale?
Just FYI, I've added a scaling feature so you can scale the 1-10 talents to 1-100 in the graphs. It'll be released in the next few days with a few other maintenance fixes (not the draft util update release).
__________________
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 10-24-2011, 01:01 PM   #45
molarmite
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,917
Quote:
Originally Posted by Getch View Post
Yeah, this is one of the things I gotta do in the draft to make it better in the next release.

The way we handle it now in one of my leagues is you generate the normal draft order as if there were no additional picks/supplemental picks. After OU generates all of the rounds, then manually edit the OOTPOU/draft/<league>/<year>/picks.txt file and insert the picks where they should go (the format is BOS-BOS, which is team the pick originally belonged to and the current team that owns it, if I recall). You'll get the pick order right, but the draft round headers will be off (which is purely cosmetic).

Yes, this is pooptastic (it was written for OOTP before it supported supplimental picks), and one of the many things that will be improved shortly.
Sounds good, thanks. Another question, is there plans to make the user auto-pick if the time runs up or is that too complicated?
__________________
From the wise mind of Davey Eckstein

"Now all you need is a signature. A quote or initial, perhaps."


[
molarmite is offline   Reply With Quote
Old 10-24-2011, 01:40 PM   #46
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by molarmite View Post
Sounds good, thanks. Another question, is there plans to make the user auto-pick if the time runs up or is that too complicated?
At the very least, I will do what StatsLab did, which is auto-pick if anyone accesses the draft page after the pick is due. To do a "true" auto-pick, meaning picking even if no one is accessing the page, may be a long shot. One way is to put a thread to sleep for X hours, but most likely I'd expect the web hosts to kill such a thread if it detected it.
__________________
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 10-26-2011, 10:52 PM   #47
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
OOTP OU 4.0.2c released. Just some minor updates:

1. Added the ability to scale talent in the graphs (option in Development->Admin screen). This is for leagues who have a very different talent scale from ratings, and the graph becomes scrunched for one of the scales.
2. Added option to ignore development of retired players (Development->Admin screen). I'm not sure why you want to leave this on, but up until now OU tracked retired players. The main point of this feature is to cut down on memory usage by OU, for those who have server limits on memory usage. By default it is on, for backwards compatibility.
3. Added the player development panel to the individual player development reports
4. Fixed the various Admin screens for multi-league universes
5. Fixed the Playoff Odds report
6. Minor fixes to the Gamecast play-by-play

Remember to go to the Admin tab and click the Generate UI Files button after unzipping the patch.

Hopefully this clears off all the minor maintenance fixes and the next release will be a redone Draft utility.
__________________
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; 10-26-2011 at 10:57 PM.
Getch is offline   Reply With Quote
Old 10-30-2011, 10:19 AM   #48
uabfan
Minors (Single A)
 
Join Date: Jul 2010
Location: Nashville, TN
Posts: 79
Hi, Getch! Really like the tool. My online league (MBWBA) just swapped over from StatsLab due to problems w/ v12 and the Dev report is miles better.

I do have a request for what I see is a glaring omission (not that you overlooked it, it just may have never climbed on the priority list): stats. What sports fans in the world loves stats more than baseball fans? In this area I think OOTPOU is severely lacking...as in, "I can't believe the tool has access to the database and this is all we get" lacking.

Just an example, on StatsLab I could see a stats page exactly like the "Sim Statistics" page in OOTPOU. But I could alter the date window to look at any time period I liked (i.e., not just the last sim and not just the default splits). This could be done at the team level, too, so I could see at a glance the impact of a trade I made on 4/25.

A few other stats-related stuff I'm having withdrawals over:

  • A way to view all of the game logs for a player. All I can see in OOTPOU is the last 10 games which is what's available in OOTP. This was invaluable to me in analyzing whether my pitchers performed better as starters or relievers.
  • More robust team stats. I loved that in StatsLab I could see runs scored per game and runs allowed per game broken down by innings. So I knew if my team was constantly getting off on the wrong foot, if the backend of my bullpen was failing, or if I needed to beef up middle relief or tell my manager to hook starters quicker.
  • The ability to dig as deep as I want into player stats. Ok, I cheated a bit here as there was a limit to what you could do in StatsLab. But with the data being there I don't see why I can't see a pitcher's stats per inning over the season, for instance. For batter's I can see how they performed in every spot they've occupied in the lineup and with every count.
In short, it seems like OOTPOU threw in the stats page for the last sim, but then left anything beyond that to just provided the same reports/screens that users can get in the client. We are stats junkies, man...give us our fix!

uabfan is offline   Reply With Quote
Old 10-31-2011, 12:25 PM   #49
MikeyB
Minors (Double A)
 
MikeyB's Avatar
 
Join Date: Jun 2010
Location: Calgary, AB
Posts: 118
Just to confirm, is the Draft Timer set-up as a rolling timer? IOW once one team picks, does the team behind them have their timer start immediately?
__________________
BML Commish
www.ootp-bml.com
MikeyB is offline   Reply With Quote
Old 10-31-2011, 02:38 PM   #50
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by uabfan View Post
I do have a request for what I see is a glaring omission (not that you overlooked it, it just may have never climbed on the priority list): stats.
Thanks for the feedback. And seriously, everyone give their feedback, I am listening. As for my response, I have two points:

1. I haven't gotten to reworking the Last Sim utility or really anything you mentioned yet. As I stated in the first post, I'm redoing these utilities one utility at a time. So far, I've only touched the Development utility, and added in the Gamecast/Live Sim. I'm now working on the Draft utility, and it'll be a few weeks before I finish it off. So, enhancing the statistical engine is on my radar, and I hope to implement some of what you said. Which brings me to...

2. I can't do everything that StatsLab did. SL had a database behind it, I have the csv files. Databases are far superior for doing some of the complex queries, with how indexing and the querying works. I don't have any indexes, so any query involves parsing each file in full, meaning it may not perform well.

That's not to say I can't expand upon what OU offers. But adding conditions to the query like "where inning is between 5 and 7 and the count is 1-2" is relatively simple with databases, but much harder with csv files. Doable, but a lot of work.

Quote:
Just to confirm, is the Draft Timer set-up as a rolling timer? IOW once one team picks, does the team behind them have their timer start immediately?
Correct.
__________________
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 10-31-2011, 02:49 PM   #51
MikeyB
Minors (Double A)
 
MikeyB's Avatar
 
Join Date: Jun 2010
Location: Calgary, AB
Posts: 118
Thanks Getch!
__________________
BML Commish
www.ootp-bml.com
MikeyB is offline   Reply With Quote
Old 10-31-2011, 09:25 PM   #52
MikeyB
Minors (Double A)
 
MikeyB's Avatar
 
Join Date: Jun 2010
Location: Calgary, AB
Posts: 118
Quote:
Originally Posted by Getch View Post
Yeah, this is one of the things I gotta do in the draft to make it better in the next release.

The way we handle it now in one of my leagues is you generate the normal draft order as if there were no additional picks/supplemental picks. After OU generates all of the rounds, then manually edit the OOTPOU/draft/<league>/<year>/picks.txt file and insert the picks where they should go (the format is BOS-BOS, which is team the pick originally belonged to and the current team that owns it, if I recall). You'll get the pick order right, but the draft round headers will be off (which is purely cosmetic).

Yes, this is pooptastic (it was written for OOTP before it supported supplimental picks), and one of the many things that will be improved shortly.
I'm attempting this but my changes won't stick. I download the picks.txt, edit it and load it back up. The changes never stick and the additional picks never get added. Is there something else I'm missing here???
__________________
BML Commish
www.ootp-bml.com
MikeyB is offline   Reply With Quote
Old 11-01-2011, 09:12 AM   #53
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by MikeyB View Post
I'm attempting this but my changes won't stick. I download the picks.txt, edit it and load it back up. The changes never stick and the additional picks never get added. Is there something else I'm missing here???
The picks.txt file is THE source of truth for OU. Unless you regenerate or reset the draft, OU doesn't get its pick order from anywhere else, nor does it rebuild it at any point.

More likely is that you are uploading to the wrong directory, or your upload isn't actually overwriting the file. Try deleting the file first, go into OU and make sure that it clears out the draft, and then upload the picks.txt.
__________________
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 11-01-2011, 09:58 AM   #54
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,805
Quote:
Originally Posted by Getch View Post
OOTP OU 4.0.2c released. Just some minor updates:

1. Added the ability to scale talent in the graphs (option in Development->Admin screen). This is for leagues who have a very different talent scale from ratings, and the graph becomes scrunched for one of the scales.
2. Added option to ignore development of retired players (Development->Admin screen). I'm not sure why you want to leave this on, but up until now OU tracked retired players. The main point of this feature is to cut down on memory usage by OU, for those who have server limits on memory usage. By default it is on, for backwards compatibility.
3. Added the player development panel to the individual player development reports
4. Fixed the various Admin screens for multi-league universes
5. Fixed the Playoff Odds report
6. Minor fixes to the Gamecast play-by-play

Remember to go to the Admin tab and click the Generate UI Files button after unzipping the patch.

Hopefully this clears off all the minor maintenance fixes and the next release will be a redone Draft utility.
Getch-

I'm not seeing any new features for multiple leagues. Probably user error, but if you could point me in the right direction I'd appreciate it.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 11-01-2011, 10:47 AM   #55
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by Recte44 View Post
Getch-

I'm not seeing any new features for multiple leagues. Probably user error, but if you could point me in the right direction I'd appreciate it.
Each utility's Admin screen (except Last Sim, which always works across all leagues) has an added dropdown at the top which states which league you are administering. For all other screens, the user's will log into the league that they belong to, and see OU for that league.

I didn't write any new code for this, I just made sure the code that was there from before worked after my rewrite (I used your csv's to test, so I know it works). If you see anything that needs fixing or needs to be enhanced, let me know. The multi-league support hasn't been used by a lot of leagues, so I'd suspect there will be room for improvement.
__________________
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 11-01-2011, 11:23 AM   #56
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,805
Hmmm. I updated using the "Last Patch" link in your signature, but not seeing that anywhere.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 11-01-2011, 11:29 AM   #57
ootpFox07
All Star Starter
 
ootpFox07's Avatar
 
Join Date: Dec 2005
Posts: 1,679
Quote:
Originally Posted by Getch View Post
2. I can't do everything that StatsLab did. SL had a database behind it, I have the csv files. Databases are far superior for doing some of the complex queries, with how indexing and the querying works. I don't have any indexes, so any query involves parsing each file in full, meaning it may not perform well.
Come to the dark side and use the databases. Have you looked at Perl->DB? I used to use that with oracle in my Perl days and it was a nice lib.
__________________
My OOTP Gaming Channels:
My OOTP Mods:
ootpFox07 is offline   Reply With Quote
Old 11-01-2011, 02:50 PM   #58
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,805
Ok, I see a drop down in the draft section. Pretty neat stuff, Getch!
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 11-01-2011, 04:28 PM   #59
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by DesertFox07 View Post
Come to the dark side and use the databases. Have you looked at Perl->DB? I used to use that with oracle in my Perl days and it was a nice lib.
I work for a database company, I know all about them . There's a lot of overhead and setup involved with a DB that I didn't want to get involved with. OU was meant to be an easy to use, lightweight utility. Forcing people with little computer background to deal with a DB can make it frustrating on them (hell, they can be frustrating with a lot of computer background)

Anyway, I'm not rewriting OU for DB support. Way too much work.
__________________
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 11-01-2011, 10:59 PM   #60
MikeyB
Minors (Double A)
 
MikeyB's Avatar
 
Join Date: Jun 2010
Location: Calgary, AB
Posts: 118
Quote:
Originally Posted by Getch View Post
The picks.txt file is THE source of truth for OU. Unless you regenerate or reset the draft, OU doesn't get its pick order from anywhere else, nor does it rebuild it at any point.

More likely is that you are uploading to the wrong directory, or your upload isn't actually overwriting the file. Try deleting the file first, go into OU and make sure that it clears out the draft, and then upload the picks.txt.
I got it, thanks again Getch.
__________________
BML Commish
www.ootp-bml.com
MikeyB 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 06:38 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