Latest News: Updated Patch #4, version 10.4.31 available! - OOTP 10 RELEASED! - Title Bout Championship Boxing 2.5 released! - Inside the Park Baseball Patch 1.03 released, DEMO now available

Click here to download Out of the Park Baseball 10!

Go Back   OOTP Developments Forums

> OUT OF THE PARK BASEBALL 9 > OOTP 9 - Mods > Database Tools


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

Reply
 
LinkBack Thread Tools Display Modes
Old 07-05-2007, 07:42 AM   #61 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,097
I think the biggest downfall is that I have had so many hints of what a player does against a minor league team IE 5 for 5 or 5 for 6...Just this morning I had 6 hints in a row with the above said problem. Other than that it is a great program
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 07-05-2007, 11:51 AM   #62 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
I think I have solved the problem. The problem was that the line of history that stated that the player went 5-6 did not contain what league he was in, like the awards or the other items that are pulled from the player's history. So, it could be in the history file for the player, even if the player is a major league player now.

So I had to be trickey. I searched the line for the team number and then check an index to see if this team was a MLB team or a minor league team. If it was a minor league team, and the no minor history is checked, it will skip it.

You will see minor league teams in there, like scoring 10 runs in a game, etc. That may be a little harder to remove, due to the league information is NOT contained in that file I get that information from. I would have to look up each game number in another file and check the team numbers and that could slow the routine down.

I created a fictional league with full minors and it seems to work here, so let me know if it solved the problem.
__________________
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 07-06-2007, 01:26 PM   #63 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
I will be patching the program today before I leave to go see DEEP PURPLE and EDGAR WINTER and here is a couple items I added:

Pitchers that have thrown 3 or more 1-hitters in their career.
Pitchers that have thrown XX or more 5 hit shutouts in their career.
Players that have hit more than 2 cycles in their career.
Batters that have collected more than XX batter of the month awards in their career.
Record for most hot dogs eaten when the teams had a hot dog eating contest for the crowd.

I also will add player of the week, and pitcher for the month/week totals.

The XX mean they have options to set, to control how many there are that get shown.

NOTE: The save option will not save the new parameters as of this moment. I will change that later.

Gooden threw 5 1-hitters in my season!! Ted Williams won the batter of the month 37 times in my career. Well, not my career, it was his career, just my game, as it is in my hands.
__________________
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 07-06-2007, 01:30 PM   #64 (permalink)
Hall Of Famer
 
endgame's Avatar
 
Join Date: Aug 2002
Posts: 8,164
Thanked 77x in 37 posts
Been a little preoccupied, but finally found time to read through the thread very quickly. Looks great, and even better that it still allows you to add your own to the text file and remains customizeable. Hope I get a chance to try this out this weekend.

Does this completely replace the existing in-game hint.txt, or simply supplement it?
__________________
"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 07-06-2007, 02:48 PM   #65 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
It does completely overwrite the existing hint file, but now that you mention that, I could add the option to append to it, but, I have to be careful there, as it could create duplicate entries.

Maybe I will add an option instead to import a text file into it after you run my program. However, that could create issues with the file being too large. I am trying to find out if there is a limit to how big it can be and if there is a max size that could hamper the speed of the ootp game, but I have yet to get an answer.
__________________
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 07-06-2007, 03:18 PM   #66 (permalink)
Major Leagues
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 409
Quote:
Originally Posted by Comedian2004 View Post
I will be patching the program today before I leave to go see DEEP PURPLE and EDGAR WINTER
I'm sure you will need a few days to recover (from the above), so it's good that you are patching before hand.
__________________
"Baseball gives every American boy a chance to excel, not just to be as good as someone else but to be better than someone else. This is the nature of man and the name of the game.
Ted Williams (1918-2002)
plannine is offline   Reply With Quote
Old 07-06-2007, 08:09 PM   #67 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
The concert is not until next Friday. Duh...

I just added a cool tidbit. It totals the player's injuries up in his career. This is going to be an estimate, since it is based on loose information. If it says he was injured 12 months, it will add 48 to the total (which is now a WEEK total). If it says that 5-6 months, it will just use the 5 and add it. If it says 3 weeks, it will add 3 weeks. If it says 5-7 weeks, it will use the 5. It ignores the day to day injuries.

