Latest News: OOTP 13 Announced with Screenshots & Feature List! Pre-Order Now! - OOTP Baseball 12 Available! - iOOTP Baseball 2011 Available! - Title Bout Championship Boxing 2.5 released! - Inside the Park Baseball Patch 1.03 released, DEMO now available

Pre-Order OOTP 13, Save & Win! | OOTP 12 Off-Season Special, just $19.99!

Go Back   OOTP Developments Forums > Out of the Park Baseball 12 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
LinkBack Thread Tools Display Modes
Old 10-08-2009, 07:23 PM   #41 (permalink)
BMW
All Star Starter
 
BMW's Avatar
 
Join Date: May 2003
Location: New Jersey
Posts: 1,471
Thanks: 125
Thanked 491x in 204 posts
Quote:
Originally Posted by Getch View Post
I'll have to make some modifications for the next OOTP patch, so I will try to add these things as well to it. Been real busy with my newborn, sorry for the delay in response.
Getch,
If you need those files with the changes for the character conversion, send me your e-mail address. You may have to double check the changes, and it's possible it's just a less-than-optimal hack. I don't know PERL that well. But they are available if you need them.

Good luck with the newborn. My goodness, it gets easier a few months in after they start sleeping through the night. My daughter is nearly one year old now. I just bought her first baseball bat from Cooperstown this weekend.

Last edited by BMW; 10-08-2009 at 07:25 PM.
BMW is offline   Reply With Quote
Old 10-10-2009, 11:57 AM   #42 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Originally Posted by thickman1 View Post
I'm getting this error: Could not open awField0.html at OOTPOU/AWAdmin.pm line 606.

when I try to enable EOY awards voting...ideas?
Can you zip up your .csv files and send them to me or put them in a place I can download them.

awField0.html should be generated when you enable Awards voting. How many subleagues (AL, NL, etc) do you have in your league?
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 10-15-2009, 12:52 PM   #43 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
This is a big reminder to not run OOTPOU on the new OOTP Patch (coming today or tomorrow) until you get the OU patch (should be tonight).

The ratings in the csv files have changed, meaning if you run development on the new patch with an older version of OU, things will get out of synch.

I'll post when the OU patch is ready including upgrade instructions.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 10-15-2009, 01:19 PM   #44 (permalink)
Minors (Double A)
 
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
Thanks: 1
Thanked 0x in 0 posts
Does the draft utility handle an OOTP 10 draft that uses FA compensation draft picks (i.e. the supplemental picks).
thickman1 is offline   Reply With Quote
Old 10-16-2009, 11:06 PM   #45 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Originally Posted by thickman1 View Post
Does the draft utility handle an OOTP 10 draft that uses FA compensation draft picks (i.e. the supplemental picks).
It can. All you have to do is modify the OOTPOU/draft/<league>/<year>/picks.txt file and insert the supplimental picks. It won't say supplemental picks in the draft selections (and the round labels will be off), but it will work. I plan on making it look nicer soon.

Unrelated, but OU Patch to work with new OOTP patch coming tomorrow.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 10-17-2009, 01:39 PM   #46 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
OOTPOU Patch 3.1.2 is out. This patch should *ONLY* be used with the new OOTP X patch 4, and likewise, any league upgrading to Patch 4 *MUST* also upgrade to 3.1.2. Markus changed the csv files in the new patch.

There are no special upgrade steps needed, just unzip the OOTPOUPatch.zip file in the cgi-bin directory and you are good to go.

I had a few minor new features, but they will have to wait a bit. Didn't want to hold up people upgrading to the new patch.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
3 thanks for this post:
Mike1 (10-17-2009), Troy30 (10-19-2009), udbacker58 (10-17-2009)
Old 10-17-2009, 04:22 PM   #47 (permalink)
Minors (Triple A)
 
Join Date: Jan 2003
Posts: 209
Thanks: 2
Thanked 3x in 3 posts
Quote:
Originally Posted by Getch View Post
OOTPOU Patch 3.1.2 is out. This patch should *ONLY* be used with the new OOTP X patch 4, and likewise, any league upgrading to Patch 4 *MUST* also upgrade to 3.1.2. Markus changed the csv files in the new patch.

