Latest News: OOTP PATCH 9.1.6 released! - 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 03-23-2007, 01:10 PM   #1 (permalink)
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,429
Win Shares and HOFmeasurements

For anyone who used it the one for 2006 does not work for 2007.

I've almost got it revamped, it'll be another couple days.

Oh, and this time it'll work right. Setting up a league in 2006 took me forever, with 2007 I've found a couple problems in the multi major league handling.
__________________
I don't know about you, but as for me, the question has already been answered: Should we be here? Yes!
Jack Buck, September 17, 2001

It's what you learn after you know it all that counts.

I firmly believe that any man's finest hour... is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. (Vince Lombardi)

I don't measure a man's success by how high he climbs but how high he bounces when he hits bottom. (George S. Patton)
tysok is offline   Reply With Quote
Old 03-24-2007, 02:10 AM   #2 (permalink)
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,429
It's finished and ready... I emailed it off to Modsquad and... okay my memory doesn't work, but I emailed it to two people just now.
__________________
I don't know about you, but as for me, the question has already been answered: Should we be here? Yes!
Jack Buck, September 17, 2001

It's what you learn after you know it all that counts.

I firmly believe that any man's finest hour... is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. (Vince Lombardi)

I don't measure a man's success by how high he climbs but how high he bounces when he hits bottom. (George S. Patton)

Last edited by tysok : 03-24-2007 at 02:21 AM.
tysok is offline   Reply With Quote
Old 03-24-2007, 03:04 PM   #3 (permalink)
All Star Reserve
 
PadresFan's Avatar
 
Join Date: Dec 2001
Location: Carlsbad, CA
Posts: 687
It's up on my site as well...
__________________
XBL/PSN: Leadfoot5
Everywhere else: PadresFan104

PadresFan Adds-On Central Info:http://www.ootpdevelopments.com/boar...od-thread.html
Text Sim Mod-File Website: http://www.padresfanmods.net
PadresFan is offline   Reply With Quote
Old 03-25-2007, 05:11 PM   #4 (permalink)
Minors (Rookie Ball)
 
Join Date: Jun 2005
Posts: 34
Tysok,

Great program! When do you suggest running this? I ran this in the middle of my first season to check it out and it gave no player listings. I did the csv dump and set the path to the export/import of my saved game.

Thanks for any help you can provide.
txmudcat is offline   Reply With Quote
Old 03-25-2007, 05:27 PM   #5 (permalink)
Minors (Rookie Ball)
 
Join Date: Jun 2005
Posts: 34
Sorry for the dola but what I meant was that the win shares works fine but the HOF monitor doesn't give any listing. Does this only work after season, with retired players or am I an idiot and not doing something right?

Thanks!
txmudcat is offline   Reply With Quote
Old 03-26-2007, 12:20 AM   #6 (permalink)
Hall Of Famer
 
Join Date: Aug 2003
Posts: 4,429
Quote:
Originally Posted by txmudcat View Post
Sorry for the dola but what I meant was that the win shares works fine but the HOF monitor doesn't give any listing. Does this only work after season, with retired players or am I an idiot and not doing something right?

Thanks!
There's a help file in there.

But I would suggest you run this just after the season ends, the day after the playoffs. There was a problem in 2006 where players were left out of quite an important file when they retired, if you do the dump and figure the win shares right after the season ends you catch them before they retire.

If you do run it in the middle of a season... well actually I need to fix that for multi-ML use I guess. When you run it it writes all the info into a table... so at the end of the season it would either say you've already run it or it'll write it twice... so everyone would end up with 1.5 times the win shares they should, or whatever.
You'd have to go in and run the "Repair crash while figuring win shares" to get rid of what had been done before. It asks for the year and deletes everything having to do with that year.
I need to fix that so it asks for the year and the league... otherwise in a multi-ML universe where you've figured the Jap league at the end of their season, but need to delete the American info it kills both.... oh well... just don't do it.

