|
|||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|
#21 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
|
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
#22 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
|
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
#23 (permalink) |
|
All Star Starter
Join Date: Jan 2003
Location: Indianapolis
Posts: 1,242
Thanks: 273
Thanked 134x in 75 posts
|
Great job with these. I cant wait for this utility. It will definetely add to the game! Thanks for doing this Comedian.
__________________
Professional Website Design - Sharp Guys Web Design - http://sharpguyswebdesign.com/ |
|
|
|
|
|
#24 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
|
OK, trade stuff.
I am working on a routine to display all of the trades and give a report on the trades. Since ratings at the time of the trade are either, not available, not accurate or turned off, I had another solution. Show each players stats for the years after the trade for the team he was traded to: I.E. OF Babe Ruth traded to New York for OF Greasy Hahnds and P Ben Dover. Babe Ruth: 6 seasons - .345/.420/.745 340 HRs, 678 RBIS, 3 SB Greasy Hahnds: 4 seasons - .220/.320/.766 3 HRs, 21 RBIS, 0 SB Ben Dover: 2 seasons - 4-19-0 5.67 How does something like this sound?
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Last edited by Comedian2004; 06-08-2006 at 01:32 PM. |
|
|
|
|
|
#25 (permalink) | |
|
Major Leagues
Join Date: Feb 2002
Location: Arizona
Posts: 442
Thanks: 22
Thanked 6x in 5 posts
|
Quote:
|
|
|
|
|
|
|
#26 (permalink) | |
|
Minors (Triple A)
Join Date: Nov 2002
Location: Chicago, IL
Posts: 270
Thanks: 61
Thanked 12x in 9 posts
|
Quote:
__________________
I'll give you three guesses—and your first three don't count! Last edited by MrHaroldG; 06-09-2006 at 12:45 AM. |
|
|
|
|
|
|
#27 (permalink) | |
|
Minors (Triple A)
Join Date: May 2005
Posts: 222
Thanks: 1
Thanked 0x in 0 posts
Infractions: 0/1 (1)
|
Quote:
Just kidding of course - these look great and I look forward. Thanks for you efforts!
__________________
They still believe that they can hold the reins, but then they've got no sense of history. |
|
|
|
|
|
|
#28 (permalink) | |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
|
Quote:
But it is a very good 'alternate' universe. I have another one that I am going to use as my test league that went from 1920 to 2002. The trade screen is coming along slowly. I might have something this weekend.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
|
#29 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
|
I guess I should have gone with the easier routines first, but this is one that perked my interest.
Trading: I redid this entire code, as I had some logic wrong and it was a pain, but the first part is working. Here is how it will work. You pick a team and it will look through and find all of the trades this team ever made. Then, it will examine each trade and give you a report on the outcome. So, if PlayerA was traded from TeamA to TeamB for PlayerB, then you would see how PlayerA did when he was on TeamB and how PlayerB did when he was on TeamA. Then, if one of the players went to a different team before three years were up, then it would also show that. But if the player stayed on the same team for, say, 7 years, you would see his entire 7 years. There are a couple ways I could do this. Maybe I could just show the entire players career after the trade? Or show his entire career, with the trade line highlighted. What do you think? Here is a screenshot of it early on. So far it is just pulling up the players name that was traded (just one of them for now) and showing how he did the rest of his career.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Last edited by Comedian2004; 06-10-2006 at 11:13 PM. |
|
|
|
|
|
#30 (permalink) | |
|
Major Leagues
Join Date: Apr 2006
Location: Winnipeg, Mb
Posts: 386
Thanks: 121
Thanked 203x in 60 posts
|
Quote:
Have you used these files at all, and if so, did you have similar problems with them? |
|
|
|
|
|
|
#31 (permalink) | |
|
All Star Starter
Join Date: Jan 2003
Location: Indianapolis
Posts: 1,242
Thanks: 273
Thanked 134x in 75 posts
|
Quote:
This sounds awesome! I cant wait to have this feature.
__________________
Professional Website Design - Sharp Guys Web Design - http://sharpguyswebdesign.com/ |
|
|
|
|
|
|
#32 (permalink) | |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
|
Quote:
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
|
#33 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
|
OK guys...
I am getting somewhere. Here is the HTML report on trades for Chicago for 1921. They had two trades that year. The first trade was Edgardo Eilzando for Frank Hester. It was done in January. As you can see by the URL, it shows the player, his ID and position and his career stats from this point foward for both players. The 2nd trade was Colton Ford for Frank O Rourke and it also shows the same. Now this trade actually contained 2 more players, that is my next confusing step to do and also show any cash that exchanged hands. http://www.sim2005.com/1957/players/Trading.html I have not added any coloring yet, but I am using the style sheet provided by OOTP to keep the fonts and tables the same. This could be very interesting.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
#34 (permalink) |
|
Hall Of Famer
Join Date: Mar 2003
Location: 39.84 N -84.12 W
Posts: 8,327
Thanks: 76
Thanked 53x in 36 posts
|
Trading in OOTB2006
This tool would make the kind of hindsight review pretty helpful in the cited thread's discussion. |
|
|
|
|
|
#35 (permalink) | |
|
Major Leagues
Join Date: Apr 2006
Location: Winnipeg, Mb
Posts: 386
Thanks: 121
Thanked 203x in 60 posts
|
Quote:
Thanks and best of luck |
|
|
|
|
|
|
#36 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
|
http://www.sim2005.com/1957/players/trading.html
This routine is almost done. As you can see, it can be very helpful in solo leagues. Just have to smooth out a few things and color it.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
#37 (permalink) | |
|
All Star Reserve
Join Date: Jun 2003
Location: Sycamore, IL
Posts: 599
Thanks: 5
Thanked 0x in 0 posts
|
Quote:
Very, very nice.
__________________
Rick |
|
|
|
|
|
|
#38 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
|
Nothing fancy, but a start for the hitting streaks:
http://www.sim2005.com/1957/players/hitting_streak.html
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
|
#39 (permalink) | ||
|
Hall Of Famer
Join Date: Jan 2004
Location: The Real Northern California
Posts: 2,382
Thanks: 5
Thanked 21x in 18 posts
|
Quote:
__________________
Quote:
|
||
|
|
|
|
|
#40 (permalink) | |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,870
Thanks: 0
Thanked 22x in 14 posts
|
Quote:
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
|
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|