Riley Paulsen rileypaulsen

rileypaulsen / Update Term Count on Admin Term Management Page

Last active December 19, 2015 13:09

update the term count on admin term management page

	$taxs = get_taxonomies();
	foreach($taxs as $tax){
	$args = array(
	'hide_empty'=> false,
	);
	$terms = get_terms($tax,$args);
	$termIDs = array(); //we need an array of IDs from all the terms in this taxonomy
	foreach($terms as $term){
	$termIDs[] = $term->term_id;
	}

rileypaulsen / Tax Query

Last active December 19, 2015 13:09

taxonomy query for get_posts()

rileypaulsen / Show Drafts and Pending Review in Parent Dropdown

Last active December 19, 2015 13:09

show all drafts and pending review in the "parent" dropdown

rileypaulsen / Retroactively Add Custom Fields

Last active December 19, 2015 13:09

retroactively add custom fields to existing posts

insert into wp_postmeta (post_id, meta_key, meta_value) select ID, '###FIELDNAME###', '1' from wp_posts WHERE post_type = '###POSTTYPE###'

rileypaulsen / Post Formats via get_posts()

Last active December 19, 2015 13:09

query post formats in get_posts

	$args = array(
	'post_type'=> 'post',
	'post_status' => 'publish',
	'order' => 'DESC',
	'tax_query' => array(
	array(
	'taxonomy' => 'post_format',
	'field' => 'slug',
	'terms' => array( 'post-format-video' ),
	'operator' => 'NOT IN'

rileypaulsen / Order By Meta - get_posts()

Last active December 19, 2015 13:09

order results by meta value in get_posts()

rileypaulsen / Gravity Forms User Capability

Last active December 19, 2015 13:09

add gravity forms capability to editors

	function add_grav_forms(){
	$role = get_role('editor');
	$role->add_cap('gform_full_access');
	}
	add_action('admin_init','add_grav_forms');

rileypaulsen / FTP Info in WP-Config.php

Last active December 19, 2015 13:09

ftp info for wp-config.php

rileypaulsen / Change Roles

Last active December 19, 2015 13:09

add/remove capabilities to user roles

	$edit_editor = get_role('editor');
	$edit_editor->add_cap('add_users');
	$edit_editor->add_cap('create_users');
	$edit_editor->add_cap('delete_users');
	$edit_editor->add_cap('edit_users');
	$edit_editor->add_cap('list_users');
	$edit_editor->add_cap('edit_theme_options');

rileypaulsen / Capitalize Field in MYSQL

Created July 10, 2013 20:40

capitalize the first letter of mysql entry

UPDATE wp_postmeta set meta_value = CONCAT(UCASE(SUBSTRING(meta_value, 1, 1)), LOWER(SUBSTRING(meta_value FROM 2))) WHERE meta_key='firstname'

	add_filter( 'page_attributes_dropdown_pages_args', 'so_3538267_enable_drafts_parents' );
	add_filter( 'quick_edit_dropdown_pages_args', 'so_3538267_enable_drafts_parents' );

	function so_3538267_enable_drafts_parents( $args ){
	$args['post_status'] = 'draft,publish,pending';
	return $args;
	}