LeagueSite

As part of the integration with the Drupal CMS platforom, the leaguesite source code has been integrated with the Drupal CVS repository.

You can view the LeagueSite project page at drupal.org at: http://drupal.org/project/leaguesite .

We hope to have a release with very basic players/teams/games functionality in the next few months.

Howdy folks. The big news of the day is that Richard and I have agreed to port LeagueSite to the Drupal content management system [0] and will be going forward only on that platform, working against the newer Drupal 6.0 codebase. I will first only be porting some basic features, but eventually hope to have a fully compatible feature set. I'll also try to provide scripts to migrate existing data from the PHPWS module to the eventual Drupal successor.

Other news is that this Drupal module code is now using SourceForge's Subversion repository, rather than CVS [1].

We both look forward to working on this project again and to working on Drupal.

[0] http://www.drupal.org
[1] http://leaguesite.svn.sourceforge.net/viewvc/leaguesite/trunk/

As promised, here is the new 0.9.1 release to fix the "editing teams with no roster" bug. It also fixes a couple of other items.

The changes are:

*legauesite-0.9.1 (26 March 2007)
Bug Fixes
* [ leaguesite-Bugs-1688292 ] Edit fails for teams with no rostered players
* [ leaguesite-Bugs-1553378 ] Div by 0 in Australian Rules standings plugin

New Features
* RFE [ 1685639 ] Permalink to standings

Note that there is also a change to the standings.tpl template for the addition of the permalink. If you have your own custom template for this file you can add the {PERMALINK} tag where you want the permalink to go.

Apologies again for the trouble with 0.9.0, and I hope this one goes better!

Hi All,

It appears there is a bug in editing games that involve teams that don't have a roster. I have therefore pulled 0.9.0 until I can fix it so it won't affect any more people.

Unfortunately I am away for the weekend so I can't fix it until Monday, but I hope to have a fixed 0.9.1 available on Monday night.

Sorry about that,
Richard

p.s. for those who have already downloaded 0.9.0 and are finding the problem, I have posted a workaround here:

http://sourceforge.net/forum/message.php?msg_id=4225929

That should get you going again until I can fix it properly on Monday.

Well this one has certainly been a long time coming! And of course, after waiting almost two years for a new release, I'm tempting fate by going away on holiday from Friday until Monday! As every developer knows, that is usually the kiss of death to any release, but I am actually pretty confident that there should be no problems with this one.

Of course, I have to thank my long suffering girlfriend for spotting what would have been an annoying bug right at the last moment before I packaged it all up. So it's about 3 hours later, but a whole lot better thanks to her ;)

So what's in this release? The highlights are:

New Features
* RFE [ 1553383 ] Add "Scorer" permission. Much asked for feature! When using, there is a small gotcha in configuring the "Scorer" users - you have to give them the "Score Games" permission in the "Update User" page, AND make them an Admin on the "Manage Users" page that lists all the users. If you only set the specific permission and don't make them an admin, they will not be able to score games.

Bug Fixes
* [ leaguesite-Bugs-1202443 ] Players Edit link available when permission not granted
* [ leaguesite-Bugs-1195678 ] Database Error (when adding a game with only 1 team selected)
* ISF-Softball Standings plugin updated to fix sorting when sorting teams in H2H with the same record.
* Made the Edit Team link from the View Team page respect the edit_teams permission, not the edit_games one.
* Games Back standings style updated to take account of ties as well as wins & losses
* Fixing bugs in Add/Edit Statistics and Delete Statistics, and related permissions

There is also a new template file for scoring games, for those who do their own templates.

As ever, if you have any questions please feel free to post them in the forum and I'll do what I can to help.

I've been sitting on this one for a while because sourceforge appears to have stopped developer access to CVS from the shell server. I was just using the cvsrelease script written by Don (rizzo) to do releases, and that script requires developer (writeable) access to cvs. Add to that I am pretty much a windows only guy (boo hiss) and it put something of a spanner in the works! Anyways, thanks to Knoppix I now have a useable linux at home so I can now run the script from here.

The quick summary of the changes in this one is:

Bug Fixes
* Fixes to html errors in the schedule list view
* Fixing bug where the umpire couldn't be set back to [TBA] after a specific umpire was selected
* Fixing bug where editing a game would default PM games to AM

New Features
* RFE [ 1110936 ] Link to schedule - shows the Next and Previous 'n' Games for the team on each Team's page, along with a link to the full schedules for that season.
* Adding the ability to mark games as postponed.
* Use cookies to select the default schedule and standings views for returning visitors
* Showing the Umpire on the Games blocks
* Added a This Week's Games block
* Patch [ 1192665 ] Add Edit Link to Venue - thanks to jbalcorn for this one.

In addition, if you are using your own templates for your leaguesite/phpws theme please note that there have also been some template changes. See the changelog for more information.

Points based tables are finally here!
----------------------------------------------------
I've finally done what I really should have done a long while ago - adding points based standings table capabilities to leaguesite. I also wanted to take into account other comments that I have received about different users/sports requiring slightly different methods of ordering the teams.

To try and support all this I have decided to use a simple plugin architecture that allows individual files to deal independantly with different methods of generating standings tables.

This hopefully means that if none of the existing ways of generating a standings table is ideal for your sport you can simply write a very basic plugin, add it to the correct directory, and it will automatically be available for use in leaguesite.

Initial plugins
----------------------------------------------------
The standings plugins that I have created so far are:

* Generic "Games Back" - Implements the standings table leaguesite used previously
* Generic Points (3 Points version) - Generic points table, with 3 points for a win
* Generic Points (2 Points version) - Generic points table, with 2 points for a win
* Generic Points (3 Points) with Bonus Points - Generic points table, with 3 points for a win, plus per-game bonus points (manually entered).
* Generic Points (2 Points) with Bonus Points - Generic points table, with 2 points for a win, plus per-game bonus points (manually entered).
* ISF Softball - Standings table to match International Softball Federation (ISF) rules

and finally (especially for gnrtoucan (Roy Collins)):
* Australian Rules Football (AFL) - Standings for the AFL version of Australian Rules
* Australian Rules Football (SANFL) - Standings for the SANFL version of Australian Rules

Choose the corect plugin
----------------------------------------------------
You can select the standings table format you require from the Season Edit page, as well as see a longer description of what the current standings format is.

This is available per-season, so if you are running a site for multiple sports you can have different standings table formats for different seasons.

Note for Users of Custom templates
----------------------------------------------------
This change has required some changes to the templates, so if you have custom templates for edit_game.tpl, edit_season.tpl, standings_item.tpl, standings.tpl, or view_game.tpl then you will need to make some changes (detailed in the readme)

Making your own plugins
----------------------------------------------------
The plugins are stored in mod/leaguesite/class/standings/standings_*.tpl

All plugins must:
* be named standings_*.tpl
* implement a class called LEAGUESITE_standings_* (where the *'ed part of the filename and the class name are identical.
* the class must extend LEAGUESITE_standings_base (standings_base.php) (or a descendant thereof)
* the class must implement:
- getDescription()
- getShortDescription()
* the class may implement:
- getHeadings()
- getFieldClasses()
- getUseBonusPoints()
- getStandingsArray()

I think the comments for these functions give a pretty good description of what they are required to do. Additionally, the existing plugins should provide a good base to 'borrow' from!

And of course, once your plugin is working well, please contribute it back to the project as a patch or even just email it to me (see my profile for the address).

If you have any further questions about how to develop plugins I will try to keep on top of the forums so feel free to ask questions there.

If I can't make my own plugin
----------------------------------------------------
If you want a sport added to the list of plugins, but won't be able to do it yourself, then please feel free to add an RFE for it. Before I will be able to do anything I will need:
* What columns are in the table
* How they are calculated
* How the ordering is done (e.g. points, then goal difference, then goals for, then 'coin toss' etc.).

That's it
----------------------------------------------------
That's it for this overly long news item. Hope you liked it ;)

Doh! There was a one character mistake in the update code in 0.6.6. that meant all games were moved to the morning. date('h') gives the 12-hour hours, and date('H') gives the 24-hour hours! Guess which one I used and which one I should have used...

This is now fixed so games will stay as afternoon games if appropriate.

If you did manage to install 0.6.6 in the time it was up, this version's update will move all games to the afternoon (on the basis that most sports play in the afternoon). If you installed 0.6.6 and the majority of your games are in the morning you may want to delete the last section of boost/update.php before updating.

If you didn't install 0.6.6, or all your games are in the afternoon then simply get 0.6.7 and update to it and all will be well.

I think I have finally managed to fix/workaround the problem with the date and time being incorrect when the page is first loaded, but being correct every reload after that.

What appears to be happening is that some other module is calling PEAR::Date_TimeZone::inDaylightTime() when a user session starts (700-odd times!!), but doesn't call it again once the session is started.

The problem is that there appears to be a bug in inDaylightTime() which can mess up the timezone of the server, setting it incorrectly to UTC.(See http://pear.php.net/bugs/bug.php?id=1180 and http://www.modem-help.co.uk/help/diary20040412.html\)

So the first time the page is loaded the timezone is being set to UTC and start times were being interpreted at that timezone, then on further reloads the timezone returns to its correct setting and the start times are correct again.

I have fixed this by removing timezones from the equation. By using gmmktime() and gmdate() instead of mktime() and date() the code now ensures that time you enter when you create or edit a game is the time that is displayed irrespective of the timezone on the server. There are some corner cases such as showing "Today's" games where obviously "Today" should be defined by the local time, not GMT but I think I have accounted for those.

The other issue is what happens to games already in the database with the time in local time? The "update" code changes the game's starttime to give the expected results, but it is possible that if the timezone on your server is messed up then the updated times could be incorrect.

This bug has been driving me mad, but I believe it is now fixed so if you have been having this problem please download 0.6.6, give it a shot, and keep an eye open for any corner cases I might have missed!

Thanks to somydi_12, aaroneast, danthecook, and especially to gregjor over on http://forum.textdrive.com for their help in finding this one.

Oh yeah and...this release also fixes a missing semi-colon in uninstall.sql - thanks to danespen for pointing that one out.

If this is fixed I intend to start working on points-based standings tables to add to the games-back based ones, so hopefully that should arrive in the next week or two.

Well I seem to be getting through these at a regular 1-release-a-week schedule. Perhaps if I didn't leave so many bugs in there in the first place I wouldn't have to ;)

Seriously, thanks to everyone who has been submitting excellent detailed bug reports that really help me narrow down the problems. The issues fixed in this release were spotted by wolfbbs, Alex (ag3586), and James - thanks all :)

The changes in this version are:

Bug Fixes
* Fixing compatability with PHP5 by correcting errors in the code that generates the "next n games" blocks
* Fixing bug in displaying stats on the Game page
* Fixing bug in displaying stats on the Team page
* Working around bugs in the table prefix adding code in the core database methods by manually adding the prefix in all required places