phoboslab

Whiteout - minimalistic skin for VLC movie player

Not exactly the kind of blog entry I had in mind when creating this site, but anyway...

I didn't really like any of the skins currently available on VLCs homepage. The miniMatrix skin looked very functional, but sadly also quite ugly - so I decided to make a skin with my own graphics based on this one.

Whiteout VLC skin

Download Whiteout VLC skin ~ 250kb

There is also a .psd template for the buttons in the .vlt file, in case you care.

VLC, Skins, Graphics, Photoshop / 2007.09.14 - 20:12 / Comments (0)

Automatic escaping of SQL parameters

Escaping of SQL parameters in PHP is an needlessly tedious and error-prone process. Calling the right escaping function for every parameter that might be dangerous is a difficult task in a big project. This is just dangerous and calls for SQL-Injection-Attacks.

It's obvious we need a uniform query function that automatically does the escaping for us. Perl-style parameter binding seems to be just the right choice. You can write your query, insert placeholders in the form of :n and pass the parameters to our function. The function automatically detects the datatype of the parameter for us and escapes it if needed.

query( 
    'SELECT posts 
        FROM blog 
        WHERE 
            status = :2
            AND created = :1',
    POST_STATUS_ACTIVE,
    '2007-08-02'
);

Read complete post »

PHP, MySQL, Security / 2007.08.21 - 23:09 / Comments (4)

Generic Syntax Highlighting with Regular expressions

Ever tried to display syntax highlighted program code with PHP? There are some solutions, which are either totally overblown, produce horrible markup or need an external program.

I obviously didn't like any of these, so I wrote my own syntax highlighting function for PHP. This function works great for a whole number of C-Style languages, but can also be used for SQL and many others. Read on for some examples and the highlighting code itself.

Read complete post »

PHP / 2007.08.02 - 21:42 / Comments (4)

Hello World!

Phoboslab.org is live again! This site runs on a minimalist installation of my Web CMS PageNode, which however is still not ready for release.

So what's Phoboslab about? Well, I decided to separate my web design and programming works from my game level design stuff. I had this domain lying around for some years now and I still quite like it's name, so... here is my all new blog!

In case you didn't know, Phobos Lab is the place where the first DooM game by id software is set. I hope I wont get sued...

Random thoughts / 2007.07.08 - 18:31 / Comments (1)