Katrina Moody katmoody

Contract Killer

The popular open-source contract for web designers and developers by Stuff & Nonsense

Originally published: 23/12/2008
Revised date: 15/12/2013
Original post

WordPress database clean up queries

Orphan rows

Since WordPress uses MyISAM for it's storage engine, we don't get foreign keys - thus orphan rows can show themselves.

wp_posts -> wp_posts (parent/child)

SELECT * FROM wp_posts
LEFT JOIN wp_posts child ON (wp_posts.post_parent = child.ID)

The reason you might not be able to remove the Open Sans font that Wordpress >= 3.8 adds to the frontend is that quite a few WP styles and scripts list 'open-sans' as a dependancy when being registered and enqueued. When you remove the 'open-sans' style the other plugins dependant on it will not load. So you just need to deregister WP's open sans style and register your own, with a false value for the src like below.

Credit to seventhsteel from http://wordpress.org/support/topic/turning-off-open-sans-for-the-38-dashboard

Setup

git clone <repo>

clone the repository specified by ; this is similar to "checkout" in some other version control systems such as Subversion and CVS

Add colors to your ~/.gitconfig file:

How I Work

This is an evolving document about my work habits.

Deep Work

I use the concept of deep work and focus time so that I can avoid context switching. The book Deep Work by Cal Newport prompted the examination of my work and learning habits. A few key principles I adopted after reading this book are:

Reserving time blocks I dedicate to deep work each day, depending on the time available in my schedule.
Cutting off as many distractions as possible, including email, Slack, and other notifications from my computer and phone.
Reducing 'shallow' tasks wherever possible (tasks can become busy work and waste time)

	/* Creates random keys for confirm checkbox */
	function generate_confirm_key($length = 50) {
	$characters = '-0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_';
	$randomString = '';
	for ($i = 0; $i < $length; $i++) {
	$randomString .= $characters[rand(0, strlen($characters) - 1)];
	}
	return $randomString;
	}

	<?php
	// add parameter html5=1 to oembed YouTube requests as per
	// http://stackoverflow.com/questions/17747443/css-transform-translate-breaking-youtube-embedded-video
	// using modified version of code on http://www.alittleofboth.com/2013/06/modifying-youtube-video-display-in-wordpress/
	add_filter( 'oembed_result', 'youtube_oembed_html5_parameter', 10, 3);
	function youtube_oembed_html5_parameter($data, $url, $args = array()) {
	// add &html5=1 parameter
	$data = preg_replace('/(youtube\.com.)(\?feature=oembed)(.)/', '$1?' . apply_filters("hyrv_extra_querystring_parameters", "feature=oembed&html5=1&") . 'rel=0$3', $data);
	return $data;
	}

-<?php
-/**
- *
- * Remove Links from Post Titles in Genesis
- *
- * @author Joshua Nelson
- * @link http://joshuadnelson.com
- *
- */

	<?php
	/**
	* Grid Content
	* Change the number of words in excerpt if in the grid loop
	*/
	function be_grid_content() {

	// First, we make sure we're in the grid loop.
	if( ! apply_filters( 'is_genesis_grid_loop', false ) )
	return;