Since spring, I've been working on a new, expanded site and promotional engine for Synklynk, Inc.. This is quite a cool project: companies use Synklynk's system to give away free music files, and get information back about the people who download the promos, including geolocation data. The front end is working very smoothly, and there are very interesting reporting options on the client side as well. For the reporting, I ended up doing some very complex mySQL queries (including multiple virtual tables), and in several test runs with clients, we've gotten a lot of response. I've also given them a custom blog with an RSS feed, and other niceties under the hood. It's been a fun project, and this is something that people are going to use a lot.