Latest News: OOTP 13 Announced with Screenshots & Feature List! Pre-Order Now! - OOTP Baseball 12 Available! - iOOTP Baseball 2011 Available! - Title Bout Championship Boxing 2.5 released! - Inside the Park Baseball Patch 1.03 released, DEMO now available

Pre-Order OOTP 13, Save & Win! | OOTP 12 Off-Season Special, just $19.99!

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

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

Reply
 
LinkBack Thread Tools Display Modes
Old 09-25-2006, 07:58 PM   #1 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
Anderson Utilities - AUDraft

Ah, no rest for the programmer.

What started out as a simple thought has grown into something rather interesting.

The original plan was for online leagues to be able to see their player's ratings, so they know when to make moves and the likes. I wanted to take it a step further, ok, a couple steps. Why not have it also be a free agent report, a WW report, a team report, a position report, etc.

Well, here we now have AUDraft. The name is sort of strange, but what the heck.

It will load the entire league in a very cool fashion, then display 3 pages (so far) or information about the players. You can sort, filter and aimlessly click on stuff. It is color coded, with the better numbers getting a green color and the worse numbers getting a red color.

HTML OUTPUT! Yes, it will make 2 pages (for now), for EVERY team, that has sortable fields and also is color coded.

Here is a quick screenshot of the program: (Scroll down, more information)




Here is a link to the screenshots of the program. A must see.

http://www.planetootp.com/AUDraft/au...reenshots1.htm

Here are 2 sample outputs of the HTML screen.

http://www.planetootp.com/AUDraft/2004_Bree_Cheese.html
http://www.planetootp.com/AUDraft/20...g_ratings.html

When completed, each HTML screen will have links to the other html screens and also a link back to the 'original' site. The players names and team names will also link to the correct pages.

Coming soon!
__________________
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 09-25-2006, 09:02 PM   #2 (permalink)
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,967
Thanks: 184
Thanked 56x in 14 posts
Unbelievable, very, wery nice. Intend to use most if not all of ur utilities on my 1939 lg.

Question, how much disc space we talkin? I have a free xdrive account, 5 gb that am thibnkin of using to store ur output, What do u think of that?
__________________
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 09-25-2006, 11:24 PM   #3 (permalink)
Hall Of Famer
 
disposableheros's Avatar
 
Join Date: Jun 2004
Posts: 4,332
Thanks: 0
Thanked 0x in 0 posts
this is very cool.

one note....the arrows for the HTML sorts are backwards. descending should be down arrow and ascending should be up arrow.
__________________
2 Wild Cards, 11 Division Champs, 4 League Champs, 3 World Champs, and 3 Best GM awards

Baseball Maelstrom - New York Mets - 180-149 .547
Corporate League Baseball - Coke Buzz - 889-649 .578
Western Hemisphere Baseball League - Santiago Saints - 672-793 .459

Record - 2428-2271 .517
disposableheros is offline   Reply With Quote
Old 09-27-2006, 12:27 PM   #4 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
AUDraft is released.

http://www.planetootp.com/AUDraft/default.htm

Complete document files can be viewed up:

http://www.planetootp.com/AUDraft/help.htm

I think it is a pretty cool program that will add a little to your online league. Check it out and let me know of any problems, what you think of it and any suggestions.

Larry - The AUguy
__________________
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 09-27-2006, 01:21 PM   #5 (permalink)
All Star Reserve
 
Kyros's Avatar
 
Join Date: May 2006
Posts: 976
Thanks: 0
Thanked 1x in 1 post
Quote:
Originally Posted by Comedian2004
AUDraft is released.

http://www.planetootp.com/AUDraft/default.htm

Complete document files can be viewed up:

http://www.planetootp.com/AUDraft/help.htm

I think it is a pretty cool program that will add a little to your online league. Check it out and let me know of any problems, what you think of it and any suggestions.

Larry - The AUguy
Thanks again for all of your hard work and great utlities.

Will this be useful for offline leagues as well?

Thanks!!!
Kyros is offline   Reply With Quote
Old 09-27-2006, 01:50 PM   #6 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
Yes, it can be a very handy tool to examine the players of the league for offline leagues. In fact, the HTML was added last. The HTML is really just used for on line leagues, but can be used for off line also.
__________________
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 09-28-2006, 07:11 PM   #7 (permalink)
DBR
Minors (Double A)
 
Join Date: Jun 2006
Posts: 159
Thanks: 7
Thanked 0x in 0 posts
found my mistake
__________________
EBL/SBM Commish
AIM- SBMnats
email- garycurrier@gmail.com

