On 11/12/06, Tim Starling tstarling@wikimedia.org wrote:
We've been having quite a few complaints about false positives from the AntiSpoof extension -- an extension which attempts to prevent registration
Sorry to post again, another thought on this:
It would probably be useful to reduce the comparison to the set of users with no non-deleted edits. Who care if someone spoofs a deleted user?
A quick DELETE FROM antispoofwhatevertable WHERE NOT EXISTS (SELECT 1 FROM revision WHERE rev_user_text=whatevertable.user limit 1); or the like would accomplish that and cut down on the false positives.