PaulBM

I’ve added more classes to the Snooker App. A news table has been added to the database too.

I also spotted a glitch with the migration data. I forgot about walkovers, well the missing player in a walkover. The migration routine had created a new player without checking if the name was empty. Ooops. I’m glad I resisted the urge to migrate all the seasons that are stored in the old database format. Fully testing one league from the 2008 season has been manageable.

The next big step will be the SQL query to work out the player’s win loss averages. Also, with the new database design, I will be able to display a lifetime average (well back to 1996 anyway ) and many more statistics. History of wins and losses in any match will be interesting too.

All the data for displaying a full scorecard from the Snooker league app is working. Viewing the var_dump() shows all items and objects are correct.

Next job is display it. I’m thinking a AJAX/JSON call to display it as a pop-up might be nice.

Saturday was a good programming day, I almost completed all of data migration routine. Just the high breaks and match comments needed finishing today. The latest season migrated without errors… yata!

Next is the big task of the scorecard class, it’ll be a busy class.