fracasula

DELETE `t` FROM `category_translation` AS `t`
LEFT JOIN `category` AS `c`
ON `c`.`id` = `t`.`id`
WHERE `c`.`id` IS NULL;

fracasula

<VirtualHost *:443>

	SSLEngine On

	# sudo apt-get install ssl-cert
	# sudo a2enmod ssl
	# Generate the crt file with: sudo make-ssl-cert /usr/share/ssl-cert/ssleay.cnf /etc/apache2/ssl/www.example.com.crt
	SSLCertificateFile /etc/apache2/ssl/www.example.com.crt

	ServerName www.example.com

fracasula

<LocationMatch ^/(folder1|folder2|folder3\/child)/(.*)[\/]{0,1}feed>
	Order deny,allow
	Deny from all
	Allow from mydomain.com 80.80.80.10/15
</LocationMatch>

fracasula

<VirtualHost *:443>
	SSLEngine On
	SSLCertificateFile /etc/apache2/ssl/www.example.com.crt
	
	ServerName example.com
	ServerAlias www.example.com
	
	<Directory "/var/www/example/">
		AllowOverride All
		Order allow,deny

fracasula

zend_extension=xdebug.so

xdebug.default_enable = On
xdebug.profiler_enable = On

xdebug.profiler_output_dir = "/tmp/xdebug"
xdebug.profiler_append = On
xdebug.profiler_enable_trigger = On
xdebug.profiler_output_name = "%u_%p.profile.xlog"

fracasula

UPDATE TABLEA a 
JOIN TABLEB b ON a.join_colA = b.join_colB  
SET a.columnToUpdate = [something]

fracasula

;(function (w, $, undefined) {
        "use strict";

        w.ajaxRouter = function (event, url) {
                if (event.ctrlKey)
                        return true; // CTRL+CLICK opens link in new tab -> no ajax, default behaviour
                else {
                        var url = url || $(this).attr('href'),
                                matches = /^http[s]?\:\/\/([^/]+)/.exec(url);
        

fracasula

<?php

namespace Acme\Bundle\Bundlename\DependencyInjection;

use Symfony\Component\DependencyInjection\ContainerBuilder;
use Symfony\Component\Config\FileLocator;
use Symfony\Component\HttpKernel\DependencyInjection\Extension;
use Symfony\Component\DependencyInjection\Loader;

/**

fracasula

# /etc/apache2/sites-enabled/site

<VirtualHost *:80>

        RewriteEngine On
        RewriteOptions Inherit

        ServerAdmin admin@example.com

        ServerName example.com

fracasula

# Example 1
mysqldump --databases dbname -u root -p > dbname.sql

# Example 2
mysqldump --databases dbname -u root -pPASSWORD | gzip -c > dbname.sql.gz

# Example 3 (just the schema with no data and disabling foreign keys)
mysqldump -u root -pPASSWORD --no-data --single-transaction --quick --lock-tables=false -y --disable-keys dbname | gzip -c > dbname_schema.sql.gz

# Example 4 (loading the DB back into MySQL)