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!

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.

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.

I went to this show on Sunday and it was siiiiiiiiiick. They used all vinyl and all 45’s with a pedal for looping. Also, the screen in the background was somehow looped into the beat of the music. The graphics were incredible, it looked like maybe they used after effects for some of it…? It was beat juggling, booty shakin, scratchtastic fun! This may explain my delayed reaction time on Monday.

I was looking for a way to get screen sharing to work better when people are looking at my screen. Because I have two monitors, one of which is really big, I was hoping there would be some way to only share one monitor. So far I haven’t found a solution (please tell me if you do), but I did find this article on other sharing enhancements.