about Useful stuff

Files I'm using from time to time. At least - useful for me. Any comments about better analogs or newer versions are welcome.

UTF-8 putty

.

How to get rid of the pass-phrase dialog at Apache startup

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!

Flash Video Player

Small and pretty simple but powerful in the same way - JW FLV Media Player
Very easy to use, supports playback of any format the Adobe Flash Player can handle (FLV, MP4, MP3, AAC, JPG, PNG and GIF). It also supports RTMP, HTTP, live streaming, various playlists formats, a wide range of settings and an extensive javascript API.
Must have tool if you want to play online video on your site.

Cheat Sheets

Cheatsheets taken from http://www.addedbytes.com

Useful code snippets for me

Simple XML/XSLT Parser

<?php
  $xml_filename
= 'name.xml';
 
$xsl_filename = 'name.xsl';
 
$doc = new DOMDocument();
 
$xsl = new XSLTProcessor();
 
$doc->load($xsl_filename);
 
$xsl->importStyleSheet($doc);
 
$doc->load($xml_filename);
 
$content = $xsl->transformToXML($doc);
?>

MySQL snippet with cursors:

DECLARE done int default 0;
DECLARE currentProfileID bigint;
DECLARE dateCreatedPrm DATETIME;
DECLARE profileCursor CURSOR FOR SELECT ID FROM Profiles WHERE ID NOT IN (SELECT pID FROM Profiles_storage);
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

Drupal CMS. Common facts

Drupal is a free software package that allows an individual or a community of users to easily publish, manage and organize a wide variety of content on a website. Tens of thousands of people and organizations are using Drupal to power scores of different web sites.
Syndicate content
© 2008-2009. Konstantin Artemov