Latest News: OOTP PATCH 9.2.2 released - buy before Oct. 17th and save $10! - 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-16-2006, 06:28 PM   #1 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
Anderson Utilities - AUHistory

I am at it again.

AUHistory is a quick and easy way to add a line to a player's history.

When you run the program and pick a league, it will display in alphabetical order, all of the players in the league. Click on one of their names and you will see this player's history in the pane below.

There is a date picker that you can use to pick any date in history and also a line to add the history you want to add. It sorts it correctly and then you can save it back to the drive. The default date for the date picker is the date of the last transaction in this guy's history. (Quite tricky to do that!)

This is an early version of the program. But it does work, if you want to add a line of history to his file. It basically just modifies the player_##_history.txt file for the player.

http://www.sim2005.com/AUHistory/

NOTE: Do not enter a date past the current date of the league. I am not sure what will happen. Nothing I think. But I will be adding a trap to not allow that to happen.

Future features:

Show players for one team only.
Allow multiple selection of players and add the same history to all selected players.
All you to add a line to every player's history.
Ability to delete history lines.
Ability to modify existing history lines.

__________________
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-16-2006 at 06:29 PM.
Comedian2004 is offline   Reply With Quote
Old 08-16-2006, 11:20 PM   #2 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
Updated the program.

- Added a team list. You can just display players from a team(s)
- Added the ability to edit existing lines and also delete existing lines

When you click on a player's name, his history, if it exists is shown below. You can type some text in the above window and press add and it will add it to his history. Be sure and select a date or it will default to the date of his newest history item.

To Edit: Click on one of the history lines. It will remove that history line and put it in the edit window. You can delete it or edit it and then click on SAVE and it will be saved.

You can load multiple teams by not clearing out the team list.
__________________
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-17-2006, 11:23 AM   #3 (permalink)
Minors (Double A)
 
Burto1945's Avatar
 
Join Date: Oct 2003
Location: Springfield, IL
Posts: 130
Great utility Comedian. One thing you might want to add to your description though. When you click on a line of history, you can then edit it, but you have to hit 'ADD' to put it back into a person's history file, and then hit save. Hitting save by itself doesn't add the line back in (I know because I lost a line of text before I realized what i needed to do.)

One more thing: I'm not sure why this is happening, but when I open a team, I still show players that I have traded away, and do not show players that I have traded for. In my example, I traded away Jacque Jones from the Cubs for Rondell White (KC), but neither show up on their new teams.

*EDIT* Nevermind about players not showing up after trades, I hadn't updated my CSV dump. It works fine now, great job, even if this is a work-in-progress.
__________________
"Baseball. The Boston Celtics and the Los Angeles Lakers could be playing for the championship, and I'd rather be here watching the Angels and Yankees."
--John Wooden, on his favorite sport (Los Angeles Times)
--------------------------------------
There's just no easy way to say
That everything you thought was right was wrong today
That is all, go away

--'That Is All' by Slobberbone
Burto1945 is offline   Reply With Quote
Old 08-17-2006, 01:34 PM   #4 (permalink)
Minors (Double A)
 
LeafsFan2005NC's Avatar
 
Join Date: Mar 2005
Posts: 108
One thing I'm noticing is that the box displaying the game generated history is displaying past the end of the window.

Also the team drop down doesn't seem to update if you change your league.
__________________
Download my OOTP 6 to OOTP 2006 Schedule Converter:

http://www.ootpdevelopments.com/boar...d.php?t=121664

Last edited by LeafsFan2005NC : 08-17-2006 at 01:43 PM.
LeafsFan2005NC is offline   Reply With Quote
Old 08-17-2006, 02:08 PM   #5 (permalink)
Hall Of Famer
 
Join Date: Dec 2001
Location: My Computer
Posts: 7,144
Quote:
Originally Posted by LeafsFan2005NC
Also the team drop down doesn't seem to update if you change your league.
Make sure you update your CSV dump.
Scott Vibert is offline   Reply With Quote
Old 08-17-2006, 02:23 PM   #6 (permalink)
Hall Of Famer
 
dougaiton's Avatar
 
Join Date: Mar 2003
Location: Location:
Posts: 3,411
This looks fantastic!
dougaiton is offline   Reply With Quote
Old 08-17-2006, 02:58 PM   #7 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
Updated:

- Made display window smaller and added scroll bars to bottom window.
- Added players name display at top
- Removed popup for players with no history. A file is automatically created now, just add what you want and click save.

