|
|||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|
#61 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
I should have mentioned this a while ago, but I completely forgot.
I added a future draft pick tracker to the draft utility. So now you can keep track of picks in future years. When the year comes around and you set up the draft order, the draft will automatically import the traded picks for that year as well.
__________________
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 |
|
|
|
|
|
#63 (permalink) |
|
Minors (Single A)
Join Date: Jul 2009
Posts: 55
Thanks: 14
Thanked 8x in 1 post
|
I do not know if this is something you have insight on as it might be a game issue and not a utility issue, but here goes.
For our first amateur draft, the draft utility does now show some players that are listed in the game's draft pool. When I open the CSV file, you can see that these players are listed in players.csv as being a '1' in draft eligibility. Why is the game exporting these players as draft ineligible despite the fact they are in the draft pool? |
|
|
|
|
|
#64 (permalink) | |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
Quote:
__________________
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 |
|
|
|
|
|
|
#65 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
Just an FYI, I did a quick sanity check and it looks like the current version of OU is good to go for OOTP 11. I plan on doing a more thorough test this weekend when I have a little more time.
__________________
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 |
|
|
|
|
|
#66 (permalink) |
|
All Star Reserve
Join Date: Feb 2002
Location: TX
Posts: 824
Thanks: 3
Thanked 4x in 3 posts
|
Will the draft utility support rounds of differing length? This could happen when the game assigns compensatory picks for failure to sign your ammy. Right now we just include the round 1 order in order.txt and upload it, but can you specify multiple rounds in order.txt?
__________________
Commish GUBA |
|
|
|
|
|
#67 (permalink) | |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
Quote:
The Round # headers will be off by a few, but you'll achieve what you want with compensatory picks. We do this in one of my leagues with no issues.
__________________
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 |
|
|
|
|
| Thank you for this post: | MLcommish (05-19-2010) |
|
|
#68 (permalink) |
|
Minors (Single A)
Join Date: Oct 2002
Posts: 66
Thanks: 4
Thanked 15x in 11 posts
|
Getch, technical question:
Does your program do a direct query of the dat files? If so, how are you accomplishing that? What kind of embedded database is OOTP using? -- I have put this question to about 9 or 10 people and they just kind of go, "huh?", or ignore the question altogether. I have a utility program I'm working on right now that imports the CSV files into SQLite3 - Sqlite, by the way, rocks, I would just like to skip these two steps if it is at all possible.
__________________
Southerners are very strange about that war -- Shelby Foote |
|
|
|
|
|
#69 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
The program parses the csv files using Perl and regular expressions. While databases are much easier to use and program with, getting commishes to set them up and maintain them is difficult, since many commishes have limited technical background. I wanted a lightweight and easy-to-setup utility, so I went with Perl and parsing, for better or for worse.
__________________
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 |
|
|
|
|
|
#70 (permalink) |
|
Minors (Single A)
Join Date: Jul 2009
Posts: 55
Thanks: 14
Thanked 8x in 1 post
|
Coming back to check out this problem as it is happening again and I don't want to slave through editing players on to teams again.
Yes, I do have feeder leagues and the ages are set. However, clearly I am doing something wrong because the utility seems to think there are more draft-eligible prospects in COL and HS than the game does. |
|
|
|
|
|
#71 (permalink) | |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
Quote:
__________________
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 |
|
|
|
|
|
|
#72 (permalink) |
|
Minors (Triple A)
Join Date: Aug 2003
Location: The Steel City
Posts: 209
Thanks: 25
Thanked 32x in 13 posts
|
Is there any way to get this to work for a non-league ID of 100? We're starting up a league that's running concurrent with Major League Baseball, and thus our league ID is 101.
|
|
|
|
|
|
#73 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
Sorry I missed this. The league ID shouldn't be hardcoded anywhere. It is pulled from the .csv files for whatever teams have a human manager.
__________________
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 |
|
|
|
|
|
#74 (permalink) |
|
Global Moderator
Join Date: Nov 2002
Location: Vancouver
Posts: 7,527
Thanks: 233
Thanked 303x in 166 posts
|
Anybody know if this version works with OOTP12 as well or will it require an update?
My lg hasn't switched yet, but I'm just curious for if/when it does.
__________________
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 |
|
|
|
|
|
#75 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
I'll be updating it for OOTP 12 shortly. Just waiting for my new computer to arrive....
__________________
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 |
|
|
|
|
|
#78 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
Yeah sorry. Things came up.
I'm looking at it tonight. I'll get it out in the next couple days.
__________________
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 |
|
|
|
|
|
#79 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
Hey guys,
I plugged OU against the OOTP 12 csv files and saw no issues. Everything appeared to be working just fine. So go ahead and just keep using the same OU when you upgrade to OOTP 12, and let me know if you see any issues. We'll be using it in some of my online leagues so I should catch anything that goes wrong as well.
__________________
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 |
|
|
|
|
|
#80 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
__________________
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 |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|