Skip to content

Instantly share code, notes, and snippets.

View aprea's full-sized avatar
💯

Chris Aprea aprea

💯
  • Sydney, Australia
View GitHub Profile
@aprea
aprea / gist:4029130
Created November 7, 2012 02:02
Clean WordPress logged in message
<?php printf( 'User is%s logged in.', ( is_user_logged_in() ? '' : ' not' ) ); ?>
@aprea
aprea / gist:4209748
Created December 4, 2012 22:44
Get all DB tables from a WordPress database installation
function reset_array( &$value, $key ) {
$value = $value[0];
}
function get_tables() {
global $wpdb;
$results = $wpdb->get_results( 'show tables from ' . DB_NAME, ARRAY_N );
array_walk( $results, 'reset_array' );
return $results;
}
@aprea
aprea / Basic Dummy Comments
Last active August 29, 2015 13:56
A small WordPress plugin to create a bunch of dummy comments for a specified post
<?php
/*
Plugin Name: Basic Dummy Comments
Version: 0.1
Plugin URI: https://github.com/aprea
Description: Creates a bunch of dummy comments
Author: Chris Aprea
Author URI: https://gist.github.com/aprea/9344578
License: GPL v3
@aprea
aprea / gist:9678766
Created March 21, 2014 03:12
Generate dummy WordPress posts
<?php
// Generates a SQL dump that imports a number of posts into the wp_posts table
set_time_limit(0);
$table_prefix = 'wp_';
$max_posts = 50000;
$max_inserts_per_query = 50;
$file = dirname( __FILE__ ) . '/dump.sql';
@aprea
aprea / gist:620566678b76bbffe0a0
Created May 21, 2014 23:30
Preserve the 'blog_plugic' setting in wp_options when migrating your DB With WP Migrate DB Pro
<?php
function custom_preserved_options( $options ) {
$options[] = 'blog_public';
return $options;
}
add_filter( 'wpmdb_preserved_options', 'custom_preserved_options' );
@aprea
aprea / gist:b1f74bfa5e16b41c421b
Created June 10, 2014 03:21
Advanced Excerpt - right align "read more" link
<?php
function custom_advanced_excerpt_read_more_link_template( $template ) {
/*
* The Advanced Excerpt plugin code looks like this
* apply_filters( 'advanced_excerpt_read_more_link_template', ' <a href="%1$s" class="read-more">%2$s</a>', get_permalink(), $read_more );
*/
return sprintf( '<p style="text-align: right;">%s</p>', $template );
}
add_filter( 'advanced_excerpt_read_more_link_template', 'custom_advanced_excerpt_read_more_link_template' );
@aprea
aprea / gist:82b5cf043ade04f55463
Created June 24, 2014 05:46
Only add the "add more" link when required
<?php
function ca_only_add_more_when_required( $default, $text, $options ) {
$text = strip_tags( $text );
if ( 'words' === $options['length_type'] ) {
$excerpt_length = str_word_count( $text );
} else {
$excerpt_length = strlen( $text );
}
@aprea
aprea / gist:886a5f1d6ec094e996fc
Last active August 29, 2015 14:02
Disable excerpt filtering for a specific post category
<?php
function disable_excerpt_filtering() {
// disable excerpt filtering for the "markup" post category
if ( has_category( 'markup' ) ) {
return true;
}
return false;
}
-- delete any usermeta specific to the other subsites
delete from wp_usermeta where meta_key regexp '^wp_([0-9]+)_';
-- duplicate the wp_usermeta structure in a working data table,
-- but add a unique index for filtering out duplicates
create table _fix_usermeta like wp_usermeta;
alter table _fix_usermeta add unique(user_id, meta_key);
-- copy the site-specific usermeta, keeping only the last of each duplicate
insert into _fix_usermeta
@aprea
aprea / gist:eae346874f39bd8d450d
Last active August 29, 2015 14:08
SQL in PHP
<?php
/**
* Get the table data
*
* @return Array
*/
private function table_data() {
global $wpdb;