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 01-06-2007, 08:24 PM   #121 (permalink)
All Star Starter
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
Thanks, yeah I heard they want a better contract with better benifits. But they get their runs the old fashioned way, they earn them LOL
__________________
www.emerge180.com
targy is offline   Reply With Quote
Old 01-31-2007, 07:44 PM   #122 (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
2007 and My Utilities

At this point, I think most of my tools work on 2007. However, a lot of the utilities are no longer needed, as they are part of the game now; at least the concept.

Historical Photos are automatically brought into the game from a location where they are stored. This is very nice, however, it is not the perfect solution, as players with the same name as other players are overwritten. With the facegen, people generally may not want to use the minor league collection I was using for fictional leagues. However, some will feel the facegen is not their cup of coffee. The main purpose of AUphoto2007 will be to fine tune the photos. I have newly found photos on my server, so you can have my program grab any new found pictures to fill in the ones that are missing in your collection. It also allows you to have a different photo(s) for each player, based on the year. So, you can have a different photo for 2002 and for 2003 for the same player.

While there is a way to have OOTP automatically load in logos, it is not year related. My logo program is now part of AUPhoto2007 and puts in the correct historical logo for each team and year.

The rest of the programs should still work, once I do some minor mods to each one. That will not be done until the 2007 game is released.

The almanac is very complete in 2007, in fact way complete, if I can say that. So my almanac program will go away, but, part of it will live on. You can save the CSV files per month and/or per year and decide what files to save. So, you can now look at a player's complete history of his ratings, month by month, over his whole career.

So, once the game is released, that is when I will start to write my fun stuff. So, have your suggestions ready. This new version of OOTP has so much stuff in it, that I will have a hard time writing as many utilities that I did last year. But you know me, I will find something to program.
__________________
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 02-26-2007, 02:46 AM   #123 (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
Just an update as the game is getting close to being released.

With well over 100 new features, there may be very little for me to write utilities. Well, wrong statistic breath. I have several plans up my short sleeves.

I already wrote one program for my own pleasure. It is called LogoWatchDog. It is a program that runs in the back ground and as the end of the year comes, my program copies over historical logos. It takes about 8 seconds to do each year. So, you can run a simulation from 1901 to 1950 and when it stops, all of the teams have the historically correct logos. As a bonus, if you are using the almanac, each year almanac will have the correct logos in it. So, if you look at the almanac in 1925, you will see the Tigers with the correct logo.

I will be rewriting the Photo program to enhance the way OOTP adds photos. My program will check my server for additonal photos that I will be updating. My goal here is to have the most complete MLB photo collection available. Whereas I may have 20 pictures of Nolan Ryan and you decide which one you want to use. I also want to try to get as many pictures of each player that I can for different years. So, if I have pictures of Nolan Ryan from 1968 to 1975, my program would update your league each year, so that Nolan will age with the game. You would then be able to see Bonds head get bigger each year.

I also have a plan for more stat displaying program. Displaying stats that are not displayed in the game now. More reports that did not make the OOTP cut this year. More ways to look at stats. My HOF point program will be revamped.

One of the suggestions that I made was to be able to automatically do a CSV dump monthly and/or yearly. This feature made it and it is going to be very powerful for me. When turned on, it may slow down the simulation by adding a minute to it for each year and also use more disk space, but it creates some great possiblities for me. You could run a 50 year simulation while you are sleeping. Wake up in the morning and then get a report on a player's ratings over his entire career, month by month.

I also have a top secret project that I have been working on in my head. No details on it, but you will like it.

I do plan on taking a look at the cato situation. Mainly because I am tired of hearing that damn cato word. I plan on writing programs to enhance the online experience by creating more HTML reports and pages.

But, once the game is released, I want to take a week or two and play the game.
Comedian2004 is offline   Reply With Quote
Old 03-10-2007, 02:09 PM   #124 (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, you had a program that allowed "watching" a game, is that finished or doi you contemplate having it for 2007? i would like to syndicate such a program on my Red Sox fan site, Is something like this possible?
__________________
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 03-15-2007, 08:48 PM   #125 (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, there is something in the works for 2007.
Comedian2004 is offline   Reply With Quote
Old 03-22-2007, 06:42 PM   #126 (permalink)
All Star Starter
 
PadresFan's Avatar
 
Join Date: Dec 2001
Location: Carlsbad, CA
Posts: 1,112
Thanks: 58
Thanked 241x in 102 posts
Once you know which utilities work with 2007, and aren't already superseded by new game functionality, let me know as I would like to add them to my site.

Thanks!

EDIT: Just saw your other posts lower in the forum... I'll grab those two utilities for now, and keep an eye out for more...

Last edited by PadresFan; 03-22-2007 at 06:44 PM.
PadresFan is offline   Reply With Quote
Old 04-07-2007, 09:25 AM   #127 (permalink)
Hall Of Famer
 
StyxNCa's Avatar
 
Join Date: Dec 2004
Location: Victoria, Texas
Posts: 2,997
Thanks: 224
Thanked 177x in 105 posts
How long is it supposed to take, generally, to update player histories wirh history 6.x? It starts out quick but then quickly starts to slow to the point that when I finally decided to exit the program, a players name had been showing for 2 1/2 hours.
StyxNCa is offline   Reply With Quote
Old 04-09-2007, 04:15 AM   #128 (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, having trouble reading the pages due to color scheme, can u make it any easier with more contrasting colors for my old eyes? preciate it.
__________________
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 04-15-2007, 11:07 PM   #129 (permalink)
edm
All Star Starter
 
edm's Avatar
 
