Jonathan Stegall jonathanstegall

When a new version of PHP is installed, to keep up with the WordPress VIP Go environment locally we need to do a few things:

pecl install gmagick
If #1 fails with a beta warning, use pecl install channel://pecl.php.net/gmagick-2.0.6RC1 instead (replace with the correct version if necessary)
pecl install memcache
code /usr/local/etc/php/[version]/php.ini to open the ini file. Uncomment the lines extension="gmagick.so" and extension="memcache.so"
valet restart

And to make curl stop complaining about the SSL, do this:

Sass typographic scale generator

Generate a typographic scale of CSS variables with any interval (fixed or proportional) and any number of sizes. Just edit $interval, $body-text, $scale-min, and $scale-max:

:root {
  $interval: 1.5;    // Unitless for proportional, unit for fixed
  $body-text: 1rem;  // Must have a unit
  $scale-min: -2;    // Unitless negative integer
  $scale-max: 2;     // Unitless positive integer

$ > sudo mysql -uroot

mysql > SELECT User, Host FROM mysql.user;

mysql > DROP USER 'root'@'localhost';

Using an Access Token for the first time

Follow the instructions on Github to Create an Access Token in Github

Configure Git to use the osxkeychain

By default, git credentials are not cached so you need to tell Git if you want to avoid having to provide them each time Github requires you to authenticate. On Mac, Git comes with an “osxkeychain” mode, which caches credentials in the secure keychain that’s attached to your system account.

You can tell Git you want to store credentials in the osxkeychain by running the following:-

	// Licensed under a CC0 1.0 Universal (CC0 1.0) Public Domain Dedication
	// http://creativecommons.org/publicdomain/zero/1.0/

	(function (win, doc) {
	// Cut the mustard.
	if (!win.localStorage) return;
	// You should probably use a more specific selector than this.
	var textarea = doc.querySelector('textarea');
	// The key for the key/value pair in localStorage is the current URL.
	var key = win.location.href;

	#!/bin/bash

	# Usage: wp-create sitename

	if [ $# -eq 0 ]; then
	echo "Need to provide the directory name to be created."
	exit 1
	fi

	# set up new folder to house the WP install

	SELECT t.term_id, REPLACE(t.name, '&', '&') as name, COUNT(p.ID) as post_count, YEAR(post_date) as year, MONTH(post_date) as month
	FROM wp_terms t
	INNER JOIN wp_term_taxonomy tax ON t.term_id = tax.term_id
	INNER JOIN wp_term_relationships r ON tax.term_taxonomy_id = r.term_taxonomy_id
	INNER JOIN wp_posts p ON r.object_id = p.ID
	WHERE tax.taxonomy = 'category' and YEAR(post_date) >= YEAR(CURDATE()) and p.post_type = 'post' and p.post_status = 'publish'
	GROUP BY term_id, YEAR(post_date), MONTH(post_date)
	ORDER BY YEAR(post_date) DESC, MONTH(post_date) DESC, t.name ASC;

	<?php

	/**
	* Co-Author Plus ES query fix.
	*
	* With CAP, authors are attached either with the traditional
	* author field or via an "author" taxonomy. So we need to check both.
	*/
	add_filter( 'es_posts_request', function( $es_args, $query ) {
	if ( ! $query->is_author() ) {

	<?php
	use \Firebase\JWT\JWT as JWT_Wrapper;

	/**
	* Class wrapper for JWT tokens.
	*/
	class JWT {

	use Singleton;

	set global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
	SET SQL_MODE='ALLOW_INVALID_DATES';