|
|||||||
| 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,751
|
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
|
|
|
|
|
|
#22 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
|
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
|
|
|
|
|
|
#24 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
|
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?
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Last edited by Comedian2004; 06-08-2006 at 01:32 PM. |
|
|
|
|
|
#25 (permalink) | |
|
Major Leagues
Join Date: Feb 2002
Location: Arizona
Posts: 394
Thanked 2x in 2 posts
|
Quote:
|
|
|
|
|
|
|
#26 (permalink) | |
|
Minors (Triple A)
Join Date: Nov 2002
Location: Chicago, IL
Posts: 206
Thanked 1x in 1 post
|
Quote:
__________________
"They give you a round bat, they throw you a round ball, and they tell you to hit it square." - Willie Stargell Last edited by MrHaroldG; 06-09-2006 at 12:45 AM. |
|
|
|
|
|
|
#27 (permalink) | |
|
Minors (Triple A)
Join Date: May 2005
Posts: 222
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,751
|
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.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
|
|
|
|
|
|
|
#29 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
|
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.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
Last edited by Comedian2004; 06-10-2006 at 11:13 PM. |
|
|
|
|
|
#30 (permalink) | |
|
Minors (Triple A)
Join Date: Apr 2006
Location: London, On
Posts: 204
Thanked 1x in 1 post
|
Quote:
Have you used these files at all, and if so, did you have similar problems with them?
__________________
"Man can now fly in the air like a bird, swim under the ocean like a fish, he can burrow into the ground like a mole. Now if only he could walk the earth like a man, this would be paradise." -Tommy Douglas www.DevinJohnston.ca |
|
|
|
|
|
|
#31 (permalink) | |
|
All Star Reserve
Join Date: Jan 2003
Location: Indianapolis
Posts: 700
Thanked 5x in 2 posts
|
Quote:
This sounds awesome! I cant wait to have this feature. |
|
|
|
|
|
|
#32 (permalink) | |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
|
Quote:
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
|
|
|
|
|
|
|
#33 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
|
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.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
|
|
|
|
|
|
#34 (permalink) |
|
Hall Of Famer
Join Date: Mar 2003
Location: 39.84 N -84.12 W
Posts: 8,220
Thanked 41x in 26 posts
|
Trading in OOTB2006
This tool would make the kind of hindsight review pretty helpful in the cited thread's discussion. |
|
|
|
|
|
#35 (permalink) | |
|
Minors (Triple A)
Join Date: Apr 2006
Location: London, On
Posts: 204
Thanked 1x in 1 post
|
Quote:
Thanks and best of luck
__________________
"Man can now fly in the air like a bird, swim under the ocean like a fish, he can burrow into the ground like a mole. Now if only he could walk the earth like a man, this would be paradise." -Tommy Douglas www.DevinJohnston.ca |
|
|
|
|
|
|
#36 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
|
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.
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
|
|
|
|
|
|
#37 (permalink) | |
|
All Star Reserve
Join Date: Jun 2003
Location: Sycamore, IL
Posts: 545
|
Quote:
Very, very nice.
__________________
Rick BTI Texas Rangers GM FLB New York Bombers GM |
|
|
|
|
|
|
#38 (permalink) |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
|
Nothing fancy, but a start for the hitting streaks:
http://www.sim2005.com/1957/players/hitting_streak.html
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
|
|
|
|
|
|
#39 (permalink) | ||
|
Hall Of Famer
Join Date: Jan 2004
Location: The Real Northern California
Posts: 2,130
Thanked 1x in 1 post
|
Quote:
__________________
Quote:
|
||
|
|
|
|
|
#40 (permalink) | |
|
Hall Of Famer
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 6,751
|
Quote:
__________________
Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!
|
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|