Join Date: Dec 2001
Location: Philadelphia, PA
Posts: 1,809
Thanks: 70
Thanked 47x in 35 posts
I've never used these programs or the csv export in ootp. for LogoWatchDog, it says to "Do a compete dump using the CSV format. (Commas or semi-colons can be used, either one will work)".

Where exactly is this in ootp2007?

Is it the "export data to csv files" under the import / export functions, in the league setup?

thanks
edm is offline   Reply With Quote
Old 04-16-2007, 02:04 AM   #130 (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
No, look under GAME SETUP and then under DATABASE. There is a button below that says TOOLS, click it.

You can also do it from the setup screen where the functions are.

Quote:
Originally Posted by edm View Post
I've never used these programs or the csv export in ootp. for LogoWatchDog, it says to "Do a compete dump using the CSV format. (Commas or semi-colons can be used, either one will work)".

Where exactly is this in ootp2007?

Is it the "export data to csv files" under the import / export functions, in the league setup?

thanks
__________________
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 04-16-2007, 10:10 AM   #131 (permalink)
edm
All Star Starter
 
edm's Avatar
 
Join Date: Dec 2001
Location: Philadelphia, PA
Posts: 1,809
Thanks: 70
Thanked 47x in 35 posts
Thank you. Program is working great.
edm is offline   Reply With Quote
Old 04-22-2007, 10:35 AM   #132 (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
NEW!! Subscribe to my PlanetOOTP newsletter. Get the latest on my new programs when they are released.

To join, simply send an e-mail to webcomedian@cfl.rr.com?subject=SUBSCRIBE PLANETOOTP with the subject line of SUBSCRIBE PLANETOOTP

You will get a comfirmation request back for you to replay to.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

Last edited by Comedian2004; 04-22-2007 at 05:48 PM.
Comedian2004 is offline   Reply With Quote
Old 06-18-2007, 12:52 AM   #133 (permalink)
All Star Reserve
 
Deft's Avatar
 
Join Date: Dec 2001
Posts: 789
Thanks: 0
Thanked 3x in 1 post
Is the website down? I can't seem to download any of your mods?
__________________
ATHL Louisville Jockeys (2001-present)
2002, 2007, 2010, 2012, 2014, 2015, 2020 World Champions
Consolidated Jersey Styles
Jersey and Cap GIMP/Photoshop Templates 3.0
Deft is offline   Reply With Quote
Old 06-19-2007, 09:49 AM   #134 (permalink)
All Star Starter
 
mgom27's Avatar
 
Join Date: Jul 2006
Posts: 1,633
Thanks: 44
Thanked 108x in 71 posts
Unretirement Program

Are you going to be making a Unretirement program because I have a Saved game and I want have nobody from the start be Retired but it would take me along time to Unretire the people who are Retired?
__________________
Grrrrrrrrrrrrrrrrrrrrrrrrrrrrrr!!!!
mgom27 is offline   Reply With Quote
Old 06-19-2007, 12:23 PM   #135 (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
Site is up and working fine from this end.

No, no new programs are planned. Support from the community has moved writing programs for OOTP to a low priority. I will continue to write programs for my own use, but I really am disappointed in the community's lack of participation in any of my programs. No one has sent me any new photos or logo collections, only 18 people have signed up the newsletter and I have recieved one donation of 20 bucks since the release of OOTP2007.

I now am starting to understand why Cato disappeared.
__________________
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-19-2007, 02:23 PM   #136 (permalink)
Minors (Single A)
 
Join Date: Jul 2002
Posts: 68
Thanks: 16
Thanked 0x in 0 posts
Quote:
Originally Posted by Comedian2004 View Post
Site is up and working fine from this end.

No, no new programs are planned. Support from the community has moved writing programs for OOTP to a low priority. I will continue to write programs for my own use, but I really am disappointed in the community's lack of participation in any of my programs. No one has sent me any new photos or logo collections, only 18 people have signed up the newsletter and I have recieved one donation of 20 bucks since the release of OOTP2007.

I now am starting to understand why Cato disappeared.
Hi. I am using your programs for my at-home league and really enjoy them. I admit that I haven't searched for any photos and don't have the talent to develop logos (I could search for old ones, but I haven't), but I have signed up for the newsletter (I know, not the biggest deal in the world, but I hope it shows I'm interested!). My point is that I appreciate your efforts and enjoy your programs. I hope that you will reconsider and continue sharing your programs with the community.

Or at least with me.

Oh, and make that 2 donations.
kbensel is offline   Reply With Quote
Old 06-20-2007, 02:03 AM   #137 (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 very sorry for the lack of support for all your great work, but can understand your feelings. Am 72 and on very tight budget myself so am unable to help financially, but always appreciated all you do for the game. Your utilities are the very best and I have used most and love ease of use you build into them. Very sorry to lose your fine work.
__________________
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 07-03-2007, 10:10 AM   #138 (permalink)
Minors (Triple A)
 
DaCubFan's Avatar
 
Join Date: Dec 2001
Location: Illinois
Posts: 221
Thanks: 0
Thanked 0x in 0 posts
Quote:
Originally Posted by Deft View Post
Is the website down? I can't seem to download any of your mods?
File not found on everything.
__________________
Baseball... It's the only game!!

Echelons of American Baseball: Boston Biohazard
iMLB: Chicago Cubs
DaCubFan is offline   Reply With Quote
Old 07-03-2007, 10:32 AM   #139 (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 checked a few minutes ago and found only one bad link.

I will be working on the site over the 4th while everyone else is shooting their fingers off with fireworks.
__________________
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 07-22-2007, 11:24 PM   #140 (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, you had an AUBallpark utility at one time, is it defunct?
__________________
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
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 11:11 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