MWX/SpamFerret/views/ClientThrottle

About

• Purpose: This view is for pre-screening Template:Spamferret (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

<mysql>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;</mysql>

<mysql>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;</mysql>