Home | Webstore
Latest News: OOTP Update 20.8 - OOTP 20 Available - FHM 6 Available

Offseason Discount! SAVE 50%!

  

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 06-12-2012, 06:30 PM   #41
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 dangarion View Post
Is there a way to specifically reset one persons' votes in Award voting?
I went in there and did it by hand. If you change the voting settings in the middle of the voting it causes votes to go on the wrong ballots.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 06-15-2012, 08:27 PM   #42
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Another suggestion, could we maybe build in some more options for HoF ballots. Would like to see some more stat options so we can make sure the amazing fielders, stealers, and relievers have a chance to be voted on.
And maybe a vote limit? Where you can enable a limit to the amount of votes someone is able to make for HoF.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!

Last edited by dangarion; 06-16-2012 at 03:27 PM.
dangarion is offline   Reply With Quote
Old 06-16-2012, 11:27 PM   #43
Spindel
All Star Reserve
 
Spindel's Avatar
 
Join Date: Oct 2003
Location: Lambertville, NJ
Posts: 728
Thanks: 99
Thanked 306x in 138 posts
I'm trying to set this up, but some of the pages on getch's site seem to be down. I'm looking for a list of the .csv files needed to get it to work with 13. Any help?
__________________
Union League Baseball Commissioner since 2011.
Spindel is offline   Reply With Quote
Old 06-17-2012, 02:16 PM   #44
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 Spindel View Post
I'm trying to set this up, but some of the pages on getch's site seem to be down. I'm looking for a list of the .csv files needed to get it to work with 13. Any help?
I think it's pretty much the same ones as in the last version.


Each utility requires its own .csv files. These are all the .csv files that are required by any utilities, and which utility requires it. AS = Allstar, DE = Development, DR= Draft, EX = Export, LS = Last Sim, MA = Manager, All = All.
• divisions.csv (EX)
• games.csv (LS)
• games_score (LS)
• human_managers (All)
• leagues (All)
• league_history (DE)
• players (AS, DE)
• players_batting (DE, DR)
• players_career_batting_stats (AS, LS)
• players_career_fielding_stats (AS)
• players_career_pitching_stats (AS, LS)
• player_fielding (DE, DR)
• players_game_batting (LS)
• players_game_pitching (LS)
• player_pitching (DE, DR)
• sub_leagues (AS, EX)
• teams (All)
team_relations (EX)
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 06-17-2012, 02:19 PM   #45
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by Spindel View Post
I'm trying to set this up, but some of the pages on getch's site seem to be down. I'm looking for a list of the .csv files needed to get it to work with 13. Any help?
leagues_basic
league_history
sub_leagues
divisions
team_relations
games_basic
games_score
human_managers_basic
players_basic
players_batting
players_pitching
players_fielding
players_player_value
players_career_batting
players_game_batting
players_career_pitching
players_game_pitching
players_career_fielding
players_awards
teams_basic
teams_financials
team_history_record
__________________
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-23-2012, 12:34 AM   #46
bulldog55
Hall Of Famer
 
bulldog55's Avatar
 
Join Date: Sep 2002
Location: California's Canada Warnings: 17
Posts: 2,396
Thanks: 86
Thanked 165x in 94 posts
Thanks for updating these! My leagues were going to be without utilities this year so you really saved us.

I set up Hall of Fame voting and there's no space between stats - the numbers all run together and it's extremely difficult to read. Is that how it's supposed to look or is it something on my end? Better yet, do you know how to fix it?

Hall of Fame Voting (none of the owners have set up their password so you should be able to log in as anyone except S. Raymond Jeffers.)
__________________
Being smart, don't always make you popular.

Trans-Continental Base Ball Association (est. 1870)
bulldog55 is offline   Reply With Quote
Old 06-25-2012, 08:39 PM   #47
PDHitman
Minors (Triple A)
 
PDHitman's Avatar
 
Join Date: Mar 2008
Location: Fernandina Beach, FL
Posts: 281
Thanks: 2
Thanked 12x in 10 posts
I am willing to paypal someone $20 if they can set up the OOTP OU for our online OOTP 13 league. I am terrible at web/ftp stuff (it was a miracle to get the online part working....all thanks to Fidel Montoya). Please email me at pcdawson2 at yahoooooo.

Paul
Wildthings2 league
__________________
____________________

Paul
RDBL Commish/Baltimore
RDBL Website

"A nickel ain't worth a dime anymore." -Yogi
PDHitman is offline   Reply With Quote
Old 06-26-2012, 10:44 AM   #48
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,627
Thanks: 256
Thanked 176x in 104 posts
Getch's website is down, uh oh.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 06-26-2012, 05:19 PM   #49
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by Recte44 View Post
Getch's website is down, uh oh.
Couldn't afford it from my paypal account .

J/K, it's back now. Someone must have tripped over the cord.
__________________
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-26-2012, 06:27 PM   #50
thomamon
Global Moderator
 
thomamon's Avatar
 
Join Date: Sep 2003
Location: NJ
Posts: 5,273
Thanks: 37
Thanked 56x in 31 posts
Quote:
Originally Posted by Recte44 View Post
Getch's website is down, uh oh.
****, we better start donating, lol
__________________
Thomas A. Montalto
Please check out my Stupid Little Blog - http://www.stupidlittleblog.com
thomamon is offline   Reply With Quote
Old 06-26-2012, 08:11 PM   #51
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,627
Thanks: 256
Thanked 176x in 104 posts
Got it!
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)

