Tech

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.

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

Dave Child, a Brighton UK based Web developer offers a series of free Reference/Cheat sheets that I think most web developers will find of value. He obviously invested a lot of time and effort into them and it shows. He's created free cheat sheets for MySQL, Javascript, PHP, RGB colors and the subject today's Gizmola.com entry, Apache mod_rewrite. If you've used Apache there's a good chance you've heard of mod_rewrite, although you might not understand what it can do for you. Lately, a lot of PHP scripts are including functionality that will create mod_rewrite rules and add them to a .htaccess file to support "SEO friendly" url's. Serendipity, which runs my blog, and the popular PHP Content Management System Mambo/Joomla are just two examples of packages that can do this for you.

For example, if your script uses a parameter like this: http://www.yoursite.com/home.php?id=5

A mod rewrite rule can allow users to use: http://www.yoursite.com/home/5/

Many search engines seem to penalize sites that use URL parameters, and are more likely to index and value the non-parameter version. Of course, that's not all that mod_rewrite can do. Many people use it for its ability to offer at least a layer of Hotlink protection, or to handle things like forwarding visitors from obsolete pages that might exist in a search engine to the new ones.

Using and understanding the black magic of mod_rewrite requires a basic understanding of Regular Expressions or as they are typically known: RegEx. If you're new to RegEx, think of them as wildcards on steroids. The October Lampsig meeting will present RegEx basics, and if you're in Los Angeles, definately try and attend the presentation, which will be given by Peter Benjamin. Check out Dave Child's succint reference for this powerful module whether or not you plan to attend Pete's presentation.

Continue reading "RegEx and the Mod_rewrite reference sheet" »

It took me a few years to write, but I finally completed and published my 3 Part introduction to web development on phpFreaks.com. Eric of phpFreaks wrote a new publishing engine, which includes a print feature, and my recollection is that if you use that to print out the series, it ends up being 60 pages or so printed out on 8.5x11. I've received numerous emails from readers over the couple of years between Part I and Parts 2 & 3, asking when Part 2 was coming. At a certain point, I'm sure it looked as though this might be the Remo Williams of the PHP tutorial world. When I wrote Part I, I promised a sequel, but after a year had passed, I doubt anyone would have been willing to bet on Part 2, or even for that matter, would still care to read it.

While I'm not in a position to answer any questions about the importance of the series, I felt I bore a responsibility wholly of my own making, to deliver on the implicit promise of an article I had the hubris to entitle Part I. I'd written a portion of Part II wll over a year ago, where it sat on my hard drive, even as the emails continuted to dribble in, always with the question of "when or where was Part 2?" I finally sat down and finished it during a recent visit by Tracy's mom, Betty, who graciously occupied Niamh and allowed me several days of uninterrupted time at my desk. Because this was a programming article, it entailed writing and testing the code to be included, and generating the screen shots as illustration. In summary, it turned out to be a lot more time an effort than I had bargained for.

What really drove me to expend the effort, was the opportunity to dedicate the series to my Dad, Frank Rolston III who passed away unexpectedly, earlier this year. Dad was an advocate of "finish what you start."

Continue reading "3 Part PHP Development Tutorial at phpfreaks.com" »

I have become an Eclipse convert. Eclipse is an IDE which I use to develope my PHP projects. Eclipse is open source and free, and has too many features to even begin listing. It also has a myriad of modules supporting language specific extensions and support for programmer tools like CVS.

I've also been using the PHPeclipse extension, which adds a number of nice PHP specific features and in eclipse terminology, an eclipse perspective, which is especially useful if you develope in an all-in-one environment with a local apache and php instance on your workstation. This allows you to iterate rapidly, as your changes can be instantly examined in the docked browser window, and ostensibly give's one access to php's debugging hooks. I'll admit I've never tried this, although having a debugger available is always a nice feature for any platform.

The main things I want out of PHPeclipse are color syntax hilighting, a class and function browser window that makes it quick to jump around inside your code, and PHP functionn prototypes so I know what the argument list is for all those useful built-ins like substr and array_sort, all of which you get with PHPEclipse. The class browser works well, except that it's not smart enough to resolve includes, and for this reason, rarely has visibility into the classes you're using because they're in their own class file. You can always open these in a seperate source window of course, as your workspace you can have numerous files open, all easily accessible from tabs.

Continue reading "PHPeclipse Annoyances" »