Skip to content

Instantly share code, notes, and snippets.

View rileypaulsen's full-sized avatar

Riley Paulsen rileypaulsen

18 followers · 17 following
View GitHub Profile
@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
rileypaulsen / Tax Query
Last active December 19, 2015 13:09
taxonomy query for get_posts()
'tax_query'=> array(
array(
'taxonomy' => 'decade',
'field' => 'id',
'terms' => $decadesArray,
'operator' => 'NOT IN'
)
)
@rileypaulsen
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
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;
}
@rileypaulsen
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
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
rileypaulsen / Order By Meta - get_posts()
Last active December 19, 2015 13:09
order results by meta value in get_posts()
$args = array(
'post_status' => 'publish',
'post_type' => '###POSTTYPE###',
'meta_key' => '###METAKEY###',
'orderby' => 'meta_value_num',
'order' => 'DESC'
);
@rileypaulsen
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
rileypaulsen / FTP Info in WP-Config.php
Last active December 19, 2015 13:09
ftp info for wp-config.php
define( 'FTP_HOST', '###HOST##' );
define( 'FTP_USER', '###USERNAME###' );
define( 'FTP_PASS', '###PASSWORD###' );
@rileypaulsen
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
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'