Show caught spam comments

[matt]

Having a number in the stats section of the dashboard that says XX,XXX spam comments caught would be cool, as people seem to love that sort of thing.

[chrisjdavis]

Would be trivial to add, I have something like that built into Spam Nuker.

$caught_spam = $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_approved = 'spam'");

[masquerade]

It'd be much better if this was a more general feature, such as a plugin hook.

[mark]

He wants it on the dashboard; why would it need to be a plugin hook? If you want to use it across multiple plugins or more than once in a plugin you could define it in my-hacks.php (ugly!) and put:

function list_caught_spam() {
    echo $wpdb->get_var("SELECT COUNT(comment_ID) FROM $wpdb->comments WHERE comment_approved = 'spam'");
}

then just put <?php list_caught_spam(); ?> wherever you want it.

[Nazgul]

This sounds like plugin territory to me.

If new hooks are needed in the core for this functionality, new tickets for those hooks should be created.