MWX/SpamFerret/views/ClientThrottle: Difference between revisions

From Woozle Writes Code
< MWX‎ | SpamFerret‎ | views
Jump to navigation Jump to search
(extracted from main page)
 
(ClientThrottle2)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': This view is for pre-screening {{spamferret|table|clients}} ([[IP address]]es) -- includes a column showing how long since the last spam attempt (in seconds) and another to indicate whether a client is permanently blocked.
* '''Purpose''': This view is for pre-screening {{spamferret|table|clients}} ([[IP address]]es) -- 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==
==SQL==
<mysql>CREATE OR REPLACE VIEW `ClientThrottle` AS
<mysql>CREATE OR REPLACE VIEW `ClientThrottle` AS
Line 13: Line 15:
     doBlock
     doBlock
   FROM clients;</mysql>
   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>

Revision as of 01:50, 9 August 2009

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>