Skip to content

PHP and Mysql graphing

I have had two hobby sites up for a while one here and the other here, both devoted to the Massive multiplayer online RPG Dark Ages of Camelot (DAoC). These games have guilds (similar to a team) and classes (which are the types of characters you can create). One site is for a Guild on the server I made my characters on, and the other site is devoted to one particular class (The Cabalist) which happens to be the one I initially picked when I started to play the game. The class site has been relatively popular, garnering around 200k page views in the month of August. Like Ultima Online and Everquest, DAoC boasts thousands of subscribers worldwide (they say 250k as of Sept, 2002).

I managed to find an excuse to experiment with some interesting technology for the sites, including PHP, Mysql, xml, phpBB2, phpWebsite and phpNuke among others. Several months back i wrote a script that began to pull the number of active users on a regular interval from an xml feed provide by the publisher of DAoC. I use this data to create a graph of daily user activity using a php graphing library called phplot that wraps support for GD a c language open source graphics display library. Although the program appears to be an image (as least that is what's returned to your browser) it's actually a php script that queries the database and returns the plotted information for that day. The program takes a few of paramaters (daocdate, width and height) in case you're interested in playing with it.
Defined tags for this entry: , , ,

New DSL

It's been a while since I updated. I have plans to move the site to a new server I bought and have been configuring. Part of the process involved getting my new ISP in place (thankfully, and after numerous false starts) I now have DSL again, courtesy of Megapath Networks. The new server is setup with RedHat 7, and is hosting several small gaming sites: Cali Tribes Players and LaLa-Lan. Eventually I plan to move Gizmola.com onto it. So obviously, I've been working on a few side ventures.

I'm also playing a lot of Ice Hockey at Culver city and Burbank, and learning PHP and MySQL in the process. I think I can now be considered officially nocturnal, as I find myself up most nights. Lately I've been playing a fair amount of Tribes2, and my Tribes2 team has climbed into the top 10 of the teamwarfare ladder. This is somewhat contributory to the nocturnal lifestyle, although I think the primary reason is that I'm just basically a night person, and without the constraints of a regular job to attend, my free running cycle allows for me to sleep when I'm tired. As I write this, it's 5:40am and I'm still awake.
Defined tags for this entry: , , , ,