Facebook back in August, let super secret code out. Which made its rounds on the internet before it has now died down. Due to the fact that, a extremely large social network, let out it’s source code opened the alley for media to scrutinize Facebook.

Due to the code being leaked, a PHP developer wrote a article about securing your site, making sure no valuable code is leaked.

I suggest reading up on this, as any practice that secures your code, is a practice you should know.

Here’s another interesting query. Say you want to get a list of items, ordered by something, lets say date. But you want a particular row at the top, it’s special. Well check this out:

SELECT id
FROM games
ORDER BY id=5 DESC, dcreate DESC

“id=5″ converts to a 1 if true, 0 if false on all the rows that are returned. By ordering that boolean by DESC, you put the 1 at the top. The rest are all 0. Thus, you have your special row with id=5 at the top and the rest ordered by date! I’m guessing this doesn’t optimize super well, I guess we’ll see.

Check out this query:

SELECT
	games.title AS game,
	GROUP_CONCAT(DISTINCT artists.name ORDER BY artists.name ASC SEPARATOR ', ') AS artists
FROM games
INNER JOIN tracks ON tracks.game_id = games.id
INNER JOIN artists ON artists.id = tracks.artist_id
GROUP BY games.id

I want to get a list of the soundtracks of all the games. The list should show me the name of the game and all of the artists that contributed to the soundtrack. I didn’t want to do two queries to select first the games and then the artists. This GROUP_CONCAT function saves the day. When you’re doing a grouping you can use it to join the columns that were collapsed with some separator, like they were an array! Nice!

For the soundwave360 site we decided to use Limelight to stream the audio. Once the audio was moved over to the Limelight CDN everything was streaming a lot faster. However there was one problem, flash was throwing a sandbox security error every time I used the computeSpectrum function to create the sound wave. (more…)

Don’t be suckered into reading those quick fix tip articles that promise to fix everything with 10 simple steps. By making it my personal policy to not read articles and blog entries with titles such as …

Five Life Saving Tips For Buying A Home

Top-10 User Interface Design Mistakes

or simply

The Ten Commandments

… I am accomplishing more things in less time, I feel more fit, and my general outlook on life is much more positive.

Well folks, the day has finally come! The Seattle office has made the plunge into the new space and we gotta say it feels great! We can now enjoy the finer things such as personal space, a working refrigerator, and private bathrooms. Seriously though, the space looks amazing and although we are not completely finished, we are amped to be here. Click the photo below to view the play by play of the whole move.

We’re officially moved out of 219 1st and into 1919 2nd! Here’s some pics to prove it:

I posted the photos from our trip this Saturday. Click the ninja to go there.

“Sometimes you eat the bar. Sometimes the bar eats you” - Some cowboy dude

I love my job. Seriously love my job. I forget most aren’t lucky enough to work amongst friends, Most people are chained to a cubicle, playing office politics and counting down the minimum required sentence to still get a check.

The problem with a job that never feels like work is when it does feel like work it sucks. We completely lose sight of what a real job is like. Between mochas, heated creative discussions, long lunches, pints of beer and totally inappropriate comments followed by even more inappropriate laughter, we forget.

The Buk team has done some pretty amazing work under tough conditions in the past couple weeks, so at the end of a long week, with a much needed long weekend it nice to stop and remember even when its bad, it is still a great way to pay for all that shit I don’t need.

So if you are lucky like us and you find yourself getting cranky, remember you could be making lemonade in a terribly insulting outfit at the food court. If that doesn’t make you feel better there is always truck driving school…

You can’t directly enable smooth on FLVPlayback instances. But you can use the following code:

video.getVideoPlayer(video.activeVideoPlayerIndex).smoothing = true;

Where video is some FLVPlayback instance. Credit goes to this forum post.