This other nice trick by you doesn’t work either from the wp comments template;
global $wpdb;
$result=$wpdb->get_var("SELECT COUNT(*) FROM bb_posts WHERE poster_id = $user_id AND post_status = 0");
echo $result;No errors though. I tried replacing poster_id with wp comment_author_id but it didn’t make it.
What I was trying to do is to put the the whole count of wp comments and bbpress posts all together.
The previous question was because I produced a hit counter that runs for both; wp and bbpress. I added the total hits of the bbpress post views plugin to the wp counterize plugin. It works but I think I did this by the hard way.
