Latest News: OOTP PATCH 9.1.2 released! - 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 09-27-2006, 05:58 AM   #1 (permalink)
Hall Of Famer
 
rasnell's Avatar
 
Join Date: Jan 2003
Posts: 2,580
How about Anderson Utilities - AU Purge?

Look at message #7 in this thread...

Deleting Messages

Any chance, Webcomedian, that you can come up with a quick utility that allows us to purge the messages, news, etc. every 10 years or so?

It is amazing how dramatically the game slows down, almost to the point of unplayability. Everything was solved by following this thread. But a handy new Anderson Utility would really be a snap.
rasnell is offline   Reply With Quote
Old 09-27-2006, 11:29 AM   #2 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,297
Putting on my AUcostume. (Blue tights with a giant AU on the shirt)

Sounds like an easy one.

Let me know what files it should delete (I will move them to another location), as I got lost in that thread.
__________________
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 09-27-2006, 06:10 PM   #3 (permalink)
Hall Of Famer
 
rasnell's Avatar
 
Join Date: Jan 2003
Posts: 2,580
Look at msg #7 in the thread and it gives the specifics and warnings.
rasnell is offline   Reply With Quote
Old 09-27-2006, 08:20 PM   #4 (permalink)
bp_
Hall Of Famer
 
bp_'s Avatar
 
Join Date: Apr 2004
Location: Philadelphia
Posts: 2,388
yeah, this would be a nice tool for those that are worried to go digging in their folders. Good idea.
bp_ is offline   Reply With Quote
Old 09-27-2006, 08:21 PM   #5 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,297
AUPurge - here ya go...

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

It will let you optionally delete the messages, PbP and box scores.

It makes a backup copy under a pre-picked folder.

I hate to see history deleted, but knock yourself out.
__________________
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 09-27-2006, 09:10 PM   #6 (permalink)
Hall Of Famer
 
rasnell's Avatar
 
Join Date: Jan 2003
Posts: 2,580
I'll try it tomorrow, but this is just incredible how well and how quickly you develop these valuable utilities.

For how flawed the release of OOTP 2006 was, I really think you have bailed it out in many ways by making it much easier to implement logos, faces, etc. because of your utilities.

And AUPurge is a perfect example of a critical utility needed to fix the horrendous game slowdowns after a number of years of simming.

I wished you were a co-game developer with Markus. We'd probably have a fully functioning game.
rasnell is offline   Reply With Quote
Old 09-27-2006, 09:17 PM   #7 (permalink)
Hall Of Famer
 
rasnell's Avatar
 
Join Date: Jan 2003
Posts: 2,580
This is so super I didn't have to wait until tomorrow to test. Zipped right through. Worked like a charm.

Just one thing: Add the option to delete the league news, too. You missed that one. Please make sure NOT to touch the player news folder or you'll lose the player histories. You did it right with this first version, except for skipping the league news folder.
rasnell is offline   Reply With Quote
Old 09-27-2006, 09:21 PM   #8 (permalink)
Hall Of Famer
 
1998 Yankees's Avatar
 
Join Date: Aug 2006
Location: Yankee Stadium
Posts: 5,588
Quote:
Originally Posted by Comedian2004
AUPurge - here ya go...

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

It will let you optionally delete the messages, PbP and box scores.

It makes a backup copy under a pre-picked folder.

I hate to see history deleted, but knock yourself out.
When you say PbP, you mean game logs, I assume. Question: Did you include anything from the news\txt\leagues and news\txt\teams files? If so, how selective were you (transaction and injury logs vs. news)? Some people may want some things and not others.

Speed issues may come from having to address the thousands of files that end up in these folders, but I know for sure that folder size issues definitely come from them, so your effort is appreciated. And nice touch about backing things up in the process. Thanks.

Edit - I see rasnell answered my question in the meantime. If you do as he requests, I urge you to work in some selectivity as far as what types of items, for both league and team, will be deleted from news folders.

