thomascrepain

function debug($msg, $exit=true) {
	if($_SERVER['REMOTE_ADDR'] == '192.168.0.0') { // only for my ip
		echo "<pre>";
		var_dump($msg);
		echo "</pre>";
  
		if ($exit) {
			exit;
		}
	}

thomascrepain

# create user
CREATE USER 'myuser'@'%' IDENTIFIED BY 'password';

# grant user all rights on database
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' WITH GRANT OPTION;

# create database with UTF8 character set
create database databasename DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

# To dump a Mysql database and gzip it:

thomascrepain

# refresh remote branches
git fetch -p

# checkout remote branch
git checkout -t origin/branchname

# delete local branch
git branch -d branchname

# list remote branch

thomascrepain

# Ignore everything in this directory
*
# Except this file
!.gitignore

thomascrepain

# Search & replace over multiple files (Linux)
find . -type f -print0 | xargs -0 sed -i 's/foo/bar/g'
# Search & replace over multiple files (Mac OS X)
find . -type f -print0 | xargs -0 sed -i '' -e 's/foo/bar/g'

# remove empty files in a directory
find /tmp -size  0 -print0 |xargs -0 rm

# Run command in multiple directories
for dir in ./*; do (cd "$dir" && echo "$dir" && cowsay "boo"); done

thomascrepain

Deploy with Capistrano from Windows

Install Cygwin (http://www.cygwin.com/)

• Select the folowing packages: curl, git, nano, openssh, openssl, ruby, unzip, util-linux, vim, wget

Download the RubyGems tarball from Ruby Forge (https://rubygems.org/pages/download)

• wget http://production.cf.rubygems.org/rubygems/rubygems-2.2.2.zip
• unzip rubygems-2.2.2.zip

In a bash terminal, navigate to the unpacked directory and run:

thomascrepain

<?php
/**
 * Class Timer
 */
class Timer
{
    /**
     * @var float|null
     */
    protected $startTime;

thomascrepain

wget --spider -w 1 -r -p http://www.example.com 2>&1 | grep -B 2 -E '\.\.\. [45]\d{2}'

Use access log on the webserver to check for the referrer on the broken links:
tail -f access.log | grep -E 'HTTP/1.1" [45]\d{2}'

thomascrepain

Calculate distance, bearing and more between Latitude/Longitude points http://www.movable-type.co.uk/scripts/latlong.html

-- Spherical Law of Cosines: calculate distance to other points

SET @lat = 51.053283, @lon = 3.720359;
SELECT *
FROM (
       SELECT
 *,

thomascrepain

#!/bin/bash

# Installs the bare minimum to start a docker container on a Raspberry Pi. Make sure you start from a fresh copy of Raspbian (light)
# See: https://www.raspberrypi.org/downloads/raspbian/
#
# Run this script as sudo

# Install docker
curl -fsSL get.docker.com -o get-docker.sh && sh get-docker.sh