Sparklines via PHP

Around 5 years ago I built a simple sparkline generation script in PHP. It wasn't very good, the lines were shaky even with antialias. During last weekend I thought I'd rebuild it from scratch to see how much better it would be second time around.

A few hours later and it was complete, the lines were thick, antialiased and almost identical in quality to the Google Image Charts version. I also added browser caching using the ETag header.

The key bit of logic that I failed to think of 5 years ago was to create the original sparkline larger than the desired size, then scale down by the same factor. The resizing naturally makes the lines smoother than imageantialias and imagesetthickness ever could.

Sparkline Examples

It's as easy as this to use:

<img src='sparkline.php?size=80x20&data=2,4,5,6,10,7,8,5,7,7,11,8,6,9,11,9,13,14,12,16&back=fff&line=5bb763&fill=d5f7d8' />

I use sparklines in a lot of my work related projects, as it's an intuitive way to display stats that only require a quick glance. Normally I'd use the Google Image Charts but has been depreciated since April 2012, and will become fully defunct in April 2015. Whilst there is the newer Google Charts library which uses HTML5, SVG, and JavaScript I prefer to use the image-only method for a leaner project with less bloat.

Check out the code on Github

20-Jun-2014 at 12:26pm

Vanillr Issue Tracker

Last year I started a little side project building an issue tracker called Vanillr. The idea was that it would be super simple, allow multiple projects with multiple users, and hosted at vanillr.com.

The need arose from having different projects on the go at the same time and having to collect bug, questions, and feature requests from various sources such as BaseCamp, Skype, and email. I personally needed a place to collect all these and have a more detailed history for each project.

Vanillr Issue Tracker Overview

Below is the selector to filter the importance of the issue and the type of issue too.

Vanillr Issue Tracker Filter

I only got as far as the designs and building the shell until I ran out of time and shelved the project, however I will be refreshing this project in 2014 to get something up and running for myself, and hopefully for others to use too.

23-Jan-2014 at 1:50pm

Similar Posts using the Jaccard Index

Today, I've added a Similar Posts section when viewing an individual post, which is calculated using the Jaccard Index. The Jaccard Index is used to compare the similarity and diversity of data sets, and in my case the data sets are the post tags. The calculation is quite simple:

Jaccard Index

The reason why the Jaccard Index is so well suited for this is because it doesn't just calculate how many tags appear in each post, but instead it calculates this based on the total number of tags in both posts. An example would be that posts matching 4 out of 5 tags would appear higher than posts matching 5 out of 20 tags.

My database structure is pretty typical in the way that I have one table for posts and another for tags, which are linked via the post ID. When viewing a post I already have the set of tags to compare the other posts to, so from these tags I can generate the SQL via:

$tags = array('tag1','tag2','tag3');
$sql = "SELECT `posts`.* FROM `posts`,`tags` WHERE  `posts`.`id` = `tags`.`post_id` AND `tags`.`post_id` != '{CURRENT_ID}' GROUP BY `posts`.`id` ORDER BY SUM(IF(" . implode('||', array_map(create_function('$a', 'return "`tags`.`tag`=\'" . $a . "\'";'), $tags)) . ",1,0))/(COUNT(`tags`.`tag`)+" . count($tags) . ") DESC LIMIT 0,3";

Which will produce the following SQL:

SELECT `posts`.* FROM `posts`,`tags` WHERE `posts`.`id` = `tags`.`post_id` AND `tags`.`post_id` != '{CURRENT_ID}' GROUP BY `posts`.`id` ORDER BY SUM(IF(`tags`.`tag`='tag1'||`tags`.`tag`='tag3'||`tags`.`tag`='tag3',1,0))/(COUNT(`tags`.`tag`)+3) DESC LIMIT 0,3

When this SQL is run it will return the top 3 posts (excluding the current post) in order of the tag similarity score. You can see it in action when viewing any individual post on my blog.

08-Jan-2014 at 4:11pm

Xbox API Twitter Bot

Alan Wynn, who built and maintains the Unofficial Xbox API, gave me full access to his Twitter bot over the weekend after I suggested some improvements to the service.

In its original form you would send a Tweet to the bot in a certain format and it would look up the specified gamertag and reply to the tweet with their current online or offline status.

Xbox API Bot

My suggestion was that if the user is offline then it would continue to check the online status every minute and tweet when the gamer eventually came online. After a complete rebuild, and taking into account multiple requests for a single gamertag, having a 7 day limit to the checks and XboxAPI limit checks, it was complete.

Usage is really simple, just Tweet the following but be sure to replace 'Major Nelson' with any gamertag of your choosing. If it doesn't exist, you'll be notified by a Tweet.

@XboxAPI_Bot isonline Major Nelson

You can view the code on Github or send a Tweet to see it working in action.

29-Sep-2013 at 5:59pm

Minecraft Skin Preview via PHP

I've expanded on my Minecraft Avatar script I built a while back so that you can now display a skin preview for a given username, like so:

Minecraft Skin Preview

It's as easy as this to use:

<img src='skin.php?u={username}&s={size}' />

Just like the facial avatar, this script grabs their skin from the Minecraft server, and then creates the 4 different views, including facial accessories such as hats or glasses. If the username does not exist, then it uses the default skin, which is stored in a base64 encoded variable to save an extra cURL request.

View the code on Github

16-Sep-2013 at 6:57pm