Best Of WordPress Snippet Part Three

How To Get Rid Of Unused Post Revisions In WordPress

The following line of codes will let you get rid of unused post revisions in WordPress.

DELETE a,b,c
FROM wp_posts a
WHERE a.post_type = 'revision'
LEFT JOIN wp_term_relationships b
ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id);

DELETE a,b,c

FROM wp_posts a

WHERE a.post_type = 'revision'

LEFT JOIN wp_term_relationships b

ON (a.ID = b.object_id)

LEFT JOIN wp_postmeta c ON (a.ID = c.post_id);

Snippet Source/Credit: WPRecipes.com

How To Have CSS Minified In WordPress

The following snippet will let you have CSS minified in WordPress.

<?php
require('../../../wp-load.php');
function colorize($m){
	// Your code to get the new color goes here, in this case it's grabbing a stored value from a Wordpress plugin.
	$c=get_option('tc_'.$m[4]);
	$m[3] = $c;
	if($c!=''){
		return $c;
	}else{
		return $m[0];
	}
}
header("Content-type: text/css");
$css = file_get_contents('style.css');
$css = preg_replace('~/\*.*\*/|\n|\t|(?<=:)\s+|(?<={)\s+|(?<=})\s+|(?<=,)\s+|\s+(?=;)|\s+(?={)|\s+(?=})|\s+(?<=:)~sU','',preg_replace_callback('~((transparent|#[A-F0-9a-f]{6}))(?=(.)+(?=/\*#(.+)#\*/))~U','colorize',$css));
echo $css;
?> 
// example of the css before colorization, note the comment
element {
	padding: 0;
	margin: 0 10px;
	color: #000000;/*#c_t#*/
} 
// how it looks after colorization, note the color.
element {
	padding: 0;
	margin: 0 10px;
	color: #FF0000;
}
 
// older version, doesn't grab color codes as well, missing transparent keyword.
<?php
function colorize($v){
	//whatever code you use to turn variable $v into color $c, very dependent on your specific implementation.
	return $c;
}
header("Content-type: text/css");
$css = file_get_contents('style.css');
$css = preg_replace('~/\*.*\*/|\n|\t|(?<=:)\s+|(?<={)\s+|(?<=})\s+|(?<=,)\s+|\s+(?=;)|\s+(?={)|\s+(?=})~sU','',preg_replace_callback('~#[A-F0-9a-f]{3,8}(?=;/\*#([\d\w\s]+)(:(.+))?#\*/)~U','colorize',$css));
echo $css;
?>

<?php

require('../../../wp-load.php');

function colorize($m){

// Your code to get the new color goes here, in this case it's grabbing a stored value from a Wordpress plugin.

$c=get_option('tc_'.$m[4]);

$m[3] = $c;

if($c!=''){

return $c;

}else{

return $m[0];

}

header("Content-type: text/css");

$css = file_get_contents('style.css');

$css = preg_replace('~/\*.*\*/|\n|\t|(?<=:)\s+|(?<={)\s+|(?<=})\s+|(?<=,)\s+|\s+(?=;)|\s+(?={)|\s+(?=})|\s+(?<=:)~sU','',preg_replace_callback('~((transparent|#[A-F0-9a-f]{6}))(?=(.)+(?=/\*#(.+)#\*/))~U','colorize',$css));

echo $css;

// example of the css before colorization, note the comment

element {

padding: 0;

margin: 0 10px;

color: #000000;/*#c_t#*/

}

// how it looks after colorization, note the color.

element {

padding: 0;

margin: 0 10px;

color: #FF0000;

}

// older version, doesn't grab color codes as well, missing transparent keyword.

<?php

function colorize($v){

//whatever code you use to turn variable $v into color $c, very dependent on your specific implementation.

return $c;

}

header("Content-type: text/css");

$css = file_get_contents('style.css');

$css = preg_replace('~/\*.*\*/|\n|\t|(?<=:)\s+|(?<={)\s+|(?<=})\s+|(?<=,)\s+|\s+(?=;)|\s+(?={)|\s+(?=})~sU','',preg_replace_callback('~#[A-F0-9a-f]{3,8}(?=;/\*#([\d\w\s]+)(:(.+))?#\*/)~U','colorize',$css));

echo $css;

Snippet Source/Credit: fatfolderdesign.com

How To Hide ‘Help’ Tab From WordPress Dashboard

The following snippet will let you hide “help” tab from WordPress dashboard.

function hide_help() {
    echo '<style type="text/css">
            #contextual-help-link-wrap { display: none !important; }
          </style>';
}
add_action('admin_head', 'hide_help');

function hide_help() {

echo '<style type="text/css">

#contextual-help-link-wrap { display: none !important; }

</style>';

}

add_action('admin_head', 'hide_help');

Snippet Source/Credit: WP-Snippets.com

How To Increase Server Memory Limit In WP-Config.php

The following snippet will let you increase server memory limit in wp-config.php.

/**
	* Increase memory limit
	*/
define('WP_MEMORY_LIMIT', '256M');

/**

* Increase memory limit

define('WP_MEMORY_LIMIT', '256M');

How To Replace Theme’s Google Font With Your Own In WordPress

Using the following snippet will let you replace theme’s Google font with your own font in WordPress.

function add_fonts() {
	// Styles Format:  wp_enqueue_style($handle, $src, $deps, $ver, $media);
        wp_register_style('open-sans', 'http://fonts.googleapis.com/css?family=Bree+Serif:400,300,700', array(), false, 'all');
        wp_enqueue_style( 'open-sans');
}
add_action('wp_enqueue_scripts', 'add_fonts', 100);

function add_fonts() {

// Styles Format: wp_enqueue_style($handle, $src, $deps, $ver, $media);

wp_register_style('open-sans', 'http://fonts.googleapis.com/css?family=Bree+Serif:400,300,700', array(), false, 'all');

wp_enqueue_style( 'open-sans');

}

add_action('wp_enqueue_scripts', 'add_fonts', 100);