Latest News: OOTP PATCH 9.2.2 released - buy before Oct. 17th and save $10! - OOTP 9 RELEASED! - Title Bout Championship Boxing 2.5 released! - OOTP 2007 receives Editors Choice Award from PC Gamer - Inside the Park Baseball Patch 1.03 released, DEMO now available

Click here to download Out of the Park Baseball 9!

Go Back   OOTP Developments Forums > OUT OF THE PARK BASEBALL 9 > OOTP 9 - Mods > Database Tools
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

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

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 11-29-2006, 01:10 AM   #1 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: West Allis, WI
Posts: 1,558
BOSI like utility?

Did anyone come up with a BOSI like utility that would track both ratings and talent development for individual players?
__________________
Matt Rectenwald
Commissioner, Owner: Milwaukee Braves, Other Reality Baseball 2

Recruiter, Owner: Pago Pago Coconuts
Recte44 is offline   Reply With Quote
Old 11-29-2006, 04:15 AM   #2 (permalink)
Hall Of Famer
 
Raderick's Avatar
 
Join Date: Oct 2003
Location: San Diego, California
Posts: 2,641
Warnings: 2
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, 11:33 AM   #3 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
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?
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Comedian2004 is offline   Reply With Quote
Old 12-08-2006, 07:48 AM   #4 (permalink)
bp_
Hall Of Famer
 
bp_'s Avatar
 
Join Date: Apr 2004
Location: Philadelphia
Posts: 2,398
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, 08:48 AM   #5 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: West Allis, WI
Posts: 1,558
bp- If I could I'd love to be let in on that testing.
__________________
Matt Rectenwald
Commissioner, Owner: Milwaukee Braves, Other Reality Baseball 2

Recruiter, Owner: Pago Pago Coconuts
Recte44 is offline   Reply With Quote
Old 12-14-2006, 10:07 PM   #6 (permalink)
Major Leagues
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 480
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, 10:17 PM   #7 (permalink)
Major Leagues
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 480
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, 12:16 AM   #8 (permalink)
Banned
 
Join Date: Jul 2006
Location: CP Indiana
Posts: 1,667
Warnings: 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, 06:50 AM   #9 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: West Allis, WI
Posts: 1,558
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.
__________________
Matt Rectenwald
Commissioner, Owner: Milwaukee Braves, Other Reality Baseball 2

Recruiter, Owner: Pago Pago Coconuts
Recte44 is offline   Reply With Quote
Old 12-18-2006, 11:55 AM   #10 (permalink)
Major Leagues
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 480
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, 10:33 PM   #11 (permalink)
Major Leagues
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 480
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, 10:35 PM   #12 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: West Allis, WI
Posts: 1,558
Thanks a million, Getch. I'll let you know.
__________________
Matt Rectenwald
Commissioner, Owner: Milwaukee Braves, Other Reality Baseball 2

Recruiter, Owner: Pago Pago Coconuts
Recte44 is offline   Reply With Quote
Old 12-18-2006, 11:21 PM   #13 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,255
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-18-2006, 11:39 PM   #14 (permalink)
Banned
 
Join Date: Jul 2006
Location: CP Indiana
Posts: 1,667
Warnings: 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, 08:13 AM   #15 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: West Allis, WI
Posts: 1,558
Now I'm intrigued by this draft utility.
__________________
Matt Rectenwald
Commissioner, Owner: Milwaukee Braves, Other Reality Baseball 2

Recruiter, Owner: Pago Pago Coconuts
Recte44 is offline   Reply With Quote
Old 12-23-2006, 11:04 PM   #16 (permalink)
Major Leagues
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 480
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, 12:41 AM   #17 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,255
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, 12:37 PM   #18 (permalink)
Major Leagues
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 480
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, 12:46 PM   #19 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,255
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, 01:30 PM   #20 (permalink)
Major Leagues
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 480
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


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



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


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 Out of the Park Developments