Adding filters for Recent Comments Widget

[hovenko]

The attached patch adds two filters called "comments_join" and "comments_where" to alter the SQL statement for the Recent Comments widget.

[rob1n]

Maybe it's time for a comments API?

[hovenko]

I see that the cache was not cleared when new comments were written. Applying a new patch.

[hovenko]

Adds filters for distinct, join and where to recent comments.

[mrmist]

Currently the recent comments widget uses a SELECT * which is a change from the version that the attached patch was created against.

Consequently this would have to be re-done, in case limiting the output to just the fields in the patch breaks other functionality.

As an aside, selecting either * or comment_id, comment_post_id would always be DISTINCT so the keyword is not required.

[Denis-de-Bernardy]

see also #9211

[Denis-de-Bernardy]

you can now override the widget's callback entirely.