SpamFerret/views/AttemptsEx

About

 * Purpose: Eventually, a SpecialPage with reports would be nice, but for now you can see what's being blocked, and where the spam attempts are coming from, with this query conveniently packaged in a stored "view":

SQL
CREATE OR REPLACE VIEW `AttemptsEx` AS SELECT a.ID, a.`When` AS WhenDone, a.Code, a.ID_Pattern, p.Pattern, a.ID_Client, c.Address, c.doBlock, a.PageServer, a.PageName, a.MatchText, a.didAllow FROM (     (attempts AS a        LEFT JOIN patterns AS p        ON (a.ID_Pattern = p.ID) ) LEFT JOIN clients AS c        ON (a.ID_Client = c.ID)     ) ORDER BY a.ID DESC;