There are no special upgrade steps needed, just unzip the OOTPOUPatch.zip file in the cgi-bin directory and you are good to go.

I had a few minor new features, but they will have to wait a bit. Didn't want to hold up people upgrading to the new patch.
Thanks Getch! Had a sim last night and there were a couple discrepencies in developement that got noticed...this should take care of it.
__________________
Mike Dills
Mike1 is offline   Reply With Quote
Old 10-19-2009, 08:42 PM   #48 (permalink)
Minors (Triple A)
 
Troy30's Avatar
 
Join Date: Jan 2009
Posts: 226
Thanks: 51
Thanked 9x in 7 posts
Will there be another update from you for the newest patch ( the .30 one )

Thanks for your hard work!!
__________________
HBC Commish http://www.hardballchronicles.com/

Currently in the 1961 season.

Troy30 is offline   Reply With Quote
Old 10-20-2009, 03:00 PM   #49 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Originally Posted by Troy30 View Post
Will there be another update from you for the newest patch ( the .30 one )

Thanks for your hard work!!
There are no changes between .29 and .30 that affect OU, so you do not need a new version of OU or anything.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Thank you for this post:
Troy30 (10-24-2009)
Old 10-24-2009, 08:33 PM   #50 (permalink)
Minors (Triple A)
 
Troy30's Avatar
 
Join Date: Jan 2009
Posts: 226
Thanks: 51
Thanked 9x in 7 posts
Quote:
Originally Posted by Getch View Post
There are no changes between .29 and .30 that affect OU, so you do not need a new version of OU or anything.
Awesome man thanks.
__________________
HBC Commish http://www.hardballchronicles.com/

Currently in the 1961 season.

Troy30 is offline   Reply With Quote
Old 10-27-2009, 08:28 PM   #51 (permalink)
All Star Reserve
 
Join Date: Feb 2007
Posts: 891
Thanks: 7
Thanked 7x in 7 posts
Disregard. Wrong mod...
__________________
OOTP X Beta Team

Last edited by gollum65; 10-28-2009 at 08:54 AM.
gollum65 is offline   Reply With Quote
Old 10-28-2009, 03:11 PM   #52 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
disregard, problems fixed now.
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM

Last edited by mikev; 10-28-2009 at 04:50 PM.
mikev is offline   Reply With Quote
Old 11-01-2009, 10:57 AM   #53 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
FYI, there was a typo in my code that handled changeup talent for the development report. I have fixed. You'll probably see some erroneous changeup talent in the first development sim after you take the fix.