New feature I am thinking of:

The ability to 'randomly' add colorful history to the history file.

A list of random events is created. The program runs through the list and randomly picks things and assigns it to random players. It could be stuff like 'Grandmother dies', 'Busted for smoking pot with groundskeeper', "bat broke, exposing cork, was fined'

It would add your custom list to the history. Color your world a little.

Anyone up for a challenge? Create a random history list? If so, it would need to contain quite a few entries, to make it interesting. Avoid phrases that could not make sense, like injuries or suspending someone for 3 days, as it could not work with certain people.

If you create something, follow this format:

8 Made local headlines when caught driving 100 MPH.
2 Fell off donkey in pregame show, made fool of self.

Where the number is the freq. All the numbers will be added up and that is the freq of how often an event can happen. Let's say it totals 150 and the number is 8. That would be a 8 in 150 chance of it happening.

Think of all those things that you hear about with players that 'could' have an effect on a player. Late for practice, locker room scuffle, drug investigation, marriage problems, divorce, kids born, relatives dying, grew beard, shaved head.
__________________
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-17-2006 at 03:02 PM.
Comedian2004 is offline   Reply With Quote
Old 08-17-2006, 03:01 PM   #8 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
Quote:
Originally Posted by LeafsFan2005NC
One thing I'm noticing is that the box displaying the game generated history is displaying past the end of the window.

Also the team drop down doesn't seem to update if you change your league.
Have not figured out the problem with the team drop down after switching yet.
__________________
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-21-2006, 02:38 PM   #9 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
No interest in the random events?
__________________
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-21-2006, 07:16 PM   #10 (permalink)
Minors (Rookie Ball)
 
MetsFrigginFan's Avatar
 
Join Date: Jul 2004
Posts: 28
all of your programs wont.i open the program and it says it cannot find the path to the saved games. what shall i do?
MetsFrigginFan is offline   Reply With Quote
Old 08-21-2006, 09:00 PM   #11 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
Quote:
Originally Posted by MetsFrigginFan
all of your programs wont.i open the program and it says it cannot find the path to the saved games. what shall i do?
I need more details. Where is your game located at for starters.

Are you doing a CSV dump?
__________________
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-21-2006, 09:22 PM   #12 (permalink)
Minors (Rookie Ball)
 
MetsFrigginFan's Avatar
 
Join Date: Jul 2004
Posts: 28
Quote:
Originally Posted by Comedian2004
I need more details. Where is your game located at for starters.

Are you doing a CSV dump?
doing a csv dump its located on my c drive

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

