wpsmith

UPDATE wp_posts SET ping_status = 'closed';

wpsmith

UPDATE wp_post SET post_content = replace(post_content, '[tweet]', '' ) ;

wpsmith

DELETE FROM wp_postmeta WHERE meta_key = 'YourMetaKey';

wpsmith

DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE count = 0 );
DELETE FROM wp_term_taxonomy WHERE term_id not IN (SELECT term_id FROM wp_terms);
DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);

wpsmith

DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient%_feed_%');

wpsmith

Update wp_comments set comment_agent ='' ;

wpsmith

DELETE FROM wp_posts WHERE post_type = 'post' AND DATEDIFF(NOW(), post_date) > 600

wpsmith

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

wpsmith

add_filter( 'edd_enabled_payment_gateways',  'kws_edd_enabled_payment_gateways');

/**
 * Modify the gateways for users who can manage options so that the Test Payment gateway is activated.
 * See /easy-digital-downloads/includes/gateways/functions.php
 * @see  edd_get_enabled_payment_gateways()
 * @param  array  $gateways Existing activated gateways array
 * @return array           Modified array
 */
function kws_edd_enabled_payment_gateways($gateway_list) {

wpsmith

<?php

add_action( 'update_option_active_sitewide_plugins', 'pluginprefix_deactivate_self', 10, 2 );
add_action( 'update_option_active_plugins', 'pluginprefix_deactivate_self', 10, 2 );
/**
 *  Deactivate ourself if Addthis is deactivated.
 * 
 *  @param mixed $old_value The old option value.
 *  @param mixed $value     The new option value.
 */