GizmoLA.com

I'll be talking about the Dynamic Scalable Vector Graphics (SVG) with Asynchronous Javascript and XML (Ajax) demo I created for the LAMPsig booth at the Southern California Linux expo 2006 (SCALE) conference that was held last weekend.

There were some excellent LAMP oriented discussions including Zend's Andi Gutmans himself, who talked about the PHP community project and PHP 6, then hung around for a while whilst myself and Chris Thompson peppered him with questions about MySQL's oop, its applicablility to the various framework projects underway. In short, Andi indicated that the PHP core team currently has no plans to add anything to the Oop capabilities of PHP 5, although I suppose that could change once the PHP Framework project matures. He indicated that the PHP Framework should be available in alpha or beta within the next few weeks.

Other LAMP hi-lights included Jim Winstead from MySQL AB who discussed new features in MySQL 5.x and provided some nice example code, and David Schecter from Sleepycat gave an entertaining talk that illustrated how integral berkely database is to Linux in general, and how its used by many major players to provide a high performance caching layer in front of oracle and mysql for websites like Yahoo.

Give this a day and it should be in Spartacus and the Sourceforge Additional Plugins cvs branch.

-.05 release
- Updated GeSHi to latest release (1.0.7.4)
- This release includes some fixes, and new language files for:
applescript, D, diff output, DIV game language, DOS batch language, eiffel, freebasic, gml, Delphi Inno script, Matlab M language files, MySQL specific SQL, Objective CAML, Ruby, Scheme, SDLBasic, and VHDL: Very high speed integrated circuit HDL

In the current release of the The Mambo/Joomla PonyGallery component, support for MamboJoe's Community Builder component is hardwired into the picture detail page. The Author name is a link to the Community Builder component. If you don't have that component installed, here is how you can remove the link.

You need to edit the PonyGallery script sub_viewdetails.php. This script is in the components/mod_ponygallery directory.

Find these lines:



And replace them with this:



I'm fairly sure this will be a configuration item in the next release of PonyGallery Until then, if you aren't using CommunityBuilder, this will hold you over.

Conor Michael Rolston was born on October 21st, 2005 at 3:00pm in the Cedar Sinai Medical center, Los Angeles California. The little guy weighed in at a healthy 9 lbs 6oz, and stands 22 inches from head to toe. My mother Doris was here with us to witness the birth of her grand son, which made the event extra special for us. He now has his own place in the photo gallery. After much cajolling, I finally got Tracy to experiment with turning the auto flash off her camera, and she took this beautiful photo of Conor sleeping.

The Dark Ages of Camelot (DAoC) is one of a number of Massive Multiplayer Online Role playing games (MMORPG) available for people who like those types of things. Mythic Entertainment, the company behind DAoC decided to offer an xml feed with various statistics about the game including the number of active players. From April 2002 to July 2005 I used a cron job to query the xml feed once every 5 minutes, parse the results and store the statistics in a database table.

I made a graph of these statistics available on a fan site I operated. The graph used the open source PHPlot graphing class in order to draw a line graph charting the number of players playing the game by hour for a 24 hour period. Visitors to the site would see the line graph shown here, plotting the number of players per hour against a second line showing the day's average. Like many PHP graphing libraries, PHPlot assumes that you have the GD library installed and available to PHP on order for the graphs to work.

This was one of my early experiments with PHP, and illustrated its power and flexibility. Now that the site where the graph appeared is no longer online, I figured I would provide the code, and a small subset of the database, for people interested in how to program with PHPlot. At the time I created this code, PHPlot didn't have much documentation and required some trial and error experimentation. Of course, since then (several years now) PHPlot has been improved, and should definately be considered if you want graphing in your application. Because I don't want to spend time debugging old obsolete code, I've provided the library I used in the download along with the graph script. It would probably work with the latest release, but I don't have time to test it. You can download my example database, version of PHPlot and script here. The database contains one months data, so you can play with the script and explore the class.

Read on for some brief instructions and an explanation of the code.

Continue reading "PHPlot, MySQL and the Dark Ages of Camelot" »

I have a small project that involves an implementation of Joomla (a fork of the popular PHP/Mysql based content management system Mambo). I started with Mambo and during the time I was configuring the site, the core developers of Mambo left to create the Joomla project. The reasons for this are discussed on their OpenSourceMatters website.

Suffice it to say, I find an Entity Relationships diagram to be very helpful in understanding the architecture of a database driven application like Joomla. There wasn't one available, so I decided to reverse engineer the database, and created these diagrams, which break the core database down into a few functional areas.

User and Security Subsystem


Backend (modularity and extensibility) Subsystem


Content and Presentation Subsystem


Banners


Logging