************** Exception Text **************
System.IO.PathTooLongException: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.
at System.IO.Path.NormalizePathFast(String path, Boolean fullCheck)
at System.IO.Path.GetFullPathInternal(String path)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)
at System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize)
at System.IO.StreamReader..ctor(String path)
at AUHistory.Form1.Form1_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Mes sage& m)
at System.Windows.Forms.ContainerControl.WndProc(Mess age& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.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
----------------------------------------
AUHistory
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Documents%20and%20Settings/Administrator.RETESTRAK/Local%20Settings/Apps/2.0/HRD2OLL2.RGQ/R7MV34NE.046/auhi..tion_21c953a19f57ad9f_0001.0001_505ff07dd299 8ccd/AUHistory.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:





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.
MetsFrigginFan is offline   Reply With Quote
Old 08-21-2006, 10:21 PM   #13 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
CodeBase: file:///C:/Documents%20and%20Settings/Administrator.RETESTRAK/Local%20Settings/Apps/2.0/HRD2OLL2.RGQ/R7MV34NE.046/auhi..tion_21c953a19f57ad9f_0001.0001_505ff07dd299 8ccd/AUHistory.exe

Here is the key.

Where did my program get installed? It looks like it is under a random name folder.

How did you install the program?
__________________
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, 09:12 AM   #14 (permalink)
Minors (Rookie Ball)
 
MetsFrigginFan's Avatar
 
Join Date: Jul 2004
Posts: 28
Quote:
Originally Posted by Comedian2004
CodeBase: file:///C:/Documents%20and%20Settings/Administrator.RETESTRAK/Local%20Settings/Apps/2.0/HRD2OLL2.RGQ/R7MV34NE.046/auhi..tion_21c953a19f57ad9f_0001.0001_505ff07dd299 8ccd/AUHistory.exe

Here is the key.

Where did my program get installed? It looks like it is under a random name folder.

How did you install the program?
i went to the website and clicked install from the website then it installed
never once asking for a permeant folder and all that jazz.
MetsFrigginFan is offline   Reply With Quote
Old 08-23-2006, 08:11 PM   #15 (permalink)
Minors (Double A)
 
LeafsFan2005NC's Avatar
 
Join Date: Mar 2005
Posts: 108
Yes, I've noticed these things in the deployment of my own programs. It seems Microsoft doesn't want end-users to choose where programs are installed. I've looked everywhere and can't figure out how to choose an install location for the end-user.

EDIT: Okay, I was upset so I checked this out. It appears Microsoft really doesn't want the end-user to choose the install directory. They claim this is all to ensure applications are "safe, reversible, and easy to administer".

I call BS on this one. Guess we'll have to go with an MSI installer at some point.
__________________
Download my OOTP 6 to OOTP 2006 Schedule Converter:

http://www.ootpdevelopments.com/boar...d.php?t=121664

Last edited by LeafsFan2005NC : 08-23-2006 at 09:19 PM.
LeafsFan2005NC is offline   Reply With Quote
Old 08-24-2006, 02:56 AM   #16 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
Metsfan...

What is your default browser? If it is not IE, then change it to IE when you install the program. You can change it back after the installation. See if that works. I will have a free standing installation soon.
__________________
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-24-2006, 06:07 AM   #17 (permalink)
Moderator*
 
sporr's Avatar
 
Join Date: Dec 2001
Location: Muscatine, IA
Posts: 8,222
Great utility. Now a question that I'm reposting from another forum:

First off, I'm not a programmer so it's very possible I'm overlooking something here.

Wouldn't it be possible to write a utility that converts the old player history over to the new format so that it could be brought over to the new game?

Line from old player text file:

Injured on 8/21/2014 with a Stiff Knee, out for one week...

Line from new player text file (same news)
:

20140821 Injured (Stiff Knee), out one week.

It would seem simple enough for a program to rearrange the order of the text lines from the old player history text file to get them into the new format. Then it would be a process of matching a player ID from the old engine with a player ID from the new (maybe using the player's name in the csv dump?).

Is it really that much more complicated than that?
__________________


Baseball Maelstrom - Commish/ St Louis Cardinals
USBA - Las Vegas Scorpions

sporr is offline   Reply With Quote
Old 08-24-2006, 09:50 AM   #18 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,396
I am up for the challenge.

I do not have any 6.x leagues, so I need someone to supply me with the data.

I will need someone to zip up their 6.x league and send it to me. I will then import it and see what I can do.

I would rather have a smaller league in years (maybe 5-10 years in length,

Let me know if you have the test data.



Quote:
Originally Posted by sporr
Great utility. Now a question that I'm reposting from another forum:

First off, I'm not a programmer so it's very possible I'm overlooking something here.

Wouldn't it be possible to write a utility that converts the old player history over to the new format so that it could be brought over to the new game?

Line from old player text file:

Injured on 8/21/2014 with a Stiff Knee, out for one week...

Line from new player text file (same news):

20140821 Injured (Stiff Knee), out one week.

It would seem simple enough for a program to rearrange the order of the text lines from the old player history text file to get them into the new format. Then it would be a process of matching a player ID from the old engine with a player ID from the new (maybe using the player's name in the csv dump?).

Is it really that much more complicated than that?
__________________
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-24-2006, 12:54 PM   #19 (permalink)
Minors (Double A)
 
Join Date: Jun 2005
Posts: 127
got a league

I will send you a league if oyu want, its in the year 2017 hope that good enough
ricobrown is offline   Reply With Quote
Old 08-29-2006, 07:30 PM   #20 (permalink)
Hall Of Famer
 
rasnell's Avatar
 
Join Date: Jan 2003
Posts: 2,661
I can't get it to work. Fresh CSV dump. Loads correct league and immediately throws the errors. Never displays players or really anything else.

Every time I open the application, I get the immediate error screen. Even worse, the AU History application screen is embedded on my desktop and cannot be closed. It's stuck there. I can go to other applications and it fades to the background, but, returning to the desktop, it's stuck in place.

Can't get rid of it with ctl/alt/delete (end program, end application or end process for auhistory.exe.) Wow! Help!

Last edited by rasnell : 08-29-2006 at 07:35 PM.
rasnell 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 10:47 AM.


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