Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 25 > OOTP Mods > OOTP Mods - Database Tools
Register Blogs FAQ Calendar Today's Posts Search

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

Reply
 
Thread Tools
Old 10-23-2006, 11:57 AM   #41
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
I added a button to load in the player's career stats for viewing and added the color coding to it as suggested by Targy.

NOTE: It will display a player's entire career, but there is a button to show the SIM only stats. So, if you started your league in 1985, you would see all of George Brett's stats. If you click the SIM ONLY button, it would just show 1985, 1986, etc.

The problems earlier with Targy was he had not selected the Almanac location. Use caution if you have multiple leagues that you have the right league selected and the right almanac. I will see if I can make that a little more targyproof.
__________________
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 10-23-2006, 09:42 PM   #42
targy
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
One last thing, please do as in your other programs. list all the teams so we can click on the team and get all the players instead of looking through all the players
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 10-24-2006, 08:51 AM   #43
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
  • Added a team drop down list
  • Added way to view players stats
  • Color Coded the stats
  • Added a way to view stats as a 162 game average

Select team after you see list of players
The 162 Avg button shows what the player would have done if he had played 162 games (it bases it on PA for batters and IP for pitchers)

When you display stats, it shows the player's entire history, even stats before the sim started. You can click the Sim only to hide the non simulated stats.
__________________
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 10-24-2006, 09:37 AM   #44
targy
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thank you again. One more suggetion on viewing the stats. For Hitters can you add their Batting Average and for Pitchers can you add ERA unless I am not seeing it with my bad eyes
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 10-24-2006, 12:29 PM   #45
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
LOL.. I just added batting average and ERA and was going to post that I have added those items and the request was here to add that.

I also froze the year, so you can scroll to the right and still see the year.
__________________
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 10-24-2006, 09:29 PM   #46
targy
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
This is getting scary Webby I say something and you just finished it. OK OK I need a million dollars and I am on my way to the mailbox...LMAO
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 10-24-2006, 09:40 PM   #47
targy
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
ERA does not seem to be color coded
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 10-25-2006, 04:17 PM   #48
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Color coded the ERA (My crayons were broke, had to buy another box)

I also added the ERA to the season best, but that ERA is NOT the season best, but it is instead his lifetime ERA. Same thing with the batting average listed there, it is his lifetime batting average.

The best season line is nothing more I am going to work on, as it would require listing the lowest value for some items and that is getting off the scope of this application. I just added the stats as a quick way to see how the guy is doing.

I will be adding some more neat stuff. I want to get into the box scores of the no-hitters and other super games next, this will create HTML pages in a folder with the box scores for those games in there. Also, an ability to search for box scores in the almanac.

Example:

Run this option and it will create the following folders:

No-Hitters
Perfect Games
5+ hits
4+ homeruns
20 or more innings
etc.

The box scores would be renamed:

box1999.html ----> box_seaver_perfect_game_06212003.html

Then a sub menu would be created that listed them, like this:

05-22-2003 MARK BELANGER - 5 home runs
06-21-2003 TOM SEAVER - Perfect game

Each line would be a link to the actual box score and of course, from the box score, you could go to the PbP, if it existed.
__________________
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 10-25-2006, 04:23 PM   #49
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,965
Larry, I just diid 2 new lgs and when I got to archive, i got already exists error on both
__________________
Elder Statesman of the Board

http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room
kagnew35 is offline   Reply With Quote
Old 10-25-2006, 04:48 PM   #50
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Change the almanac folder to a different location for each league.

For instance, create a folder called Almanac Mongo League and another one called Alamanac Panda Bear League (Substitute your league name, unless it is called Mongo)

Inside each Almanac, a year folder will be created. If you do not switch almanacs, it can cause problems. But, because of the way the almanac is designed to use different almanac folders for each league, you can easily 'fix' things by just deleting the archived wrong information.

The structure is as follows:

ALMANAC Mongo League:
1987
HTML
IMPORT_EXPORT
MESSAGES
TXT
1988
HTML
IMPORT_EXPORT
MESSAGES
TXT
etc..

so, the league you are trying to archive already sees a year that matches folder and it won't let you archive, possibly over writing what you have there already.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

Last edited by Comedian2004; 10-25-2006 at 04:50 PM.
Comedian2004 is offline   Reply With Quote
Old 10-25-2006, 06:17 PM   #51
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Added the retrieval of the no-hitters, now have to parse the line and go locate the box score. Fun stuff here now.
__________________
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 10-25-2006, 08:06 PM   #52
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Ok, if you click on REPORTS PLAYER NO HITTERS

You will get a list of all the no-nos in your league so far. Click on any of them and it will bring up the box score for that game. I have not put in error checking, so if the box score does not exist, it will error.

I also noticed that one box score came up with the same number as the last one. I have not trouble shot that.

It is tricky. It finds the no-hitter in the team news page for that year. It pulls the date out and the pitchers name. It also grabs the rest of the info and sorts it out a little different, removing the links too.

It then looks in the games.csv file for that season and finds games with the matching date. It then looks in that same line to see if this game has the starting pitcher as the same one that was in the transaction list. If it does find a match, it grabs that box score number and shows it from that year.

Now I have to see why it is not finding the correct information for ONE game. But, first..

IT'S TIGER TIME
__________________
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 10-25-2006, 09:28 PM   #53
targy
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
You never cease to amaze me. What will you think of next. Thank you again
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 10-25-2006, 09:40 PM   #54
targy
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
I tried to open the no hitters file and this is the error I get

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.ComponentModel.Win32Exception: The system cannot find the file specified
at System.Diagnostics.Process.StartWithShellExecuteEx (ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start()
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start(String fileName)
at AUAlmanac.Form1.lbInfo_MouseClick(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseClick(MouseEve ntArgs e)
at System.Windows.Forms.ListBox.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AUAlmanac
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/Targy/Local%20Settings/Apps/2.0/8MOALNKY.WJK/EWVNJ26A.C6C/aual..tion_6f5451800df83779_0001.0002_a87040b7f44f bc8d/AUAlmanac.exe
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


Am I doing soomething wrong, also the all star thing also gives me an error
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 10-25-2006, 10:43 PM   #55
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Try it now, as I added an error message if it cannot find the box score in question. See if you can see if the box score is there or not.
__________________
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 10-25-2006, 11:33 PM   #56
targy
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
I figured out the problem, when I run the program I check the delete box scores and logs. Oh well. the box scores no longer exist
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 10-25-2006, 11:40 PM   #57
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Nope, not the problem.

That deletes the box scores from the season that was just archived AFTER they are copied over to the almanac.

Are you saving box scores in OOTP?
__________________
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 10-26-2006, 08:25 AM   #58
targy
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Error Will Robinson

Cannot locate C:\Documents and Settings\Targy\Desktop\Almanac\\html\box_scores\ga me_box_0.html
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 10-26-2006, 08:34 AM   #59
targy
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Does it make a difference that box scores start with the #1, there is no box_score_0
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 10-26-2006, 09:41 AM   #60
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
I see two problems. One is the // and the other is boxscore 0. Zero means it is not locating the correct game in the games file.

Back to the drawing board.

BTW, it must list some box scores, does it error on all of them? Can you go to the almanac folder for that year, click on INDEX and then go to the date of the no hitter and locate it?
__________________
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
Reply

Bookmarks


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

Forum Jump


All times are GMT -4. The time now is 06:50 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments