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-21-2006, 01:12 PM   #41 (permalink)
Hall Of Famer
 
Giants44's Avatar
 
Join Date: Dec 2001
Posts: 2,032
Thanks: 25
Thanked 44x in 23 posts
wow - between this and factool this version has really taken off for me.

now, any way to edit/change things like MVP and Gold Glove winners???
__________________
"In a text sim - Immersion is everything"
-Me

"Judge a man not by the color of their skin, but by the content of their character"
-Martin Luther King

"Not everything that counts can be counted, and not everything that can be counted counts."
-Einstein

"The man who views the world at 50 the same as he did at 20 has wasted 30 years of his life."
-Muhammad Ali

"Baseball statistics are like a girl in a bikini. They show a lot, but not everything."
-Toby Harrah
Giants44 is offline   Reply With Quote
Old 09-21-2006, 09:41 PM   #42 (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
Why would there be a need to change that?

Quote:
Originally Posted by Giants44
wow - between this and factool this version has really taken off for me.

now, any way to edit/change things like MVP and Gold Glove winners???
__________________
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-21-2006, 11:54 PM   #43 (permalink)
Hall Of Famer
 
Giants44's Avatar
 
Join Date: Dec 2001
Posts: 2,032
Thanks: 25
Thanked 44x in 23 posts
Quote:
Originally Posted by Comedian2004
Why would there be a need to change that?
2 reasons:

1. on-line leagues that vote for their own awards and
2. god-mode owners that like to control everything including who win awards - I know it is no big deal, but for example when a mediocre SS wins the gold glove over Ozzie Smith for no good reason, it bugs me.

in previous 6x I was able to make these changes by doing the following:

for awards:
edit the individual player pages simply by opening up the p#.txt file and adding in what you want, just make sure you put 3 periods at the end of the sentence.

ie

won AOBL owners award 2003...

The txt files can be found in the players subfolder which is inside the league_News_Box folder within your league. You can also edit the leaguehistory from there as well.<o></o>

<o></o>
<o></o>
<!--[if !supportLists]-->1.edit specific file (gg,poy,etc)<!--[endif]-->
<!--[if !supportLists]-->2.edit lhistory.txt<!--[endif]-->
<!--[if !supportLists]-->3.edit player pxxx.txt<!--[endif]-->
<!--[if !supportLists]-->4.edit almanac (if necessary) <!--[endif]-->
<!--[if !supportLists]-->a.specific page<!--[endif]-->
<!--[if !supportLists]-->b.player page

for gold glove:
To change gold glove

MUST BE DONE BEFORE END OF SEASON FOR CORRECT ALAMANC
  • change lnews.txt
  • change gg.txt
  • change pxxx.txt of each player involved
<!--[endif]-->
__________________
"In a text sim - Immersion is everything"
-Me

"Judge a man not by the color of their skin, but by the content of their character"
-Martin Luther King

"Not everything that counts can be counted, and not everything that can be counted counts."
-Einstein

"The man who views the world at 50 the same as he did at 20 has wasted 30 years of his life."
-Muhammad Ali

"Baseball statistics are like a girl in a bikini. They show a lot, but not everything."
-Toby Harrah
Giants44 is offline   Reply With Quote
Old 09-22-2006, 12:27 AM   #44 (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, you can already edit any player's history, modify a record or delete a record or even add a record.

Plus, it is easy to give the same history for several players. By design, if you add a history line to a player, then pick out a different player, the other modified history line is still there. You just have to click ADD and then save..

Do you want the ability to search for all players with a certain history 'phrase' and display them?

So, you enter 'Gold Glove' as the search phrase and all players with Gold Glove in their history (for that year) are displayed, you can simply click on their name on the left and their history is displayed. Click on the Gold Glove line and it is removed, click Save and then do the next player.

Quote:
Originally Posted by Giants44
2 reasons:

1. on-line leagues that vote for their own awards and
2. god-mode owners that like to control everything including who win awards - I know it is no big deal, but for example when a mediocre SS wins the gold glove over Ozzie Smith for no good reason, it bugs me.

in previous 6x I was able to make these changes by doing the following:

for awards:
edit the individual player pages simply by opening up the p#.txt file and adding in what you want, just make sure you put 3 periods at the end of the sentence.

ie

won AOBL owners award 2003...

The txt files can be found in the players subfolder which is inside the league_News_Box folder within your league. You can also edit the leaguehistory from there as well.<O></O>

<O></O>
<O></O>
<!--[if !supportLists]-->1.edit specific file (gg,poy,etc)<!--[endif]-->
<!--[if !supportLists]-->2.edit lhistory.txt<!--[endif]-->
<!--[if !supportLists]-->3.edit player pxxx.txt<!--[endif]-->
<!--[if !supportLists]-->4.edit almanac (if necessary) <!--[endif]-->
<!--[if !supportLists]-->a.specific page<!--[endif]-->
<!--[if !supportLists]-->b.player page

for gold glove:
To change gold glove

MUST BE DONE BEFORE END OF SEASON FOR CORRECT ALAMANC
  • change lnews.txt
  • change gg.txt
  • change pxxx.txt of each player involved
<!--[endif]-->
__________________
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-22-2006, 02:26 AM   #45 (permalink)
Hall Of Famer
 
Giants44's Avatar
 
Join Date: Dec 2001
Posts: 2,032
Thanks: 25
Thanked 44x in 23 posts
I was looking to change it in the broader sense of the entire games history.

I can see with this utility how to add it to one guy and remove it from another, but I don't see any possibility for changing the league historical record, they way I was able to in the past (by editing lhistory and almanac files)

of course this is no big deal, but it would be nice to be able to do, however with this versions broader scope, this might be a bit more then is possible.

I am still holding out hope that one day Markus will add the option for us to vote for all awards ourselves.
__________________
"In a text sim - Immersion is everything"
-Me

"Judge a man not by the color of their skin, but by the content of their character"
-Martin Luther King

"Not everything that counts can be counted, and not everything that can be counted counts."
-Einstein

"The man who views the world at 50 the same as he did at 20 has wasted 30 years of his life."
-Muhammad Ali

"Baseball statistics are like a girl in a bikini. They show a lot, but not everything."
-Toby Harrah
Giants44 is offline   Reply With Quote
Old 09-22-2006, 03:22 PM   #46 (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 will look into it, there may be a way to do that.

Quote:
Originally Posted by Giants44
I was looking to change it in the broader sense of the entire games history.

I can see with this utility how to add it to one guy and remove it from another, but I don't see any possibility for changing the league historical record, they way I was able to in the past (by editing lhistory and almanac files)

of course this is no big deal, but it would be nice to be able to do, however with this versions broader scope, this might be a bit more then is possible.

I am still holding out hope that one day Markus will add the option for us to vote for all awards ourselves.
__________________
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-24-2006, 02:22 PM   #47 (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
Added a SEARCH function under BULK CHANGES.

Enter a phrase, such as GOLD GLOVE and it will search all the history files for the players and display them all on the left.

This could be handy for something.
__________________
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-24-2006, 07:02 PM   #48 (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
Added another simple mod. Click on team and it will display the HTML part of a team name. <a href... etc..

Put in a team name and their team number (listed on the left) and then you can add text in front of or in back off and the team link will work in the game.

i.e.

Rumored to be pricing houses in Boston during the offseason.

I wanted to add the 'trade rumors' from the news, but there is no date stamp on them, so I do not know when they appeared. Do those just happen during the off season?
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

Last edited by Comedian2004; 09-24-2006 at 07:04 PM.
Comedian2004 is offline   Reply With Quote
Old 04-07-2007, 12:47 AM   #49 (permalink)
Hall Of Famer
 
endgame's Avatar
 
Join Date: Aug 2002
Posts: 10,075
Thanks: 542
Thanked 498x in 285 posts
Is this particular utility compatible with v2007, Larry?
__________________
"Try again. Fail again. Fail better." -- Samuel Beckett
_____________________________________________
endgame is offline   Reply With Quote
Old 04-07-2007, 09:40 AM   #50 (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
Nope, with the history editor built in, no need for a lot of it. I will come out with a new version one day though.
Comedian2004 is offline   Reply With Quote
Old 04-08-2007, 01:01 AM   #51 (permalink)
Hall Of Famer
 
endgame's Avatar
 
Join Date: Aug 2002
Posts: 10,075
Thanks: 542
Thanked 498x in 285 posts
Quote:
Originally Posted by Comedian2004 View Post
Nope, with the history editor built in, no need for a lot of it. I will come out with a new version one day though.
Okay, I'm missing something or having a flashback. There's a player history editor built in to v2007?
__________________
"Try again. Fail again. Fail better." -- Samuel Beckett
_____________________________________________
endgame is offline   Reply With Quote
Old 04-08-2007, 05:21 AM   #52 (permalink)
Hall Of Famer
 
rasnell's Avatar
 
Join Date: Jan 2003
Posts: 3,077
Thanks: 1
Thanked 16x in 11 posts
Wow. You missed a big new feature. Just go to the player's individual history and there's the button. One of more than 100 new things to love about OOTP 2007.
__________________
Charlie Root won more games for the Cubs than any pitcher, yet was remembered for one pitch to Babe Ruth. Learn more, see rare video, and order the first biography of this Cub great as revealed by daughter Della, 90, and Roger Snell -- OOTP beta tester, Pulitzer Prize winner and author of "Root for the Cubs: Charlie Root and the 1929 Chicago Cubs." See all this at www.rootforthecubs.com.

Beta tester, OOTP 2007-2011.

Member, Society for American Baseball Research.
rasnell 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 05:11 PM.


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