If the total is greater than 25 weeks, it will add it saying something like this:

It is estimated that Joe Kelly has spent 36.3 months injured.

I will add an option to change the default 25.

I also changed the layout to look a little cleaner.

Keep in mind that if there is something that you do not want displayed, like extra inning games, just set that option to a high number that won't get reached, like 100 or whatever I have the max set at.
__________________
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 07-06-2007, 08:15 PM   #68 (permalink)
Hall Of Famer
 
remangiii's Avatar
 
Join Date: Jul 2003
Location: At this point, any shade of green will do
Posts: 4,923
Thanked 7x in 5 posts
Infractions: 0/1 (1)
Great work, Larry.
__________________
New York Yankees GM, The CBL - Rewind

2005 Winner of LL's Pick the Loser Contest! - 15-0
remangiii is offline   Reply With Quote
Old 07-06-2007, 09:15 PM   #69 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,097
OK OK OK , what are you a mind reader also. I just finished and exited my game and was getting ready to write you and let you know I was so tired of the 5 for 5 games and I restarted your program and lo and behold there is a prompt to ignore 5 for 5 entries, now does this cover 5-6 games...LOL

People do you all understand that Larry has a real job, them comes home and writes all these great utilities and from what I read a lot of you love and use his programs. So how many of you have sent him any donations for all the hard work he does. I have and you should too.

Ask yourself how much do his utilities enhance the way you play the game. I have had many a conversation with Larry and have suggested that he charge a one time fee and you get access to all his programs and all the updates. He could even allow people demo versions of all his programs...

I for one would send him a fee for the unlimited use of all his programs. Lets hear what you think about this idea

Would you do all he does for no money at all...

Hey Larry you do great work and I am proud to be a card carrying member of the planetootp.com club Keep up the great work
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 07-06-2007, 11:28 PM   #70 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,097
Just started the program and there was a new update, downloaded it and the program started, noticed the new logo at the bottom and then as I ran the program I got another error message and can't run the program
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 07-06-2007, 11:31 PM   #71 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,097
Oh yeah I forgot. The 5 for 5 games are gone but I still get the 5 for 6 games
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 07-06-2007, 11:34 PM   #72 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
Uh. a little more information that 'an error' might help, 5-6 and 5-7 should not be displayed.. will look
__________________
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 07-06-2007, 11:35 PM   #73 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,097
Do you still have my number
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 07-06-2007, 11:39 PM   #74 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,097
Now I can't run the program it is at the Getting games information prompt and it says Microsoft.NET Framework Error

Value cannot be null
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 07-07-2007, 12:27 AM   #75 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,097
Got the newest update but i am still getting the above said error
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit from going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 15 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 07-07-2007, 12:59 AM   #76 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
I think I fixed the errors that were reported.

PLEASE.. if you get an error, let me know what the error is and more important than that, let me know what you did that caused the error.

Was it when you loaded the program or after you hit start?

If it was AFTER you hit start, then let me know what routine it was on when it did it. Restart the program and and click DEBUG to get more details. The blue bar status tells you what it was doing. Otherwise I have to figure out though thousands of line of code what crashed.

Also let me know the month and year your season is in. You can quickly find that by running my app and looking at the title bar at the top.

Just to let you know what this was, I had added a recent routine that told you what the most runs in an inning was. Like 11 runs in the 1st, 9 runs in the 2nd, etc. The error was caused if you ran it during the offseason AFTER Feb, but before the games were played. So, since my season is in July, I did not get the error. I cannot possibly try every single scenario after I add a new option.

On another side note. Keep an eye out for the runs per inning thing. I have never seen more than 11 runs in one single inning and I am wondering if it is an error on my part or if there is some kind of cap there, like when 11 runs are reached, the next batter(s) will strike out or something to prevent that from happening.
__________________
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 07-07-2007, 10:15 PM   #77 (permalink)
Minors (Triple A)
 
Rangersfan's Avatar
 
Join Date: Feb 2002
Location: Winston-Salem, NC
Posts: 284
i'm now getting an error when I try to run this program on my computer. Weird thing is i have had no trouble running it until a couple of days ago.

Error message that pops up: Application can not be started . Contact the aplication vendor

