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 11-29-2006, 02:10 AM   #1 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Greendale, WI
Posts: 1,921
Thanks: 24
Thanked 29x in 8 posts
BOSI like utility?

Did anyone come up with a BOSI like utility that would track both ratings and talent development for individual players?
Recte44 is offline   Reply With Quote
Old 11-29-2006, 05:15 AM   #2 (permalink)
Hall Of Famer
 
Raderick's Avatar
 
Join Date: Oct 2003
Location: San Diego, California
Posts: 2,729
Thanks: 0
Thanked 1x in 1 post
I don't think any exists as of now. I know CommishJoe stopped doing work on BOSI after v2, which only works on OOTP 6.
__________________
The Blog of the Open Mind



Quote:
Originally Posted by Cryomaniac View Post
I'd prefer a Tom Brady sex tape any day of the week.
Raderick is offline   Reply With Quote
Old 11-29-2006, 12:33 PM   #3 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
I have.

Check out the thread called AUAlmanac under the database forum.

It requires you to run the program at the end of each month, but has some nice stuff when you do do that.

Quote:
Originally Posted by Recte44 View Post
Did anyone come up with a BOSI like utility that would track both ratings and talent development for individual players?
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 12-08-2006, 08:48 AM   #4 (permalink)
bp_
Hall Of Famer
 
bp_'s Avatar
 
Join Date: Apr 2004
Location: Philadelphia
Posts: 2,631
Thanks: 50
Thanked 22x in 10 posts
Our league has one as well. I believe it is still being tested for general release: http://www.diamondleaguebaseball.com/ (click on development reports on the left)
__________________
"al Qaeda wouldn't last a day in parts of Philadelphia" - Mayor Michael Nutter
bp_ is offline   Reply With Quote
Old 12-08-2006, 09:48 AM   #5 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Greendale, WI
Posts: 1,921
Thanks: 24
Thanked 29x in 8 posts
bp- If I could I'd love to be let in on that testing.
Recte44 is offline   Reply With Quote
Old 12-14-2006, 11:07 PM   #6 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Yeah... work's been killing me so I haven't gotten around to releasing that thing. It's stupid, it's like a few more hours of work tops. I promise I'll work on it this weekend.
Getch is offline   Reply With Quote
Old 12-17-2006, 11:17 PM   #7 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Here you go:

http://www.diamondleaguebaseball.com/utils/dev.zip

Instructions are in the readme.txt. This is only the development report and the waiver wire utility. I didn't get to the DLB draft utility I wrote, and I want to add things like draft lists, etc., so that'll have to wait for now.

One other thing is that it is hardcoded to 2-8 talent ratings and 1-10 player ratings. I need to make it generic, which shouldn't be hard to do.

Anyway, let me know if you have any problems with it. I suspect there will be some. Once it's been tested, I'll upload it to the Modsquad page for general use.
Getch is offline   Reply With Quote
Old 12-18-2006, 01:16 AM   #8 (permalink)
Banned
 
Join Date: Jul 2006
Location: CP Indiana
Posts: 1,667
Thanks: 0
Thanked 0x in 0 posts
Infractions: 1/3 (3)
Hey Getch, even as is you should release your draft util. It was very cool and would be a huge thing for online leaguers
APujols5 is offline   Reply With Quote
Old 12-18-2006, 07:50 AM   #9 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Greendale, WI
Posts: 1,921
Thanks: 24
Thanked 29x in 8 posts
Quote:
Originally Posted by Getch View Post
Here you go:

http://www.diamondleaguebaseball.com/utils/dev.zip

Instructions are in the readme.txt. This is only the development report and the waiver wire utility. I didn't get to the DLB draft utility I wrote, and I want to add things like draft lists, etc., so that'll have to wait for now.

One other thing is that it is hardcoded to 2-8 talent ratings and 1-10 player ratings. I need to make it generic, which shouldn't be hard to do.

Anyway, let me know if you have any problems with it. I suspect there will be some. Once it's been tested, I'll upload it to the Modsquad page for general use.
The hard coded part is going to be an issue. We run 1-10 talents and 1-20 ratings.
Recte44 is offline   Reply With Quote
Old 12-18-2006, 12:55 PM   #10 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
OK, I'll whip something up. It shouldn't be too bad. I'll repackage it when I'm done.

