MWX/SpamFerret/tables/attempt

About

• Fields:
  • Code:
    • NULL = normal filter match
    • "AMP" = ampersandbot (to be eventually superceded by some kind of difference-pattern)
    • "THR" = throttled: too many spam attempts, temporary blacklist of IP address
  • MatchText: mainly useful for regex filters and (especially) non-listable offenses
  • ID_Pattern needs to allow NULL in order to log throttled saves with no pattern match

SQL

<mysql>CREATE TABLE `attempts` (

 `ID`         INT NOT NULL AUTO_INCREMENT,
 `When`       DATETIME                   COMMENT "timestamp of attempt",
 `ID_Pattern` INT DEFAULT NULL           COMMENT "(patterns.ID) matching pattern found",
 `ID_Client`  INT NOT NULL               COMMENT "(clients.ID) spamming client",
 `IDS_Session` varchar(255)              COMMENT "PHP session ID from session_id()",
 `Code`       varchar(15)                COMMENT "type of attempt",
 `PageServer` varchar(63)                COMMENT "identifier of wiki being attacked (usually domain)",
 `PageName`   varchar(255)               COMMENT "name of page where the spam would have displayed",
 `MatchText`  varchar(255) DEFAULT NULL  COMMENT "optional: text that triggered the filter",
 `didAllow`   TINYINT(1)   DEFAULT FALSE COMMENT "edit was allowed",
 `Diff`       MEDIUMTEXT                 COMMENT "difference between original and attempted edit",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>