Rock Band Disc Repaired!

Last week I posted about our Rock Band disc getting scratched.  Not surprisingly I was unsuccessful getting EA to replace the disc which was a little surprising given that they replace the instruments with little pushback.  I was expecting to have to buy a new disc but asked my son to see if he could track down a used one first.

It turns out the PlayNTrade near us has a disc polisher and for $3.20, they will attempt to repair your scratched disc.  For $3, this is a no brainer as opposed to spending $35 (used) to $60 (new) for another disc.  So we wandered on up to PlayNTrade to see if our disc could be fixed.  After a couple spins in the polisher our disc looked  pretty good.  We took it home and SUCCESS, it works and we were able to play Rock Band all evening.

My nephew also brought along a scratched copy of Forza 2 he had and it too was polished and successfully plays now.  As I stated above, for $3 it is a no brainer when you have a scratched disk.

Struggling with MS Access

While it isn’t really relevant to the wp-swimteam plugin, it is related to swim team.  Our team is using WinSwim for meet management which relies on Crystal Reports for generating reports.  I have been customizing reports for our team and am working on one which requires me to really poke into Access.

I have done quite a bit of work with MySQL so it is frustrating to encounter SQL constructs which Access doen’t support.  Right now I am struggling with how to determine if a table in Access already exists and if it does, I want to drop it.  What a PITA.  Access doesn’t support the DROP TABLE IF EXISTS construct which MySQL (and others) support.

If you know how to do this, please tell me how in the comments!  🙂

Tracking my progress

This morning I played 18 by myself and decided to track some stats after seeing another friend of mine do it recently.  It was interesting to see where I gave a lot of strokes away.  I played pretty well, better than I have the last couple times out.  I shot 92, 45/47.

Other than #10 and #11, particularly #10, I was pretty happy with my round.  I feel like I am getting closer.  I only 2 real bad wedge shots and I putted reasonably well.
As you can see below, I am not hitting many greens in regulation which means I don’t give myself a lot of chances at par or better.  If I could get off the tee a little farther I think having shorter irons into the green would help improve my GIR.

2008-07-17 Score Card

2008-07-17 Score Card

More on Opt-in and Opt-out

As the season comes to a close we are seeing a lot of scratches for our last couple meets. For this week we will be missing about 40% of our swimmers. Previously I had written about the pros and cons of Opt-in and Opt-out for swim meets and after watching this season unfold, I believe my thinking still holds.

Originally I had thought that opting in or out from a meet as a binary decision:  A swimmer was either participating or not.  It turns out it isn’t that simple.  Year round school is pretty popular here in Wake County, North Carolina and roughly 1/3 to 1/2 of our swimmers are in school for either all or part of the summer swimming season.  Since our meets are held on Tuesday nights, they tend to run pretty late and some parents are taking their kids out of the late events (e.g. Butterfly and/or Freestyle Relay).

This has resulted in what my wife is referring to as a “partial scratch”.  In addition to kids needing to leave early, we have also had some kids come late due to other commitments so they are missing one or two events early in the meet.

So as I sit down to implement opt-in and opt-out, I have concluded I need to account for partial participation in a swim meet.

Google Maps short code implemented

I have been using the Inline Google Maps plugin on the MacDolphins site but lately it has been flaky to say the least.  Sometimes the Google Map is displayed and sometimes it isn’t.  There isn’t any real rhyme or reason as to when it displays and when it doesn’t that I could find AND the plugin is actually hard to use, particularly for the casual author.

So I implemented a new short code for Google Maps called wpst_google_map which will take an address as an argument and display a Google Map.  The plugin uses this as part of the Club Profile to map a swim club for directions and such.  The short code is based on a Google Maps class called Phoogle Maps which has been extended to work with the plugin.  Phoogle Maps works pretty much as advertised.  I wish it didn’t echo it’s output directly to the output buffer but fortunately PHP can control the output buffer so it can be captured and used in the context of the plugin.

