|
||||
|
![]() |
#361 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
I can only reply that the fix is in for them.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#362 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
This is part of the how:SELECT [750PitchingCareer].playerID, [300/50MinimumBatting].SumOfG AS BattingGames, IIf([300/50MinimumBatting.sumofg] Is Null,1,[sumofg]/[300/50MinimumBatting.sumofg]) AS KillThesePitchingRecords, [300/50MinimumBatting].TooFew300G, CInt(([sumofipouts]/[sumofg])*[toofew300g]) AS NewIPOuts, [750PitchingCareer].SumOfG, [750PitchingCareer].SumOfIPouts, [750PitchingCareer].SumOfW, CInt(([sumofw]/[sumofg])*[toofew300g]) AS NewW, [750PitchingCareer].SumOfL, CInt(([sumofl]/[sumofg])*[toofew300g]) AS NewL, [750PitchingCareer].SumOfGS, CInt(([sumofgs]/[sumofg])*[toofew300g]) AS NewGS, [750PitchingCareer].SumOfCG, CInt(([sumofcg]/[sumofg])*[toofew300g]) AS NewCG, [750PitchingCareer].SumOfNewSHO, CInt(([sumofnewsho]/[sumofg])*[toofew300g]) AS NewSho, [750PitchingCareer].SumOfSV, CInt(([sumofsv]/[sumofg])*[toofew300g]) AS NewSV, [750PitchingCareer].SumOfNewH, CInt(([sumofnewH]/[sumofg])*[toofew300g]) AS NewH, [750PitchingCareer].SumOfnewER, CInt(([sumofnewer]/[sumofg])*[toofew300g]) AS NewER, [750PitchingCareer].SumOfNewHR, CInt(([sumofnewHR]/[sumofg])*[toofew300g]) AS NewHR, [750PitchingCareer].SumOfnewbb, CInt(([sumofnewbb]/[sumofg])*[toofew300g]) AS NewBB, [750PitchingCareer].SumOfnewso, CInt(([sumofnewso]/[sumofg])*[toofew300g]) AS NewSO, [750PitchingCareer].SumOfnewibb, CInt(([sumofnewibb]/[sumofg])*[toofew300g]) AS NewIBB, [750PitchingCareer].SumOfnewwp, CInt(([sumofnewwp]/[sumofg])*[toofew300g]) AS NewWP, [750PitchingCareer].SumOfnewhbp, CInt(([sumofnewhbp]/[sumofg])*[toofew300g]) AS NewHBP, [750PitchingCareer].SumOfnewbk, CInt(([sumofnewbk]/[sumofg])*[toofew300g]) AS NewBK, [750PitchingCareer].SumOfBFP, CInt(([sumofbfp]/[sumofg])*[toofew300g]) AS NewBFP, [750PitchingCareer].SumOfGF, CInt(([sumofgf]/[sumofg])*[toofew300g]) AS NewGF, [750PitchingCareer].SumOfnewr, CInt(([sumofnewr]/[sumofg])*[toofew300g]) AS NewR, [750PitchingCareer].SumOfnewsh, CInt(([sumofnewsh]/[sumofg])*[toofew300g]) AS NewSH, [750PitchingCareer].SumOfnewsf, CInt(([sumofnewsf]/[sumofg])*[toofew300g]) AS NewSF, [750PitchingCareer].SumOfnewgidp, CInt(([sumofnewgidp]/[sumofg])*[toofew300g]) AS NewGIDP
FROM [300/50MinimumBatting] RIGHT JOIN 750PitchingCareer ON [300/50MinimumBatting].playerID = [750PitchingCareer].playerID WHERE (((IIf([300/50MinimumBatting.sumofg] Is Null,1,[sumofg]/[300/50MinimumBatting.sumofg]))>0.02)) ORDER BY [750PitchingCareer].playerID;
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#363 | |
Hall Of Famer
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
|
Quote:
![]() |
|
![]() |
![]() |
![]() |
#364 |
All Star Reserve
Join Date: Dec 2001
Location: Canada
Posts: 574
|
Thanks Spritze for your quick response to my previous posts. I ran a quick sim starting in 1961 with the newest rosters to find duplicated players, with the same name (removing special characters and spaces) and birth month. Some were mentioned in my post from last week. Here are the results:
Bryan Price 1986-11 CC Sabathia 1980-07 Chuck Smith 1969-10 D'Angelo Jimenez 1977-12 Darren O'Day 1982-10 Eric O'Flaherty 1985-02 Erisbel Arruebarrena 1990-03 Freddy Garcia 1975-06 (the pitcher with majors ID garcifr03 should have minors ID garcia003fre) Gabe Gonzalez 1972-05 J C Hartman 1934-04 Jeff C D'Amico 1975-12 Jeff M D'Amico 1974-11 Jesus de la Rosa 1953-08 Jim Morris 1964-01 Johan Santana 1979-03 John D'Acquisto 1951-12 Jorge De La Rosa 1981-04 Jose D Ortiz 1977-06 Julio Ramirez 1977-08 Kevin Nicholson 1976-03 La Schelle Tarver 1959-01 Mark Watson 1974-01 Michael Stutes 1986-09 Mike de la Hoz 1938-10 Mike O'Connor 1980-08 Neil Weber 1972-12 Oil Can Boyd 1959-10 Peter O'Brien 1990-07 Rafael Furcal 1977-10 Randy St. Claire 1960-08 RC Stevens 1934-07 Rick Greene 1971-01 Rob Woodward 1962-09 Rodrigo Lopez 1975-12 Roosevelt Brown 1975-08 Ryan O'Rourke 1988-04 Shawn O'Malley 1987-12 Steve Schrenk 1968-11 Tike Redman 1977-03 Tom Jacquez 1975-12 Tony La Russa 1944-10 UL Washington 1953-10 Willie Harris 1978-06 Wily Mo Pena 1982-01 I'll give my computer a rest and look for duplicates pre-1961 in a few days. Last edited by Hoiles; 05-02-2016 at 06:41 AM. |
![]() |
![]() |
![]() |
#365 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
It appears from your list that all these players have already been fixed. Those fixes will appear in the next full update due out in a month or two.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#366 |
All Star Reserve
Join Date: Dec 2001
Location: Canada
Posts: 574
|
Oh that's good to hear. At least I got some programming practice and my laptop didn't explode in the sim, which I do admit is super fast now, I wouldn't have tried this with older versions.
|
![]() |
![]() |
![]() |
#367 | |
Hall Of Famer
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
|
Quote:
EDIT: I can dig up all 174 of them if need be. Thanks. Last edited by actionjackson; 05-02-2016 at 03:05 PM. |
|
![]() |
![]() |
![]() |
#368 |
Hall Of Famer
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
|
Also Will Harris/Willie Harris problem still exists, but Jerome Williams/Jeff Williams issue appears to have been fixed.
|
![]() |
![]() |
![]() |
#369 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
These fixes will not be released until the NEXT full update, in a month or two.
You are just looking at the old files that have no changes applied.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#370 |
Hall Of Famer
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
|
|
![]() |
![]() |
![]() |
#371 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
No changes will have been processed until later this summer. I believe .51 is a 3D fix you don't need special glasses for.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#372 |
Minors (Triple A)
Join Date: Apr 2016
Location: Toronto
Posts: 250
|
When I go to Historical Exhibition and play the 1920 World Series there is a missing player. Steve O'Neill is not on the Cleveland Indians roster even though he was their starting catcher and played 7 games in the 1920 WS. However, if I set up an exhibition game with that Indians team against any other team then O'Neill does appear on the roster.
|
![]() |
![]() |
![]() |
#373 |
Hall Of Famer
Join Date: Dec 2005
Posts: 16,374
|
grmagne, I'll bet O'Neill is someone whose ID has changed. I'll make the change(s) to the World Series rosters file.
ETA: I made more than a dozen ID changes and sent the updated file to Markus. Last edited by pstrickert; 05-06-2016 at 11:29 PM. |
![]() |
![]() |
![]() |
#374 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
The known duplicate players will have been fixed in the next upgrade to be released in a few days. If you find any remaining they will either have been unreported or I messed up when fixing them. Even though a few hundred were reported this lead to several thousand additional fixes.
Thanks!
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#375 | |
Hall Of Famer
Join Date: Dec 2005
Posts: 16,374
|
Quote:
![]() |
|
![]() |
![]() |
![]() |
#376 |
All Star Reserve
Join Date: Dec 2001
Location: Canada
Posts: 574
|
I just downloaded the beta, thanks for the updates on the duplicated players (Johan Santana, Furcal, etc). In a 2001 import, there are some fringy players I reported a bit later, like D'Angelo Jimenez, Jeff D'Amico (both of them), Willie Harris with two copies. Are these going to be fixed in the official patch coming up soon?
|
![]() |
![]() |
![]() |
#377 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
There are two major league Willie Harris's and one minor league one. I just renamed one of the major league ones Willie R. Harris so you can tell them apart easier. There are also several William, Will, Bill and Billy Harris's.
D'Angelo Jimenez, Jeff D'Amico (both of them) are in the update and were corrected. I do not know when the newer files will show up in the game. Not my call.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! Last edited by Spritze; 05-11-2016 at 05:41 PM. |
![]() |
![]() |
![]() |
#378 |
All Star Reserve
Join Date: Apr 2009
Posts: 648
|
So many Oil Cans
Historical with affiliated minors. Started in 1988. Now, it's the first day of the off-season. Minors database loads and a second Oil Can Boyd appears as a free agent. After checking, I see that regular Oil Can has only MLB stats in his real stats, and new Oil Can has only MiLB stats in his. I'm guess that somehow the two should be merged into a genuine Oil Can.
*FWIW, I started this league with one of the previous builds (don't remember which now) and I am currently in the new build 54. |
![]() |
![]() |
![]() |
#379 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
This was fixed a while ago. Don't know when OOTP will release it.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#380 | |
All Star Reserve
Join Date: Dec 2001
Location: Canada
Posts: 574
|
Quote:
|
|
![]() |
![]() |
![]() |
Bookmarks |
|
|