Last edited by 1998 Yankees : 09-27-2006 at 09:37 PM.
1998 Yankees is offline   Reply With Quote
Old 09-27-2006, 09:43 PM   #9 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,297
First of all, nothing is deleted, just moved to your backup folder. You can see exactly what was moved by looking there.

C:\backups\1975A.lg\box_scores (I only do files that match game_box*.html
C:\backups\1975A.lg\leagues (I only do files that match log*.txt
C:\backups\1975A.lg\messages (I only do files that match message*.txt

I originally had the news folder as an option, but when I browsed it, I was not sure what could be kept and what what could not be kept, or should be kept.

If someone could do some research on a league that is a few years old and see how deleting files from this folder affects the OOTP program, then I can add the ability to do those folders.
__________________
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 09-27-2006, 10:07 PM   #10 (permalink)
All Star Starter
 
Join Date: Sep 2003
Location: Las Vegas
Posts: 1,250
Yet again Larry fixes an OOTP error. If it weren't for these Utilities OOTP2006 would be completely unplayable. Larry's stuff is free but those clowns at SI charge us $39.95...yeah that makes sense!
Cowboys3356 is offline   Reply With Quote
Old 09-27-2006, 10:09 PM   #11 (permalink)
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Medford, MA
Posts: 2,861
Quote:
Originally Posted by Cowboys3356
Yet again Larry fixes an OOTP error. If it weren't for these Utilities OOTP2006 would be completely unplayable. Larry's stuff is free but those clowns at SI charge us $39.95...yeah that makes sense!
I agree that Larry's Utilities are awesome and free!

That's about it.
__________________
Check out my Fictional Uniform Project!
http://s76.photobucket.com/albums/j1...007%20Jerseys/

Also, Check out my collection of Circular OOTP logos (Kudos to cephasjames for his original logos)
http://s76.photobucket.com/albums/j10/silvam14/

My fictional Solo Universe reports (USBL)
https://home.comcast.net/~silvam14/index.html
silvam14 is offline   Reply With Quote
Old 09-27-2006, 10:30 PM   #12 (permalink)
Hall Of Famer
 
1998 Yankees's Avatar
 
Join Date: Aug 2006
Location: Yankee Stadium
Posts: 5,588
Quote:
Originally Posted by Comedian2004
First of all, nothing is deleted, just moved to your backup folder. You can see exactly what was moved by looking there.

C:\backups\1975A.lg\box_scores (I only do files that match game_box*.html
C:\backups\1975A.lg\leagues (I only do files that match log*.txt
C:\backups\1975A.lg\messages (I only do files that match message*.txt

I originally had the news folder as an option, but when I browsed it, I was not sure what could be kept and what what could not be kept, or should be kept.

If someone could do some research on a league that is a few years old and see how deleting files from this folder affects the OOTP program, then I can add the ability to do those folders.
I can tell you that I deleted everything in those news\txt\leagues and news\txt\teams folders, knowing exactly what I was doing, and my game runs fine and game file space needs are way down.

However: 1) This is my game only, a sample of one - hardly scientific, and 2) I made the choice not to have any of this stuff available and I have not missed it. Others may want some of it, hence my continued urging to be careful about deleting folder contents without looking. Your approach seems to address that concern, however, by not deleting but moving stuff to another folder.

Anyway, my final word on this matter: Caution.
1998 Yankees is offline   Reply With Quote
Old 09-28-2006, 05:08 AM   #13 (permalink)
Hall Of Famer
 
rasnell's Avatar
 
Join Date: Jan 2003
Posts: 2,580
I agree with 1998 Yankees. What is deleted causes no problems for me. I would just add the news/league/txt to the list of items that you're removing, Larry.

Also Larry, are any of these removed files required by your other utilities or does the CSV dump take care of everything for all other AU utilities?
rasnell is offline   Reply With Quote
Old 09-28-2006, 10:07 AM   #14 (permalink)
All Star Reserve
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 942
Question

I deleted all the messages and when I go back into the game the messages are gone but the dates of the messages I deleted are still there
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit for going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 25 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 09-28-2006, 10:45 AM   #15 (permalink)
Hall Of Famer
 
eriqjaffe's Avatar
 
Join Date: May 2003
Location: Slatten Island
Posts: 4,311
Quote:
Originally Posted by Cowboys3356
Yet again Larry fixes an OOTP error. If it weren't for these Utilities OOTP2006 would be completely unplayable. Larry's stuff is free but those clowns at SI charge us $39.95...yeah that makes sense!
But you should see how many SI employees can fit inside a Volkswagen.
__________________
Quote:
Originally Posted by Gastric ReFlux View Post
I'm trying to help you here. Eriq is notoriously obscure and we've been working for years at mainstreaming him. All I suggest is that you try to be a bit more lenient with him as he tries to normalize, as I believe supportive criticism will be more warmly received by Eriq than if he is made to feel threatened.
eriqjaffe is offline   Reply With Quote
Old 09-28-2006, 11:59 AM   #16 (permalink)
Hall Of Famer
 
silvam14's Avatar
 
Join Date: Apr 2004
Location: Medford, MA
Posts: 2,861
Quote:
Originally Posted by targy
Question

I deleted all the messages and when I go back into the game the messages are gone but the dates of the messages I deleted are still there
I believe you need to delete messages.dat and let the game create a new blank one. This should solve your problem
__________________
Check out my Fictional Uniform Project!
http://s76.photobucket.com/albums/j1...007%20Jerseys/

Also, Check out my collection of Circular OOTP logos (Kudos to cephasjames for his original logos)
http://s76.photobucket.com/albums/j10/silvam14/

My fictional Solo Universe reports (USBL)
https://home.comcast.net/~silvam14/index.html
silvam14 is offline   Reply With Quote
Old 09-28-2006, 12:45 PM   #17 (permalink)
All Star Reserve
 
targy's Avatar
 
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 942
Thanks worked great
__________________
If you own a business and have a lawsuit or judgment pending against your company and do not want to pay the high price of an attorney. I can stop the judgment or lawsuit for going forward. I can reduce the settlement by almost half and if both parties do not agree on the settlement amount there is no fee...We keep the attorneys away and the case out of court...The company I work for has 25 years of experience in negotiating settlements.....
targy is offline   Reply With Quote
Old 12-08-2006, 04:12 PM   #18 (permalink)
Major Leagues
 
Join Date: Nov 2005
Posts: 496
Quote:
Originally Posted by Comedian2004 View Post
First of all, nothing is deleted, just moved to your backup folder. You can see exactly what was moved by looking there.

C:\backups\1975A.lg\box_scores (I only do files that match game_box*.html
C:\backups\1975A.lg\leagues (I only do files that match log*.txt
C:\backups\1975A.lg\messages (I only do files that match message*.txt

I originally had the news folder as an option, but when I browsed it, I was not sure what could be kept and what what could not be kept, or should be kept.

If someone could do some research on a league that is a few years old and see how deleting files from this folder affects the OOTP program, then I can add the ability to do those folders.
No chance of getting a Mac version huh?
DaMook is offline   Reply With Quote
Old 12-08-2006, 07:42 PM   #19 (permalink)
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,297
Not unless someone sends me a Mac. (And no McDonald coupons please)

Quote:
Originally Posted by DaMook View Post
No chance of getting a Mac version huh?
__________________
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 04-28-2007, 11:04 AM   #20 (permalink)
bp_
Hall Of Famer
 
bp_'s Avatar
 
Join Date: Apr 2004
Location: Philadelphia
Posts: 2,388
will this util be updated for 07? I've seen a few people mention they are having problems with large file sizes again on the tech support forum.
bp_ 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 05:31 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