sabrina-zeidan

function bulk_delete_posts(){
  $args = array( 'post_type' =>'post', 'posts_per_page' => -1, 'post_status' => 'any', 'fields' =>'ids');
  $books = get_posts( $args );
  foreach ($posts as $post) {
    wp_delete_post( $post, true);
  }
}
add_action( 'wp_head', 'bulk_delete_posts' );

sabrina-zeidan

function bulk_delete_comments(){
$args = array('fields' => 'ids','number' => '','status' => 'all');
$comments = get_comments( $args );
foreach ($comments as $comment) {
wp_delete_comment( $comment, true);
}
}
add_action( 'wp_head', 'bulk_delete_comments' );

sabrina-zeidan

function bulk_delete_books(){
$args = array( 'post_type' =>'book', 'posts_per_page' => -1, 'post_status' => 'any', 'fields' =>'ids');
$books = get_posts( $args );
foreach ($books as $book) {
wp_delete_post( $book, true);
}
}
add_action( 'wp_head', 'bulk_delete_books' );

sabrina-zeidan

function bulk_delete_revisions(){
$args = array( 'post_type' =>'revision', 'posts_per_page' => -1, 'post_status' => 'any', 'fields' =>'ids');
$revisions = get_posts( $args );
foreach ($revisions as $revision) {
wp_delete_post( $revision, true);
}
}
add_action( 'wp_head', 'bulk_delete_revisions' );

sabrina-zeidan

function bulk_delete_spam_comments(){
$args = array('fields' => 'ids','number' => '','status' => 'spam');
$comments = get_comments( $args );
foreach ($comments as $comment) {
wp_delete_comment( $comment, true);
}
}
add_action( 'wp_head', 'bulk_delete_spam_comments' );

sabrina-zeidan

Private Sub CommandButton2_Click()
Dim CSVfolder As String, _
    XlsFolder As String, _
    fname As String, _
    wBook As Workbook

 CSVfolder = "C:\csv\txt\"
 XlsFolder = "C:\csv\xlsx\"

 fname = Dir(CSVfolder & "*.txt")

sabrina-zeidan

function delete_tags_with_no_posts(){
	$tags = get_tags( array('number' => 0,'hide_empty' => false));
	foreach ( $tags as $tag ) {		
		$tag_id = $tag->term_id;
		$args = array( 'post_type' => 'post', 'posts_per_page'   => -1,
			'tax_query' => array(
				array(
					'taxonomy' => 'post_tag',
					'field' => 'id',
					'terms' => $tag_id

sabrina-zeidan

function delete_empty_tags(){
	$tags = get_tags( array('number' => 0,'hide_empty' => false));
	foreach ( $tags as $tag ) {		
		$tag_count = $tag->count;		
		if ($tag_count < 1 ){ 
                   wp_delete_term( $tag->term_id, 'post_tag' );
		} 
	}
}
add_action( 'wp_head', 'delete_empty_tags' );

sabrina-zeidan

function delete_all_tags(){
	$tags = get_tags( array('number' => 0,'hide_empty' => false));
	foreach ( $tags as $tag ) {
             wp_delete_term( $tag->term_id, 'post_tag' );
	} 
}
add_action( 'wp_head', 'delete_all_tags' );

sabrina-zeidan

function delete_empty_terms(){
	$taxonomy_name = 'city';
	$terms = get_terms( array(
		'taxonomy' => $taxonomy_name,
		'hide_empty' => false
	) );
	foreach ( $terms as $term ) {
		$term_count = $term->count;
		if ($term_count < 1){ wp_delete_term($term->term_id, $taxonomy_name); 
		}