Last edited by Recte44; 06-26-2012 at 08:18 PM.
Recte44 is offline   Reply With Quote
Old 06-26-2012, 11:16 PM   #52
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,351
Thanks: 69
Thanked 680x in 393 posts
Getch, is there any plans for widgets like Statslab has?

Since there's no 13 version of Statslab, those of use addicted to widgets would be so happy.
Cooleyvol is offline   Reply With Quote
Old 06-28-2012, 12:30 AM   #53
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Version 5.0.4 released This is just a bug fix update. Grab the latest OOTPOU.zip and install it over your existing installation. Bugs fixed:

- Fixed the Live Sim to work in OOTP 13 (the QA department has been fired over this one)
- Fixed the Allstar and Awards utilities to not error if the league is using a fresh install of OU in OOTP 13 (instead of upgrading OU from OOTP 12)
- Fixed the Allstar pitching page's column headers to not be mis-aligned
- Fixed a bug in Awards where sometimes votes were tallied for the wrong league
- Fixed the rookie AB eligibility in the Awards to be 130, not 100
- Fixed issues with setting the league's default skin. Also added a "league default" skin in the Profile page
- Fixed issues where some utilities would not work on certain web servers. The server was shutting OU process down due to too many innocuous warnings.

I also did a little work on the Readme, but still got a ways to go. We'll get there!
__________________
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-29-2012, 07:40 PM   #54
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
Getch,

I have 2 questions

1. I have a question on the import draft into OOTP13. I read the thread and wasnt sure if something was implemented that enabled that Import button to create an actual CSV file. Does that work or is that feature on hold?

2. I stumbled upon a situation where In OOTP13, within the draft screen, you have a certain number of draft eligbile players who you can draft (where you drag the player to the draft box). Well...My league is running a draft and someone was drafted in OOTPOU that is not on that draft list in OOTP13. The person was a HS Player. Weird...its like there are players that are not on the draft list in the game...but are available in OOTPOU to be drafted. I must be doing something wrong.
almo is offline   Reply With Quote
Old 06-29-2012, 08:02 PM   #55
thomamon
Global Moderator
 
thomamon's Avatar
 
Join Date: Sep 2003
Location: NJ
Posts: 5,273
Thanks: 37
Thanked 56x in 31 posts
Quote:
Originally Posted by almo View Post
Getch,

I have 2 questions

1. I have a question on the import draft into OOTP13. I read the thread and wasnt sure if something was implemented that enabled that Import button to create an actual CSV file. Does that work or is that feature on hold?

2. I stumbled upon a situation where In OOTP13, within the draft screen, you have a certain number of draft eligbile players who you can draft (where you drag the player to the draft box). Well...My league is running a draft and someone was drafted in OOTPOU that is not on that draft list in OOTP13. The person was a HS Player. Weird...its like there are players that are not on the draft list in the game...but are available in OOTPOU to be drafted. I must be doing something wrong.
Getch is on vacation for a couple weeks, so you may not hear from him for a while. I'll try and answer the best I can.

1. The draft utility is up in the air at the moment. Next patch should tell more.

2. Are you using feeder leagues? Sounds like you may have one of the ages set wrong in your setup!
__________________
Thomas A. Montalto
Please check out my Stupid Little Blog - http://www.stupidlittleblog.com
thomamon is offline   Reply With Quote
Old 06-29-2012, 08:28 PM   #56
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
Quote:
Originally Posted by thomamon View Post
Getch is on vacation for a couple weeks, so you may not hear from him for a while. I'll try and answer the best I can.

1. The draft utility is up in the air at the moment. Next patch should tell more.

2. Are you using feeder leagues? Sounds like you may have one of the ages set wrong in your setup!
We are indeed using feeders!!! I have it set to HS18 and Col 22
almo is offline   Reply With Quote
Old 06-29-2012, 08:30 PM   #57
thomamon
Global Moderator
 
thomamon's Avatar
 
Join Date: Sep 2003
Location: NJ
Posts: 5,273
Thanks: 37
Thanked 56x in 31 posts
Quote:
Originally Posted by almo View Post
We are indeed using feeders!!! I have it set to HS18 and Col 22
Try HS 19
__________________
Thomas A. Montalto
Please check out my Stupid Little Blog - http://www.stupidlittleblog.com
thomamon is offline   Reply With Quote
Thank you for this post:
almo (06-29-2012)
Old 06-29-2012, 08:39 PM   #58
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
Is there a limit on the coll age. I tinkered with 24.

Thanks for your quick reply though...its well appreciated!!
almo is offline   Reply With Quote
Old 06-29-2012, 08:42 PM   #59
thomamon
Global Moderator
 
thomamon's Avatar
 
Join Date: Sep 2003
Location: NJ
Posts: 5,273
Thanks: 37
Thanked 56x in 31 posts
Quote:
Originally Posted by almo View Post
Is there a limit on the coll age. I tinkered with 24.

Thanks for your quick reply though...its well appreciated!!
College is correct the way you had it
__________________
Thomas A. Montalto
Please check out my Stupid Little Blog - http://www.stupidlittleblog.com
thomamon is offline   Reply With Quote
Old 06-29-2012, 09:19 PM   #60
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
Thanks again!!
almo 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 10:44 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