[wpst_google_map address="1600 Pennsylvania Ave, Washington DC, 20006" align="center"]

The short code syntax above will display a map similar to this:

RockBand Disc Scratched

Bah.  Our RockBand disc got scratched over the weekend and now it won’t do much other than start.  As soon as you try to play, the disc is deemed “unreadable”.  I thought EA would replace scratched discs but I got a “non-answer” from my support query so I will have to pursue that further.  I may have to go look for a used copy.

I am not sure how it got scratched but the Xbox, which we have vertically, was sitting on top of a cable over the weekend so it was slightly tilted.  I had read somewhere that discs can become scratched if the console isn’t horizontal or vertical although I am not sure if I believe it.  Regardless, the disc is scratched and now I need a new one.

RRoD for our Xbox360

For the second time, our Xbox360 has died due to the Red Ring of Death (aka RRoD) failure.  Since this has happened before, I know what to expect.  I am not as annoyed as I was last time because Microsoft has changed their warranty policy and will fix it and they have finally addressed the problem with downloadable content licenses.  I do still need to chase down the fact that all of our licenses didn’t get transfered last time but I will wait until the box returns.

I am actually not all that disappointed that the box failed.  It was really loud – I am hoping the replacement doesn’t have such a loud fan.  This unit has been much louder than the first one we had since we received it and the fan kicks on more frequently as well.

In the meantime, I have another Xbox at home which I had at work.  I had found an Xbox360 Elite (the black one) on Craig’s List a while back for $200 so I bought it thinking I’d take our original down to the beach house.  I didn’t have all of the pieces when I was last down there so the Elite has been sitting on my desk unused.  Depending on what we get back from Microsoft, I may just keep the Elite at home and take the replacement to the beach or put the replacement down in the basement.

Busy with Swim Team

It seems like most of my free time has been consumed with swim team lately.  I volunteered to help bring the MacDolphins into the 21st century this year and it has taken quite a bit more time than I expected it would.  A lot of that is because it is fun working a technical problem and doing it right.

We had some goals for the season.

  1. Report results in a timely manner.
  2. Capture times and keep a history so swimmers and parents could monitor their progress.
  3. Electronic registration to minimize data entry errors.
  4. Communicate quickly and effectively.

After searching the internet for an existing swim team solution I determined there really wasn’t anything suitable do I decided to write my own WordPress plugin to address part of the problem.  I had no aspirations to build a complete solution but I did want to offer something which addressed goals 1, 3, and 4 above.  I started working on the plugin early this year and for the most part, it is working out pretty well.  I wish I had a few more things done but I am happy with what I have been able to do.

For actual meet management, our team (actually me) ended up choosing WinSwim over the industry standard Hy-Tek solution.  I went with WinSwim mostly because their support was excellent and their ability to import our roster electronically.  For whatever reason, Hy-Tek has made doing this difficult if not impossible to do.  (Read more on my wp-swimteam plugin blog regarding my dealings with Hy-Tek.)

WinSwim is easy to use but it hasn’t been without some problems.  Fortunately they don’t seem to mind the volume of e-mail and issues I am sending them and they turn around solutions really quickly.  To distribute the data our parents and swimmers want to see (mostly their times), I have learned quite a bit about Crystal Reports.  It is pretty powerful once you get the hang of it but the learning curve is non-trivial.  This weekend I think I had the “ah-ha” moment because now I am able to edit and create new reports pretty quickly.

The season is coming to a close and I still have a few things to do.  I need to get end of season reports done for our banquet.  I think this will be pretty straight forward now that I think I have a handle on Crystal Reports!

New Shortcode – wpst_club_profile

I implemented a new shortcode to show club profile detail.  You can see the short code in action on the MacDolphins web site.

[wpst_club_profile clubid=1 googlemap=’y’ mapquestmap=’yes’ link=’yes’]

This short code can optionally display a Google Map but in order to do so, the Google Inline Maps plugin must be installed.  For the short code to display anything meaningful the club profile data must be enterted for the club of interest.