OOTP Developments Forums - View Single Post - Anderson Utilities 2006

Comedian2004 · 12-17-2006, 12:24 AM

Thanks, until I hit a bump in the road.

The current release works as reported, creating the HR log files and also modifying the existing player HTML files. You can see a season with the mods in place here:

http://www.planetootp.com/leagues/1975/index.html

Go click on a HR hitter and you will see the HR LOG link.

I am working on the database, well, was, going to take a break now. I have a way to do the database and it works correctly, but having some problems merging the data.

1. It is adding 2 blank lines in the middle, between the years and it hops out of it there. I will figure that one out and then that part should work fine.

2. I may have not thought of something. I am basically merging last years GAMES.CSV and another file. I look in the one file and then go look in the game file and pull up the game, pulling out the pitchers name and team.

Well, problem is, it will find the 1st game from the 1st year and then exit, never getting to the 2nd game. Ah, if this was Chess, then I have just been mated.

But, since this is not Chess, I just have to start the database routine over and redesign it.

I will save each year in a file with AU_YEAR_ appended to the start of it. Then search in each one. So, it is still doable.

The only problem I forsee is running this program after 20 or 50 seasons. It may take a while to complete. So, I may change it so that it gives you a choice to just show log for this season or show log for career. Maybe even just have it to the career for retired players and check to see if it has already been done for the retired player and not do it again. The brain is working as I write this message, but it may be just the rattling of the headphones I have on.

12-17-2006, 12:24 AM	#7
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	Thanks, until I hit a bump in the road. The current release works as reported, creating the HR log files and also modifying the existing player HTML files. You can see a season with the mods in place here: http://www.planetootp.com/leagues/1975/index.html Go click on a HR hitter and you will see the HR LOG link. I am working on the database, well, was, going to take a break now. I have a way to do the database and it works correctly, but having some problems merging the data. 1. It is adding 2 blank lines in the middle, between the years and it hops out of it there. I will figure that one out and then that part should work fine. 2. I may have not thought of something. I am basically merging last years GAMES.CSV and another file. I look in the one file and then go look in the game file and pull up the game, pulling out the pitchers name and team. Well, problem is, it will find the 1st game from the 1st year and then exit, never getting to the 2nd game. Ah, if this was Chess, then I have just been mated. But, since this is not Chess, I just have to start the database routine over and redesign it. I will save each year in a file with AU_YEAR_ appended to the start of it. Then search in each one. So, it is still doable. The only problem I forsee is running this program after 20 or 50 seasons. It may take a while to complete. So, I may change it so that it gives you a choice to just show log for this season or show log for career. Maybe even just have it to the career for retired players and check to see if it has already been done for the retired player and not do it again. The brain is working as I write this message, but it may be just the rattling of the headphones I have on. __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]