Sorry about that, not sure how I missed it in testing.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 11-14-2009, 06:59 PM   #54 (permalink)
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver
Posts: 7,523
Thanks: 232
Thanked 303x in 166 posts
Our timer keeps going screwy. At the moment it's saying the next pick was due before I'm pretty sure that team was even on the clock. Any ideas why or how we might fix it? On the admin page I have it set 9, 20, and 8 for 9 hours per pick (1st rd), shuts off at 20:00 (8PM using the server's mountain time), and start at 8:00 (8AM). I thought it was working right for awhile. Our commish has traded picks while the draft has been going. Would that screw it up? Anyway to fix it?
__________________
Useful Links: Manuals | Downloads | Newsletters | Knowledge Base | New Tech Support | Updated Forum Rules

Interactive Online League Directory - find or advertise a league today!
Canadian Baseball League - uses OOTP11, running steadily since April 2002

Last edited by kq76; 11-14-2009 at 07:02 PM.
kq76 is offline   Reply With Quote
Old 11-14-2009, 10:18 PM   #55 (permalink)
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver
Posts: 7,523
Thanks: 232
Thanked 303x in 166 posts
Strange. We just had a player get picked 4 times in a row.

If I may make some suggestions for additions to the draft utility.

Record and display:
  1. the time the pick was made - this is the most important especially when the timer goes bad, this way we can figure it out ourselves from when the previous pick was made
  2. if the pick was made by running out the clock, draft list or on the clock pick - mainly for bragging rights (obviously lists are the best, OTC next and last is ran out the clock), but a league could also give some sort of bonus or penalty based on this
  3. which account (that member or an admin) made the pick - good for record purposes
  4. whether pick was by a human or AI - just interesting

There's plenty of room on the page for all of this and some of it would be quite useful or at least interesting.
__________________
Useful Links: Manuals | Downloads | Newsletters | Knowledge Base | New Tech Support | Updated Forum Rules

Interactive Online League Directory - find or advertise a league today!
Canadian Baseball League - uses OOTP11, running steadily since April 2002

Last edited by kq76; 11-14-2009 at 10:22 PM.
kq76 is offline   Reply With Quote
Old 11-17-2009, 05:47 PM   #56 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
I've never heard of any issue with the timer (except confusion in which timezone it runs in); the code has been the same for 2+ years. If there still is an issue, can you point me to the site?

As for the multiple player picked 4 times in a row, could you send me your csv files and OOTPOU draft directory? This is an extremely rare error that one or two other people have said has happened back in OOTP 8. I've never been able to track it down since the commishes usually fix the issue before I can get my hands on it.

Thanks.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 12-29-2009, 04:43 AM   #57 (permalink)
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver
Posts: 7,523
Thanks: 232
Thanked 303x in 166 posts
In our Getch's Utilities and our OOTP Reports I see a form of
Code:
******** src="../scripts/sorttable.js"></script>
, but I don't actually see that folder or file in our ftp. This is something added by Getch's and not something we have to worry about, right?

EDIT: Nevermind. I ran a test and it seems to be something OOTP puts in. Why, I have no idea. I still don't see that folder/file anywhere.
__________________
Useful Links: Manuals | Downloads | Newsletters | Knowledge Base | New Tech Support | Updated Forum Rules

Interactive Online League Directory - find or advertise a league today!
Canadian Baseball League - uses OOTP11, running steadily since April 2002

Last edited by kq76; 12-29-2009 at 03:57 PM.
kq76 is offline   Reply With Quote
Old 12-31-2009, 04:51 PM   #58 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Originally Posted by kq76 View Post
In our Getch's Utilities and our OOTP Reports I see a form of
Code:
******** src="../scripts/sorttable.js"></script>
, but I don't actually see that folder or file in our ftp. This is something added by Getch's and not something we have to worry about, right?

EDIT: Nevermind. I ran a test and it seems to be something OOTP puts in. Why, I have no idea. I still don't see that folder/file anywhere.
It's left over from OOTP 9, or a Beta version, I forget. They used to support sorting on the HTML tables, and that was the javascript to enable it. You can ignore it, it doesnt do (or refer to) anything now.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 02-25-2010, 09:34 PM   #59 (permalink)
Minors (Single A)
 
Join Date: Jul 2009
Posts: 55
Thanks: 14
Thanked 8x in 1 post
If I may ask here, I am in the midst of conducting my league's (16 teams) inaugural draft of 120 rounds. I am currently entering the picks into OOTP manually and, boy, is it laborious. That said, I've three questions.

1. Is there a way to import the final draft results from the draft utility into the game?

2. If so, there was one other problem. The utility listed all of the college and high school kids as draft eligible even if the game did not. No matter, I allowed it to continue and I am simply drafting a crappy old player in that draftee's stead, editing him onto the free agent market, locating the actual pick, and editing him on to the appropriate team.

However, if the answer to #1 is "yes," will the problem I am having in #2 cause any issues.

3. If #1 is "yes," does it matter that I've already begun entering picks?

Thanks in advance!
trendon is offline   Reply With Quote
Old 02-25-2010, 11:25 PM   #60 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Unfortunately, the game does not support importing of picks. I've asked for it, but it is up to Markus to implement it.

As for college/high school eligibility, make sure you set the minimum age requirements for each feeder league in the admin page.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Thank you for this post:
trendon (02-26-2010)
Reply

Bookmarks

Thread Tools
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 12:44 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
Copyright © 2009 Out of the Park Developments