|
|||||||
| 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: 2,858
|
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,751
|
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!
|
|
|
|
|
|
#4 (permalink) |
|
Hall Of Famer
Join Date: Apr 2004
Location: Philadelphia
Posts: 2,480
|
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,751
|
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!
|
|
|
|
|
|
#6 (permalink) |
|
Hall Of Famer
Join Date: Jan 2003
Posts: 2,858
|
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: 2,858
|
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
Posts: 6,401
|
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 10:37 PM. |
|
|
|
|
|
|
#9 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
|
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!
|
|
|
|
|
|
#10 (permalink) |
|
All Star Starter
Join Date: Sep 2003
Location: The Most Interesting Place in the World...
Posts: 1,282
|
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!
__________________
Click here to sign up to play Goal Line Blitz and be part of the team! Stay thirsty my friends... |
|
|
|
|
|
#11 (permalink) | |
|
Hall Of Famer
Join Date: Apr 2004
Location: Medford, MA
Posts: 3,278
Thanked 53x in 25 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
Posts: 6,401
|
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: 2,858
|
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,097
|
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 from 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 15 years of experience in negotiating settlements..... |
|
|
|
|
|
#15 (permalink) | ||
|
Hall Of Famer
Join Date: May 2003
Location: Under The Christmas Fish
Posts: 4,682
Thanked 12x in 8 posts
|
Quote:
__________________
Quote:
|
||
|
|
|
|
|
#16 (permalink) | |
|
Hall Of Famer
Join Date: Apr 2004
Location: Medford, MA
Posts: 3,278
Thanked 53x in 25 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,097
|
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 from 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 15 years of experience in negotiating settlements..... |
|
|
|
|
|
#18 (permalink) | |
|
All Star Reserve
Join Date: Nov 2005
Posts: 512
|
Quote:
|
|
|
|
|
|
|
#19 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
|
Not unless someone sends me a Mac. (And no McDonald coupons please)
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
|
|
|
|
|
|
#20 (permalink) |
|
Hall Of Famer
Join Date: Apr 2004
Location: Philadelphia
Posts: 2,480
|
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 | |
|
|