The screens are limited to players that get at least 1 HOF Monitor point. To get a point for hitting over .300 they have to have played in 100 games that season, you probably did this before 100 games were played. They could also get points for over 35 doubles or over 30 HRs... it was probably just too early in your first season for anyone to have qualified to get any HOF Monitor points.
__________________
I don't know about you, but as for me, the question has already been answered: Should we be here? Yes!
Jack Buck, September 17, 2001

It's what you learn after you know it all that counts.

I firmly believe that any man's finest hour... is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. (Vince Lombardi)

I don't measure a man's success by how high he climbs but how high he bounces when he hits bottom. (George S. Patton)
tysok is offline   Reply With Quote
Old 03-26-2007, 02:52 AM   #7 (permalink)
Minors (Rookie Ball)
 
Join Date: Jun 2005
Posts: 34
Thanks Tysok, I appreciate the information and your patience since I didn't see (hence:read) the help file before I posted.
I am using your utility to figure my manual award so thanks for explaining how to undo the win share as I had run it mid season.

Thanks again for your utility!

Chris
txmudcat is offline   Reply With Quote
Old 03-26-2007, 03:00 PM   #8 (permalink)
Hall Of Famer
 
Gastric ReFlux's Avatar
 
Join Date: Oct 2002
Location: Member #3409
Posts: 8,313
Has anyone tried using this with Open Office?
Gastric ReFlux is offline   Reply With Quote
Old 04-08-2007, 08:33 PM   #9 (permalink)
Major Leagues
 
gbmoore121's Avatar
 
Join Date: Feb 2002
Location: Arizona
Posts: 383
A bump and a thanks. Great program!

I used this to get Win Shares mainly, but the points are great too.

I used it to go with the user created award. I made mine the MVP and will use the Win Shares to determine the winner.
__________________
WHBL

Hardball Heroes
gbmoore121 is offline   Reply With Quote
Old 11-12-2007, 01:17 PM   #10 (permalink)
Hall Of Famer
 
Mike D's Avatar
 
Join Date: Dec 2001
Location: In a van, down by the river
Posts: 2,238
I just want to say what an awesome, awesome program this is. I am using it on my historical league, which started in 1901 and is up to 2009. I used the program for the first time after the 2007 season and it imported all the HOF measurements with no problems at all. Thanks for this
__________________
Sometimes the best laid plans will never get you laid the way you plan.
Mike D is offline   Reply With Quote
Old 11-15-2007, 09:45 AM   #11 (permalink)
Major Leagues
 
Join Date: Mar 2007
Posts: 403
Is this program for solo leagues or online leagues??
__________________
GM of the OBL - Cincinnati Reds (578-654, .469)
1938 NL West Champs
1938 National League Champs

GM of the SSBL - Atlanta Braves (360-254, .586)
2022, 2024-2025 NL East Champs
2024 National League Champs

GM of the BJHL - Avery Island Hot Peppers (169-155, .522)
falkonisback is offline   Reply With Quote
Old 11-15-2007, 08:09 PM   #12 (permalink)
Hall Of Famer
 
Mike D's Avatar
 
Join Date: Dec 2001
Location: In a van, down by the river
Posts: 2,238
I'm sure the commish could use it with no problem in an online league. I think the online league would have to have been entirely made and played in 2007 for it to work.
__________________
Sometimes the best laid plans will never get you laid the way you plan.
Mike D is offline   Reply With Quote
Old 12-27-2007, 07:36 PM   #13 (permalink)
Major Leagues
 
Renner's Avatar
 
Join Date: Jun 2005
Location: Connecticut
Posts: 317
I was hoping someone could help me. I am a total novice to the world of mods, but was interested in this one. I went to Padresfan great site and downloaded the file...now what ? I see the Microsoft Access "file", but not a Help file. Can someone walk me through the process of getting this to work (where do I save it on my PC, etc etc) ? Thanks everybody
__________________
Robots are everywhere, and they eat old people's medicine for fuel.
Renner is offline   Reply With Quote
Old 12-28-2007, 03:38 PM   #14 (permalink)
Hall Of Famer
 
