Engineering Analysis
Mysql ISO-8859-1 (LATIN1) to UTF-8
Mon, 12/03/2007 - 15:26 — James O'MalleyI thought I would throw in a link to a howto I wrote over at OG Consulting. I would wager there are a few people out there that have legacy data in an old MySQL installation (4.0.x and below), and need to bring their installation up to date. I believe the MySQL folks are going to EOL (end of life) MySQL versions less than 4.1.x, so it is now a necessity to get it up to speed. For those of you with a lot of legacy data, I've written a little tutorial on stuffing your mixed character encoded data into a fresh shiny new MySQL installation.
Drupal + BBClone
Mon, 11/26/2007 - 16:26 — James O'MalleyI like BBCLONE's visitor statistics package. It has served us well for more than a few years. Our customers like it too. There is a problem though. Drupal and BBClone do not get along very well. Here are a couple of tips to get BBClone working with virtual hosts (multiple sites hosted via one single drupal installation), and with caching enabled.
Most of the helpful hints proposed on http://drupal.org/ suggest installing the relevant BBClone code in the ~drupal/index.php file, like so:
$bbrequest = strtolower($_SERVER["REQUEST_URI"]);
define("_BBC_PAGE_NAME", $bbrequest);
define("_BBCLONE_DIR", "bbclone/");
define("COUNTER", _BBCLONE_DIR."mark_page.php");
if (is_readable(COUNTER)) include_once(COUNTER);
This is all fine and good, but if you are hosting multiple sites under ~drupal/sites/ then you are going to have a problem. Each virtual site has its own statistics counter and bbclone directory. We want each site to count only its own vistors.
You Already Own All the Software on This Website
Tue, 10/23/2007 - 04:34 — James O'Malley
It was time to refactor this website, offer new services, organize content, and hone our client focus. I will recount the process here, partly for historical reasons and as documentation for later, but also just because the whole process was so cool. First, the technology used was, as always, 100% GPL'ed or BSD licensed software, from the content management system, to the flash animations, to the images, 3-d modelling, PDF generation, authoring, hosting, and database. If I think of anything else, I'll throw it in the soup. Everything from start to finish was done with 100% software libre.

