SpamFerret/views/ClientThrottle

About

 * Purpose: This view is for pre-screening (IP addresses) -- includes a column showing how long since the last spam attempt (in seconds) and another to indicate whether a client is permanently blocked.
 * History:
 * 2009-08-08 created ClientThrottle2 as temporary measure until legacy code can be gotten rid of

SQL
CREATE OR REPLACE VIEW `ClientThrottle` AS SELECT ID, Address, WhenFirst, WhenLast, Count, IFNULL(Retries,0) AS Retries, TIMESTAMPDIFF(SECOND,WhenLast,NOW) AS ThrottleTime, doBlock FROM clients;

CREATE OR REPLACE VIEW `ClientThrottle2` AS SELECT Address, WhenFirst, WhenLast, Count, IFNULL(Retries,0) AS Retries, TIMESTAMPDIFF(SECOND,WhenLast,NOW) AS ThrottleTime, doBlock FROM client;