I'll look at the draft utility as is. I wanted to make a commishiner UI before I released it so you didnt have to manipulate text files to trade picks and stuff.
Getch is offline   Reply With Quote
Old 12-18-2006, 11:33 PM   #11 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Updated to take any ratings/talent scale. I wasn't able to test it out other than to make sure I didn't break our own league. Let me know if the scales are off somehow... there might be an off-by-one error.

Let me know how it works for you.
Getch is offline   Reply With Quote
Old 12-18-2006, 11:35 PM   #12 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Greendale, WI
Posts: 1,921
Thanks: 24
Thanked 29x in 8 posts
Thanks a million, Getch. I'll let you know.
Recte44 is offline   Reply With Quote
Old 12-19-2006, 12:21 AM   #13 (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
Or I will, since I'll be setting it up
__________________
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
mikev is offline   Reply With Quote
Old 12-19-2006, 12:39 AM   #14 (permalink)
Banned
 
Join Date: Jul 2006
Location: CP Indiana
Posts: 1,667
Thanks: 0
Thanked 0x in 0 posts
Infractions: 1/3 (3)
Quote:
Originally Posted by Getch View Post

I'll look at the draft utility as is. I wanted to make a commishiner UI before I released it so you didnt have to manipulate text files to trade picks and stuff.
Great News... Your Util could actually make online league drafting fun.
APujols5 is offline   Reply With Quote
Old 12-19-2006, 09:13 AM   #15 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Greendale, WI
Posts: 1,921
Thanks: 24
Thanked 29x in 8 posts
Now I'm intrigued by this draft utility.
Recte44 is offline   Reply With Quote
Old 12-24-2006, 12:04 AM   #16 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
I fixed a few issues in the development reports (had league name hardcoded still and there was a bug with getting the league date). I also made the draft utility, as it stands now, generic and rolled it all into one. I plan to be making it better in the next few weeks, but people want it released now, so here it is:

http://www.diamondleaguebaseball.com/utils/utils.zip

Let me know if you have any problems.
Getch is offline   Reply With Quote
Old 01-04-2007, 01:41 AM   #17 (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
Quote:
Originally Posted by Getch View Post
I fixed a few issues in the development reports (had league name hardcoded still and there was a bug with getting the league date). I also made the draft utility, as it stands now, generic and rolled it all into one. I plan to be making it better in the next few weeks, but people want it released now, so here it is:

http://www.diamondleaguebaseball.com/utils/utils.zip

Let me know if you have any problems.
I ran into one small issue, but everything else seems to be working OK.

When I edited the setup.txt file and input the league ID, which was 100, all the HTML links are pointing to league_1_blah.html instead.

Somehow it's not picking up the trailing zeroes.
__________________
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
mikev is offline   Reply With Quote
Old 01-04-2007, 01:37 PM   #18 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Yeah, someone else who is uptaking the utils hit the same issue yesterday and I already fixed. There's now a LEAGUEID variable in the setup.txt file that you can enter your league ID.

I have made a few other fixes since my last post, and revamped the draft util to include draft lists and auto-drafting. Our league's just about to start the draft, and it hasnt been fully tested, so I'd wait a little time for our league to be the guinea pig and iron out the issues.

All of the changes are uploaded to the same place.
Getch is offline   Reply With Quote
Old 01-04-2007, 01:46 PM   #19 (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
Quote:
Originally Posted by Getch View Post
Yeah, someone else who is uptaking the utils hit the same issue yesterday and I already fixed. There's now a LEAGUEID variable in the setup.txt file that you can enter your league ID.
I know, what I'm saying is that my LEAGUEID is 100, and when it's creating the HTML page, the league ID is 1 and not 100 like I put in the setup.txt.

Here's my development page, and if you look, the SION HOME and DLB links are pointing to the right URL, but everything from Scores to History points at League_1_blahblah and not League_100_blahblah.

Actually, noting the "DLB" link which I'm assuming to be Diamond League Baseball, maybe something in the script is still hard coded?
__________________
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
mikev is offline   Reply With Quote
Old 01-04-2007, 02:30 PM   #20 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Right, what I am saying is that the latest version at:

http://www.diamondleaguebaseball.com/utils/utils.zip

Has the code changes so that it supports any league ID. In that version, there is a LEAGUEID parameter in setup.txt. You should take that version and set 100 for your league ID.

The hardcoded DLB at the top of the page is also fixed in that version.
Getch is offline   Reply With Quote
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 07:04 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