|
|||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|
#1 (permalink) |
|
Hall Of Famer
Join Date: Jan 2003
Posts: 3,106
Thanks: 1
Thanked 23x in 16 posts
|
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. |
|
|
|
|
|
#2 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,895
Thanks: 0
Thanked 27x in 17 posts
|
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.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
#4 (permalink) |
|
Hall Of Famer
Join Date: Apr 2004
Location: Philadelphia
Posts: 2,642
Thanks: 54
Thanked 23x in 11 posts
|
yeah, this would be a nice tool for those that are worried to go digging in their folders. Good idea.
__________________
"al Qaeda wouldn't last a day in parts of Philadelphia" - Mayor Michael Nutter |
|
|
|
|
|
#5 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,895
Thanks: 0
Thanked 27x in 17 posts
|
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.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
#6 (permalink) |
|
Hall Of Famer
Join Date: Jan 2003
Posts: 3,106
Thanks: 1
Thanked 23x in 16 posts
|
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. |
|
|
|
|
|
#7 (permalink) |
|
Hall Of Famer
Join Date: Jan 2003
Posts: 3,106
Thanks: 1
Thanked 23x in 16 posts
|
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. |
|
|
|
|
|
#8 (permalink) | |
|
Hall Of Famer
Join Date: Aug 2006
Location: Yankee Stadium, back in 1998.
Posts: 8,364
Thanks: 442
Thanked 651x in 435 posts
|
Quote:
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. |
|
|
|
|
|
|
#9 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,895
Thanks: 0
Thanked 27x in 17 posts
|
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.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
#10 (permalink) |
|
All Star Starter
Join Date: Sep 2003
Posts: 1,382
Thanks: 8
Thanked 5x in 5 posts
|
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!
|
|
|
|
|
|
#11 (permalink) | |
|
Hall Of Famer
Join Date: Apr 2004
Location: Medford, MA
Posts: 4,219
Thanks: 286
Thanked 1,693x in 530 posts
|
Quote:
That's about it.
__________________
Senior "Nancy Boy" of the OOTP Boards _______________________________________________ Check out my Fictional Uniform Project! http://s76.photobucket.com/albums/j1...007%20Jerseys/ |
|
|
|
|
|
|
#12 (permalink) | |
|
Hall Of Famer
Join Date: Aug 2006
Location: Yankee Stadium, back in 1998.
Posts: 8,364
Thanks: 442
Thanked 651x in 435 posts
|
Quote:
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. |
|
|
|
|
|
|
#13 (permalink) |
|
Hall Of Famer
Join Date: Jan 2003
Posts: 3,106
Thanks: 1
Thanked 23x in 16 posts
|
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? |
|
|
|
|
|
#14 (permalink) |
|
All Star Starter
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
|
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
__________________
www.emerge180.com |
|
|
|
|
|
#15 (permalink) | |
|
Hall Of Famer
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 5,236
Thanks: 15
Thanked 337x in 174 posts
|
Quote:
|
|
|
|
|
|
|
#16 (permalink) | |
|
Hall Of Famer
Join Date: Apr 2004
Location: Medford, MA
Posts: 4,219
Thanks: 286
Thanked 1,693x in 530 posts
|
Quote:
__________________
Senior "Nancy Boy" of the OOTP Boards _______________________________________________ Check out my Fictional Uniform Project! http://s76.photobucket.com/albums/j1...007%20Jerseys/ |
|
|
|
|
|
|
#17 (permalink) |
|
All Star Starter
Join Date: Jan 2002
Location: Clearwater, FL
Posts: 1,152
Thanks: 4
Thanked 4x in 2 posts
|
Thanks worked great
__________________
www.emerge180.com |
|
|
|
|
|
#18 (permalink) | |
|
All Star Reserve
Join Date: Nov 2005
Posts: 534
Thanks: 0
Thanked 0x in 0 posts
|
Quote:
|
|
|
|
|
|
|
#19 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,895
Thanks: 0
Thanked 27x in 17 posts
|
Not unless someone sends me a Mac. (And no McDonald coupons please)
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
#20 (permalink) |
|
Hall Of Famer
Join Date: Apr 2004
Location: Philadelphia
Posts: 2,642
Thanks: 54
Thanked 23x in 11 posts
|
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.
__________________
"al Qaeda wouldn't last a day in parts of Philadelphia" - Mayor Michael Nutter |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|