Last edited by DBR; 09-28-2006 at 07:19 PM.
DBR is offline   Reply With Quote
Old 09-28-2006, 08:27 PM   #8 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
Small problem, when I load the league it works great but then I clicked on C and it has now been sorting for about 5 minutes
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-29-2006, 01:04 PM   #9 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
bump
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-29-2006, 01:12 PM   #10 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
Does it just happen when you click on C?

Does it ever get done sorting?

Quote:
Originally Posted by targy
Small problem, when I load the league it works great but then I clicked on C and it has now been sorting for about 5 minutes
__________________
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 09-29-2006, 01:26 PM   #11 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
No it happens when I try to sort by postion and it never finishes
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-29-2006, 03:46 PM   #12 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
OK, I will look into it today and see if I can see a problem.

Are you picking a team first, or just loading and then hitting C after the page is colored?

Quote:
Originally Posted by targy
No it happens when I try to sort by postion and it never finishes
__________________
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 09-29-2006, 04:26 PM   #13 (permalink)
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,967
Thanks: 184
Thanked 56x in 14 posts
Larry, am starting a 1939 league with finances off and all players in lg show up as free agents. It sorts for me but the blue sort bar stays in middle of screen
__________________
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 09-29-2006, 04:59 PM   #14 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
OK, just updated the program. Give it a try now.

The problem was that I added the team display option AFTER I had the position option working. It was leaving that sort routine because no team was selected and it was not closing the blue bar status window.

See if this solves your problem Targy.
__________________
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 09-29-2006, 05:02 PM   #15 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
I may have to redo that free agent and draft only part, I will look at that later on.

Quote:
Originally Posted by kagnew35
Larry, am starting a 1939 league with finances off and all players in lg show up as free agents. It sorts for me but the blue sort bar stays in middle of screen
__________________
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 09-29-2006, 05:57 PM   #16 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
That did it, Thanks
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-30-2006, 01:19 AM   #17 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
I updated the program a couple of minutes ago to change some of the color coding.

Most of the ratings in the OOTP game are the same from league to league, like stealing value, but some ratings, like Offensive Value, or talent_value vary from league to league. We have not an idea how these numbers are generated. But one league may have a player with a 1400 rating as being the highest in the league, while another league may have the highest player with only a 900. The color coding was based on a 1-1600 scale basically. I have now changed it work another way for these ratings.

It takes the highest rated player in that field, let's say it was 1600. It divides that number by 4 to give a value I call vmax.

Now, for the best color rating, dark green, it takes the highest rating and subtracts half of vmax, so in this case, it would be:

1400-xxxx

Now, the 2nd color, a lighter green would be

(vmax times 3) to (highest rating - (vmax /2)) -1
or
1200-1399

then: (yellow)
(vmax times 2) to (highest rating - (vmax * 3) -1
or
800-1199

then: (lightpink)
vmax to (vmax *2) -1
or
400 to 799

Then: (indianred)

1 to 399

This way, you have about 5 in the top color, and the rest vary.

This update just is for the on the screen coloring, I will do the HTML re-coloring next and then add the pitchers rating page that I forgot about.
__________________
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 09-30-2006, 12:05 PM   #18 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
I have now added the pitchers HTML code.

I have to tweak the draft report and the free agent report still. It will work for some leagues, but not other leagues.
__________________
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 09-30-2006, 09:46 PM   #19 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
I get an error with this program when I open it

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 : file:///C:/Documents%20and%20Settings/Targy/Desktop/Anderson%20Utilities%202005%20-%20AUDraft.appref-ms

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of C:\Documents and Settings\Targy\Desktop\Anderson Utilities 2005 - AUDraft.appref-ms 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
* [9/30/2006 8:38:00 PM] : Activation of C:\Documents and Settings\Targy\Desktop\Anderson Utilities 2005 - AUDraft.appref-ms has started.

ERROR DETAILS
Following errors were detected during this operation.
* [9/30/2006 8:38:00 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.ApplicationActivator .ProcessOrFollowShortcut(String shortcutFile, TempFile& deployFile)
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.
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 09-30-2006, 10:25 PM   #20 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
Odd... I did not add any new components to this and it worked for you before.

Is IE your default browser? If not, change the default to IE and see if it works.

Or...

Try uninstalling it from the control panel and then installing it again.

Is IE your default browser? If not, change the default to IE and see if it works.
__________________
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
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 06:14 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
Copyright © 2009 Out of the Park Developments