Lam Nguyen lamguy

Useful Links / Sources

PrestoDB Selects Doc

Housekeeping

change column type

ALTER TABLE logs.trades CHANGE recentprice price int;

Basics

Creating a new PHPExcel Object.

    $this->PHPExcel = new PHPExcel();

Working with sheets

Creating a new sheet:

Off canvas menu with touch handles.

View an example here.

This example is based on elements of this post.

Incliudes a OffCanvasMenuController to handle touch events bound to the off canvas menu. For example when swiping from the outer left side to the right, the left off canvas menu is dragged along.

Example usage

Make it useful

Install Package Control. For SublimeText 2, paste the following in Terminal:

import urllib2,os; pf='Package Control.sublime-package'; ipp = sublime.installed_packages_path(); os.makedirs( ipp ) if not os.path.exists(ipp) else None; urllib2.install_opener( urllib2.build_opener( urllib2.ProxyHandler( ))); open( os.path.join( ipp, pf), 'wb' ).write( urllib2.urlopen( 'http://sublime.wbond.net/' +pf.replace( ' ','%20' )).read()); print( 'Please restart Sublime Text to finish installation')

From here on out, use Package Control to install everything. ⌘+Shift+P, then type Install to get a list of installable packages you can 'livesearch through. After installing plugins, they should be running.

	user web;

	# One worker process per CPU core.
	worker_processes 8;

	# Also set
	# /etc/security/limits.conf
	# web soft nofile 65535
	# web hard nofile 65535
	# /etc/default/nginx

	server {
	listen 80;
	server_name localhost;
	root /Users/YOUR_USERNAME/Sites;

	access_log /Library/Logs/default.access.log main;

	location / {
	include /usr/local/etc/nginx/conf.d/php-fpm;
	}

	## Configure eth0
	#
	# vi /etc/sysconfig/network-scripts/ifcfg-eth0

	DEVICE="eth0"
	NM_CONTROLLED="yes"
	ONBOOT=yes
	HWADDR=A4:BA:DB:37:F1:04
	TYPE=Ethernet
	BOOTPROTO=static


	/*!
	* @description Grunt@!!!!!
	*/

	module.exports = function(grunt) {

	grunt.initConfig({
	pkg: grunt.file.readJSON('package.json'),
	uglify: {

	<?php

	function sanitize_phone( $phone, $international = false ) {
	$format = "/(?:(?:\+?1\s(?:[.-]\s)?)?(?:\(\s([2-9]1[02-9]\|[2-9][02-8]1\|[2-9][02-8][02-9])\s\)\|([2-9]1[02-9]\|[2-9][02-8]1\|[2-9][02-8][02-9]))\s(?:[.-]\s)?)?([2-9]1[02-9]\|[2-9][02-9]1\|[2-9][02-9]{2})\s(?:[.-]\s)?([0-9]{4})(?:\s(?:#\|x\.?\|ext\.?\|extension)\s(\d+))?$/";

	$alt_format = '/^(\+\s)?((0{0,2}1{1,3}[^\d]+)?\(?\s([2-9][0-9]{2})\s[^\d]?\s([2-9][0-9]{2})\s[^\d]?\s([\d]{4})){1}(\s([[:alpha:]#][^\d]\d.*))?$/';

	// Trim & Clean extension
	$phone = trim( $phone );
	$phone = preg_replace( '/\s+(#\|x\|ext(ension)?)\.?:?\s*(\d+)/', ' ext \3', $phone );

	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048