Author Archives: Michael Sharman

May 11, 2011

FancyBox for WordPress plugin not working

I just spent some time figuring out why fancybox wasn’t working tonight (image thumbnails were just linking to the large image…not loading the overlay as they should). It now seems obvious after the fact but as far as I can see it’s NOT in the fancybox docs. When you insert your gallery from the media [...]

April 17, 2011

FarCry twitter plugin

I spent a couple of hours on a FarCry plugin for twitter yesterday based off their official API. What? This plugin basically wraps up the options that the offical twitter API gives you including: Twitter username Showing avatars, timestamps, hashtags etc Theme appearance (colours for background and text etc Dimensions of widget For more, visit [...]

March 3, 2011

MySQL alternative to MSSQL’s isNull()

I was looking for a way to do isNull() in MySQL the other day, for those that don’t know this means you can do something like: If the value in mycolumn is NULL, then ‘blah’ is returned, this can of course be any string literal/numeric value you want. MySQL doesn’t have isNull() but it does [...]

February 8, 2011

SQL for finding duplicate values

Quick post to remind me how to check a table column for duplicate values next time I’m looking for it (when my memory fails!)

January 12, 2011

Checking for correct case-sensitive tables in FarCry

We run several FarCry projects at Learnosity and all of them run on Linux. We have occasionally come across issues where the FarCry codebase will refer to a MySQL table in the wrong “case”. E.g. referring to “dmhtml” where the actual table name is “dmHTML”. This is course fails in any case sensitive environment. Note [...]