Chris breenie

## remote-enable-xdebug
XDEBUG_SESSION_START=XDEBUG_ECLIPSE

## .emacs
(custom-set-variables
 ;; custom-set-variables was added by Custom.
 ;; If you edit it by hand, you could mess it up, so be careful.
 ;; Your init file should contain only one such instance.
 ;; If there is more than one, they won't work right.
 )
(custom-set-faces
 ;; custom-set-faces was added by Custom.
 ;; If you edit it by hand, you could mess it up, so be careful.
 ;; Your init file should contain only one such instance.

## gist:5755114
<?php
namespace Foo;

use Symfony\Component\EventDispatcher\EventSubscriberInterface;
use Symfony\Component\Form\FormEvents;
use Symfony\Component\Form\FormEvent;

/**
 * Changes Form->bind() behavior so that it treats not set values as if they
 * were sent unchanged.

## compact-sparsebundle
hdiutil compact bundle.sparsebundle

## adding-ssh-keys
$ ssh-keygen -t dsa
$ scp ~/.ssh/id_dsa.pub <host name>:.ssh/authorized_keys2

# This only needs to be called once to add the key.

$ ssh-agent sh -c 'ssh-add < /dev/null && bash'

## gist:5934075
sudo tcpdump -A -s0 -ien1 port 8080

## camel-case-to-underscore
<?php strtolower(preg_replace('/(?<=[a-z])([A-Z])/', '_$1', $string)); ?>

## debug-console-app
export XDEBUG_CONFIG="idekey=XDEBUG_ECLIPSE"

## gist:6192497
SELECT c.table_schema,u.table_name,u.column_name,u.referenced_table_name,u.referenced_column_name
FROM information_schema.table_constraints AS c
INNER JOIN information_schema.key_column_usage AS u
USING( constraint_schema, constraint_name )
WHERE c.constraint_type = 'FOREIGN KEY'
AND u.referenced_table_schema='<database>'
AND u.referenced_table_name = '<table>'
ORDER BY c.table_schema,u.table_name;

## gist:6222217
scp ~/.ssh/id_rsa.pub <username>@<server>:.ssh/authorized_keys
	(custom-set-variables
	;; custom-set-variables was added by Custom.
	;; If you edit it by hand, you could mess it up, so be careful.
	;; Your init file should contain only one such instance.
	;; If there is more than one, they won't work right.
	)
	(custom-set-faces
	;; custom-set-faces was added by Custom.
	;; If you edit it by hand, you could mess it up, so be careful.
	;; Your init file should contain only one such instance.
	<?php
	namespace Foo;

	use Symfony\Component\EventDispatcher\EventSubscriberInterface;
	use Symfony\Component\Form\FormEvents;
	use Symfony\Component\Form\FormEvent;

	/**
	* Changes Form->bind() behavior so that it treats not set values as if they
	* were sent unchanged.
	$ ssh-keygen -t dsa
	$ scp ~/.ssh/id_dsa.pub <host name>:.ssh/authorized_keys2

	# This only needs to be called once to add the key.

	$ ssh-agent sh -c 'ssh-add < /dev/null && bash'
	SELECT c.table_schema,u.table_name,u.column_name,u.referenced_table_name,u.referenced_column_name
	FROM information_schema.table_constraints AS c
	INNER JOIN information_schema.key_column_usage AS u
	USING( constraint_schema, constraint_name )
	WHERE c.constraint_type = 'FOREIGN KEY'
	AND u.referenced_table_schema='<database>'
	AND u.referenced_table_name = '<table>'
	ORDER BY c.table_schema,u.table_name;