fbpx
How to Show WordPress Pingback and Trackback Count in Admin Post Column

How to Show WordPress Pingback and Trackback Count in Admin Post Column

This snippet will add a new column called counts within the WordPress admin post listing that will display the total number of pingbacks and trackbacks for each WordPress post.

Instructions
Add this to your functions.php file.

function commentCount($type = 'comments'){
	if($type == 'trackbacks'):
		$typeSql = 'comment_type = "trackback"';
		$oneText = 'One :trackback';
		$moreText = '% :trackbacks';
		$noneText = 'No :trackbacks';
	elseif($type == 'pingbacks'):
		$typeSql = 'comment_type = "pingback"';
		$oneText = 'One :pingback';
		$moreText = '% :pingbacks';
		$noneText = 'No :pingbacks';
	endif;
	global $wpdb;
    $result = $wpdb->get_var('
        SELECT
            COUNT(comment_ID)
        FROM
            '.$wpdb->comments.'
        WHERE
            '.$typeSql.' AND
            comment_approved="1" AND
            comment_post_ID= '.get_the_ID()
    );
	if($result == 0):
		echo str_replace('%', $result, $noneText);
	elseif($result == 1):
		echo str_replace('%', $result, $oneText);
	elseif($result > 1):
		echo str_replace('%', $result, $moreText);
	endif;
}
add_filter('manage_posts_columns', 'posts_columns_counts', 1);
add_action('manage_posts_custom_column', 'posts_custom_columns_counts', 1, 2);
function posts_columns_counts($defaults){
    $defaults['wps_post_counts'] = __('Counts');
    return $defaults;
}
function posts_custom_columns_counts($column_name, $id){
	if($column_name === 'wps_post_counts'){
		commentCount('trackbacks'); echo "<br />";
		commentCount('pingbacks');
          }
}

WordPress Snippet Info

Tested with Wordpress v. 4.7.1
Last Reviewed: 01.09.2017
Review Status: Needs Review

How to Show WordPress Pingback and Trackback Count in Admin Post Column
4.1 (82.5%) 8 vote[s]
Please report broken snippets.
Report Broken Snippet
WordPress Hosting

Recent Comments