Home | Webstore
Latest News: OOTP Update 20.5.52 - OOTP 20 Available - FHM 5 Available

MLB All-Star Game Special: Save 50% on OOTP 20!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > OOTP Mods > OOTP Mods - Database Tools

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

Reply
 
Thread Tools
Old 08-22-2006, 12:05 AM   #1
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
Anderson Utilities - AUAmmies

Another hot off the press.

This is still early, but have some sweet plans for this one.

http://www.sim2005.com/AUAmmie/default.htm

What this one does:
  • Loads in the league's amatuer players before the draft
  • Allows you to sort by any ratings
  • Allows you to display only certain positions (like thirdbase)
  • Hitters and pitchers in different grids
  • 31 fields for hitters
  • 42 fields for pitchers
What else will it be able to do when I add it:
  • Display draft history
  • Make it easy to track draftees
  • Whatever else I think of or what you suggest
  • Show players for fantasy draft before draft
  • Show free agents, free agents next year, wavier wire players
NOTE: The program will only display players if you run it AFTER the draft players are announced and BEFORE you run the draft. After the draft or before, it will display empty grids.
__________________
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 08-22-2006, 03:25 AM   #2
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
I did some more stuff on it.

I added a new button called DRAFT REPORT. Click on this, if you dare, and it will load in all of your draft picks over the years. NOTE: If your league is 40 or more years, it may take a minute, so be patience.

There will be several columns, 1 to as many draft rounds your league has for the ammy draft. You will see all of the draft picks in there. Click on one of their names and it will popup a career page for them.

(The career page has not been enhanced yet. It just has the year by year stats. Later, I will fill in team, league, etc. (Maybe even put splits in).

This really flew on a league with just several years of history, but when ran with a league that had 50 seasons, it was a little sluggish when sorting. I will work on that.

Also will be working on another layout, not sure if I like it.

Anyhow, give it a look at and let me know what you think.
__________________
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 08-22-2006, 07:52 AM   #3
robster1225
Hall Of Famer
 
robster1225's Avatar
 
Join Date: Jun 2006
Location: Hidd, Bahrain
Posts: 2,616
Thanks: 3
Thanked 9x in 8 posts
Make it easy to track draftees

I'm curious, does this mean that as the draft happens, we can see the progress? This would be really cool for online leagues, especially if in the future you could find a way for teams to make draft picks in the program, and then email the pick to the commissioner.
__________________
Robby Ruggles
robster1225 is offline   Reply With Quote
Old 08-22-2006, 11:00 AM   #4
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Location: Vancouver, Canada
Posts: 8,874
Thanks: 1,189
Thanked 937x in 527 posts
Quote:
Originally Posted by robster1225
Make it easy to track draftees

I'm curious, does this mean that as the draft happens, we can see the progress? This would be really cool for online leagues, especially if in the future you could find a way for teams to make draft picks in the program, and then email the pick to the commissioner.
I don't know if you're familiar with the old BOSI utility, but probably the best thing about it was its draft utility. You could login to a website that had the draftee info on it, make your draft list, and then as soon as your pick was up the program would make your pick based on your list and go on to the next person. It was great because then you didn't have to wait for the commish and the commish didn't have to try to follow the draft so closely. There were a number of things I wish were added to it (automatic email notifying the next few up and the commish, make a draft list based on different player characteristics not just by specifically identified players, etc), but as basic as it was it was great. It'd be great to have a simple program that would do just that again.
__________________
Support the one-and-done DH or the SP-only DH
(I think they're both better than both the AL and NL games)
and more flexible substitution rules.
kq76 is offline   Reply With Quote
Old 08-22-2006, 12:58 PM   #5
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
That is not what I had meant by 'track draftees', what I meant is the ability to easily look at some high or low draft picks and see how they turned out many years later.

However, you did get my brain working on thinking about something like that. If it is doable, that is the question.
__________________
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 08-22-2006, 01:00 PM   #6
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
I have updated it again.

I changed the layout to show 10 tabs, 1-10. Tab 1 shows all of the #1 picks, tab 2 shows all of round 2 picks, etc. Tab 10 shows 10 or higher. Do you think we need more than 10?

I also now have it loading hitters stats if he was a hitter and pitchers stats if he was a pitcher.

Next, I will work on enhancing the 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 08-22-2006, 01:10 PM   #7
axp113
Minors (Single A)
 
axp113's Avatar
 
Join Date: Sep 2003
Posts: 56
Thanks: 0
Thanked 0x in 0 posts
can you post an example html page of the output?
__________________
IOSBL - Philadelphia Rebels
axp113 is offline   Reply With Quote
Old 08-22-2006, 03:03 PM   #8
robster1225
Hall Of Famer
 
robster1225's Avatar
 
Join Date: Jun 2006
Location: Hidd, Bahrain
Posts: 2,616
Thanks: 3
Thanked 9x in 8 posts
Quote:
Originally Posted by Comedian2004
That is not what I had meant by 'track draftees', what I meant is the ability to easily look at some high or low draft picks and see how they turned out many years later.

However, you did get my brain working on thinking about something like that. If it is doable, that is the question.
That is a good idea as well, and I will definetely use this utility.

But, i'm hoping something like the BOSI utility that kq76 described comes out.
__________________
Robby Ruggles
robster1225 is offline   Reply With Quote
Old 08-22-2006, 05:16 PM   #9
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
NO Html output yet. But here is some screenshots of the program in action.

Eligible Draft kids:


Looking at all the #4 picks in the history:


When you click on a players name:

__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

Last edited by Comedian2004; 08-22-2006 at 05:18 PM.
Comedian2004 is offline   Reply With Quote
Old 08-24-2006, 05:57 AM   #10
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
I updated the program to add a team pull down list so you can just see the picks for a certain team.

I also added a RESTART under the FILE command. This will close the program and quickly load it again.

Use this when you want to 'start all over'.
__________________
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

Thread Tools

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 07:01 AM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

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 © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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