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 08-22-2006, 12:05 AM   #1 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
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.
__________________
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 08-22-2006, 03:25 AM   #2 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
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.
__________________
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 08-22-2006, 07:52 AM   #3 (permalink)
Hall Of Famer
 
robster1225's Avatar
 
Join Date: Jun 2006
Location: Long Branch, NJ
Posts: 2,524
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.
__________________

Total Sports World - The Place To Get Your Sports Fix!

eMLB - New York Mets
2013 - 30-23
2014 - 93-69 (First ever post season appearance for the Mets)



BLB - Los Lunas Javelinas
robster1225 is offline   Reply With Quote
Old 08-22-2006, 11:00 AM   #4 (permalink)
Moderator
 
Join Date: Nov 2002
Posts: 5,306
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.
__________________
Interactive Online League Directory - find or advertise a league today! (now OOTP9 compatible, thanks for the space jazzrack!)
Canadian Baseball League - one of the last OOTP6.5 leagues still left, running since April 2002
SGCBL - a Lord of the Rings themed league with a very friendly membership and a commish constantly looking to improve the smallest of things
kq76 is offline   Reply With Quote
Old 08-22-2006, 12:58 PM   #5 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
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.
__________________
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 08-22-2006, 01:00 PM   #6 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
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.
__________________
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 08-22-2006, 01:10 PM   #7 (permalink)
Minors (Single A)
 
axp113's Avatar
 
Join Date: Sep 2003
Posts: 56
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 (permalink)
Hall Of Famer
 
robster1225's Avatar
 
Join Date: Jun 2006
Location: Long Branch, NJ
Posts: 2,524
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.
__________________

Total Sports World - The Place To Get Your Sports Fix!

eMLB - New York Mets
2013 - 30-23
2014 - 93-69 (First ever post season appearance for the Mets)



BLB - Los Lunas Javelinas
robster1225 is offline   Reply With Quote
Old 08-22-2006, 05:16 PM   #9 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
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:

__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

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 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,378
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'.
__________________
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
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 12:23 PM.


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