vemod.net

build_query

Tue, 30 Sep 2008 23:42:49 +0200

A simple helper function for preparing SQL queries with data from outside – say no to SQL injections.

<?
function build_query($query, $_query_args_) {
  $query_args = array_slice(func_get_args(), 1); 
  $escaped_query_args = array_map("mysql_real_escape_string", $query_args);
  $sprinf_args = array_merge(array($query), $escaped_query_args);
  $result = call_user_func_array("sprintf", $sprintf_args);

  return $result;
}
?>

Example

<?
build_query("SELECT * FROM users WHERE username = '%s' AND password = '%s'", "qerub", "god' or ''='")
# => "SELECT * FROM users WHERE username = 'qerub' AND password = 'god\' or \'t\'=\'t'" 
?>

A Note About Magic Quotes

If you have magic quotes enabled, please disable them before they make the world implode because of amentia.

Tags: PHP

iTunes Triggers in Adium

Sat, 13 Sep 2008 23:20:32 +0200

Here’s a complete list of the triggers defined in ESiTunesPlugin.m of Adium:

%_album: Trigger for the album of the currently playing iTunes song
%_artist: Trigger for the artist of the currently playing iTunes song
%_composer: Trigger for the composer of the currently playing iTunes song
%_genre: Trigger for the genre of the currently playing iTunes song
%_status: Trigger for the genre of the currently playing iTunes song
%_track: Trigger for the name of the currently playing iTunes song
%_year: Trigger for the year of the currently playing iTunes song
%_iTMS: Trigger for an iTunes Music Store link to the currently playing iTunes song
%_music: Command which triggers *is listening to %_track by %_artist*
%_iTunes: Trigger for the song - artist of the currently playing iTunes song

Please note that Adium localizes these strings so, for example, %_track becomes %_spår in Swedish.

Tags: Mac

C

Thu, 04 Sep 2008 02:30:44 +0200

C is a general-purpose, block structured, procedural, imperative computer programming language developed in 1972 by Dennis Ritchie at the Bell Telephone Laboratories for use with the Unix operating system.

Wikipedia on C

My personal favorite description of C is “portable assembler”. Please think of it that way. Think of the kittens.

Tags:

assert for Ruby

Thu, 04 Sep 2008 02:28:53 +0200

A little assert mechanism superficially similiar to that in Java and C.

class AssertionFailure < RuntimeError
end

def assert(condition, message)
  unless condition
    raise AssertionFailure, "Assertion failed: #{message}" 
  end
end

Tags: Ruby

HTML

Mon, 25 Aug 2008 03:40:56 +0200

HTML, an initialism of HyperText Markup Language, is the predominant markup language for web pages. It provides a means to describe the structure of text-based information in a document — by denoting certain text as links, headings, paragraphs, lists, and so on — and to supplement that text with interactive forms, embedded images, and other objects.

Wikipedia on HTML

Tags:

rel Keyboard Navigation

Mon, 25 Aug 2008 01:49:04 +0200

Keyboard navigation is often missing on web sites. Its absence is especially frustrating on sites like Flickr where you simply want to move from photo to photo with a minimum of fuss. By providing a very simple way to add keyboard navigation I’m hoping to make it a little bit more popular.

There’s a rel attribute in (X)HTML that is used to define the relations the document has to other documents. With this mechanism we can, for example, easily state that a page is to the right of another page, in any of these ways:

<link rel="right" href="smurfs.html" />
<a rel="right" href="smurfs.html">Smurfs</a>

This information can then be accessed from JavaScript when arrow keys are pressed.

An Implementation

My photo gallery has a simple and elegant implementation of this idea that you’re free to use under the very liberal WTFPL. Here’s an example photo page – try going there and pressing the arrow keys on your keyboard.

Tags: JavaScript and HTML

Post-Installation Notes for Mac OS X Leopard

Mon, 04 Aug 2008 17:42:24 +0200

Make the menu bar opaque

Check the checkbox at the bottom of Desktop & Screen-Saver in System Preferences.

Get back the 2D dock

defaults write com.apple.dock no-glass -boolean YES
killall Dock

Disable delayed TCP acks

These make Samba/CIFS transfer slow as hell.

x="net.inet.tcp.delayed_ack=0" 
echo "$x" | sudo tee -a /etc/sysctl.conf
sudo chown root:wheel /etc/sysctl.conf
sudo chmod 0644 /etc/sysctl.conf 
sudo sysctl -w "$x"

Fix iTunes

Not really an OS X thing, but whatever…

defaults write com.apple.iTunes show-store-arrow-links -bool FALSE
defaults write com.apple.itunes show-genre-when-browsing -bool FALSE

Enable full keyboard access

It’s somewhere in System Preferences…

Tags: Mac

Photos

Mon, 21 Jul 2008 17:46:03 +0200

My photos are available at photos.vemod.net.

Tags:

TextMate Integration for Rack::ShowExceptions

Thu, 10 Jul 2008 00:55:19 +0200

Rack::ShowExceptions is very nice, but it is even nicer with links straight into TextMate:

You can get the functionality by cherry picking 859bba0de77d391134c422d87370cff3924f1cef from git://github.com/Qerub/rack.git.

Tags: Ruby and Mac

Slugalizer

Thu, 10 Jul 2008 00:39:14 +0200

Slugalizer is a one-method Ruby library that can slugalize (or slugify) strings, like this:

Slugalizer.slugalize("Åh, räksmörgåsar!")
# => "ah-raksmorgasar"

Download

slugalizer.rb

Tags: Ruby