On Tue, Sep 08, 2009 at 02:25:39PM -0400, Peter McAlpine wrote: > That is more extensive than I had considered, but would cover some cases I > had not thought of. I simply figured that teams would serve as what you > named a club - effectively making them a grouping of players. Your > suggestion would cover cases where there is the same team but different > roster playing on different nights in the same season, and would serve as a > better way to archive league standings (preserving team rosters).
For OCUA, it's fairly infrequent that the same team wants to play multiple nights with a slightly different roster (though we do have a few of those). The main time we encounter problems with team re-use is at the end of summer season, when captains are trying to firm up their rosters for the upcoming fall league, but are still actively playing in summer league. The other time it's an issue is each spring, during summer league registration, when coordinators are trying to seed their leagues. At that time, it would be useful to be able to compare the previous year's roster to the current one, and make adjustments if necessary. For example, a team that had an average player rating of 6 last year may have a lower average this year and need to be seeded below their final ranking for the coming season. As for archiving, keeping stats within LR would be great. For years OCUA has been exporting them as sportsml using the script shipped with Leageurunner because it's been too much work to even contemplate preserving results in the database forever. Perhaps with the club/roster structure it might be a bit easier. > I think I'll probably end up just updating the standings generator to take > an optional season parameter, and filter out everything else in the set of > scores. It looks like I can do this by adjusting the sql select in > calculate_standings. I can't really think of a case where I'd have a league > that has the scores from other leagues included in the standings. In case you're curious, the reason it works the way it does is because years ago, OCUA ran multiple tiers for a given night as separate leagues in Leaguerunner (so Tier 1 Monday, Tier 2 Monday, etc, were separate). Then, when a team moved up or down to a different tier mid-season, we needed the record to follow that team to the new league. Now with the ladder system, we don't really need that behaviour very often, but nobody's gotten around to fixing it. Cheers, Dave _______________________________________________ Leaguerunner mailing list [email protected] http://www.dmo.ca/cgi-bin/mailman/listinfo/leaguerunner