Mike D's Avatar
 
Join Date: Dec 2001
Location: In a van, down by the river
Posts: 2,238
When you open the file, there is a help file there. The help file is very detailed and will walk you through everything.
__________________
Sometimes the best laid plans will never get you laid the way you plan.
Mike D is offline   Reply With Quote
Old 12-28-2007, 07:56 PM   #15 (permalink)
Major Leagues
 
Renner's Avatar
 
Join Date: Jun 2005
Location: Connecticut
Posts: 317
Quote:
Originally Posted by Mike D View Post
When you open the file, there is a help file there. The help file is very detailed and will walk you through everything.
Thanks, but I may be an idiot. I open the Win Shares 2007.zip and the only file in there is Win Shares 2007.mdb.
__________________
Robots are everywhere, and they eat old people's medicine for fuel.
Renner is offline   Reply With Quote
Old 12-28-2007, 07:57 PM   #16 (permalink)
All Star Reserve
 
Doughnuts?'s Avatar
 
Join Date: Sep 2005
Posts: 705
Quote:
Originally Posted by Renner View Post
Thanks, but I may be an idiot. I open the Win Shares 2007.zip and the only file in there is Win Shares 2007.mdb.

me too.
Doughnuts? is offline   Reply With Quote
Old 12-28-2007, 09:18 PM   #17 (permalink)
Hall Of Famer
 
endgame's Avatar
 
Join Date: Aug 2002
Posts: 6,246
Quote:
Originally Posted by Renner View Post
Thanks, but I may be an idiot. I open the Win Shares 2007.zip and the only file in there is Win Shares 2007.mdb.
Once Access opens the database, there is a menu with an option to View the Help File.
__________________
"Try again. Fail again. Fail better." -- Samuel Beckett

We live in the shadowlands. The sun is always shining somewhere else.
__________________
endgame is offline   Reply With Quote
Old 12-28-2007, 09:23 PM   #18 (permalink)
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 2,686
Several months ago, I tried to use this utility. It did not work as advertised, perhaps because I have the most recent version of Access. Of course, the problem may be due to user error.
pstrickert is offline   Reply With Quote
Old 12-28-2007, 11:14 PM   #19 (permalink)
Major Leagues
 
Renner's Avatar
 
Join Date: Jun 2005
Location: Connecticut
Posts: 317
Quote:
Originally Posted by endgame View Post
Once Access opens the database, there is a menu with an option to View the Help File.
I open the Win Shares 2007.mdb...I open the file...I see a pop up that says it's a read only database...I click OK...I don't see anything in Microsoft Access (I have Access 2000). Ideas what I should do next or what I've done incorrectly ?
__________________
Robots are everywhere, and they eat old people's medicine for fuel.
Renner is offline   Reply With Quote
Old 12-28-2007, 11:42 PM   #20 (permalink)
Hall Of Famer
 
endgame's Avatar
 
Join Date: Aug 2002
Posts: 6,246
Quote:
Originally Posted by Renner View Post
I open the Win Shares 2007.mdb...I open the file...I see a pop up that says it's a read only database...I click OK...I don't see anything in Microsoft Access (I have Access 2000). Ideas what I should do next or what I've done incorrectly ?
I have Access 2000. When I double click on the .mdb file, one of the options it gives me is to convert the database. The other was something like the equivalent to cancel the operation. I elected to convert it and then saw the menu as well as the help file. So I'm not sure what's going on then. I'll think on it though.
__________________
"Try again. Fail again. Fail better." -- Samuel Beckett

We live in the shadowlands. The sun is always shining somewhere else.
__________________
endgame 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 09:09 AM.


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