Search & replace

# replace the Listen directive.
cat $HTTPCONF | sed 's/^Listen 80/Listen 21000/' > $HTTPCONF.new
mv $HTTPCONF.new $HTTPCONF

CSS propert: Clip

http://www.w3schools.com/css/tryit.asp?filename=trycss_clip

Appunti query

$query = $this->m_Db->prepare('
 SELECT  product.id  FROM product

 JOIN
 (
 SELECT selparent.cparent, selvers.cversion, selvers.cid FROM
 (
 SELECT c.parent_id AS cparent FROM product AS a JOIN depends_on AS b ON b.son = a.id JOIN product AS c ON b.parent = c.id WHERE b.son = :id
 ) AS selparent

 JOIN
 (
 SELECT CONCAT(c.major_version, c.minor_version, c.release_version) AS cversion, c.parent_id AS cparent, c.id AS cid FROM product AS a JOIN depends_on AS b ON b.son = a.id JOIN product AS c ON b.parent = c.id WHERE b.son = :id
 ) AS selvers

 ON selparent.cparent = selvers.cparent
 ) AS step1

 ON
 (
 (step1.cparent <> 0 AND step1.cparent = product.parent_id AND CONCAT(product.major_version, product.minor_version, product.release_version) >= step1.cversion)
 OR
 (step1.cparent = 0 AND (product.parent_id = step1.cid OR product.id = step1.cid))
 )
 WHERE product.id <> :id
 GROUP BY product.id
 ');