Here’s a flight tracker project I’ve been working on. This is based on an assignment for a Ruby class. It has a Sinatra-powered server, an inbound flight simulator, a tracker backed by a SQLite database, and a frontend built with jqPlot, Bootstrap, and some rather sloppy jQuery. Full project description and design spec are on the Github project page.
This is the first draft of a little project I hacked together in Python. Everything I know about Python I learned today, so let’s all go ahead and agree that this is the worst code ever written except for the large parts I stole from Old Nabble. It probably won’t work for you, and no I don’t know how to fix it. I’m just hoping some smart people will think this is a good idea and make it better.
What I’m doing is creating custom window decorations for an instant messenger contact list window. In this case I’m using Empathy. However it should work with any contact list window. In fact, if you make the background the right size, this would work with any window at all! Really? No. Maybe, in theory. I have no idea. Anyway this isn’t a skin, but it might be a step in that direction.
Code after the fold, still very much in development.
read more …
One of the hacks I put in place for my new site design was to get image titles to display when you click on an image in the gallery. This isn’t out-of-the-box functionality for the NextGEN plugin; the description (which you set manually in the gallery manager) is populated, but the image title is not. The solution lies in modifying the title attribute of the a tag generated by gallery.php. To see an example of this hack in action for images with and without descriptions, visit the Space Needle pictures gallery and click on the last two images in the set. One shows only the image title, the other shows title and description. Code after the fold.
Update 11.19.2010: Now with EXIF! (maybe)
read more …
If you know why you’re reading this already, skip to the code below the fold. Otherwise, here’s some explanation. In a project Work Breakdown Structure (WBS), tasks are organized into major tasks, sub-tasks, sub-sub-tasks, etc. as in the following example which is an actual project plan used by NASA:
1 Build a spaceship
1.1 Read wikipedia article on spaceships to determine required supplies
1.2 Buy spaceship supplies
1.3 Assemble spaceship
1.3.1 Attach top part to middle part
1.3.2 Attach middle part to thruster thingie
1.3.3 Paint spaceship a neat-o color
1.4 Set spaceship upright (facing sky)
2 Fly around in spaceship
3 Discover strange new worlds
4 Return home
4.1 Point spaceship at Earth
4.2 Land spaceship on Earth
4.3 Park spaceship in designated parking space
Instead of sequentially numbering the tasks, we assign subtask numbers to those tasks that roll up under other tasks. Assemble spaceship is a subtask of Build a spaceship so it gets Build a spaceship‘s number (1) plus a subtask number (3, since it’s the third subtask) so its WBS number is 1.3. Attach top part to middle part is a subtask of Assemble spaceship, so it gets 1.3 plus a sub-subtask number (1.3.1), and so on. MS Project also bolds any items with subtasks.
Since this type of WBS or outline numbering functionality isn’t available in Excel, it requires a VBA macro. Free code after the fold.
read more …
I was in the middle of upgrading the Wasington Parkour forum software to the new phpBB 3.0 when I got distracted by a MySQL limitation I wasn’t previously aware of: it seems you can’t drop more than one table at a time in the MySQL command line interface. This curious limitation begs for a command-line script solution, and indeed I was not surprised to find that there are plenty of them out there. As usual, though, I’m reinventing the wheel for my own entertainment.
For today’s exercise, I experimented with PHP on the command line (PHP CLI). Some of the features I wanted to include weren’t in the scripts I found elsewhere, so I built them in order to make this useful for my current phpBB upgrade and on into the future for various other situations:
- Allow the user to store db login information in the script if he really wants to, but if he’s a security-conscious and relatively sane person, leave it empty in the script and prompt him for the login information when the script is called.
- Allow the user to specify table prefixes so only certain tables are deleted. When I experienced epic failure on my first attempted phpBB 2 -> phpbb3 conversion, I had to go back and remove all the bad tables that had been created. They were prefixed with phpbb3_ while the old tables were prefixed with phpbb_. Obviously I wanted to leave the old ones alone.
- Provide some useful reporting on any errors encountered and results of the batch drop.
So, here’s what I have for you today: a PHP CLI script to batch drop all your unwanted MySQL tables (after the fold).
read more …