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 08-24-2008, 02:52 PM   #1 (permalink)
Minors (Double A)
 
whizkid1950's Avatar
 
Join Date: Feb 2004
Location: Durham, NC
Posts: 154
Thanks: 7
Thanked 0x in 0 posts
player history editing

Back in the days of OOTP 6.5 I used Pierre's excellent utilities to make changes to player data, usually past-season stats. Is there a tool yet to do the same for OOTP9?

I'm not sql savvy but my desire is to go through my players.dat and convert every reference of year '2005' to year '1957'. If anyone can even point me to a utility outside of OOTP that will do that as a batch process, I'd be one happy camper.
whizkid1950 is offline   Reply With Quote
Old 08-24-2008, 04:14 PM   #2 (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
Yep, I have one.

Anderson Utilities for OOTP2007

Go to page 2 and scroll down to AUPlayersHistory2007

Make sure you go to the site with IE and not FIREFOX.

You can edit individual players history, add random events, add items, like Walkoff Home runs, and, what you want. A bulk search and replace.

Back up the history folder before doing it, in case you make a boo boo.

It will work for version 9.
__________________
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-24-2008, 04:40 PM   #3 (permalink)
All Star Starter
 
SittingDuck's Avatar
 
Join Date: Apr 2007
Location: Richmond, VA
Posts: 1,834
Thanks: 0
Thanked 0x in 0 posts
WOW. Just used that for the first time in a bulk process. That's incredible.

Man, I really am looking forward to your converting some of the other programs!
SittingDuck is offline   Reply With Quote
Old 08-25-2008, 12:04 AM   #4 (permalink)
Minors (Double A)
 
whizkid1950's Avatar
 
Join Date: Feb 2004
Location: Durham, NC
Posts: 154
Thanks: 7
Thanked 0x in 0 posts
Quote:
Originally Posted by Comedian2004 View Post
Yep, I have one.

Anderson Utilities for OOTP2007

Go to page 2 and scroll down to AUPlayersHistory2007

Make sure you go to the site with IE and not FIREFOX.

You can edit individual players history, add random events, add items, like Walkoff Home runs, and, what you want. A bulk search and replace.

Back up the history folder before doing it, in case you make a boo boo.

It will work for version 9.
Thanks! I thought of AU initially but wasn't sure it was OOTP9-friendly.
whizkid1950 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:05 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