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 06-17-2006, 08:30 PM   #41
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Here is an updated hitting streak and an RBI streak page.

www.sim2005.com/1957/players/hitting_streak.html
www.sim2005.com/1957/players/rbi_streak.html

Plus an inning by inning report for runs scored by all teams:

www.sim2005.com/1957/players/game_scores.html

Notice the lower amount of runs scored in the ninth. Closers do work.

Also notice the lack of extra inning games. Not sure if this is a bug 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 06-17-2006, 08:51 PM   #42
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
NOTE: Determined the lack of extra inning games to be a bug and have TT'd 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
Old 06-18-2006, 06:21 PM   #43
fantom1979
Hall Of Famer
 
fantom1979's Avatar
 
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,498
Wow, this looks great. I have played around with some of the CVS files and I just dont see where you were able to pull the no hitter and cycle data out of there. I have alot to learn

Anyways, cant wait for you to release this.
__________________

fantom1979 is offline   Reply With Quote
Old 06-18-2006, 08:19 PM   #44
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Quote:
Originally Posted by fantom1979
Wow, this looks great. I have played around with some of the CVS files and I just dont see where you were able to pull the no hitter and cycle data out of there. I have alot to learn

Anyways, cant wait for you to release this.
Who says I pulled that information from there? Trade secrets...
__________________
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 06-18-2006, 08:33 PM   #45
turdfurgeson
Major Leagues
 
turdfurgeson's Avatar
 
Join Date: Jan 2005
Posts: 421
I cant't wait to get this utility when it is all finished. That trade part alone looks great.
Plus your tutorials are very helpful (at showing me how computer backwards i am) at learning some new things.
turdfurgeson is offline   Reply With Quote
Old 06-18-2006, 09:43 PM   #46
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
I am glad to see everyone looking forward to it, hope I do not let you down!

I really need to wait until the next patch is released, since so much will change when it happens.

Here is a neat one I created.

http://www.sim2005.com/1957/players/..._Earnings.html

Total Career Earnings for the players. I made the cutoff 100 million for this list. The links work, just use the backspace or back button to return to the list.
__________________
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 06-18-2006, 09:48 PM   #47
turdfurgeson
Major Leagues
 
turdfurgeson's Avatar
 
Join Date: Jan 2005
Posts: 421
Wow thats nice! But now I feel dumb, do your player photos all show up in the SION pages, because I just get the fictional pic still (even though I get real pics everywhere else). If you know of a link where this is explained I would be very thankful.
turdfurgeson is offline   Reply With Quote
Old 06-18-2006, 10:00 PM   #48
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Download the customization file here:

http://www.ootpbaseball2006.com/down...=download&id=4

It explains everything and yes, they appear everywhere.
__________________
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 06-18-2006, 11:25 PM   #49
turdfurgeson
Major Leagues
 
turdfurgeson's Avatar
 
Join Date: Jan 2005
Posts: 421
Got it, thanks

Last edited by turdfurgeson; 06-18-2006 at 11:52 PM.
turdfurgeson is offline   Reply With Quote
Old 06-19-2006, 03:09 AM   #50
fantom1979
Hall Of Famer
 
fantom1979's Avatar
 
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,498
Quote:
Originally Posted by Comedian2004
Who says I pulled that information from there? Trade secrets...

Well, if you ever decide to go open source, let me know.
__________________

fantom1979 is offline   Reply With Quote
Old 06-19-2006, 07:20 PM   #51
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Ran it to 2005 or something like that and updated everything.

Also added more information to the salary report.

www.sim2005.com/1950t

http://www.sim2005.com/1950T/players..._Earnings.html

http://www.sim2005.com/1950T/players...-injuries.html

http://www.sim2005.com/1950T/players/no-hitters.html
__________________
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 06-23-2006, 02:06 AM   #52
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
I wrote a pretty cool routine this AM. After you create the HTML pages, you run my HOF function and it modifies all of the player HTML files for players that are in the HOF, adding a neat Hall of Fame Banner, like BF does.

Example:

http://www.sim2005.com/1950t/history...inductees.html

Click on any player.
__________________
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 06-23-2006, 10:01 AM   #53
gbmoore121
All Star Reserve
 
gbmoore121's Avatar
 
Join Date: Feb 2002
Location: Arizona
Posts: 602
I like the banner a lot. Very nice function!
gbmoore121 is offline   Reply With Quote
Old 06-24-2006, 11:44 AM   #54
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Wow everything is looking great.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 06-25-2006, 02:08 AM   #55
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 function to modify all the players HTML files to add the word ALL-STAR in red, next to their name if they made the all-star game anytime.

Going to change it to say: 5 time All-star

Also going to add 5 time MVP, etc...

NOTE: The example files of the HOF banner are messed up in the above link. I changed the size of the banner to fit in the screen, but forgot to program it to check to see if the file has already been modified. (Like if you ran the routine twice.)

I fixed the program, but unable to redo the HTML files, as OOTP dies when I try create the reports.

I will be uploading another league that I ran from 1920-sometime...
__________________
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 06-25-2006, 01:16 PM   #56
halos17
Minors (Single A)
 
halos17's Avatar
 
Join Date: Oct 2002
Location: Indianapolis, IN
Posts: 59
I'm working on some small utilities for my personal use, but am curious as to what will be changing with the patch? Like you, I don't want to get too far in and then have to change everything.

Your help/insights would be greatly appreciated!
__________________
"The man who was the spearhead of the Dodger offense throughout the year, who saved them in the LCS, will not see any action tonight, for sure." -- Vin Scully on Kirk Gibson, 1988 WS Game 1
halos17 is offline   Reply With Quote
Old 06-26-2006, 10:36 PM   #57
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Mainly the SQL dumps, and they are undocumented.

I use every output that I can find that contains information that I can use, so I basically have to check all my routines.
__________________
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 06-26-2006, 10:42 PM   #58
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
I will be ready to release my 1st version of the program after the next patch release.

So far, here is what I have done:

5+ hit report
no-hitter report
CEI report
Career salary reports
no-hitter reports
Cycle Report
HOF mod - adds HOF banner to HOF players HTML
ALL-STAR mod - adds all-star next to name if played in all-star

Discovered some bugs in the complicated trade routine, working those out. Ate a major bug and just have a couple minor ones to fix.
__________________
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 06-27-2006, 01:09 AM   #59
fantom1979
Hall Of Famer
 
fantom1979's Avatar
 
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,498
Looking good.

Thanks for the update. Hopefully the next patch wont make you change too much.
__________________

fantom1979 is offline   Reply With Quote
Old 06-29-2006, 12:05 PM   #60
f.montoya
Hall Of Famer
 
f.montoya's Avatar
 
Join Date: Nov 2004
Posts: 6,069
Back to the CEI...


04/02/1975 Chicago White Sox: J. Rice was injured in a collision at a base. The Diagnosis: Blurred Vision.

Looks like someone other than Jim Rice had blurred vision.
__________________
Fidel Montoya

Asahi2 Baseball ex-Commissioner(Historical League Since 2004)
www.allsimbaseball.com (OOTP web hosting - Customized sites for online leagues - Sign up, Connect OOTP and Play!)
Share Your Mods - Free, unlimited and easy to upload to share your Mods instantly(free site registration required)
f.montoya 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 05:56 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