http://dean.edwards.name/packer/

.

http://honda.autoportal.ua/newcars/honda-accord-2008/foto-73138.html#scroll

Here's the problem:
You got SSL certificate from any issuer, you are happy that you can now use https!
You've installed your site, tuned your apache server to listen 443 port and include the certificate for your virtual host.... and you stuck with entering pass phrase each time when you restart apache! Even worse, you have not too much visitors on your site and your apache server shuts down to free resources. And it just can't start without entering that damn pass phrase!

Assume that you have incoming parameter "ModerationStatus" that is responsible for filtering results.
Depending on this parameter you need to show either all rows or limited number of rows. Here's the example of the routine how this can be made with the least effort:

CREATE PROCEDURE `Photo_Get_List`(ModerationStatus tinyint(1))
BEGIN
SET @query = 'SELECT * FROM Photos';
IF ModerationStatus IS NOT NULL THEN
SET @query = CONCAT(@query, ' WHERE ModerationStatus = ', ModerationStatus);
END IF;
PREPARE statement FROM @query;
EXECUTE statement;
DEALLOCATE PREPARE statement;

It's strange... but when I searched for the js snippet for this functionality I either got out-of-date javascript snippets that don't work anywhere else except IE 5 (I guess) or strange monsters that allow to save current page anywhere except browser itself!

Here's the solution for the case when you want to create nice input hints when there's no focus in the input or on lose focus action.
Example:

Very useful for the cases when you don't want to reload the page and don't want to use ajax either.
Here's an example of how it works:

I definitely like this game! :)
Today played it for the third time, difficult but very interesting! Highest break is 16 points, how about you? ))