Page 1 of 1
Addin Updates Available
Posted: Tue Jul 01, 2008 1:51 pm
by CrashDavis
Five maintenance updates are available for the following Addins:
POSTSEASON
SABERPACK
PROSPECTS
TEAMEVALUATIONS
ERRORS-CURRENT
I would be interested in hearing whether the POSTSEASON fixes problems that some were experiencing with their associations.
Also, a new Addin has been added:
DIAMOND KINGS - your associations best fielders at all positions. Will show the Top 3 at each position if they meet the required threshhold.
CrashDavis Addins
RE: Addin Updates Available
Posted: Tue Jul 01, 2008 3:44 pm
by Wrathchild
They all work great for me.
RE: Addin Updates Available
Posted: Wed Jul 02, 2008 12:17 am
by KG Erwin
Thanks for the updates, Crash. This is good stuff.
RE: Addin Updates Available
Posted: Wed Jul 02, 2008 3:26 pm
by LetsPlay2
Very good !! [&o]
RE: Addin Updates Available
Posted: Fri Jul 18, 2008 6:24 pm
by LetsPlay2
Post Season works great here !! [:D]
I do have one question though :
The "Top 25 Homerun Hitters" for each cluub have never worked for me. Do I need to go a few years for it to work ??
Thanks Crash for all the Add-Ins !! [&o]
RE: Addin Updates Available
Posted: Fri Jul 18, 2008 6:57 pm
by CrashDavis
"Top 25 Homeruns"? Is that the name of the addin? I don't think that one is mine.
RE: Addin Updates Available
Posted: Fri Jul 18, 2008 7:33 pm
by LetsPlay2
Sorry you are right that is Shaun's !!
RE: Addin Updates Available
Posted: Thu Feb 26, 2009 2:35 pm
by Wrathchild
I just noticed something with the Triple Crown add-in. At least on my system, it's showing American Leaguers under National League and National Leaguers under American League.
RE: Addin Updates Available
Posted: Fri Feb 27, 2009 9:30 pm
by CrashDavis
I'm not really sure how that could occur, Wrath.
Code: Select all
Set rs1 = db.OpenRecordset("SELECT Awards.PlayerID, Awards.YearNumber, Awards.LeagueID, Awards.fValue AS AVG, " & _
"Awards_1.fValue AS HR, Awards_2.fValue AS RBI, Player.Retired, Player.PrimaryPOS " & _
"FROM ((Awards INNER JOIN Player ON Awards.PlayerID = Player.PlayerID) INNER JOIN Awards AS Awards_1 ON " & _
"(Awards.LeagueID = Awards_1.LeagueID) AND (Awards.YearNumber = Awards_1.YearNumber) AND " & _
"(Awards.PlayerID = Awards_1.PlayerID)) INNER JOIN Awards AS Awards_2 ON (Awards.LeagueID = Awards_2.LeagueID) " & _
"AND (Awards.YearNumber = Awards_2.YearNumber) AND (Awards.PlayerID = Awards_2.PlayerID) " & _
"GROUP BY Awards.PlayerID, Awards.YearNumber, Awards.LeagueID, Awards.fValue, Awards_1.fValue, Awards_2.fValue, " & _
"Awards.AwardID, Awards_1.AwardID, Awards_2.AwardID, Player.Retired, Player.PrimaryPOS " & _
"Having (((Awards.LeagueID) = 1) And ((Awards.AwardID) = 4) And ((Awards_1.AwardID) = 8) And " & _
"((Awards_2.AwardID) = 15)) " & _
"ORDER BY Awards.YearNumber", dbOpenDynaset)
s = s & "<br><CENTER style='color:white;font-size:8pt;background-color:green'>Triple Crown Winners - AL Batters</CENTER><BR>"
The league ID is being pulled from the Awards table for this addon, not the Teams table. Did you make any changes - outside of PureSim - to the LeagueID for any teams in this association?
Also, it is assumed that your LeagueID #1 is also your American League teams - since that is the default PureSim uses when creating an association.
Question: Is this occuring to only a select few players on this list(s) or every one on the list(s)?
RE: Addin Updates Available
Posted: Fri Feb 27, 2009 9:44 pm
by Wrathchild
I'm posting an image that shows a portion of what I see on my end. Note how Pittsburgh is under American League and Cleveland is under National League.
I imagine, based on what you've written, that this because I started in 1900 with just the National League. I expanded for 1901 adding the American League as a new league, so when you look at my standings you see NL on top and AL on bottom.
EDIT: What would happen if you aren't using AL and NL, but running a fictional association?
RE: Addin Updates Available
Posted: Fri Feb 27, 2009 9:57 pm
by CrashDavis
Real or Fictional League: Whichever league is "on top" (ie., appears first in standings) is assigned League ID #1 and the other will be League ID #2.
For real association purposes, and by PureSim default, this is always understood to be AL first and then NL second.
Your situation is a scenario I had not aniticpated when creating the addon and it is indeed the reason why they appear switched. I will need to think about this more and see if there isn't a reasonable way to account for this scenario in the addon.
Steven 'Crash Davis' Lucey
RE: Addin Updates Available
Posted: Fri Feb 27, 2009 10:03 pm
by Wrathchild
It's no biggie. In fact I never even noticed it until the other day. Leave it to me to do things backwards! I can never just leave things alone.
RE: Addin Updates Available
Posted: Fri Feb 27, 2009 11:58 pm
by CrashDavis
Triple Crown updated. The fix was simple enough and should now account for associations that start up with only 1 league. In addition, the league names are no longer hard coded, they are pulled from database, so fictional leagues with names other than AL or NL should display properly.
CrashDavis Addons
P.S. Anyone using 3 or more leagues in an association, give me shout, please.
RE: Addin Updates Available
Posted: Sat Feb 28, 2009 11:57 pm
by GNDN
Crash, do I need to download both addin's links or will just the second one get me all of it?
Thanks
RE: Addin Updates Available
Posted: Sun Mar 01, 2009 2:59 am
by CrashDavis
By "both" I assume you mean Triple Crowns and PSPN Baseball? Yes, will need to DL from the two links on my web page.
Crash
RE: Addin Updates Available
Posted: Sun Mar 01, 2009 5:08 pm
by Wrathchild
More thanks!