The full error message i recieve

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : http://www.planetootp.com/AUHistoryH...nt.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://www.planetootp.com/AUHistoryH...nt.application resulted in exception. Following failure messages were detected:
+ The referenced assembly is not installed on your system. (Exception from HRESULT: 0x800736B3)

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [7/7/2007 9:00:34 PM] : Activation of http://www.planetootp.com/AUHistoryH...nt.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [7/7/2007 9:00:34 PM] System.Runtime.InteropServices.COMException
- The referenced assembly is not installed on your system. (Exception from HRESULT: 0x800736B3)
- Source: System.Deployment
- Stack trace:
at System.Deployment.Internal.Isolation.IStore.GetAss emblyInformation(UInt32 Flags, IDefinitionIdentity DefinitionIdentity, Guid& riid)
at System.Deployment.Internal.Isolation.Store.GetAsse mblyManifest(UInt32 Flags, IDefinitionIdentity DefinitionIdentity)
at System.Deployment.Application.ComponentStore.GetSu bscriptionStateInternal(DefinitionIdentity subId)
at System.Deployment.Application.SubscriptionStore.Ge tSubscriptionStateInternal(SubscriptionState subState)
at System.Deployment.Application.SubscriptionStore.Ch eckAndReferenceApplication(SubscriptionState subState, DefinitionAppId appId, Int64 transactionId)
at System.Deployment.Application.DownloadManager.Down loadDeploymentManifestDirectBypass(SubscriptionSto re subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.Down loadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator .PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator .ActivateDeploymentWorker(Object state)

COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.


Any idea on what is causing this?

Thanks in advance.

-Jon
Rangersfan is offline   Reply With Quote
Old 07-07-2007, 10:46 PM   #78 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
Those are one of those odd errors that users get on occasion. It is something to do with the way the application is deployed. Try going to the control panel and under add/remove programs, locate it and then install it.

Head to the website using IE and install it again. (See page one of thread for link). Let me know if this solves the problem and I will research it and see if I can see another solution.

After you uninstall it, please reboot the computer before you try installing it again. Sorry for the problems. And thanks for reporting it.

When I am in a streak, I update the program quite a bit, so it could be any thing that I have added since you last ran it successfully. I am thinking that I added a math routine a few days ago for some math functions I needed and that may be the culprit.

Let me know the results. You can e-mail me directly at larry@cfl.rr.com for a quicker reply.

Since I am here, I added a few more tidbits (surprised?). Some you may never see appear in your league, but if you do, you sure will be surprised! I added a few more options and I removed the really cool looking buttons and replaced then with a menu bar. While the buttons were easier to use, I needed the screen real estate.

I also added the ability to merge in a text file. It does no checking, so use at your own discreation. One thing to keep in mind is the game only supports hint lines that contain 256 characters or less. I am not sure what happens if they are longer, if it will crash or just trunacate it. I will test that one day.

I also added the ability to sort the list. It does not save it in sorted format, since that is meaningless, but it will help you find what options you want to disable because of too many items.

Another item I added is a quick way to load the hint.txt file into your default text editor. So, after you use my program you can use this option and then remove any lines that you want to. Then save it back. Note that the saved version is not loaded into my program. Once again, there would be no need to do that.
__________________
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 07-07-2007, 10:58 PM   #79 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
If uninstalling and reinstalling does not work, remove this folder:

Uninstall the app again, the downside is that you will have to install all my other apps that you use. (It will not remove data folders, settings, photos, etc. and it will have no bearing on OOTP or Window XP)

Click on your Windows START button and select RUN.

Paste this in there and hit OK

%userprofile%\Local Settings\Apps

Then delete the folder that is located there. Reboot and then install again.

Then let me know. According to MS, some files somehow got corrupt. The posts that I have read showed that this solved most issues, either the 1st step or the 2nd step.
__________________
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 07-08-2007, 02:01 AM   #80 (permalink)
Minors (Triple A)
 
Rangersfan's Avatar
 
Join Date: Feb 2002
Location: Winston-Salem, NC
Posts: 284
After doing the second step you suggested the problem seems to be fixed. Thanks for all your help.
Rangersfan 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 08:40 PM.


Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Copyright © 2009 Out of the Park Developments