Home | Webstore
Latest News: OOTP Update 20.6 - OOTP 20 Available - FHM 5 Available

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > 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-07-2012, 11:14 PM   #1
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Online Utilities (OU) for OOTP 13

OU is released for OOTP 19. Get the the OOTP 19 version here. Readme is here.

Prior versions of OU are still available on request.

The latest version for OOTP 19 is 10.0.1, released on 5/24/2018.
The latest version for OOTP 17/18 is 9.0.1, released on 4/3/2016.

For those of you who are new to OU, it provides the following utilities for an online league:

- Allstar/Awards/Hall of Fame Voting
- Draft
- Export Tracker
- Gamecast
- Last Sim
- Live Sim
- Managers
- Stats

The readme linked above has full instructions for installation, configuration, and running OU.

Last, but not least, this version was a lot of work, much more than I first thought would be needed. If you want to see even more features, the best way to see them come to fruition is to donate using the Donate link at the bottom of every page. Nothing gets me more motivated than a good old "Thank You", and the donate link is the best way to say Thank You. I have at least 3 big features left to do, and if you want to see them in your own leagues, donate!

As always, let me know if you have any issues, questions, etc. Hope everyone enjoys it!

Older versions:

OOTP 17/18 (9.0.1)

Older versions available by request.
__________________
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; 07-15-2018 at 10:35 AM.
Getch is offline   Reply With Quote
14 thanks for this post:
bp_ (01-12-2013), bulldog55 (06-22-2012), cheesestring (07-08-2015), dangarion (05-23-2012), goldfinger77 (05-09-2012), Kaaosaste (09-18-2012), Killebrew (05-08-2012), knudlen (05-15-2012), kq76 (05-08-2012), NeuroticTruth (04-07-2016), rutri01 (09-01-2012), sdodd (05-09-2012), soadeathdealer (05-06-2013), Spindel (06-16-2012)
Old 05-08-2012, 12:15 AM   #2
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,025
Thanks: 475
Thanked 366x in 306 posts
Thank u ill set it up this week

Sent from my DROID X2 using Tapatalk
__________________
Jerseys and caps/logos and more
http://s39.photobucket.com/albums/e1...%20and%20caps/


Leagues


POTD: Vermont/Co-Commish: http://potd.ca/
MTBL: Atlanta Braves(Commish): http://mtblcentral.ca/mtblca/
The Show: Jacksonville Bombers/Commish: theshow.ootpleagues.com
RFTP : Braves/co-commish: League Closed
HRBL: Commish: League Closed
soadeathdealer is offline   Reply With Quote
Old 05-08-2012, 01:53 PM   #3
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
One thing I forgot to test was a multi-league setup. If any OOTP 13 leagues are set up this way, if you could PM me and send me your csv files, I'll do a quick sanity check.

It should still work, but I probably need to minor update the UI of the league selector to fit with the new look-and-feel.
__________________
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-08-2012, 03:54 PM   #4
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
Getch, if I can pick your brain on the config, that would be very helpful -- the website setup I have is a little unique so I'm not 100% certain I'm getting the path correctly for HTML reports and export directory.

Alternatively, will the utility recognize if I use full paths?

Strangely enough I am getting the background image, but I'm also getting the errors for HTML reports and Export directories.
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 05-08-2012, 04:00 PM   #5
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, also, it looks like the league logo is still hard coded to be apbl.png
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 05-08-2012, 05:05 PM   #6
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
Getch, if I can pick your brain on the config, that would be very helpful -- the website setup I have is a little unique so I'm not 100% certain I'm getting the path correctly for HTML reports and export directory.

Alternatively, will the utility recognize if I use full paths?

Strangely enough I am getting the background image, but I'm also getting the errors for HTML reports and Export directories.
Full paths are fine. Looking at your site, it actually just looks like you need to click Generate UI Files in the Admin screen.
Quote:
oh, also, it looks like the league logo is still hard coded to be apbl.png
Fudgenuts.
__________________
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-08-2012 at 07:54 PM.
Getch is offline   Reply With Quote
Old 05-09-2012, 11:23 AM   #7
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
actually... I just figured it out. Forgot that I had a symlink to cgi-bin so that threw off the path to HTML reports.

Where does it read the exports directory relative to?
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM

Last edited by mikev; 05-09-2012 at 11:30 AM.
mikev is offline   Reply With Quote
Old 05-09-2012, 02:17 PM   #8
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
actually... I just figured it out. Forgot that I had a symlink to cgi-bin so that threw off the path to HTML reports.

Where does it read the exports directory relative to?
Relative to the location of OU. This is actually in the little bit of the readme I've written

Let me know if you league has any issues with implementing. I'll release a quick patch with the any fixes needed, and the league banner (and some other odds-and-ends) which I've already fixed.

One more thing... when exporting the csv's in OOTP, check the option to replace the foreign characters with alphanumeric characters (I forget exactly what the option is called). This will fix all the garbage characters you see in like the draft and development reports.
__________________
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-09-2012 at 02:30 PM.
Getch is offline   Reply With Quote
Old 05-09-2012, 02:42 PM   #9
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
Cool -- looks like I got the exports figured out as well.

aside from the league logo, all seems to be working! Awesome.
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM

Last edited by mikev; 05-09-2012 at 02:47 PM.
mikev is offline   Reply With Quote
Old 05-09-2012, 03:06 PM   #10
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
In 13, the checkbox simply says "Replace Accents" in the Tools - Configure data export to CSV files menu.

Just FYI in case someone else looks for it.
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 05-09-2012, 08:32 PM   #11
goldfinger77
Minors (Double A)
 
goldfinger77's Avatar
 
Join Date: Dec 2004
Posts: 160
Thanks: 5
Thanked 1x in 1 post
By the way, Getch - the utility looks amazing. The draft function is slick as hell, and development is beautiful.
goldfinger77 is offline   Reply With Quote
Old 05-09-2012, 10:31 PM   #12
sdodd
Major Leagues
 
sdodd's Avatar
 
Join Date: Jan 2011
Posts: 332
Thanks: 54
Thanked 67x in 31 posts
I upgraded from a previous installation, now I am unable to login. All I get is "Invalid Login". When I installed it, I went into my profile and even set a new password, then saved it, but I still get the invalid login. Any help is appreciated
sdodd is offline   Reply With Quote
Old 05-09-2012, 10:56 PM   #13
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by sdodd35@yahoo.com View Post
I upgraded from a previous installation, now I am unable to login. All I get is "Invalid Login". When I installed it, I went into my profile and even set a new password, then saved it, but I still get the invalid login. Any help is appreciated
Does "baseball" work? It is the default password. Otherwise, PM me your site info.
__________________
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-10-2012, 10:09 PM   #14
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Posted a minor update, version 5.0.3. Bugs fixed:

- No/wrong logo appearing in the title bar
- Editing prior picks in the draft doesn't work
- Minor cosmetic issues

Just unzip the latest file where OU is installed and you're good to go.
__________________
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 (05-23-2012)
Old 05-11-2012, 05:47 PM   #15
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
THANK YOU! We just started out league, this will make things easier, I was getting by with the previous version.
dangarion is offline   Reply With Quote
Old 05-11-2012, 07:48 PM   #16
sdodd
Major Leagues
 
sdodd's Avatar
 
Join Date: Jan 2011
Posts: 332
Thanks: 54
Thanked 67x in 31 posts
Quote:
Originally Posted by Getch View Post
Does "baseball" work? It is the default password. Otherwise, PM me your site info.

No baseball doesn't work. I'm going to try a fresh install and see what happens
sdodd is offline   Reply With Quote
Old 05-11-2012, 08:26 PM   #17
sdodd
Major Leagues
 
sdodd's Avatar
 
Join Date: Jan 2011
Posts: 332
Thanks: 54
Thanked 67x in 31 posts
Ok.. did a fresh install and all is good again
sdodd is offline   Reply With Quote
Old 05-14-2012, 10:13 PM   #18
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
Getch -- we're not getting any stats or team stats in the Last Sim page. Link for ya:

Sim Results

What do you need from me?
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 05-14-2012, 11:37 PM   #19
mddst34
Bat Boy
 
Join Date: Mar 2007
Posts: 3
Thanks: 0
Thanked 0x in 0 posts
Thanks for the utility. Super useful.

Question:

When creating an import from the draft utility, does it create a new draft.csv file to import? I am asking because it does not seem to be creating any new file . Thanks!

Edit: I created my own draft.csv with some vi and python foo, but I'd like to know what the create import uses and then ultimately produces.

Last edited by mddst34; 05-15-2012 at 12:41 AM. Reason: Solved, Kind of....
mddst34 is offline   Reply With Quote
Old 05-15-2012, 09:52 AM   #20
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
Getch -- we're not getting any stats or team stats in the Last Sim page. Link for ya:

Sim Results

What do you need from me?
Weird. Zip up the csv files and put them in a place on your server I can download them.

Quote:
When creating an import from the draft utility, does it create a new draft.csv file to import? I am asking because it does not seem to be creating any new file . Thanks!

Edit: I created my own draft.csv with some vi and python foo, but I'd like to know what the create import uses and then ultimately produces.
Ah yes, I meant to write a small blurb on the draft import/export in the original post. Here's the full story:

In OOTP 13, Markus added the ability to import and export the draft from the game. In theory, you should be able to export the draft order into OU, run the draft, and then when it is done, import it back to the game.

However, it's not quite that simple. In the new version, OU will allow you to import the draft order from OOTP (this is the draft.csv that the game generates). The only caveat here is that if you import the draft this way, you will lose the history of any traded picks... meaning, if team A traded a pick to team B, you will no longer see "Team B (from Team A)" in the draft utility. If you don't allow traded picks, then you don't need to worry about this. If you do allow traded picks, and you want to preserve this history, then generate the draft the old way, by setting the order in OU and clicking generate.

However, OU does *not* support importing the draft back into OOTP when it is done. The issue here is with how Markus implemented it: The entire draft has to be imported... you cannot just import the first 3 rounds and let OOTP automate the rest. If you only import the first 3 rounds, then the draft lasts only 3 rounds and all the other players are tossed into the FA pool.

We tried to get Markus to change this, but he didn't have the time (this was one of the features I was hoping would be in the first patch). I didn't want to implement something that could possibly cause an entire draft to go haywire if not done just perfectly. If Markus fixes this in the future, I will add in an import-back-to-game option.

Let me know if that makes sense.
__________________
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
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 05:37 AM.

 

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